Made the switch from MySQL to Postgres!

Jeff · 01-16-2004, 07:07 PM

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!!!!

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!

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://www.labanimal.com/

~See you at the SCIWire-used-to-be-paralyzed Reunion

~

mattblan · 01-17-2004, 08:13 PM

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

Jeff · 01-19-2004, 12:06 PM

Thanks, Matt.

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

~

01-16-2004, 07:07 PM	#1
Jeff Senior Member Join Date: Jul 2001 Location: North Brunswick, NJ, USA Posts: 6,846	Made the switch from MySQL to Postgres! 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!!!! 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! 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://www.labanimal.com/ ~See you at the SCIWire-used-to-be-paralyzed Reunion ~

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

01-17-2004, 08:13 PM	#2
mattblan Senior Member Join Date: Oct 2001 Location: N. California Posts: 1,095	Congratulations, Jeff. We appreciate all the work you do. Way to keep it BSD baby.

01-19-2004, 12:06 PM	#3
Jeff Senior Member Join Date: Jul 2001 Location: North Brunswick, NJ, USA Posts: 6,846	Thanks, Matt. 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 ~