SQLite and its weird new fork “libSQL”

Take a first look at a SQLite fork growing in popularity called libSQL, which makes it possible to launch one database per user. Let's dive into the history of SQLite and examine the tradeoffs of database scaling techniques.

#programming #database #thecodereport

💬 Chat with Me on Discord

🔗 Resources

🔥 Get More Content - Upgrade to PRO

Use code YT25 for 25% off PRO access

🎨 My Editor Settings

- Atom One Dark
- vscode-icons
- Fira Code Font

🔖 Topics Covered

- What is SQLite?
- World's most deployed database
- SQLite vs PostgreSQL
- What is libSQL?
- libSQL quickstart tutorial

[stefanschimmel]

Everytime I watch Fireship videos I try to convince myself that I know what he's talking about.

[jeeukko]

"SQLite says that the following query returns false:
SELECT 1='1';
It does this because an integer is not a string. Every other major SQL database engine says this is true, for reasons that the creator of SQLite does not understand. "

Gotta love SQLite docs

[daddelcrafter]

0:45 unauthorized backdoor penetration is wild😭

[johanw]

I vividly recall when SQLite was released and support was added in PHP back in the early 2000's. People were confused why you would ever use SQLite over MySQL and for who and what use case this database was for. Truly ahead of its time.

[alxkub]

SQLite is so nice exactly because it doesn’t have all those fancy extra features. Simple, compact, efficient. It’s perfect.

[Guergeiro]

The drawback mentioned in this video is the same drawback for any DB that replicates or shards data, it's not a libsql problem. You can only choose 2 out of 3 from the CAP theorem so you have to work around the missing 3rd.

[nestwr]

SQLite is for when it makes sense to store application data in a SQL-like table format locally, rather than an over-complicated JSON file. The per-user DB concept is its bread and butter, what libSQL does is it lets you query across those databases. So it's effectively something between MongoDB, where all data is stored in a document for every user but on the server side, and regular SQLite.

[I-sed-no]

"...big win for the Dildo user." lol... I died.

[DisturbedNeo]

I’ve used a similar approach where each user’s device maintains a SQLite database to store and persist any entered data locally, because it needs to work in the middle of nowhere with no internet, and then when the user returns to a location, such as the office, with a stable connection, it syncs the local SQLite DB with the main server to transfer the data over.

If they happen to be in an area with good internet anyway, it just auto-syncs upon completing an entry.

[VectorAlphaSec]

SQLite is awesome and for sure underappreciated. One of the best and easiest databases for production. iOS and Android mobile devs know this well, it really is a cool piece of tech.

[phillieseva]

I really love how you refer to sharding. I attended a talk on sharding years ago and i remember talking about how unfortunate the naming is which a lot of my fellow devs didn’t pick up on right away. Glad I’m not the only one

[DobryWujaszekKun]

> They don't even have a CoC
They have Code of Ethics. Very sufficient.

[APDesignFXP]

“SQLite is under-appreciated” so true, can hold so much data for any medium sized project, without all the extra resources.

[TheRailroad]

Mhh.
We already have so many DB systems, not sure if this one is really needed.
SQLite is just so perfect. Its small, consists of just one C file, ressource friendly.
Its main feature is that its almost the smallest possible way to get an (almost) complete SQL database.
Most people dont use SQLite because of its featureset, but because its simplicity (and, at least I do, because its really easy to upgrade to a "real" SQL dbms later on - compared to various non-standard ways of managing the data like linked lists, tables etc.)

[bruce]

Turning SQLite into a daemonised SQL server seems like the opposite of what it's going for

[sermah]

1:20 SHARTING! have been thinking about this ever since I’ve learnt about sharding

[kreuner]

SQLite doesn't just power pocket base it's used by everything that needs a local database including web browsers

[everyhandletaken]

I think I can speak for us all, when I say that we really appreciate that you go the extra mile to add all the humorous elements to your videos. This was one of your best.

[heckchuckman]

3:19 when you start laughing so hard you're no longer listening.

[fredio]

I woke my wife laughing when you chose your second random location :-D