sqlite is my favorite database (beginner - intermediate) anthony explains  

I use sqlite3 as database for most of my projects (I mostly just need read-only data). One useful command to know is ".mode table" which makes query results much more readable, especially when you have multiline strings in one of the columns!

Woah, 500! Just 12 until a big round-number milestone!

SQLite is great! Love the in-memory feature as it allows you to write tests for a web app without having to spin up a whole database (like postgres) or you can also plot it to a file storage for backup and recovery and whatnot. Super super nice.

#500 !!! congrats !

Do you have any good videos on sync between SQLite on android and a MySQL server?

Hi, do you know where to host django project with sqlite online?

Happy 500th video!!

Happy 500th

Multiple writers works fine with Sqlite, just use 'PRAGMA busy_timeout' when you open the database. You can test it like this: seq 1 10 | xargs -P 5 --replace sqlite3 db.db "PRAGMA busy_timeout = 5000" "insert into wat values ({}')"

thank you anthony i am a beginnre coder and i was told sqlite is the best fo rthe small pet project im working on this is very helpful and easy to digest!

Any alternatives that are good at handling multiple writers ? I looking for an alternative with python binding.

It's excellent for typical any single user desktop PC applications.

In-memory databases are great for high i/o apps with transient data, like multiplayer game states.

Regarding concurrency: WAL mode broaw.

Interesting that you mention prototyping. What I found most frustrating with SQL are database migrations. I want a new column, different datatype, new table, change the key, but somehow keep the data. How do you deal with these things?

i only want to open an .exe file that is saved as sqlite why is it so hard ? i still cant figure it out

Very nice video. Thanks! For a Flat File DB, I find SQLite amazingly fast and easy to interface with GAMBAS in Linux as my GUI. The ONLY issue I've been unable to solve is to have a copy on my NAS {RasPi running OpenMediaVault} or just a RasPi with a thumb drive so that 2 users, can read/write to it {but never at the same time, usually hours apart} Reads are fine but I can never write to it. on my NAS or standalone Pi and it's thumb drive. Every attempt to CHOWN or setting permissions to 777 fail. As I run SSDs on everything I'm very interested in the in-memory feature to minimize writes especially during the development/testing/debugging phase.

Sqlite is incredible. You can even embed it into application binaries.

Don't have a clue what I just watched. My phone downloads this torrent all by itself every night which consists of a jpg, an SQLite and an XML. I delete it and the next time I go to sleep I wake up to find the same 15K file. Anyone know what could be going on?

it would be so cool to see how you did the twitch chat database step by step. great cxontent. thank you!

Would you use orm like sqlalchemy or do you like your queries raw?

Great Video. Any chance you could share your terminal theme?

Hi. What keyboard is that?

Whats a wat

duckdb has replaced sqllite for me.