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 :)
@ahmad-mureryАй бұрын
I feel the need to open up a SQLite DB and play with it 😎 Thanks Aaron!
@The_WookieeАй бұрын
Is fun.
@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!
@vikingthedudeАй бұрын
I love kicking it back with the boys and talking about men’s favourite topics: sports, boobs and sqlite
@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 🎉🎉🎉
@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!
@CapitaineToinonАй бұрын
Relatable opening
@Majiy00Ай бұрын
Great video, you really deserve more views and subscriber 😊😊
@davidharting3119Ай бұрын
Watching this while enjoying a nice cold water
@nullzeonАй бұрын
I literally level up as a dev everytime I watch! love it here! TryHard Studios! ❤❤❤
@theSlavenIvanovАй бұрын
Superb video quality as always!
@tiagorodrigues_brАй бұрын
What an excellent video!!
@MichielofzoАй бұрын
Intro cracked me up
@TomNook.Ай бұрын
BLAZINGLY
@AhmedSalah-xm9xuАй бұрын
Hey Aaron, are you going to continue streaming the development of your life OS? I really enjoyed the content. Keep up the great work👍👍👍
@aarondfrancisАй бұрын
Yes for sure!
@mme725Ай бұрын
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)
@davidsiewert8649Ай бұрын
You are going to some very strange parties.
@Kane0123Ай бұрын
Classic cold water conversation - SQLite config options.
@sudhanshubhagwat9538Ай бұрын
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
@aarondfrancisАй бұрын
Yes, it's listed in the FAQ!
@jannismilzАй бұрын
Would it be possible to get your benchmarking code as well? Anyways, thanks for this awesome content!
@aarondfrancisАй бұрын
@@jannismilz yes I'll make a video!
@OldKing11100Ай бұрын
Excellent baseline test. If you don't mind me asking: What is your take on the future of WAL2 + CONCURRENT for SQLite?
@rudiedirkxАй бұрын
Can you benchmark journal_mode = off too? Is that even way very much faster?
@davidguilherme5574Ай бұрын
Is there a benchmark between a tuned sqlite vs postgres or mysql in the same machine?
@abhilashkr117523 күн бұрын
You will have to consider purchasing power parity when pricing the courses in different countries
@aarondfrancis23 күн бұрын
I do. It's in the FAQ
@vlad981Ай бұрын
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
@fredericoneto1984Ай бұрын
wanna share that Bench.php ? would be usefull to tweak it to test more DB's
@julianjackson8756Ай бұрын
Thanks for that
@jesper.ordrupАй бұрын
Extremly clear explanarion of Wal. Thanks 🎉 Have u tried pocketbase?
@N3m3s7s83Ай бұрын
Amazingly explained. But the question is ... Why wal mode is not the default mode? 😮
@daknyx1448Ай бұрын
for backwards compatibility (the maintainers see it as highest priority)
@master742004 күн бұрын
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.
@kirayamato6128Ай бұрын
love you Aaron 💘😍
@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.
@adampattersonАй бұрын
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?
@zacharyquinn3676Ай бұрын
What terminal is that?
@nicobaier542417 күн бұрын
What is the `ar` command you're using to run the `bench` script?
@australianman8566Ай бұрын
does anyone know wehere I can find the bench marking script?
@rahmanramsiАй бұрын
i need the code to try it myself
@the-avid-engineerАй бұрын
*nods head first 20 seconds*
@davidharting3119Ай бұрын
Do you need to run the pragma to set WAL mode every time a process connects to SQLite? Or is it a durable config?
@ricky2629Ай бұрын
It's a one time thing, you only need to do it when you initially create the db
@davidharting3119Ай бұрын
Awesome thanks!
@gavinh7845Ай бұрын
🚀🚀🚀
@luismex5575Ай бұрын
Why we stop seeing you fron planetscale videos ?
@aarondfrancisАй бұрын
I got laid off
@luismex5575Ай бұрын
@aarondfrancis sorry to hear that, your videos of MySQL were the best , I think they made a mistake
@luismex5575Ай бұрын
@@aarondfrancis😢
@paulclarke409926 күн бұрын
@@aarondfrancis Wow, that's so sad, your videos were absolutely brilliant 😭
@njordhoderАй бұрын
Haha the intro 😂
@Pbertrand_devАй бұрын
WAL mode should be a paid feature, im suprised its included in the lite plan
@patelmalavdevАй бұрын
Wal mode is reason why sqlite took resurgence and sqlite is public domain code. The team behind get paid other ways providing exclusive services and support
@night23412Ай бұрын
@@patelmalavdev I think it's a joke about the lite in sqlite
@patelmalavdevАй бұрын
@@night23412 ah Though I always thought SQLite was a open source project but It's just a company making it and giving away for free
@kevinbatdorfАй бұрын
When not to use WAL mode?
@OldKing11100Ай бұрын
Server is subject to random poweroff creating corruption.
@aarondfrancisАй бұрын
WAL mode is safe through power loss! I can't think of a single reason to not use WAL anymore
@OldKing11100Ай бұрын
@@aarondfrancis Nice. I thought there was still a chance of the WAL file getting corrupted during write, but it probably just does a discard on the bad write when reconnecting the DB.