DuckDB – An embeddable SQL database like SQLite, but supports Postgres features

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by chrisdalke on Saturday September 19, 2020 @10:30PM (#24531564)

I would also love this, in the past I’ve used the H2 in-memory database for tests with Spring boot applications.

The Hibernate ORM handles configuring the H2 schema but they’re not fully compatible, so it means I have to be careful to not rely on Postgres-specific features. I generally am not testing database logic, just need a working persistence layer to get the tests running, but an in-memory Postgres implementation would be amazing.

[ Parent | on HN ]

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by viraptor on Saturday September 19, 2020 @10:39PM (#24531588)

Although it's something I'd love to write, supporting it over a long time as pure FOSS would probably be a sad experience. I wonder what model could be used here. Maybe something like patreon or "sponsor a feature" with an open-source project? FOSS core + proprietary Java / .NET bindings because corps can pay?

[ Parent | on HN ]

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by chrisdalke on Sunday September 20, 2020 @09:05AM (#24533781)

Yeah, for sure this is the type of niche, high-effort work that would be used extensively by the closed-source world and yet struggle to find adequate support.

[ Parent | on HN ]

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by vips7L on Saturday September 19, 2020 @11:16PM (#24531671)

IIRC h2 supports a postgres compatibility mode. Though I'm not sure how feature complete it is.

http://h2database.com/html/features.html

[ Parent | on HN ]