http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365 --- Comment #7 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- (In reply to comment #5)
Created attachment 8428 [details] Add DBQ, a small module to generate DB specific SQL code
To eliminate database specific SQL idoms (aka MySQLisms) it is necessary to either use a standard SQL form like 'CAST(now() as date)' instead of the non-standard MySQLism 'CURDATE()', or to generate a database specific idiom where no such standard form exists (e.g. to get the list of column names from a table).
The new DBQ module is a generator for DB specific SQL idioms and comes with an implementatio for both MySQL and PostgreSQL. Generating the SQL idioms this way is the least invasive form of getting DB independence, as no large changes to the database layer are required. Please note that DBQ->dbq returns a singleton.
DBQ stands for Database Query. Name, usage patterns, and implementation discussed and agreed upon with many during the Marseille Hackfest 2012.
Why don't we just use one of the existing database abstraction layers available for Perl? Then someone could use a completely different database, if they so desired. -- You are receiving this mail because: You are watching all bug changes.