Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Ask HN: A Lightweight Data Warehouse?
2 points by xmonkee on Dec 17, 2022 | hide | past | favorite | 2 comments
I'll admit I'm unfamiliar with the warehousing landscape, but the existing solutions are quite hard to evaluate as they are all quite enterprise-y and offer too many features.

I am looking for a solution that will

- slurp data from my PostgreSQL instance into a columnar store of some kind - includes a sql-pad that my team can write and share queries on - maybe include some lightweight graphing

Thanks!



A data warehouse is basically a read oriented database. In my mind, any database that offers column based indexes can serve as a data warehouse.

My default is Azure SQL database (SQL as a service) using its column store indexes. [1] https://learn.microsoft.com/en-us/sql/relational-databases/i... [2] https://learn.microsoft.com/en-us/sql/relational-databases/i...

If I outgrow it, I would look into more enterprise-y solutions.


Clickhouse




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: