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:
“She isn’t harassed. She’s busy, and it’s glamorous to be busy. Indeed, the image of the on- the-go working mother is very like the glamorous image of the busy top executive. The scarcity of the working mother’s time seems like the scarcity of the top executive’s time.... The analogy between the busy working mother and the busy top executive obscures the wage gap between them at work, and their different amounts of backstage support at home.”
—Arlie Hochschild (20th century)