Made the switch from MySQL to Postgres!

[Jeff]

Phew!!! Using the ADOdb library I was able to go database-independent with the SCI-Base.....the Spinal Cord Injury Database. Fired up a Postgres backend and rooted out non-standard SQL.....and bingo!!!! http://sci.rutgers.edu/forum/images/smilies/smile.gif

Postgres has more sophisticated query abilities, stored procedures and triggers, transaction support and views! Views will help us use reporting tools that cannot handle elaborate queries. We'll simply code the query as the select statement behind a view. Then the reporting tool will see the view as a single table. Life is good! http://sci.rutgers.edu/forum/images/smilies/smile.gif http://sci.rutgers.edu/forum/images/smilies/smile.gif

We got published in Lab Animal magazine with an article about this system. It's the first ever being published for me. Our article will be in the March issue. http://sci.rutgers.edu/forum/images/smilies/smile.gif

http://www.labanimal.com/

~See you at the SCIWire-used-to-be-paralyzed Reunion http://www.stopstart.fsnet.co.uk/smilie/wavey.gif ~

[mattblan]

Congratulations, Jeff. We appreciate all the work you do. Way to keep it BSD baby.

[Jeff]

Thanks, Matt. http://sci.rutgers.edu/forum/images/smilies/smile.gif

We're actually loving the BSD backend of OSX. And Apple's rackserver delivers a lot of bang for the buck. OSX being BSD is a great platform for open source and the graphical admin tools that Apple is adding are really starting to improve.

~See you at the SCIWire-used-to-be-paralyzed Reunion http://www.stopstart.fsnet.co.uk/smilie/wavey.gif ~