yourarthere.net

Database design – front page

Posted in coding, design, organization by callibeth on February 5, 2010

Brittany and I collaborated on creately.com to design the database structure needed for the front page of the new design. Link to the design is here: http://create.ly/g5b4d1z73.

If you want to join the collaboration, sign up at creately.com, let us know your username, and we’ll share the document with you.

Advertisements
Tagged with: , , ,

3 Responses

Subscribe to comments with RSS.

  1. Owen said, on February 15, 2010 at 7:34 pm

    Looks wonderful! If only creately.com could export an .sql dump file from this graphic.

  2. callibeth said, on February 16, 2010 at 6:22 am

    Actually, it *can* be exported as XML data. I wonder if it’s possible to export the XML to an SQL? I don’t know enough about SQL to know (yet).

    Don’t you have Navicat, Owen? Would this tutorial do it?:
    http://www.stardeveloper.com/articles/display.html?article=2003101901&page=1

  3. Owen said, on February 21, 2010 at 10:44 pm

    Yeah, but XML is only a document type which would include the content with the names of the fields. High-end database design applications allow you to export SQL queries from your GUI that create databases, with tables, with fields and corresponding data types automatically.
    http://www.w3schools.com/sql/sql_create_table.asp

    Speaking of Navicat, its great for what it does but I’ve found its UI very hard to use. I just transferred the Art Review system to a new server and had an impossible time getting Navicat to run a MySQL dump query.

    I would try Sequel Pro instead. Its free, does everything Navicat does, but is easier to use, doesn’t crash when your computer goes to sleep (or you close your laptop), and moving data was so much easier. And did I mention free?
    http://www.sequelpro.com/


Comments are closed.

%d bloggers like this: