Catalyst (software) - Database Support

Database Support

Catalyst can run using any database supported by Perl's DBI (this means almost anything, even a CSV file), but a proper RDBMS or ODBMS is recommended. The database access is entirely abstracted from the programmer's point of view and Catalyst, through one of its model classes, handles access to all databases automatically – though, if needed, using direct SQL queries is possible. This enables database-neutrality, application portability over different database systems, and usability of pre-existing databases for Catalyst application development as much as possible, though due to different feature sets of the RDBMSes, it is not completely guaranteed by the framework alone. Several different RDBMS systems are supported, including MySQL, PostgreSQL, SQLite, IBM DB2, Oracle and Microsoft SQL Server. For ODBMSes, there is explicit support for KiokuDB via Catalyst::Model::KiokuDB. The Model abstraction allows databases of any nature to be accessed via Catalyst::Model::Adaptor.

Many Catalyst-based projects use DBIx::Class as the ORM layer, which provides further abstraction of SQL queries, using a resultset-based API with transparent support for arbitrary joins and other features.

Read more about this topic:  Catalyst (software)

Famous quotes containing the word support:

    The confirmation of Clarence Thomas, one of the most conservative voices to be added to the [Supreme] Court in recent memory, carries a sobering message for the African- American community.... As he begins to make his mark upon the lives of African Americans, we must acknowledge that his successful nomination is due in no small measure to the support he received from black Americans.
    Kimberly Crenshaw (b. 1959)