DuckDB: Querying JSON files as if they were tables

1

Steampipe

This is really cool! With their Postgres scanner[0] you can now easily query multiple datasources using SQL and join between them (i.e. Postgres table with JSON file). Something I strived to build with OctoSQL[1] before. It's amazing to see how quickly DuckDB is adding new features. Not a huge fan of C++, which is right now used for authoring extensions, it'd be really cool if somebody implemented a Rust extension SDK, or even something like Steampipe[2] does for Postgres FDWs which would provide a shim for quickly implementing non-performance-sensitive extensions for various things. Godspeed! [0]: https://duckdb.org/2022/09/30/postgres-scanner.html [1]: https://github.com/cube2222/octosql.

#Big Data #Databases #Big Data Analytics 39 social mentions

2

OctoSQL

This is really cool! With their Postgres scanner[0] you can now easily query multiple datasources using SQL and join between them (i.e. Postgres table with JSON file). Something I strived to build with OctoSQL[1] before. It's amazing to see how quickly DuckDB is adding new features. Not a huge fan of C++, which is right now used for authoring extensions, it'd be really cool if somebody implemented a Rust extension SDK, or even something like Steampipe[2] does for Postgres FDWs which would provide a shim for quickly implementing non-performance-sensitive extensions for various things. Godspeed! [0]: https://duckdb.org/2022/09/30/postgres-scanner.html [1]: https://github.com/cube2222/octosql.

#Databases #Big Data #Relational Databases 22 social mentions

3

Superintendent.app

That is exactly https://superintendent.app (disclaimer: I'm the creator).

#Productivity #Developer Tools #Data Dashboard 19 social mentions