Database Configuration
indoglobal.com
has a complete and easy to use database system. At the moment we support two popular database servers, MySQL and PostgreSQL.
MySQL is the most commonly used database for use with web environment. A lot of web applications, free or commercial depends on MySQL for their database backend. The speed, compactness and simplicity of MySQL makes it suitable for most web sites.
PostgreSQL on the other hand is a complete relational database management system. It supports a lot of database features found in high end system. While not as popular as MySQL, PostgreSQL still have its place in web sites, quite some application utilizes PostgreSQL as backend database server.
Database Configuration
You can configure your database from an easy to use interface on our SiteManager. From there, you are able to add new databases, monitor the disk usage, and change database password to mention a few. We also provide our customers with example on how to connect and access their databases with some popular programming languages.
Support for More Than One Database
You are allowed to create more than one database. This has the advantage that it will simplify your development process since you can easily separate database for various functions, and will not clobber a single database with various unrelated tables.
Aside from that, you will also find a lot of third party software that uses the same table name, especially with table names like 'user' or 'group'. If you need to install two or more programs that uses a table named 'user' and only allowed to use only a single database, then you are in trouble. The only solution would be to edit those programs so that it would use another table name. In indoglobal.com system you are able to create two databases for two different programs and they won't conflict or require heavy modifications.
You are allowed to create as many databases as you need. The maximum limit of databases you can create is only limited by your disk space quota.
Database Administration
The administration of your database can be done within our SiteManager as well, this including things like creating a table, modifying a table, deleting a table, altering a table, and even adding or modifying records within a table. At the moment we only support MySQL, support for PostgreSQL is planned in the future.
We also provide an interactive SQL shell for you to enter SQL commands manually into your browser window. Our system then will display the resulting table if any. This feature is very similar to MySQL shell when used inside your shell account, with the difference of this is done in your browser window, without the slowness and complexity of using a shell account.
Sooner or later, your database needs to be optimized to enhance its performance, reliability and compactness. We provide the tool to automatically do the optimization to all of your table without needing to do it manually from an SQL shell.