Show HN: Octo – Generate a serverless API from an SQL query
I've got a similar project that reads your db schema and generates a Go REST API and a TypeScript/React web interface. (The code-generation is language agnostic so at some point I'd like to add at least a Java REST API as well.) It supports PostgreSQL, MySQL, and SQLite.<p>Unlike PostgREST/Hasura and some other dynamic tools you can "eject" at this point if you'd like and continue on development without the generator in a language you already know. But I'm working on exposing Lua-based hooks you could carry across whatever backend language you choose to generate and avoid the need to eject.<p>It has builtin support for paginated bulk GET requests with filtering, sorting, limiting. Built-in support for bcrypt-password authentication and optional SQL filters specified in configuration for authorization of particular endpoints based on session and request metadata.<p>Still very much a work in progress but the goal is to push the envelope on application boilerplate.<p>Screenshots are of the example/notes project in the repo.<p><a href="https://www.dbcore.org/" rel="nofollow">https://www.dbcore.org/</a><p><a href="https://github.com/eatonphil/dbcore" rel="nofollow">https://github.com/eatonphil/dbcore</a>