SQLite

Creator

Creator

Seonglae Cho

Created

Created

2021 Mar 7 14:38

Editor

Editor

Seonglae Cho

Edited

Edited

2024 Aug 2 14:22

Refs

Refs

SQLite is open-source, meaning that you can make as many copies of it as you want and do whatever you want with those copies, without limitation. But SQLite is not open-contribution

SQLite is maintained by3 guys. And they don't accept public patches or fixes.

SQLite Notion

SQLite Usages

Maintainence

'If this one guy got hit by a bus, the world's software would fall apart.'

Connect with Lunduke and other members of Lunduke community

'If this one guy got hit by a bus, the world's software would fall apart.'

https://lunduke.locals.com/post/5477752/if-this-one-guy-got-hit-by-a-bus-the-worlds-software-would-fall-apart?utm_source=tldrnewsletter

'If this one guy got hit by a bus, the world's software would fall apart.'

Production

3 things that surprised me while running SQLite in production

I've been using SQLite in several production projects for six months, and I've encountered some surprising aspects."

3 things that surprised me while running SQLite in production

https://www.joseferben.com/posts/3-things-that-surprised-me-while-running-sqlite-in-production

3 things that surprised me while running SQLite in production

Hosting SQLite databases on Github Pages

I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar.

https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/?utm_source=tldrnewsletter

Performance

35% Faster Than The Filesystem

SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite().

35% Faster Than The Filesystem

https://sqlite.org/fasterthanfs.html

Recommendations

//////