Database
From Lanius CMS Wiki
Lanius CMS uses ADOdb Lite as its database abstraction layer; thanks to this middleware we can support a wide range of database management systems. In order to keep the official Lanius CMS package as small as possible, some of them are distributed separately in Lanius CMS Online Updates.
Contents |
Supported DBMSes
- Frontbase
- Gladius DB
- MaxDB
- miniSQL
- MSSQL
- MSSQL Pro
- MySQL
- MySQLi
- MySQLt
- PostgresSQL
- PostgresSQL64
- PostgresSQL7
- SqLite
- Sybase
Activating DBMSes
Database management systems are usually provided with PHP; if you cannot use a DBMS (it displays in red color), you will need to install the proper extension (DLL on Windows or .so library on Linux).
If the DBMS is displayed in gray color, you might need to install the necessary driver (see AdoDB Lite Drivers Pack).
Browsing databases
Manual modification of databases is not supported, since it will break Lanius CMS internals. However, if you want to give a look there is interesting software which allows database browsing:
- phpMyAdmin - handles the administration of one or more MySQL servers over the web
- phpPgAdmin - handles the administration of PostgreSQL Databases over the web
- SQLite Database Browser - open source visual tool used to create, design and edit database files compatible with SQLite (cross-platform, uses Qt)
- SQLite Administrator - a powerful tool if you easily want to create, design or administrate SQLite database files
