SQLite's WAL mode is fast fast 

came for the thumbnail. stayed for the content

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 :)

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

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!

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

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 🎉🎉🎉

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

Relatable opening

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

Watching this while enjoying a nice cold water

I literally level up as a dev everytime I watch! love it here! TryHard Studios! ❤❤❤

Superb video quality as always!

What an excellent video!!

Intro cracked me up

BLAZINGLY

Hey Aaron, are you going to continue streaming the development of your life OS? I really enjoyed the content. Keep up the great work👍👍👍

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)

You are going to some very strange parties.

Classic cold water conversation - SQLite config options.

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

Would it be possible to get your benchmarking code as well? Anyways, thanks for this awesome content!

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

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

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

You will have to consider purchasing power parity when pricing the courses in different countries

Hi, nice video. Although 10x read seems like due to the some php driver optimization or testing methodology, as wal mode not supposed to incense reads, as specified in official site. In out app, where like 95-97% reads, we don’t notice any difference between 2 modes

wanna share that Bench.php ? would be usefull to tweak it to test more DB's

Thanks for that

Extremly clear explanarion of Wal. Thanks 🎉 Have u tried pocketbase?

Amazingly explained. But the question is ... Why wal mode is not the default mode? 😮

There are VERY good reasons not to use WAL mode and I am honestly disappointed that an outright recommendation for WAL mode was made here. WAL mode sounds better BUT it does not work if there are multiple applications on different computers all reading and writing the same database. In the classic rollback mode, this does work.

love you Aaron 💘😍

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.

I'd love to see something on Enums and modifying enums with SQLite. I wanted to test my app with SQLite but the migrations exploded and I didn't feel like modifying client work for the test 😬 But maybe it's a good topic?

What terminal is that?

What is the `ar` command you're using to run the `bench` script?

does anyone know wehere I can find the bench marking script?

i need the code to try it myself

*nods head first 20 seconds*

Do you need to run the pragma to set WAL mode every time a process connects to SQLite? Or is it a durable config?

🚀🚀🚀

Why we stop seeing you fron planetscale videos ?

Haha the intro 😂

WAL mode should be a paid feature, im suprised its included in the lite plan

When not to use WAL mode?

php? Seriously?