Closed

database tables generator

This project received 16 bids from talented freelancers with an average bid price of $135 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
16
Project Description

Hello,

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)

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