[Koha-bugs] [Bug 7365] Koha uses MySQL

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365

stephane.delaune at biblibre.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Attachment #6851|0                           |1
        is obsolete|                            |

--- Comment #5 from stephane.delaune at biblibre.com ---
Created attachment 8428
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8428&action=edit
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.

-- 
You are receiving this mail because:
You are watching all bug changes.