Email list hosting service & mailing list manager


Re: Should the DBI layer be query language agnostic, even completely "ignorant"? Lassi Kortela 20 Sep 2019 12:06 UTC

> That's indeed my point, and those two non-SQL databases, plus we assume the in-progress Graph Query Language (GQL), match the SQL interaction shape, including columns having names. Which we can be sure is No Accident.

I don't know much about graph databases in general, but GraphQL query
results have a completely different structure from SQL query results.
It's hierarchical (literally JSON, basically) instead of tabular.

Document databases like CouchDB can be expected to hit the same issue.
IIRC they also return hierarchical results, or at least some of them.

> Strongly suggesting my project will be (re-)named sdbi for Scheme Database Interface

This is a tangential nit, but I'd avoid inventing new acronyms where
possible. A Scheme Database Interface could be called just "database",
since you always call it from Scheme, and anything you can call is an
interface. So procedures named like "database-connect" (or abbreviated
"db-connect") would be clearer than "sdbi-connect".

Using a generic name like "database" has the added benefit that it
discourages people from making slightly different APIs for the same
task; if the obvious name is already reserved, it sends a strong signal
that this is the official one (even if it isn't officially official :)