[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

--- Comment #7 from Jared Camins-Esakov <jcamins at 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.