o1lab · HackerTrans

6 năm trướcdiscuss

It's been a while I tried Django.

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

o1lab

6 năm trướcdiscuss

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)

o1lab

6 năm trướcdiscuss

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

o1lab

6 năm trướcdiscuss

>> 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.

o1lab

6 năm trướcdiscuss

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.

o1lab

6 năm trướcdiscuss

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

o1lab

6 năm trướcdiscuss

>> (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.

o1lab

6 năm trướcdiscuss

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

o1lab

6 năm trướcdiscuss

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

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

o1lab

6 năm trướcdiscuss

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.

o1lab

6 năm trướcdiscuss

we'll be adding a pubilc roadmap soon.

Thanks for your input.

o1lab

6 năm trướcdiscuss

Which SQL database are you using ?

It will take about two minutes to try

o1lab

6 năm trướcdiscuss

Please click on the link below :)

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

Website : https://xgenecloud.com

Usage: takes just two minutes

   npm install -g xc-cli
   xc app.install
   xc app.open

   xc new <project_name>

o1lab

6 năm trướcdiscuss

NoSQL is on our roadmap.

Which NoSQL you had in mind ?

o1lab

6 năm trướcdiscuss

Thank you! We are fixing this.

o1lab

6 năm trướcdiscuss

For rest apis on mysql instantly - https://github.com/o1lab/xmysql/

(shameless plug)

o1lab

7 năm trướcdiscuss

ACL and other features are work in progress. Please watch repo for updates.

o1lab

7 năm trướcdiscuss

xmysql - Creates instant REST APIs over a mysql database.

https://github.com/o1lab/xmysql/

Give it a try.

(Im the author)

o1lab

7 năm trướcdiscuss

For those interested in creating REST APIs instantly on a mysql database

https://github.com/o1lab/xmysql/

o1lab

7 năm trướcdiscuss

One of the short comings I found in many logging mechanism in backend is : There are no APIs to enable/disable logs at runtime.

Have made an small attempt to fix it in node.js

https://github.com/o1lab/dynamic-debug

comments