链接已失效, 只维护英文版本的文章.

English: Get WordPress 2.2 working with SQLite

原始(For Wordpress 2.0 Only)
源码以 GPL 协议发布.

环境要求:

运行中的 PHP 安装. 有 SQLite 支持
(暂不支持 PDO_SQLite)

运行情况:

基本上都能工作吧
Read the rest of this entry »

This code is no longer maintained.

Please use PDO for Wordpress instead.

—

This wordpress for sqlite patch is based on tume and havarddahle’s work.
Mysql – Sqlite SQL Parse Code comes from tikiwiki project.

Original Version(For Wordpress 2.0 Only)

The previous version can be found here, based on Hasin’s work, Wordpress for SQLite
(For Wordpress 2.0 Only )

This source code is released under the terms of the GNU Public License.

It will never go into the Wordpress release,
but it is REALLY easy to get wordpress working with sqlite.

only SQLite 2(2.8.16) have been tested.
Almost Everything works well.

Chinese version
Read the rest of this entry »

最近心情不好,效率明显降低,终于想起来要给blog更新一小下. – 平常可是必做的任务…

1 sqlite中不支持的函数太多太多太多了,怎么办?

sqlite_create_function:
void sqlite_create_function ( resource dbhandle, string function_name, callback callback [, int num_args] )
这东西虽然标为CVS,实际上早已可用.

可能有用的函数:
now
from_unixtime
unix_timestamp
md5(偶想这个应该自己写)
upper
lower
floor (这三个居然不提供…)
year
month
day
dayofmonth (from Gregarius)
concat
if
substring

真是太多太多了.
mysql就没这么多问题,呵呵.
2 php5自带的sqlite extension只支持sqlite2.PDO支持sqlite3
3 mysql中的什么show tables之类全没有了,自己到sqlite_master表里去找吧.
4 ***不要过分相信现在成品的wrapper***.(比如索引之类可能就会损坏,不信就自己找找看.)
5 定义数据库结构的时候,存时间一律unixtimestamp.now之类的函数直接手工替换.enum不用

6 这些就差不多了吧…有别的想法的也放上来.呵呵

NOTICE:

THIS VERSION WILL NOT BE SUPPORTED.

Here is the new version, sqlite patch for wordpress 2.2
Read the rest of this entry »