Xmysql

🚀 One command to generate REST APIs for any MySql Database.

get it
#5 Product of the DayJune 16, 2018

APIS AND FEATURES

🔥 Generates API for ANY MySql database

🔥 Powerful & Intuitive query interface

🔥 Usual suspects: CRUD, List, Count, Exists, Distinct

🔥 Relations, Paging, Sorting, Filtering (rows & columns too)

🔥 Bulk ops: insert-read-delete

🔥 Aggregate functions, Group By,Chart API

🔥 Multiple table joins !!

🔥 Supports Docker & AWS Lambda

Around the web

Reviews

AkhilSinghT
Deniz Vatan
Ed John
 +1 review

Discussion

Hunter
Makers
You need to become a Contributor to join the discussion - Find out how.
o1lab
o1labMaker@o1lab · software
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.
o1lab
o1labMaker@o1lab · software
Xmysql is writting in Node.js ❤️ Setup npm install -g xmysql xmysql -u dbUsername -p dbPassword -d databaseName Happy hackery!
o1lab
o1labMaker@o1lab · software
* written :)
Roland Horváth
Roland Horváth@hroland_ · 17yo developer, designer, WWDC scholar
Awesome idea, awesome execution! I hope authentication and protected routes are on the roadmap 👍
Mick
Mick@mickc79 · Founder of SongBox.Rocks
If this actually does what it says on the tin then I’m very excited to try it out.
o1lab
o1labMaker@o1lab · software
@mickc79 : Please do try - it won't take more than 30 seconds right from installation :) (assuming you have node and mysql installed)
Brad Bitler
Brad Bitler@bitler · Principal UX at Autodesk
Very cool--thanks!
Umut Muhaddisoğlu
Umut Muhaddisoğlu@umut_muhaddisoglu
Although didn't try it yet, it looks awesome and an authentication mechanism will definitely make it much more usable.