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.

On the "off chance" that you actually liked this post,
how about liking us on Facebook?...

Powered By Facebook Like Post Plugin