in reply to Should it be database independent?

> It seems that the Perl people ... will try to hide any SQL

Depends on your programming style. If you use straight DBI instead of CDBI, you can do whatever you want with the SQL.

> and make sure you are database independent

Again, that depends on your programming style. DBI is designed to provide a maximum of database independence without compromising the ability to use database specific features when needed.

Replies are listed 'Best First'.
Re^2: Should it be database independent?
by cbrandtbuffalo (Deacon) on Mar 22, 2005 at 19:15 UTC
    Just to be clear, CDBI does not prevent you from writing custom SQL, it just provides an abstraction layer. You can write any SQL statement you want (including complex joins, etc.) into a CDBI class and reference it from your code.

    We use CDBI as our abstraction layer, sometimes with complex SQL. The advantage here is the SQL is re-usable and all in one place. We use Oracle, but generally try to avoid 'special' Oracle features.

[reply]

In Section Meditations