3 ms·
I've often wanted (or thought that I wanted) something that works similarly to a SQL database but where you write queries at about the same level of abstraction
by foldr 3y ago
I've often wanted (or thought that I wanted) something that works similarly to a SQL database but where you write queries at about the same level of abstraction as the output of EXPLAIN. SQL is great for generating ad-hoc reports, or in other contexts where performance isn't critical. But in a production environment you can't always rely on it to perform as expected.
- whartung 3y agoBack in the day, we were use a SQL db on the PC. The planner wasn’t particularly sophisticated in those days, nor was the data volume crushing. But in the end, we would take all of our queries, and check their plans. We would pad the db with data until the combination of data and statistics and the planner all did what we wanted. Once we were happy with the statistics and the results we’d reset the database with “empty” data for the customer, and never touch the statistics again. We were mostly trying to eliminate table scans on simple queries and joins, and influencing index selection.