4 ms·
Most relational databases aren't relational enough For example in Drupal you can have a node table which is a foreign key relationship to many other custom tab
by slifin 6y ago
Most relational databases aren't relational enough
For example in Drupal you can have a node table which is a foreign key relationship to many other custom tables
In SQL I can't say get me all the nodes that have a start date without explicitly left joining to a potentially dynamic number of other tables using a higher level language to modify the query
In Datomic or Datascript or Datahike or Datalevin or Crux this query would be trivial these are not nosql databases they're EAVT datalog engines, that in some cases also support SQL for compatibility
- petepete 6y agoYou're judging all relational databases having looked at Drupal's approach? Ok...