The problem with this approach is that SQLite dialect is not the same as most pr... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

DanielHB on Dec 30, 2024 | parent | context | favorite | on: Database mocks are not worth it

The problem with this approach is that SQLite dialect is not the same as most production setups. Even if you use an ORM you often have manual queries or you are using a feature that is only supported in some databases (like geospatial queries)

isbvhodnvemrwvn on Dec 30, 2024 [–]

And sqlite is extremely lax by default (and even non-defaults are not great).

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact