xgenecloud

@yuval : Congrats on launch. Happy to come across it. We need more people tackling this problem. UI looks cool :)

At XgeneCloud[1], we are after the same problem.

XgeneCloud provides a desktop app that can connect to any new/existing databases to instantly generate REST & GraphQL APIs.

(Supports MySQL, Postgres, SQL server & SQLite)

Happy to share notes on discord.

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

XgeneCloud[1] supports REST as well.

https://github.com/xgenecloud/xgenecloud

Checkout XgeneCloud for instant REST APIs on

- MySQL / MariaDB

- SQL Server / MSSQL

- SQLite

- and Postgres

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

We do support instant GraphQL as well!

(Full disclosure : Im the creator)

XgeneCloud:

An open source alternative of Parse for SQL databases : https://github.com/xgenecloud/xgenecloud

* Instantly generates REST APIs & GraphQL APIs on 'ANY' MySQL, PostgreSQL, Microsoft SQL Server, SQLite & MariaDB databases.

* Has a built in GUI to design SQL schema which auto-generates reversible schema migrations.

* And lastly, the entire backend generated can be even deployed as a Lambda Function or GCP Cloud Function or Azure Function App!

Demos are below : Happy to answer any questions

[1] : GUI based schema designer : https://www.youtube.com/watch?v=ETEEcY4mmEg&list=PLhQvP2JTFb...

[2] : REST API creation : https://www.youtube.com/watch?v=gEU-QvmwSKQ&list=PLhQvP2JTFb...

[3] : GraphQL API creation : https://www.youtube.com/watch?v=qaLIpXe1gb0&list=PLhQvP2JTFb...

(full disclosure : Im the Founder of XgeneCloud)

Canonic Team, Congrats shipping this. UI appears slick & menus snappy.

Faced an issue creating column in a new model[1] - Can't click on any of the button in image [1] (I'm on Mac & Firefox if that helps)

We are in similar space & open source : we automatically generate REST & GraphQL APIs automatically on any Microsoft SQL Server, Postgres & MySQL databases. Do give us a try. https://github.com/xgenecloud/xgenecloud

[1] : https://imgur.com/efPfFRx

Kudos, much needed. Neat documentation. Would love to try with JS APIs.

Cool, feel free to reach out. Happy to 've a chat.

Cool, congrats on this release.

Any advantages of having Cassandra as underlying db ? An example docker-compose would help to try it out quickly.

We[1] are in similar space but mostly for SQL databases. With automatic APIs we do provide GUI for schema management.

https://github.com/xgenecloud/xgenecloud

Happy to come across. Love metabase.

In business plan, does 'Isolated Application Server' and 'No Noisy Neighbors' mean the same ?

>> you shouldn't need to worry too much about re-running the generator breaking things or stomping on your code.

Can't agree more! There are code parsers which give out a DOM and then code can be manipulated. But is a bit of work. We are trying this concept in our framework.

Downloaded for trying it out. Setup steps are too many unfortunately.

Happy to have a chat. My email is registered with you.

>> I also got into the more nitty-gritty nuances of mysql through with phpmyadmin.

Have to say phpmyadmin is underappreciated. Guess a bit of UI makover can do wonders for it.

Saw @dancodes review after making a comment.

Please see here : https://news.ycombinator.com/item?id=24412737

Quite liked the demo video and landing page. Simple and easy to use GUI. Pricing is a bit steep.

Does this provide full schema edit operations like creating index, triggers etc ?

We are in similar space but as an API framework[1] for all SQL Databases.

So with GUI, one also gets REST/GraphQL APIs instantly on any SQL database.

However, I should admit our data browser is basic. And product is free.

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

Not exactly no-code, but the spirit is the same in what we are building at XgeneCloud. Via our GUI you can scaffold most of the repeatable code that is required in any backend and modify it to your business needs from there on.

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

* Demo link : https://youtu.be/gEU-QvmwSKQ (Creating CRUD APIs via GUI for a MySQL database)

* So by just pointing to a database via a GUI, you can generate CRUD-Aggregation APIs (REST/GraphQL) automatically for any given database. It has built in GUI to edit and manage schemas and access control as well.

In last few months, we built[1] a cross platform GUI app that generates automatic APIs over any SQL database.

Here are our key learnings :

* Building desktop apps is made up of an ecosystem which has sub optimal tools and it is very likely that it will never get better. On one end there is Electron which makes it easy to build but then if its a trivial app and your users are not likely to 've faster machines - your users are likely to suffer. Chrome the culprit is pretty much a joke. And on the other end there is QT, GTK which are awful to say the least.

* More than building, it is the publishing these apps that is painful which gets rarely discussed here. It costs you both time and money. By time, on how bureaucratic the process is involved in procuring the SSL from a licensed vendor, its verification and so on. And money to get the code signing licenses which are separate for both MAC and windows. And good luck publishing them without code signing - apss will be treated like malware by OS. However popular apps still go ahead and do this (notepad++ etc)

I would say use electron if you do not have sufficient resources to build natively for every OS. With some webpack optimizations you can squeeze in the app size to less than 300 MB but many electron apps without these optimizations go upto 650+ MB. Or else build it for MAC/Windows - release and see your adoption and take the next step.

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

https://GitHub.audio was fun

Nice.

Does Django provide an ACL/RBAC - how does that fit in with JWT based auth.

For a Django equivalent in node.js : Check out Xgene Cloud[1].

It automatically generates node.js API source code over new/existing SQL database with auth, acl & GUI schema design tool.

Here is simple demo of it : https://youtu.be/8LGJKUW9hhU

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

This is nice idea, see if you can use us to build interesting playgrounds on your site. We are in based in UK as well (Dorset).

Try XgeneCloud : https://github.com/xgenecloud/xgenecloud - its free & open source.

With XgeneCloud,

* You can generate REST/GraphQL APIs instantly on any database (MySQL, PG, MSSQL, SQLite)

* And deploy entire backend into a single Serverless function! (AWS Lambda, GCP CLoud fn, Azure Function Compute)

* Has a built in GUI tool for Database design and API debugging as well.

Idea is you get to pass the boring bits (CRUD et al) and invest time into business parts of application.

(Disclaimer : Im the creator)

I hear you - thank you for the feedback. I've got similar feedback from devs who are liking XgeneCloud as well. We are in really early days of our journey - I promise to improve this flow by many folds.

The way it currently works is :

* Each new project has a folder in your filesystem where GraphQL API source code is generated on pointing to database! So when we generate APIs, we also generate source code for those APIs (node.js/express.js) behind the scenes. This is a big leap on how easy it becomes to customise APIs or put some business logic in them

* Thereafter, as and when a developer changes schema (add table, add column etc) - the underlying GraphQL code also gets updated automatically.

Here is a demo of generating GraphQL on postgres & GUI based schema design:

https://youtu.be/QEq3Mjbeelg

https://youtu.be/ETEEcY4mmEg

Feel to free reach out on twitter/Discord (in profile). Happy to help you get started.

edit: sentence corrections

hey, XgeneCloud creator here. How can we improve ? which parts you didn't like

This is amazing. Congrats on shipping it Pallav!

> Is there also support for a code-first approach where these rules are stored in a (sanely human editable) text format.

We follow this approach. ACL is generated as JSON which then pass through REST & GraphQL middlewares. Completely extensible. Do watch us out [1]

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

Try XgeneCloud[1] : Generates Express.js REST APIs within seconds on any database.

It comes with a nice UI too : https://youtu.be/NtCwnlLudnk

Just point & click - you get 100s of full functional APIs.

https://github.com/xgenecloud/xgenecloud

Xmysql, an instant REST API generator for MySQL was a side project which led to XgeneCloud[1]

XgeneCloud now generates REST & GraphQL APIs on any SQL Database. Plus there is much more! :)

Supported databases : MySQL, PostgreSQL, SQL Server, SQLite, MariaDB & AWS Aurora

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

Has a broken github link in website.

Actual link https://github.com/agrinman/tunnelto

Check out https://github.com/xgenecloud/xgenecloud - it scaffolds backend boilerplate with database migrations creation and management via a GUI tool. It supports : MySQL, PostgreSQL, SQL server & SQLite.

That's phenomenal! Hitting $100k in 5 months.

Here is OP's repo - https://github.com/livewire/livewire

>> we had this in different forms since the early 80s already

Could you name them, happy to check them out.