Database connection script generator

Updated on April 5, 2017 in  [S] Works in progress
Share on Facebook0Tweet about this on TwitterShare on Google+0Share on Reddit0
6 on April 4, 2017

Hey all,

This post will probably be a bit shorter then I first imagined, something went second time writing this :/

What is this?
For the past few days I’ve been working on a custom editor that allows the user to setup a database, tables and columns and that give the user the ability to generate a .sql script to import on your webserver, as well as generating the php script that will get the values from the database and generate a C# script that connects to the php script.

What can this do right now?
Right now it can without errors, for as far as I know, generate the sql script, this has been tested with a MySQL database I have no knowledge of normal SQL so I have no idea if that works.

Planned features:

  • Generate the php script
  • Generate the C# script

Features that might be added:

  • More database support
  • The ability to return JSON
  • And probably some other things

Screenshots:



This is how the generated sql script looks:

  • Liked by
  • maxartz15
  • Leon Laci
  • Dion Dokter
Reply
1 on April 4, 2017

Ooh that’s pretty cool!
Which dialect do you target? Mysql, Sqlite, …?

Guru
on April 4, 2017

Right now only MySQL since that is basically the only I have knowledge of, but I would like to add support for others later on.

Show more replies
  • Liked by
Reply
Cancel
2 on April 4, 2017

Nice, too bad you did this now, if you have been here earlier with this project then it would be helpful for me. Who knows, I will probably run into a part where I would need databases.

Wise
on April 4, 2017

Also, are you going to publish to the asset store?

Guru
on April 4, 2017

If I can get it to be accepted for the asset store then yes

Show more replies
  • Liked by
Reply
Cancel
0 on April 5, 2017

Looks great!

  • Liked by
Reply
Cancel