Ask HN: Best stack for real time data intensive apps
Question to HN: I have been overwhelmed with the variety of new database and analytics solutions out there. This question is meant to hear the experiences of everyone who built data intensive apps like a financial information app or a CRM. Purpose is to simply make data loading speeds fast, whether purely by speed or using sockets or GraphQL does not matter. I am looking for opinionated views.
So far seen:
- DuckDB (guess makes things faster but no experience with it)
- Tinybird (real time data APIs?)
- GraphQL (learning curve?)
- and many more
I am relatively new to this stuff but a long time user of Postgres. Looking to learn but wildly confused and overwhelmed around what I should work on to implement for the best UX[1]
[1] Best UX defined as fast loading times for large number of rows and dynamically being able to load data (sockets?) and realtime data communication
So far seen: - DuckDB (guess makes things faster but no experience with it) - Tinybird (real time data APIs?) - GraphQL (learning curve?) - and many more
I am relatively new to this stuff but a long time user of Postgres. Looking to learn but wildly confused and overwhelmed around what I should work on to implement for the best UX[1]
[1] Best UX defined as fast loading times for large number of rows and dynamically being able to load data (sockets?) and realtime data communication