SQLite or PostgreSQL? It's Complicated

Re:SQLite or PostgreSQL? It's Complicated by rr888 on Tuesday June 28, 2022 @12:01PM (#31909427)

I like that but its the testing that makes it hard. Being able to use ORM then mock yourdatabase with sqlite or similar is very useful. You can use testcontainers but not in my firm.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by heurisko on Tuesday June 28, 2022 @02:30PM (#31911260)

This is the promise, but in experience nasty bugs occur when the abstraction inevitably doesn't work.

If it doesn't work with an real life implementation e.g. docker test container, then I don't consider it a robust test.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by rr888 on Wednesday June 29, 2022 @01:09PM (#31922932)

Yeah one problem is my corp employer doesnt let us use docker.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by heurisko on Thursday June 30, 2022 @07:37AM (#31931137)

Would plain virtual machines be acceptable?

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by cryptonector on Tuesday June 28, 2022 @12:27PM (#31909783)

You can test with PG. Trivially.

[ Parent | on HN ]