#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.

Now we can utilize PHP's SQlite backend via PDO and this function is enabled as a default.

Here, Nucleus CMS's SQLite implementation exists, written by Katsumi Morimatsu. It's based on version 3.41.

I propose to merge this implementation into the core.


  • Anonymous

    Anonymous - 2012-02-09
    • summary: selecting SQLite backend --> able to select SQLite backend
  • Anonymous

    Anonymous - 2012-02-29

    This is MySQL extensions to standard ANSI SQL 92.

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

  • Anonymous

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

    Anonymous - 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.

  • Anonymous

    Anonymous - 2012-05-05

    conceptual diagram


Log in to post a comment.