Sign in

Google App Engine

« Back to gallery

GAE SQL Designer

By: Jason W. Miller - Nov 07, 2008   -     

GAE SQL Designer

The application allows you to 1. Draw E-R designs, 2. Edit tables and rows, 3. Manage keys, 4. Create relations (FK constraints), 5. Save & Load designs (in progress),6. Import DB schema. Ported to App Engine by Jason W. Miller Based Heavly on WWW SQL Designer by Ondrej Zara Tested in the following browsers: * Firefox 2.x+ * Internet Explorer 6+ * Safari 3 * Opera 9.x * Konqueror 3.5.x

http://gaesql.appspot.com

Tags: SQL Schema MySQL Database web2py sqliteMSSQL

Comments (17)

Title

Rating

Comments

Your name

 

Please make sure your comments are useful and informative.

Good Suggestion    - Jason W. Miller - Nov. 11, 2008

Working on adding GQL and save/load

GOOD!    - Jason - Nov. 09, 2008

but,if it can generate GQL ,it'll be better !

Keyword spam?    -  interface@p3k.org - Dec. 15, 2008

This is an impressing piece of code but I am confused by the two <div> elements (both id="keywords") containing keyword spam or the like...? To me that looks a little bit suspicious.

You are my God    -  davide.rognoni - Nov. 08, 2008

A super GAE application. Thank You

Fixed bug on creating a table    - Jason W. Miller - Dec. 01, 2008

fjanon, I fixed the bug you reported.

Great!    -  harlley - Nov. 12, 2008

Looking into bug reported by fjanon    - Jason W. Miller - Dec. 01, 2008

I am able to re-create, looking into what changed.

Problem importing XML    -  lagniappe12 - Dec. 04, 2008

I'm having a problem importing XML. I first exported, copied & pasted into a Google Doc. When I try to copy & paste back from my Google doc, I get an "XML Error: Null document" error. The XML validates so I'm not sure what the problem is. This is a great app, by the way, I love it, I'm just having a slight problem with my workflow sans a save functionality.

Is it supposed to work with FF 3.0.4 on WinXP?    -  fjanon - Nov. 26, 2008

I clicked on "Create Table" and cannot figure out what to do next to create it in the grid. I clicked, dragged, right-clicked... nothing.

a    -  Mia1314 - Dec. 08, 2008

a

Great!    - JorgeRS - Jan. 13, 2009

Great app! Congratulations!

Good Work    -  alanparsons - Dec. 24, 2008

It allows you to create a foreing key to the same table.

Good job ! and keep up the progress    - simo - Jan. 18, 2009

Is the source code available for this App ? just curious how some of the visual functionality was accomplished. Again, Good job.

Any documentation or tutorials?    - -Thanh Lam - Jan. 15, 2009

It looks like an interesting example of the Google App Eng. Any documentation on how to use this would be appreciated! I'd like also to learn the code. Are all this written with python? Thanks for sharing the application.

-    -  simo - Jan. 18, 2009

-

Very Nice App!    -  dan.x.shepherd@googlemail.com - Feb. 21, 2009

I really like this application, the interface makes creating tables very easy, much cleaner interface than the phpmyadmin thing and the fact that relations can be drawn to connect keys makes the overall structure of the database very obvious. Although, Load and Save have not been implemented yet it is still possible to copy and past the sql and save it.

XML import    - mikele - March 02, 2009

Hi there.. how can I automatically generate the XML describing an already existing MySQL schema? I'm on OSX.. many thanks!!!!!