o1lab

It's been a while I tried Django.

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

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

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

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.

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.

we'll be adding a pubilc roadmap soon.

Thanks for your input.

Which SQL database are you using ?

It will take about two minutes to try

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>

NoSQL is on our roadmap.

Which NoSQL you had in mind ?

Thank you! We are fixing this.

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

(shameless plug)

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

xmysql - Creates instant REST APIs over a mysql database.

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

Give it a try.

(Im the author)

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

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

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

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

Zero configuration to generate REST APIs for any MySQL databases

(shameless plug)

If anyone is looking for apis for mysql : xmysql will be really helpful.

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

Xmysql is just one command to generate REST APIs for any mysql database.

.. This is WIP

Deriving an application using the best of frameworks - I believe is still very arduous. Yes, [ROR, Django,..] have helped but they kind of have been stagnant in their ease of deriving an app for many years.

Hence I am using a home-brewed stack on Express (Node.jS) + Nuxt (Vue.js) + MySql + Google App Engine.

This is based on Xmysql - which is absolutely a zero configuration way to derive REST APIs.

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

I plan to make internal framework open source in coming few months.

It has built in features of regular frameworks + Authentication + Authorization + ACL + Payments (Stripe) + Microservice (google-cloud functions) + Pubsub (background jobs)..

Building REST APIs for database schemas which do not follow conventions of frameworks (rails,django,play etc) is incredibly tedious.

Xmysql solves this problem [1]. Within 2 seconds you can serve REST APIs for any MySql database. Other than CRUD-List APIs it has few more cool APIs and features relating to filtering, grouping and prototyping.

[1] https://github.com/o1lab/xmysql/

Xmysql: One command to generate REST APIs for any MySql database.

https://github.com/o1lab/xmysql

This has been a fun project that I worked on last year. I started to learn backend but felt the process of creating rest apis can be improved. And I started to work on Xmysql. It is written in nodejs.

This is neat. Was looking for something like this for Xmysql[1] - which has a CHART API to fetch 'numeric column distribution' in MySql table. The data from Xmysql-chart-api[2] can then be fed to this. Will give it a try over weekend.

[1] https://github.com/o1lab/xmysql [2] : https://github.com/o1lab/xmysql#chart

Xmysql: One command to generate api for any MySql database. Generates api at blink of an eye (literally).

https://github.com/o1lab/xmysql

Has some really nice apis for group by, join and intutive way to perform 'where', 'order by' and other MySql clauses.

(shameless plug)

shameless plug (for MySql) : https://github.com/o1lab/xmysql/

  supports where clause in intuitive way in queryinh
  provides 'many' apis for groups 
  provides api for join

shameless plug (for MySql) : https://github.com/o1lab/xmysql

  XMYSQL : One command to generate REST APIs for any MySql 
  Database.

  > 20+ releases to npm in last 2 weeks. 
  > Have added 'a ton' of features since last shown on HN.