😤 Stop using MySQL #javascript #webdevelopment #sql #programming

SQLite is a fast, cheap alternative to a full SQL server. It's where I'd start for any new web dev project.

#whiteboardtheweb

[IainSimmons]

Given Astro DB's use of Turso/libSQL, I'd like to see a video of the differences between libSQL and SQLite

[albinmiftari]

I still dont understand why use sqlite instead of postgres? Anyone can tell why it can be better?

[tamtrinh]

Startup always dreams of millions users, but in fact, your app is not that interesting, a thousand users can be consider a success

[andyengle]

Sometimes these "stop using" videos are a little annoying.

If you want to use something, use it. Eventually, something else will become better, but if it works for you here and now, go for it.

[jonathancrowder]

Lost my word press site i had been making for a potential client. have to copy entire /var/lib/mysql directory to backup, not just /WordPress subdirectory. Doesn't happen with sqlite. Just one db file. Haven't been this upset in a while.

[camsaffari]

SQLite doesn't make sense under any circumstances in which you need a database. Just download a postgres docker container and the rest is similar.

[tznniwm]

is called lite for a reason... avoid that and use a regular db like mysql or postgres (if you need REAL distributed sql db, use cockroachdb or tidb) 😉

[omaribbrahim]

Local databases is where SQLite really shines. It’s faster than file I/O, manages data in a structured relational manner, can be object-relational mapped, and encryptable!

[HideBuz]

I swear this generation of web dev have all no clue about hosting databases. It it literally a few lines of code to spin up a mysql server yourself for free.

[البراءبنمالك-رم]

Yea but how do make sure it’s atomic if it’s distributed across the globe?!

[santoshpattnaik]

He looks and talks like Linus from Linus Tech Tips😅😅

[xen]

Seriously. What a terrible and irresponsible video

[julians.]

Sqlite is also one of the few dates formats the US gov considered suitable for long term digital storage. It's been compatible for pets much thirty years and will stay for many more. It's also on pretty much every end user device and server already.

[Titano]

Just finished setting up the essentials as well as some test data for my home server using linux fedora. I use mysql and php with apache httpd to handle interfacing for my own projects, as well as some automatic scraping via python with beautifulsoup to populate the database tables.
Always hurts to see stuff like this after finishing all of the essentials haha 🤦‍♂️

[razor-eg]

just stop using sql at all and use document based db ffs

[gokukakarot]

There is wal log mode in sqlite. No locking the whole database, you get a form a mvcc now, combine that with few other changes like increasing pagesize etc, you have a better sqlite that can handle concurrency

[stevepine]

Didn't hear any real pro against mysql. If I have some small local thing, I'd use SQLite, if I have heavy access, many tables, few 100K entries, I use mysql if I want something free/cheap, that can run in portable as local/integrated for testing, can sync, and only need a few files for it, can migrate in with a command or few clicks.

[Cyandog]

What if I want to host my project in a provider that either conteinerize my app or run on serverless functions, can I still use an in memory database?

[zyxwvutsrqponmlkh]

MS access, was a flat file db, that was network connected, and had multiple people sticking fingers in it at the same time... It was a disaster.

[pauldudley]

Damit... you answered a question i've had on my next side project. Thanks