pyrogyra developer blog

Its been a while since I've worked on Pyrogyra (work got in the way, and the holidays, and I went on a medical science research binge, and then I finished off the 1st draft of my screenplay - all of which you can read about here if you want). Oh, and I put together a quick website for my friends over at Pontevecchio Italian Bistro in Seattle, which you can find at www.pontevecchioitalianbistro.com, or alternatively at www.aplaceforlovers.com.

*phew*

So how far have I gotten?

Well, here's the database design so far:

I'm using MicroOlap Database Designer for MySql which is frankly quite awesome, and a steal at the price. (It even has a 31 day full-feature evaluation period). If you're doing MySql database design, I can highly recommend it - it'll make doing this kind of thing much easier than hacking it together by hand.

I've still got to figure out my foreign key relationships a little better, and I need to figure out triggers at some point soon, but other than that, it's starting to shape up nicely.

Turquoise is reviews, gold is user account info, red is friendship status, light blue (hard to tell) is the inbox implementation, and the rest is... well... classified right now :)

Most of the tables are done... I still need to add 4 or 5, and then I'll be ready to start pushing data into it, and starting to make the ASP side live.

Left to do: Tables for thumbnail management, Foreign Key constraints, and a bit of decision making on how many more features I want ready to roll when the site goes live.

Labels: site implementation

# posted by Simon Cooke @ 12:03 AM 0 Comments