#47 able to select SQLite backend

Future
open
Mocchi
7
2012-03-25
2012-02-09
Mocchi
No

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.

Discussion

  • Mocchi
    Mocchi
    2012-02-09

    • summary: selecting SQLite backend --> able to select SQLite backend
     
  • Mocchi
    Mocchi
    2012-03-25

    • milestone: 2543203 --> Future
     
  • Mocchi
    Mocchi
    2012-03-25

    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.

     
  • Mocchi
    Mocchi
    2012-05-05

    conceptual diagram