Hacker News new | past | comments | ask | show | jobs | submit login

Some things that I'd love to see as options in rdbms:

Enforced globally unique column names - natural joins on everything.

Throw an exception if a query requires a table scan (bonus points if it printed the statement that would create the appropriate index).

Translate all update and delete statements into inserts (enforced immutable data + versioning).




For queries returning results from a majority of rows in the table, won't a sequential table scan be faster than an index scan?


For non-clustered indices, yes.


and if the order is not important. Reordering large numbers of rows can be a very expensive operation.


You can force the last one but just dropping the delete and update permissions from your role.




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: