PstSQL & popular Com_

[Cero Code]

Using Elxis with MySQL works pretty good and stable I've added a couple components such s Joomla! Board from http://www.tsmf.net/  and Zoom Gallery from http://www.zoomfactory.org/ and all works fine, I haven't tried any other component bcuz no need to, if u have more information about your users you can also add more fields which is a pretty cool tool you guys have add very cool and usefull.

If you want to use Elxis with postgreSQL  you won't have any problems, Elxis it self works normal, no error at all back-end and front-end but I you want to add a 3rd party component, module or bot, then you are going to find tons of error so heres some error that I have found using the most popular components galleries and boards

---------------------------------
Simple Board 1.1.2

Upload component - Failed
SQL Error DB function failed with error number -1
ERROR: syntax error at or near "NOT" at character 17
SQL =

CREATE TABLE IF NOT EXISTS `elx_sb_categories` (
              `id` int(11) NOT NULL auto_increment,
              `parent` int(11) default '0',
              `name` tinytext,
              `cat_emoticon` tinyint(4) NOT NULL default '0',
              `locked` tinyint(4) NOT NULL default '0',
              `alert_admin` tinyint(4) NOT NULL default '0',
              `moderated` tinyint(4) NOT NULL default '0',
              `moderators` varchar(15) default NULL,
              `pub_access` tinyint(4) default '1',
              `pub_recurse` tinyint(4) default '1',
              `admin_access` tinyint(4) default '0',
              `admin_recurse` tinyint(4) default '1',
              `ordering` tinyint(4) NOT NULL default '0',
              `future2` int(11) default '0',
              `published` tinyint(4) NOT NULL default '0',
              `checked_out` tinyint(4) NOT NULL default '0',
              `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
              `review` tinyint(4) NOT NULL default '0',
              `hits` int(11) NOT NULL default '0',
              `description` text NOT NULL,
              UNIQUE KEY `catid` (`id`),
              KEY `catparent` (`parent`)
            )

no installation at all...
---------------------------------

Zoom Gallery 2.5.1 RC3

PHP: in_array() [function.in-array]: Wrong datatype for second argument
uri: index2.php
path: /administrator/components/com_installer/component/component.php
version: Elxis 2006.4 Stable rev1080 [ Nestor ] 04-December-2006 23:08 GMT+2
WARNING(2): /hsphere/local/home2/srgdboy/demo.argonsystem.com/elx/administrator/components/com_zoom/install.zoom.php, line 41

also lines :
147, 192, 216, 235, 264 error type.
------------------------------------
also shows this as successfuly
#_zoom
Database created successfully!
#_zoom_comments
Database created successfully!
#_zoom_ecards
Database created successfully!
#_zoom_editmon
Database created successfully!
#_zoom_getid3_cache
Database created successfully!
#_zoomfiles
Database created successfully!
#_zoom_priv
Database created successfully!

Upload component - Success
---------------- let see how it works now...

Configuration Panel shows this

PHP: mysql_fetch_object(): supplied argument is not a valid MySQL result resource
uri: index2.php?option=com_zoom&Itemid=&page=settings
path: /administrator/components/com_zoom/admin.zoom.php
version: Elxis 2006.4 Stable rev1080 [ Nestor ] 04-December-2006 23:08 GMT+2

also...

PHP: mysql_num_rows(): supplied argument is not a valid MySQL result resource
uri: index2.php?option=com_zoom&Itemid=&page=settings
path: /administrator/components/com_zoom/admin.zoom.php
version: Elxis 2006.4 Stable rev1080 [ Nestor ] 04-December-2006 23:08 GMT+2

Clearlly most component are focus on MySQL not PstSQL

the backend is working with some gliches... at the moment of add a new gallery "album" it show a warning box see image bellow




Can't add an album and bcuz that images can't be add...

thats the far as I can go with that...

when it has to be uninstall it just not do that, it only shows "Failed" thats all... but can't be uninstall....

[datahell]

Very good Cero Code!
Elxis it self is PostgreSQL compatible (via ADODB). But all of the third party components from mambo/joomla have been created by their creators to support only mysql. Elxis uses ADODB database layer, so the querries have been modified to work with any database type, but this is only for the main CMS. There is more way to this. We now support without problems only MySQL and Postgre but in the future we are planning making 100% compatible Elxis with MSSQL and Oracle.

For third party developers:
There is more information in this forum on how to code your applications in order to work with any database. For example for the installation procedure you should use XML schemas and avoid hardcoded SQL querries.

From your example Cero Code:
This will fail on Postgre
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',

You should use instead XML schema with this inside:
<field name="checked_out_time" type="T">
<NOTNULL/>
<DEFAULT value="1979-12-19 00:00:00"/>
</field>

Another example:
instead of this:
`cat_emoticon` tinyint(4) NOT NULL default '0'
Use this:
<field name="cat_emotion" type="I4">
<NOTNULL />
<DEFAULT VALUE= '0'>
</field>

Another example:

instead oif this:
`id` int(11) NOT NULL auto_increment,
use this:
<field name="id" type="I">
<KEY/>
<AUTOINCREMENT/>
</field>

We should all to gether try to make our components, modules etc ADODB compatible.

Except than database compatibility Elxis has a number of other important differences related to mambo/joomla (tottaly different access control system for example), so as we have many times say: DO NOT INSTALL ANYTHING THAT IS NOT ELXIS COMPATIBLE AND THAT YOU HAVE NOT DOWNLOAD FROM ELXIS.ORG!