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.
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.
> Think of SQLite not as a replacement for Oracle but as a replacement for fopen().
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.
It’s not a replacement for a real DB but it is damn close.