Databasing like mad

I've been playing around with databases. We are looking to revamp or replace the Computerbank database (postgres/mysql/qt app) so I wanted to get a feel for what is out there.

My foray into LAMP has begun. I turned my lappy into a LAMP server even though I was warned against doing such things (it's my only computer). So far so good, the Computerbank distro is cool to build on.

I installed apache, plone, mysql, postgres 7.4 and 8.1, phpmyadmin, ruby on rails, probably some other stuff and some databases. Tiny erp, Bizar Shop, Free Geek Db and Zen Shopping Cart.

I couldn't get the Free Geek db to fully work, so I hope to catch up with the free geek folks. Maybe I don't have a full copy. Who knows, I have never used ruby, so I may not have it configured correctly. I just followed a how to. As Free Geek are similar to us it makes sense to see if their database can be modified to suit our needs.

I still need to play with Tiny erp, it seemed to have lots in it. So much I was overwhelmed. Bizar shop and Zen Shopping cart both look nice and easy to use but don't meet our needs enough.

I'll be looking at PHP Myinventory next and any others that people might suggest. One thing I don't plan on doing is writing a database from scratch. Sounds like too much work for me right now. :)