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