database tables generator

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 16

Project Description


I want to do an application that generators the sql for creating a table by simply typing up text instead of having to use phpmyadmin which is a bit slow, so basically the requirement is as follows:

- I would type the tables I need in a simple text format such as:

cars: id, name, description, image

the column ' : ' would tell the script that what is before it is the table name, and commas ',' tell the script it's a column name

- the trick is that as I type, I want the script to automatically guess what is the column type, so for example after I finish typing the above, the script would have updated the display to be something like this:

cars: id int-autoinc-primary, name varchar(255), description text, image varchar(255)

it is a bit like facebook when you tag people

The script will use something like jquery's autocomplete plugin,

if I click on one of the field types or press backspace, I want be able to edit the column types or select from a predefined list

I want the text input to be color coded, so color coding table names, column names, and column types.

For example the above:

cars would have a gray background,

id, name, description, and image would be have a green background,

and int-auto, varchar, text would have a pink background

I should be able to paste a string of text and the script will automatically figure out what it is, so for example if I paste this:

cars: id, name, description, image ; colors: id, name

the script will automiatcally know that there are 2 tables and with the appropriate column types

Here are some usable scripts I found that can be good reference and have the looks & feel I want:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Budget is less than 50$ as I think this shouldn't take more than 5 hours of work (I am an experienced developer)

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online