#47 able to select SQLite backend

Nucleus CMS's default database is MySQL. But MySQL is a bit complicated and large.

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. I note that SQLite can deal only with UTF-8.
http://www.sqlite.org/

Now we can utilize PHP's SQlite backend via PDO and this function is enabled as a default.
http://www.php.net/manual/en/ref.pdo-sqlite.php

Here, Nucleus CMS's SQLite implementation exists, written by Katsumi Morimatsu. It's based on version 3.41.
http://japan.nucleuscms.org/bb/viewtopic.php?t=2379

I propose to merge this implementation into the core.

[Anonymous]

This is MySQL extensions to standard ANSI SQL 92.
http://dev.mysql.com/doc/refman/5.0/en/extensions-to-ansi.html

We should pay attension to these points. For example, INSERT statement with SET argument.

[Anonymous]

To achieve this issue, several heavy steps stand in front of us:

1. modifying so that generated SQL statements follows SQL standards
2. modifying so that generated SQL statements utilizes common functions defined in SQl standards
3. change table structure to utilize common functions defined in SQL standards
4. create wrapper scripts for each SQL implements such as SQLite
5. advertizing the way to create plugins with portability and promoting re-developing

Here ANSI SQL89 is better as SQL standards.

[Anonymous]

At revision 1808, new db handler 'DB' class is appied.
http://nucleuscms.svn.sourceforge.net/viewvc/nucleuscms?view=revision&revision=1808

With this commit, we officially support PDO with enough compatibility.

[Anonymous]

conceptual diagram