3 ms·
Yeah, Postgresql was the FreeBSD of DBMSes. Solid, conceptually integral, well documented.* I recall doing an evaluation of open source databases in 2001. MySQ
by tuatoru 4y ago
Yeah, Postgresql was the FreeBSD of DBMSes. Solid, conceptually integral, well documented.*
I recall doing an evaluation of open source databases in 2001. MySQL didn't even have row-level locking, let alone any concept of transactions. I summarised it as "easy to use; but only for data you don't care about".
* Not that Postgres (as it was then) was without warts in 2001. A huge one was its "object orientation": table inheritance. What it needed then, and would still be nice to have, is object orientation at data type (column) level, an extension of the SQL domain.
- mickeyp 4y agoYou can create types in postgresql and use them as columns... so you can have your "object" style encapsulation at a column level. So you can have a "currency" type that has both the amount and the currency.