SQLite's WAL mode is fast fast

SQLite's WAL mode is significantly faster than the rollback mode. Let me show you why!

Chapters
00:00 How Fast is WAL Mode
03:50 Benchmarking Code
05:03 What is WAL Mode
08:45 Why Change Default to WAL Mode

[typecraft_dev]

came for the thumbnail. stayed for the content

[seanwoods]

I have the honor or working on one of the original projects that Sqlite was designed for: an expert system used by several navies around the world to evaluate the survivability of their ships. Sqlite is actually a Tcl extension that escaped into the wider world.

[ahmad-murery]

I feel the need to open up a SQLite DB and play with it 😎
Thanks Aaron!

[vikingthedude]

I love kicking it back with the boys and talking about men’s favourite topics: sports, boobs and sqlite

[kasmanialisaad]

The course is amazing. Highly recommend it. Can’t wait for the last modules!

Now I can be the coll guy explaining WAL mode to all the people! Thank you!

[haradalucas]

I thought Laravel would've default my DB to WAL mode, but turns out it didn't. I've since fixed it thanks to this video :)

[SimoneFolador]

Thanks Aaron! I didn't know the details of WAL mode. I will definitely check it out on my projects. Great video, as always!

[mortjac]

What a wonderful dinner story. And BTW, the storyteller isn’t bad either 😅
I saw all your videos in your preparation phase, and I’m delighted to see your take on SQLite wal- mode.
Congratulations 🎉🎉🎉

[Majiy]

Great video, you really deserve more views and subscriber 😊😊

[davidsiewert]

You are going to some very strange parties.

[davidharting]

Watching this while enjoying a nice cold water

[davidguilherme]

Is there a benchmark between a tuned sqlite vs postgres or mysql in the same machine?

[sudhanshubhagwat]

Hi Aaron, loving the course. Is there purchase power parity for buying the course for India? Would love to buy the course. Keep up the good work

[jesper.ordrup]

Extremly clear explanarion of Wal. Thanks 🎉

Have u tried pocketbase?

[mme]

I would love to see this benchmark ran with all 6 journal modes. (Obviously OFF wouldn't be useful for production, but it would be an interesting point of comparison)

[OldKing]

Excellent baseline test. If you don't mind me asking: What is your take on the future of WAL2 + CONCURRENT for SQLite?

[YuriyNasretdinov]

Thanks for the video! I'm a bit surprised by the performance though, in my benchmarks it's not uncommon to get around ~10us per read query, which would already amount to 100, 000 QPS in a single thread / process. I guess the somewhat poor results are probably due to a mix of reads and writes in different threads, and, since SQLite doesn't allow for concurrent writes, it might be the bottleneck here. If you weren't using PHP I would suggest putting all writers into a single thread, but I guess here you need a separate process, which wouldn't be very close to a production PHP setup unfortunately.

[rudiedirkx]

Can you benchmark journal_mode = off too? Is that even way very much faster?

[AbhinavKulshreshtha]

Is the script on github? I was surprised to see a PHP script. Now I need to take a good look at the whole script.