3 ms·
Agreed, SQL has really nice clauses. from, select (sub selects), expressions, joins, aggregation, sorting, limit/offset. I tried going through graphql but foun
by nojvek 7y ago
Agreed, SQL has really nice clauses. from, select (sub selects), expressions, joins, aggregation, sorting, limit/offset.
I tried going through graphql but found it quite hard to grok. Plus that graphql is different language, that needs more plugins to then go into sql. It's really hard to beat the expressivity of SQL.
I do hate writing SQL though, you miss a comma and it barfs at you. The error messages aren't very helpful either.
I'm working on a web mysql admin called BoomAdmin (like phpMyAdmin but invented for 21st century). https://github.com/nojvek/boomadmin https://github.com/nojvek/boomadmin (open source)
The core difference is there is a SQL block builder UI. It's 10X faster than writing a SQL by hand since you're mostly just clicking buttons and selecting fields. The front-end sends a json AST to /api/select which then compiles it to raw SQL. It's a really nice experience.
The vision is to build really nice editing, query & visualizing experience for SQL-ish backends. There are now nosql databases like couchbase that support SQL via https://www.couchbase.com/products/n1ql https://www.couchbase.com/products/n1ql