The TroZone

Applications grow and they grow in no time. Every application begins small and then starts adding in new functionalities. Let us say that you are running a small website which deals with classified ads. The service is free in the beginning. Slowly your website catches up and you want to start a paid service. Now is the problem - you have to manage financial transactions as well as the regular data your site hosts. However, now there is a risk - if for any reason, your main site database crashes or is hacked into, you are risking your financial transactions data as well!

Web applications, just like any other type of application grow and when they grow fast, you will find yourself in need of more than one database before you will know it yourself! There are multiple reasons for that. You might be needing to separate your products database from the one where you do your financial transactions. You might be having another one for a customer care front end and what not! Now, there is a huge possibility that the types of database you use will vary. For example, let us say you created your basic web application in MySQL but now, you want a more robust one for financial transactions and you want to go for PostgreSQL or may be Microsoft SQL Server!With QCubed, you will not face a problem! The good thing about RDBMS systems is SQL. In most of the cases, the SQL for all the databases will remain same and hence, the QCubed's querying mechanism (it's called QQuery) will take care of that!

QCubed supports the following databases:

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:

1. 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.
2. 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!
3. 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!

In the last part we examined the way to extract out the Query String from the URL. However, as is known well, the query string in itself is useless. It is the keys and their values that matter! This post is just about that - how to extract the names of the keys and their values from the query string received on the URL (via GET request). We will not cover how to read the query string as we have done that already in the last program. Let us bring in a few new goodies into that program and introduce a way to extract and print the values in the URL.

QCubed PHP Framework features a lot of things really useful for helping you build your web application real fast. Here are some of those features: