At the last PHP Class I held, it was suggested that I develop some of the databases we’ll be using to organize our businesses on OpenOffice Base. Which is the Database Application of OpenOffice (I only use OpenOffice).
There is a great amount of info on getting up and running with this application and I did get as far as hooking together all my relational tables to generate the correct queries. So for those of you that attend my classes, Yes I gave it a go.
There are some little differences ( as expected ) between the SQL, it wants to generate as opposed to MYSQL which I’m more familiar with. I Never really got too deep into using Microsoft’s Access only because I didn’t have a real understanding of proper Database Design at the time.
Time has fixed that. I’m at home with MySQL and Stored procedures. Not everyones cup of tea but I enjoy creating useful, safe applications with it. The only problem is with the Data Sensitive stuff is you really don’t want up on a Website. There are various ways to make a Desktop application ( NOT Windows only based…) that works on all platforms and OpenOffice is a quick and easy and FREE way to do just that.
Anyway, I’ve got somewhere, rather quickly with it and it’s probably a very good platform for explaining the correct way to design a Database. I was impressed.
Now I’ve just got to get a handle on the interface ( forms ) and interacting correctly with the tables and enforce proper data entry rules across tables. Should be a fun excercise.
So while I’m in Hospital this Saturday (my time) getting my Infususion, hopefully the wireless connection will hold up and I can demonstrate database basics a lot more clearly. Got to love Desktop sharing conference calls.
A Resource I use and recommend
