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

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by mst on Sunday September 20, 2020 @10:59AM (#24534409)

I'd note that when moving from pg to $other the thing that really trips me up isn't the syntax changes, it's the lack of ARRAY and ROWTYPE.

I'm not sure whether those are in scope for you but it'd be nice if the docs said "to be implemented" or "out of scope" somewhere ... and my apologies in advance if they do and I somehow missed it.

[ Parent | on HN ]

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by mytherin on Sunday September 20, 2020 @01:44PM (#24535680)

We already have support for LIST and STRUCT (which I think are equivalent to ARRAY and ROW, respectively). There is still some functionality missing there (notably storage, and several functions) - but the base functionality is there and the remainder definitely will be added.

[ Parent | on HN ]

Re:DuckDB – An embeddable SQL database like SQLite, but supp... by mst on Monday September 21, 2020 @08:54PM (#24549866)

Could only find a pull request on struct, and nothing at all on 'list' because I just got a billion 'select list' articles. Also nothing in the docs.

Struct looks 10x uglier but perfectly easy to generate, mind, but the whole thing is non-trivial to find :/

[ Parent | on HN ]