My favorites | Sign in
Project Hosting will be READ-ONLY Thursday at 3:00pm UTC for up to 3 hours for network maintenance.
Project Home Downloads Wiki Issues Source
Search
for
Extending  
Adding new functionality to WWW SQL Designer
Updated Jun 19, 2011 by ondrej.zara

Extending

Many aspects of WWW SQL Designer can be customized and enhanced. If you manage to create a new locale / db / backend, feel free to send it to me. I will include your feature in a distribution archive.

CSS

Visual properties of the application can be tuned by editing files in css/ subdirectory.

Locale

Locales can be edited and added in locale/ subdirectory. New locales must be also registered in js/config.js.

Databases

Supported databases (their datatypes and XSLT template) are stored in db/ subdirectory. Each database has a datatype definition file (datatypes.xml) and a XSL transformation (output.xsl). New databases must be also registered in js/config.js.

Backends

Serverside backends allow you to save, load, list and import DB designs. They are written in a serverside scripting language and communicate via HTTP requests. Backends are stored in backend/ subdirectory. A brief summary of backend API follows:

  • Saving

Request: POST ?action=save&keyword=somename, XML data contained in POST body

Valid responses: HTTP/201 Created, HTTP/500 Internal Server Error, HTTP/503 Service Unavailable
  • Loading

Request: GET ?action=load&keyword=somename

Valid responses: HTTP/200 OK (loaded XML in response body), HTTP/404 Not Found, HTTP/503 Service Unavailable
  • Listing

Request: GET ?action=list

Valid responses: HTTP/200 OK (list of available designs separated by newlines in response body), HTTP/503 Service Unavailable
  • Importing

Request: GET ?action=import

Valid responses: HTTP/200 OK (imported data in response body), HTTP/503 Service Unavailable

For every action mentioned, the backend may also return HTTP/501 Not Implemented, meaning that this action is not supported by the backend.

Comment by reik...@gmail.com, Mar 7, 2009

muy bueno su aplicativo, super ligero y rapido, los felicitio,ustedes son las personas ke hacen de este mundo un lugar mejor. FELICITACIONES

Comment by elgranre...@gmail.com, Aug 17, 2009

Great work. Just thinking it could be extended to be collaborative... maybe I'll give it a thought.

Congratulations.

Comment by rodolfoa...@gmail.com, Feb 12, 2010

it's fantastic peace of work. Really usefull and simple. Just a little thing to add to the wish list: the posibility to add comments.

Comment by trock...@gmail.com, Mar 25, 2010

ce mieux, s'il on peut affiché le type devant le champ sa sera bine

Comment by trock...@gmail.com, Mar 25, 2010

ou le commentaire devant le champ key étranger

exemple :
table badge et table vendeur
id_badge (num_badge,code_activation) récupérer les champs (num_badge,code_activation) de la table badge en utilisant le key de badge id_badge
comme ça on connais bien le champ on a besoin sans retourne vers le cahier du charge et merci un outils bien avant un développement, aide beaucoup Moi je ne trouve pas ce temps pour le personnalisé et ajouter cette nouvelle fonctionnalité qui aide beaucoup.

Comment by luca...@gmail.com, Apr 30, 2010

It would be great if the javascript libraries could be ported to jQuery or similar - I have a ton of ideas for customising the interface, but as it is written in a one-off library, it's hard to reverse-engineer and extend.

Comment by secram...@gmail.com, May 7, 2010

Hello Ondrej, what is your meaning about storge via locale-storing in the browser.

Comment by project member ondrej.zara, May 7, 2010

Yes, localStorage is generally a very good idea. Please create an issue for this feature, as I will probably implement it.

Comment by legrand....@gmail.com, May 12, 2010

Very nice application ! Thanks for your work !

Comment by porka...@gmail.com, Jul 30, 2010

Very good, I like it !! Perhaps an import from SQL file ? ;)

Keep up the good work.

Comment by lasse.ku...@gmail.com, Dec 1, 2010

Hi

I found this tool excellent! Just the thing i've been looking for. Would it be possible to add functionality which would save the design I've made as image (jpeg/pdf/whatever)?

Comment by project member ondrej.zara, Dec 3, 2010

In theory, yes. However, that would require either

a) server-side drawing support, OR b) drawing onto <canvas>.

Both of these are very time-intensive and my time is pretty limited these days, so don't expect this in close future :/

Comment by lpan...@gmail.com, Dec 23, 2010

This Application is EXCELLENT!!! It is THE BEST DB deginer app: super FAST and with just about all the really required functionalities.

Thanks for sharing!

Comment by kramitdf...@gmail.com, Feb 3, 2011

I've coded up an aspx backend for use on iis servers without a php interpreter. Please let me know if you want the code.

Comment by project member ondrej.zara, Feb 3, 2011

Yes please. Create a new issue and attach the code; I will add that to repository as soon as I have some time.

Comment by daniel....@gmail.com, Feb 8, 2011

I've got a working ColdFusion?-SQL Server backend. I want to continue to work on it and make it compatible with the different versions of SQL Server. I also plan on coding a PHP-SQL Server backend. Should I send you the code that I have completed already or wait until I have all of my contributions done? Thanks for making this great project!

Comment by project member ondrej.zara, Feb 8, 2011

Please send me the code when it reaches "working" state - some features (such as import) might be ommited.

Comment by rafher...@gmail.com, Feb 14, 2011

Very nice ! Thanks for your work !

Comment by i...@kunstnet.de, Feb 22, 2011

What do u think about a visuell import helper function ;) I want connect old and new fields, to import the old data into the new db. ok, its a little bit much, but i needed. ;) For future versions it may be interesting?

table1.title to NewTable?.Name table1.id to NewTable?.TagId? table2.text to NewTable?.Body

on table1.id = table2.id

CREATE TABLE  NewTable ( `Id` INT( 11 ) , `Name` varchar(200), `TagId` INT( 11 ), `Body` varchar(255),
) ;
INSERT INTO  NewTable SELECT a.title, a.id, b.text FROM table1 as a INNER JOIN table2 as b on (a.id = b.id);
 ;}}}
Comment by iprockb...@gmail.com, Apr 26, 2011

ASDASDASDASDASDDDDDDDDDDDDDDDDDD

Comment by shotashv...@gmail.com, Jul 19, 2011

i have made my style for google chrome :-)

http://stylebot.me/styles/510

Comment by RobertVP...@gmail.com, Jan 14, 2012

This is awesome! Thank you for creating this incredible package!

Comment by willdavidwarren, Jan 31, 2012

Hi Ondrej

I love this tool.

One thing I would love to see is "Export to PDF" or "Export to Image" or something of that nature.

If it had the export to pdf option, then this would go from a basic small db designer to an enterprise tool that rivals the most expensive db designer tools!

Thanks

Comment by project member ondrej.zara, Jan 31, 2012

Hi,

you might be interested in reading/watching Issue 70: http://code.google.com/p/wwwsqldesigner/issues/detail?id=70


Sign in to add a comment
Powered by Google Project Hosting