News for hackers. Stuff that matters.
Re:Database mocks are just not worth it by zeroonetwothree on Monday December 30, 2024 @04:16PM (#42553633)
Sqlite supports recursive CTE
Re:Database mocks are just not worth it by rikthevik on Monday December 30, 2024 @05:03PM (#42554035)
I think you're missing the point.

I want to develop on postgres and test on postgres because I run postgres in production and I want to take advantage of all of its features. I don't understand why a person would 1) develop/test on a different database than production or 2) restrict one's self to the lowest common denominator of database features.

Test what you fly, fly what you test.

Re:Database mocks are just not worth it by maxbond on Monday December 30, 2024 @05:06PM (#42554057)
And JSONB, but you can't insert or update in a CTE like you can with Postgres.