Xmysql

πŸš€ One command to generate REST APIs for any MySql Database.

#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

Discussion
Would you recommend this product?
6 Reviews5.0/5
Maker
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.
Upvote (2)Share
Maker
Xmysql is writting in Node.js ❀️ Setup npm install -g xmysql xmysql -u dbUsername -p dbPassword -d databaseName Happy hackery!
Maker
* written :)
Awesome idea, awesome execution! I hope authentication and protected routes are on the roadmap πŸ‘
Upvote (3)Share
@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?
If this actually does what it says on the tin then I’m very excited to try it out.
Upvote (1)Share
Maker
@mickc79 : Please do try - it won't take more than 30 seconds right from installation :) (assuming you have node and mysql installed)
Very cool--thanks!
Upvote (1)Share
Although didn't try it yet, it looks awesome and an authentication mechanism will definitely make it much more usable.
Upvote (1)Share