News for hackers. Stuff that matters.
Re:What’s so exciting about Postgres? by api on Friday October 30, 2020 @06:27PM (#24947464)
SQLite is amazing, and “lite” is really not fair. I’ve seen it handle 1tb+ with at least decent performance.

It’s not a replacement for a real DB but it is damn close.

Re:What’s so exciting about Postgres? by Rodeoclash on Friday October 30, 2020 @06:49PM (#24947593)
Actually as I understand it (and a couple of minutes Googling doesn't back up my case) the "lite" on the end is pronounced "ite" and refers more to SQL as a geology like term. In other words, the SQL is a rock.
Re:What’s so exciting about Postgres? by eindiran on Friday October 30, 2020 @07:03PM (#24947673)
Even if that was what the name was intended to be, the vast majority of people pronounce it as SQL - lite. (In fact, this is the first I've heard of someone pronouncing it that way).

The documentation seems to suggest that it is in fact pronounced "SQL-lite": https://www.sqlite.org/fullsql.html

> Don't be misled by the "Lite" in the name.

Re:What’s so exciting about Postgres? by robertlagrant on Friday October 30, 2020 @06:30PM (#24947489)
It's not, because it is a real DB. It's just one for single user access only.
Re:What’s so exciting about Postgres? by bachmeier on Friday October 30, 2020 @07:43PM (#24947893)
> Think of SQLite not as a replacement for Oracle but as a replacement for fopen().

https://sqlite.org/about.html

Re:What’s so exciting about Postgres? by Koshkin on Friday October 30, 2020 @08:56PM (#24948213)
Well sure, it’s better be thought of as a replacement for fopen() than one for Oracle. (Unless you were thinking of buying Oracle in order to use it on your desktop.) An even better way would be to compare it with MS Access, for example.