3 ms·
Store the json in postgresql as JSONB. Not trying to flame - I do realise that duckdb is an alternative, but everyone in this space does this Especially for d
by sandGorgon 5y ago
Store the json in postgresql as JSONB.
Not trying to flame - I do realise that duckdb is an alternative, but everyone in this space does this
Especially for data scientists, etc. The tooling flow around dbt, pandas, jupyter, postgresql and json is rock solid.
- PaulHoule 5y agoarangodb for the win. I've done data analytics in it and OLTP. You never hear hype about arangodb because arangodb users see it as a "secret weapon" and want their competitors to use mongo.
- The_rationalist 5y ago
- boredumb 5y agoI can second that using JSONB with postgres is fast and easy, the features and operators to query json structures are also about as extensive as you'll ever need.
- gavinray 5y agoThirded, though DuckDB is compelling for scenarios when you'd traditionally be able to use SQLite, if analytics/OLAP is your thing. It's exciting and brilliant technology. I believe the authors are the same ones behind MonetDB.
- orlp 5y ago> Not trying to flame Please, flame away. I'm not here to put up a fight for one approach or another, simply interested in hearing what people think works well and what doesn't; what they'd expect/want.
- anakaine 5y agoProbably best not to encourage fighting, since flaming is what an argument descends into when it starts to get directed and nasty. How about "discuss away", heh.
- bachmeier 5y agoWouldn't that require setting up and running a postgres server? DuckDB is an sqlite replacement.
- cryptonector 5y agoYou could copy the JSONB code and not run PG.
- bigcat123 5y ago