SQLite数据文件往Linux内存文件系统/dev/shm/data.sqlite3一放,就是内存级读写性能的SQL系统.

用SQLite实现内存键值存储:

CREATE TABLE IF NOT EXISTS memory (

  key VARCHAR(40) NOT NULL PRIMARY KEY,

  value TEXT NOT NULL,

  time INTEGER NOT NULL

);

INSERT INTO memory (key, value, time) VALUES ('key1', 'value1', 1484033720);

INSERT INTO memory (key, value, time) VALUES ('key2', 'value2', 1484033724);

SELECT * FROM memory WHERE key = 'key1';