Hacker News new | ask | show | jobs
by gavinray 1095 days ago
I'm not sure if I fully understand what exactly "Ayb" is. Maybe a diagram/visual image would help to clarify the flow and architecture?

From the example it seems like it is a CLI that will create SQLite databases, and then runs an HTTP server that passes through queries to the underlying database?

Not trying to be critical but a few questions:

- What is the appeal of a CLI for creating SQLite databases when you can create one by making a new file like "my_db.sqlite3"?

- If it's meant to make the DB setup process easier for students, how does it create and run Postgres or MySQL etc? It seems like you have to already have a running DB server and then configure the credentials, versus something like starting a server using Docker and auto-wiring the credentials.

- For exposing an HTTP API on top of databases, as a heads-up there are tools like Apache Avatica which let you query any DB that has a JDBC driver over HTTP, JDBC, and gRPC. https://calcite.apache.org/avatica/docs/json_reference.html