It can communicate with multiple databases such as: MySQL, PostgreSQL, ODBC, SQLite, Oracle, DB2, MS SQL Server, MaxDB, Visual FoxPro, FrontBase, InterBase, Firebird, Informix, LDAP, Netezza, SAP DB, Sybase, and generate code from them.
The regular expression is generated in the notation used by awk, ed, egrep, Emacs, expect, find, grep, lex, Lisp, MySQL, OpenOffice.org, Perl, PHP, PostgreSQL, Procmail, Python, Sed, Tcl, VBscript, Vi, and Vim.
It supports connection to following data sources: MSSQL Server, Oracle, PostgreSQL, MySQL, SQL Server Analysis Services, Microsoft Excel, Amazon Redshift, CSV files.
The software was built using open source technologies that include Django, GeoServer, Celery, jQuery, PostgreSQL and PostGIS and can be hosted in different environments such as Amazon Web Services, Azavea Hosting, local Linux server.
GIS Basic distribution: Knoppix Software included: GRASS 6.2, UMN MapServer 4.4.1, MapLab 2.0.1, PostgreSQL 8.1.4.2, TerraView 2.0, MapDesk, MySQL 5.0.21, JUMP GIS 1.1.2, Interlis, QGIS 0.8, Thuban 1.0.0, GSdrive, GPSMan
For PHP there are two different code generators, PHP for MySQL and PHP for PostgreSQL, creating source code using the respective database native driver.
Sirius provide a full Enterprise Stack which can include, but is not limited to, products such as Asterisk (VoIP), JBoss (application server), Apache (web server), Squid (proxy), OGo/Scalix (groupware), Sendmail/Cyrus (email), Samba/CUPS (file & print), OpenLDAP (directory server), PostgreSQL (database), PostGIS (geographic information systems) and Linux (operating system).
SQLObject supports a number of common database backends: included in the distribution are MySQL, PostgreSQL, SQLite, Sybase SQL Server, MaxDB, Microsoft SQL Server and Firebird.
In spatially enabled databases (such as IBM DB2, IBM Informix, Microsoft SQL Server, MySQL, Oracle, Teradata, PostgreSQL and SQL Anywhere), SRIDs are used to uniquely identify the coordinate systems used to define columns of spatial data or individual spatial objects in a spatial column (depending on the spatial implementation).