News for hackers. Stuff that matters.

A comment on DuckDB – An embeddable SQL database like SQLite, but supports Postgres features. Parent comment

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by oauea on Sunday September 20, 2020 @02:30AM (#24532290)
And if you need to run expensive migrations, use a template database.

https://www.postgresql.org/docs/current/manage-ag-templatedb...

[ Parent | on HN ]
Re:DuckDB – An embeddable SQL database like SQLite, but supp... by majodev on Sunday September 20, 2020 @04:08AM (#24532629)
While PostgreSQL templates allow to scaffold new databases (one per test-spec) quite fast, it's even faster to have a warmed up pool of databases ready: https://github.com/allaboutapps/integresql#background

Disclaimer: author.

[ Parent | on HN ]
Re:DuckDB – An embeddable SQL database like SQLite, but supp... by oauea on Sunday September 20, 2020 @04:47PM (#24537286)
Oh that looks great, and very close to what I had in mind for the next upgrade of our in-house testing framework. Definitely going to give that a try soon. Thanks for posting it!
[ Parent | on HN ]