Conversation

Jul 7, 2020

"when you query one of these postmodern databases you don't get back a fact you get back an opinion. depending on your application sometimes that might be okay but you just but you don't want to do this for absolutely everything" - D. Richard Hipp

Suraj

@electron0zero

Jul 7, 2020

This quote is from PGCon 2014 talk "SQLite: Protégé of PostgreSQL" This talk really shows the power of a embedded database (SQLite), great watch Note: D. Richard Hipp is primary author of SQLite

youtube.com

SQLite: Protégé of PostgreSQL

The Keynote for PGCon 2014 by D. Richard HippSQLite has become the most widely deployed SQL database engine in the world, with over two billion installations...

TIL: SQLite uses

as reference to implement SQL standard. When dealing with not so well defined parts of SQL, they use "What Would

Do" process. 😂

Replying to

and

Is that why they copied ON CONFLICT rather than implementing MERGE 😉

Replying to

and

I am the primary author of ON CONFLICT in Postgres. MERGE does not provide a guarantee about an insert-or-update outcome. MERGE is rather different. We briefly had MERGE, but the commit had to be reverted due to specific problems with the implementation.

Replying to

If you want all the gory details: postgresql.org/message-id/CAM

4:13 PM · Aug 18, 2020Twitter Web App

Likes