#47 able to select SQLite backend

Future
open
7
2012-03-25
2012-02-09
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

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

    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 - 2012-03-25
    • milestone: 2543203 --> Future
     
  • 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 - 2012-05-05

    conceptual diagram

     

Log in to post a comment.