It's been a while I tried Django.

Does Django admin provide a way to model schema in GUI and create migrations automatically ?

No GUI but the migrations are created automatically once you define the models.

Have a look at http://forestadmin.com. It's a fully GUI admin component. I found it when looking for Django alternatives when developing in Java.

Nope, still done though code, at least in the base framework.

If you need a GUI tool that creates schema migrations automatically as you change schema - try XgeneCloud [1].

The GUI database client generates up and down SQL files automatically when you click and change schema.

Currently, it supports MySQL, MSSQL, PostgresSQL, SQLite.

Here is a simple demo how this GUI works : https://youtu.be/IKvraKy0S90

[1] : https://github.com/xgenecloud/xgenecloud

(Full disclosure : I'm the creator)

Interesting concept and quite liked the playful logo. Can we pass in env variables to db connection ?

We are in similar space, we take input params of db and generate CRUD apis with Auth+ACL and then APIs are packed into a single lambda function. There is support for serverless framework as well.

[1]: https://github.com/xgenecloud/xgenecloud

Yes, for example:-

? Enter the database password: ${DB_PASSWORD}

>> I haven’t written a migration in 1+ years

This.

Above should be the goal of every database backed application framework. A really well balanced post (author is super modest).

>> Dialect support is no picnic.

Are you doing SQL statement parsing here for diff of pg ? This can lead to lot of work if you want to add other databases.

@awinter-py : have a look at our approach to schema migrations - we hand a GUI DB application to devs and it generates schema migrations as you change database. The goal is still the same - backend devs should never write schema migrations.

XgeneCloud: writing APIs will never be simpler.

With just one command you can generate REST/Graphql on 5 different types of databases instantly.

https://github.com/xgenecloud/xgenecloud/

Has GUI for dB design and API debugging.

And APIs generated can be deployed as even AWS lambda function too.

And this is our MVP :)

Disclaimer: I'm the founder.

since you’re here: I didn’t find anything about pricing, what’s your model?

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

>> (even if it was a little ridiculous to fire up a cluster for something Excel or SQLite could handle)

I know above comment will be lost - but this is such a genuine truth.

I'm sorry but if your problem can be solved on excel then hire people who are good with excel, not people good with Hadoop.

Things tend to evolve - a system that worked on excel yesterday may well be a dangerous un maintainable monster next week.

Thank you.

Yes, XgeneCloud started as a simple project (Xmysql) that was first showed on HN[1].

[1] Xmysql on HN : https://news.ycombinator.com/item?id=15580914

Excellent! Would be lovely to hear some feedback. :)

Thank you for catching the typo in pricing - we will be fixing this.

Yes, Thank you. By using this you will never have to write CRUD APIs ever. That's about 60-80% of work in backend.

Also it is absolutely free to use with all features.