Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I wish. I'm constantly having to reinvent materialized views on engines that don't have good support for the concept (ms SQL, sqlite) because my users want to sort/filter on a calculated column, meaning that I have to revert to "dumb bucket of bits" for records in seven figures and user-counts in the dozens.

Relational algebra is good. I like the idea of nornalized data.

I hope to be able to use it one day instead of SQL.




So… use one of the engines with better support for materialized views?

This sentiment is like saying, "Java doesn't support traits, so I hate all programming languages."

If an engine doesn't support a feature you need, use a different engine. If your workplace does not allow this, that's an issue you have with your workplace, not the tools.




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

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

Search: