Hello Product Hunters!
Generating REST APIs for an existing (MySql) database which does not follow conventions of frameworks such as rails, django, laravel etc is a hairy adventure that one should better avoid.
Hence I started Xmysql - a solution to scratch a simple itch. In the beginning I just needed REST APIs to learn new frontend frameworks such as Vue, Nuxt etc. Early vision of this framework was to build a tool for fast prototyping.
In the process of building these APIs - I kept adding features which I felt will be cool. And soon this list grew. Below are the current features.
FEATURES:
π₯ Generates API for ANY MySql database
π₯ Serves APIs irrespective of naming conventions of primary keys, foreign keys, tables etc
π₯ Support for composite primary keys
π₯ REST API Usual suspects : CRUD, List, FindOne, Count, Exists, Distinct
π₯ Bulk insert, Bulk delete, Bulk read
π₯ Relations
π₯ Pagination
π₯ Sorting
π₯ Column filtering - Fields
π₯ Row filtering - Where
π₯ Aggregate functions
π₯ Group By, Having (as query params)
π₯ Group By, Having (as a separate API)
π₯ Multiple group by in one API
π₯ Chart API for numeric column
π₯ Auto Chart API - (a gift for lazy while prototyping)
π₯ XJOIN - (Supports any number of JOINS)
π₯ Supports views
π₯ Prototyping (features available when using local MySql server only)
π₯ Run dynamic queries
π₯ Upload single file
π₯ Upload multiple files
π₯ Download file
π₯ Health and version apis
π₯ Use more than one CPU Cores
π₯ Docker support and Nginx reverse proxy config
π₯ AWS Lambda Example
In no respect is Xmysql is a complete MVC framework yet.
I am currently working on a full feature set of Xmysql which has below features
π₯ Builtin: Authentication, Social Authorization, Sessions, Email, File Scaffolding, Storage
π₯ Payment: Stripe
π₯ Client: Vuejs/Nuxt + Vuetify
π₯ Cloud : Google App Engine
π₯ Microservices: Google cloud functions
π₯ Background tasks: Google Pubsub and Cloud functions
Please let me know your feedback and questions on
> what can be improved ?
Thank you so much for your time.
Hi, wonderful tool, but I strongly need to use JWT authorization? Do you have any idea if and how I can add it? Is it something that you're already planning to integrate and release as a next feature?
Report
Although didn't try it yet, it looks awesome and an authentication mechanism will definitely make it much more usable.
Report
this product is great. One question ,how to write xmysql lines for below query.
"SELECT SUM(payment), country,city groupby coutnry,city"
Report
I need help, I am trying to fire xmysql running from google cloud sql accessing a mysql8 db, where can I find the pdf of documents for this please.
I can be reached at 818 645 5295 or r mander. ca@g mail.com
Awesome idea, awesome execution! I hope authentication and protected routes are on the roadmap π
Report
@o1lab Hi, really a wonderful tool, but I strongly need to use it with JWT authorization...Do you have any idea if and how I can add it? Is it something that you're already planning to integrate and release as a next feature?
NocoDB
NocoDB
NocoDB
Keep up the amazing work!
Pros:Very helpful for UI dev work
Cons:JWT auth would be amazing.
PH Higher-Lower Game
Songbox
NocoDB