Databases




Documentation > Develop with and for CorneliOS > CorneliOS structure, libraries and program code > Databases


CorneliOS doesn't require an SQL database, but using a database is strongly recommended as many advanced features require an SQL database.

Supported engines


Currently we only support MySQL, although other engines can probably also be used.

Database Manager


The CorneliOS database manager can be used to setup, create and manage databases. The database manager can be found among the standard CorneliOS applications that ship with the system. The database manager app is located here:

/app/cora/dbms

How CorneliOS accesses databases


CorneliOS supports multiple database gateway, and different CorneliOS apps may reply on different databases too (local and remote). Databases can be configured here:

/etc/sql - contains SQL configuration files
/etc/sql/example.conf - a CorneliOS SQL configuration file

A CorneliOS SQL configuration file may look like this:

driver mysql
host localhost
database dbname
username dbusername
password dbpassword

How to set up a database


You may of course create and/or edit files inside /etc/sql manually, but it's definately easier to use the CorneliOS database manager app to set up you database(s).

Accessing data throught the filesystem


/sql/example - show all database "example" tables
/sql/example/table - read all data from table "table"
/sql/example/table/record - read all data from record "record"
/sql/example/table/record/field - read field "field" from record "record"



Working with CorneliOS


Installation and Administration


Develop with and for CorneliOS



(c)2006-2012 Joopita Research | Privacy Policy | Sitemap | Contact Us
FeaturesDownloadsDocumentationCommunityDonateShop