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

today I talk about sqlite -- how to get started with it, where you should use it, and why I like it so much!

==========

I won't ask for subscriptions / likes / comments in videos but it really helps the channel. If you have any suggestions or things you'd like to see please comment below!

[mjiii]

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!

[mrswats]

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.

[fsouza]

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

[Stegodandy]

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!

[AceofSpades]

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

[DoctorMandible]

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

[johanwithag]

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

[christopherprobst-ranly]

Regarding concurrency: WAL mode broaw.

[PetterWersland]

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 ({}')"

[ChristianBrugger]

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?

[kimaegaii]

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

[Senumunu]

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

[gabrielatoma]

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?

[mfjones]

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

[JohnZakaria]

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

[niolss]

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

[mikewurlitzer]

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.

[efpbuqn]

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

[stephendeese]

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