2 ms·
How are they 'ad-hoc'? With the exceptions of JSON and XML support (cf. the 'NoSQL' fad), they're all valuable enhancements to core functionalities, no? > the
by MaxBarraclough 8y ago
How are they 'ad-hoc'? With the exceptions of JSON and XML support (cf. the 'NoSQL' fad), they're all valuable enhancements to core functionalities, no?
> the fact that you need to manually specify so many details about indices sounds like a failure to have a good theory around indexing which can be integrated into query plans
I'm no SQL guru, but this smacks of a variant on the 'sufficiently smart compiler fallacy' to me.
That the system can't always, uh, optimally optimise, isn't necessarily an indication that the system is fundamentally flawed.
GCC permits inline assembly, but that doesn't mean GCC is a failure.
- Retra 8y agoIf GCC required inline assembly everywhere, it would definitely be a failure.
- MaxBarraclough 8y agoOf course. Given that this feature was added to the DBMS pretty late in the game, we can infer that it's only rarely worthwhile.
- naasking 8y agoSee my other comment [1] if you want further details as to SQL's limitations. [1] https://news.ycombinator.com/item?id=18147388 https://news.ycombinator.com/item?id=18147388