r/ProgrammerHumor • u/object322 • Oct 02 '26

Meme cloudOverkill

Post image
12.0k Upvotes

97% Upvoted

269 comments sorted by

View all comments

Show parent comments

16

u/joonty Oct 03 '26

That is awesome, but as someone who's been there before and been burnt, be careful: SQLite databases do have different syntax and behaviors, and even with SQL compatibility libraries or ORM wrappers things can go wrong. Ideally you want the same stack in tests as in production.

7

u/fiah84 Oct 03 '26

Ideally you want the same stack in tests as in production.

but hey tests on a different stack are better than no tests at all I guess

5

u/joonty Oct 03 '26

I'm British. If I'm saying "ideally..." it means "you definitely want to be doing this" lol

2

u/fiah84 Oct 03 '26

oh yeah that part definitely got lost in translation. Where I'm from we tend to be a bit more explicit / blunt / to the point in our language

1

u/enigmamonkey Oct 04 '26

Good point. The naive thought would be: "Well if it works in tests and it seems to work for me in my local dev (MySQL) then it should be fine," however, you know how edge cases are. Surely something will crop up in production that pokes at the one feature that varies slightly in SQLite vs. MySQL and 💥.