SQLite: Protégé of PostgreSQL
Channel:Andrea Ross · Length:39:00 · Published:2014-05-31 · Views:7873
Summary
D. Richard Hipp's PGCon 2014 keynote on SQLite's relationship to PostgreSQL. He explains that SQLite was originally written from PostgreSQL 6.5 documentation and that the two engines serve different classes of problems.
Why HN recommends it
Recommended as a talk from SQLite's main author, and cited for the project's focus on backwards compatibility and for deployment anecdotes.
You might also enjoy this talk by the main author of SQLite — HN, 2017
Software practice, open source & careers · Databases & storage
Subtitles (excerpt)
um it's the um it's an embedded database engine it's found in a lot of products like your web browser uh Microsoft Excel QuickBooks iTunes Skype uh Lightroom it's also found in a lot of gadgets it's it's running your smartphone it's running uh your probably running your your your set top box for your cable television um your camcorder game consoles and this sort of thing it's a small embedded database and like postc it's open source and so I don't really know how many versions are out there running but if you count up the number of smartphones and the number of copies of Firefox and so forth and so on we think that maybe there's about two billion instances of sqlite running at any particular moment and about 500,000 different applications that code to use sqli it's a huge user base I did not really set out to to do that but it kind of worked out and so you may be asking right off well what does this have to do with um postgress I came to a postgress conference not an sqlite conference well it turns out that sqi is sort of a spin-off of postgress uh I call it maybe a conceptual Fork sqlite doesn't have any postgress code in it it but the way sqlite came about was I was working on a project and we were using postgress uh as a development
On Hacker News
AFAIK SQLite doesn't achieve atomicity by virtue of its global write lock. It does so by using a rollback journal (default) or WAL. So it's not really all that different from PostgreSQL in that regard and the authors point remains valid :). You might also enjoy this talk by the main author of SQLite: [VIDEO] (SQLite: Protégé of PostgreSQL) — felixge, 2017-08
Not sure about a 30 year timeframe. 10 years seems like it wouldn't be any kind of problem (personal opinion), but 30 years is an awful long time. That being said, the SQLite development Community are very very big on backwards compatibility. eg: [VIDEO] Hmmmm, there's a better talk by D. Richard Hipp around, but I'm not finding it atm. In the better talk he explains they (SQLite) are planning to… — justinclift, 2017-02
As a read-only database, sqlite doesn't have too many limits, since the storage mechanism is flexible enough to allow fast queries. The problem comes when you start writing, and reads have to wait for them. Also, (I believe) it was this talk [VIDEO] that mentions sqlite being used in adobe lightroom, and it being faster to access thumbnails from an sqlite database. — keeperofdakeys, 2014-07
Related videos
- "Testing Distributed Systems w/ Deterministic Simulation" by Will Wilson · Strange Loop Conference · 40:20
- 🚀 TDD, Where Did It All Go Wrong (Ian Cooper) · DevTernity Conference · 1:03:55
- The Value of Values with Rich Hickey · InfoQ · 31:43
- Bret Victor The Future of Programming · Joey Reid · 32:55
- "Uncle" Bob Martin - "The Future of Programming" · Paul Stringer's Mobile Tech · 1:18:21
- AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401) · Amazon Web Services · 59:56
- Tim Ewald - Clojure: Programming with Hand Tools · ClojureTV · 58:39
- "Turning the database inside out with Apache Samza" by Martin Kleppmann · Strange Loop Conference · 47:42
- Using Python to Code by Voice · Next Day Video · 28:17
- Transforming Code into Beautiful, Idiomatic Python · Next Day Video · 48:51
- Agile is Dead • Pragmatic Dave Thomas • GOTO 2015 · GOTO Conferences · 40:39
- Plover: Thought to Text at 240 WPM · Next Day Video · 34:21
- "The Economics of Programming Languages" by Evan Czaplicki (Strange Loop 2023) · Strange Loop Conference · 43:57
- "The Mess We're In" by Joe Armstrong · Strange Loop Conference · 45:50
- Conflict Resolution for Eventual Consistency • Martin Kleppmann • GOTO 2016 · GOTO Conferences · 51:35
- Principles of Technology Leadership | Bryan Cantrill | Monktoberfest 2017 · RedMonk Tech Events · 51:22