DEV Community

[Comment from a deleted post]
Collapse
 
geraldew profile image
geraldew

There's some irony in my answer to that question.

For Databases, I think the major difficulty is that SQL is the only language consistently available for working with them.

For SQL the major difficulty is that the implementations are so inconsistent.

To be a bit less wry, I find that handling self-referential data structures is the thing where I keep re-inventing the wheel with bespoke solutions for lack of some more powerful principles built into the data engines. Such reinventions are always challenging, both to create and support. Ditto for many-to-many structures, which always seem to require a lot of extra interface building.

When using proprietary engines such work-arounds are inherently necessary. For the Open Source options I'll have to admit responsibility for not chipping in to help building something better.