zlacker

[parent] [thread] 2 comments
1. steve_+(OP)[view] [source] 2023-04-27 01:10:16
PostgreSQL became the internet's darling DBMS long before that. Oracle's acquisition of MySQL in 2008 made people finally take notice of PostgreSQL. Before that, most developers barely knew it existed.
replies(1): >>tuator+2B1
2. tuator+2B1[view] [source] 2023-04-27 13:56:02
>>steve_+(OP)
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+CS1
◧◩
3. mickey+CS1[view] [source] [discussion] 2023-04-27 15:05:47
>>tuator+2B1
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]