DEV Community

loading...

Discussion on: SQLite Rocks and Here's Why

Collapse
orask profile image
Oras Al-Kubaisi

Thanks a lot for sharing this post. I didn't know that SQLite was used in production. I used it for testing locally in dev environments.

Collapse
engineercoding profile image
Wesley Ameling

I actually encountered an issue with this. I updated a migration once to have a char(8) and accidentally updated a field to a string with 9 characters. Locally testing it with SQLite threw no errors, but on the CI my tests were failing and I couldn't figure out why.

Personal lesson learned: use the same rdbms as on production while testing.

Collapse
dmerejkowsky profile image
Dimitri Merejkowsky • Edited

It works great for this use case but it also works well in production.

It's also used pretty often for mobile apps.

And, in case you never read it, you might enjoy How SQLite is tested :)

Forem Open with the Forem app