PostgreSQL

[Morgan Dennithorne]

Hi,

I need to get BugLog working with PostgreSQL,  I've already done a bit of work against the 1.5 code. 

I thought I'd fork the latest on GitHub so my changes can be merged in.

Any ideas, tip before I get started?

Morgan.

[Oscar Arevalo]

Hi Morgan,

The DB stuff is largely unchanged from 1.5 to 1.6, so you shouldn't have much problem there.

Pretty much all database interaction is handled by an abstraction layer in /bugLog/components/lib/dao, and the "meat" of the SQL syntax is pretty much centralized in dbDataProvider.cfc; so if the sql syntax changes are minimal, then you can maybe get away with just adding a couple of IF/THEN statements here and there, but if the changes are more significant then you could try having a different dataProvider child object.

Here is an old blog post describing this library: 

Aside from that, there is a large SELECT statement in entryFinder which may or may not need to be adjusted for SQL syntax. Also the util/includes directory have a few templates with small SQL statements. There are used to generate the Digest.

Other than that, just let me know if you hit any roadblocks and have any questions or suggestions about the code.

Oscar

--
Oscar Arevalo

http://about.me/oarevalo
http://www.coldbricks.com - Content Management System
http://www.oscararevalo.com - My Blog

[Oscar Arevalo]

Sorry, forgot to add the link to the dao library:

http://www.oscararevalo.com/index.cfm/2007/11/28/Using-Polymorphism-and-Inheritance-to-Build-a-Switchable-Data-Access-Layer 

Oscar