Authors: , Sylver-John Imhoff Mathieu Morainville When we finished our last project that used as the backend we realized that there was no MySQL equivalent of this really cool . So we wondered if we could do something similar but instead of relying on GraphQL we would just create some REST endpoints and a MySQL database. The idea of Poorless was born. Freatle Graphcool BaaS Why it looked like a great idea When you start a project from scratch and you need a database, you have to install a server locally like MariaDB with Xampp on Windows. This is a waste of time when you are building a side project. With a serverless solution, you just have to call an API to manage your data. How I built Poorless As Poorless should be an API, there is only one good choice: Go. Using the small but good framework , you can build a small API in less than 1 day. The plan is really simple: Echo a user needs to manage some data so he goes to the Poorless website, he fills a form to create his database and his tables by entering the entities he wants to create alongside with their properties, the API receives the request from the user, creates the database and the tables using a UUID, the API returns the UUID to the user which can then access his private database. e.GET("/:key/table/:table", handler.GetTable)e.GET("/:key/table/:table/:id", handler.GetRowById)e.GET("/:key/table/:table/:filter/:id", handler.GetFilteredRow)e.POST("/:key/table/:table", handler.AddRow)e.PUT("/:key/table/:table/:id", handler.AddRow)e.DELETE("/:key/table/:table", handler.DeleteTable)e.DELETE("/:key/table/:table/:id", handler.DeleteTable)e.DELETE("/:key/table/:table/:filter/:id", handler.DeleteTable) On the API side, we have a MySQL server running where we store the user’s data. It’s really easy to access and manage the MySQL server with Go. CreateDatabase(db *****sql.DB, uid ) {log.Println("Create Database " uid)_, err db.Query("Create Database " uid) err {log.Fatal(err)}} /* Here we create the user's database */ func string + := + if != nil The limits of Poorless As you saw above, we create the routes which the user can call to manage his data. As this is a REST API, one route = one entity. So this route e.GET("/:key/table/:table", handler.GetTable) handled by GetTable(c echo.Context) {userId c.Param("key")table c.Param("table") func error := := config, configErr util.GetConfig("./config.json") configErr {log.Fatal(configErr)} := if != nil db service.GetDatabaseConnexion(config, userId)data service.FindAll(db, table) := := c.JSON(http.StatusOK, data)} return matches with FindAll(db *****sql.DB, tableName ) *****sql.Rows{query "Select * From " tableNamelog.Print(query)rows, err db.Query(query) err {log.Fatal(err)} rows} /* Here we find all row in the table */ func string := + := if != nil return Do you see the problem? . You are limited If you only need to select some fields, add a count, a groupby, etc. you can’t. If you use Poorless, you are limited to the routes that we create. So I asked myself: How can I let the user customize the request without having to write more routes? Well the solution already exists and I love it: GraphQL. With GraphQL, as a client, you tell to the API what you need. With only one request, you can retrieve many entities, add as many filter as you want, etc. Should you use GraphQL ? Yes. I’m not convinced. Well read and . :) this this Being afraid of giving up Imagine you want to create an app, you hire some mobile developers who cost you 10,000 $ each month. Five months already passed and you need two more months to end the project. But your idea leaked at the beginning of the project without you knowing it. Someone stole it and released the app. Should you invest 20,000 $ to end your project to release an app that already exists? This is called . In this case you should stop the app production. Your money is already spent and releasing the app two months later will only make you waste more money. sunk cost So did I worked for nothing? Of course you didn’t. Even if you don’t reach your goal and even if you don’t realize it, you have learn something. Giving up your project will not remove this knowledge and experience from your brain.

Alongside

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

Why I gave up my almost done project

Too Long; Didn't Read

Company Mentioned

Pulsar

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

Why I gave up my almost done project

Too Long; Didn't Read

Company Mentioned

Pulsar

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES