Generating a full-stack application from a database

https://notes.eatonphil.com/generating-a-full-stack-application-from-a-database.html

by jaden • 6 years ago

11 8 6 years ago

notes.eatonphil.com

darkteflon3• 6 years ago

This is neat. What are some other projects in this space?

eatonphil3• 6 years ago

For Go, there's xo/xo, sqlboiler and gnorm. But they mostly are used to generate data access code only.

Hasura, couchdb, supabase and PostgREST wrap your database but don't generate code they just run in memory (and you have to deal with Haskell and Erlang).

Prisma is most similar in spirit but has it's own data description language whereas this uses SQL. This generates a Go backend currently (I'm working on Java though too) but Prisma generates typescript.

steve-chavez• 6 years ago

Just to clarify :)

PostgREST wrap your database but don't generate code they just run in memory.

PostgREST generates an OpenAPI output, which in turn can generate code with tools such as openapi-generator[1], Go being one of the many langs supported.

(and you have to deal with Haskell and Erlang)

I guess this is only as true as saying that you have to deal with Erlang because you use RabbitMQ. Or you have to deal with C because you use PostgreSQL. Same applies with PostgREST, you don't have to write Haskell to use it, only SQL.

[1] https://openapi-generator.tech

darkteflon3• 6 years ago

Thanks, this is very helpful.

o1lab• 6 years ago

hey eatonphil, Really happy to come across this. Cool stuff.

We launched[1] XgeneCloud last week. https://github.com/xgenecloud/xgenecloud

And XgeneCloud also generates source code for REST APIs & GraphQL APIs with auth and ACL. The source code is in Express.js/Node.js - We support MySQL, PostgreSQL, MSSQL, SQLite and MariDB.

[1] https://news.ycombinator.com/item?id=23466782

Generating a full-stack application from a database

Related Stories