zlacker

[parent] [thread] 1 comments
1. tuator+(OP)[view] [source] 2023-04-27 13:56:02
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.

replies(1): >>mickey+Ah
2. mickey+Ah[view] [source] 2023-04-27 15:05:47
>>tuator+(OP)
You 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.
[go to top]