There are multiple ways in which QCubed helps you get along with the database of your choice! This section covers the 'M' or the Model part of the QCubed Documentation and tells you about how QCubed helps you to get going with your databases. Here are the features in brief:
- Multiple Database types supported: QCubed supports MySQL, PostgreSQL and SQLite on the open source side and Oracle, Microsoft SQL Server and Informix on the closed source side.
- Multiple Databases (in number) supported: As a web application expands its wings, it is going to be in need of multiple databases at one time. QCubed comes ready with that and supports more virtually unlimited number of databases at a time!
- Code Generation: One of the most salient features of QCubed is that it generates code for all your tables in all your databases. You receive a lot of good things from in here!
- ORM Classes: QCubed is a ORM (or Object Relational Mapping) architecture and you do not need to have a object relational database for that. QCubed will produce ORM Classes on your regular relational database and make sure that you are accessing your tables as classes and the rows in them as objects of that class. Simple and easy!
- ORM Relationships: ORM has one thing which makes it ORM - the Relation Mapping. QCubed will create the PHP code for your classes to allow you map the database objects in them (and in a lot of ways).
- Object Caching: QCubed allows you to use memcached to save single rows from your database as PHP Objects. This saves a lot of time for highly trafficked websites. You will not face any worries about growing big!
- Flexible Querying: With QQurey (the QCubed mechanism to automatically create SQL queries for you), there is hardly any SQL Queries that you would be writing but QCubed would anyway allow you to write your own SQL queries and interpret them as you want!
- Automated Data entry forms (drafts): When you do the codegen with QCubed, you get already made data entry forms (individual pages) as well as panels (that you can place in your site safely). No need to create forms for you database, sir! Modify them if you wish to and use them as you want! It is all flexible!
- Dedicated Control Creation: You want to show only one data entry field from your 100 column table in a database? No problems - you can get that - all the columns in all tables of all databases get their own controls and they will be tailored to handle exceptions and wrong data for you (integer fields will not accept characters, boolean fields appear as checkboxes ans so on).
- Meta Controls: These are the dedicated control created which we mentioned above. They make up the panels and drafts as well! To show data or to receive data for any field is just one line away (or may be 2 if you wanted to change a thing).
With all that in your hand, you will feel comfortable with your database, I am sure!