随笔分类 - sqlite
摘要：Write-ahead logging Algorithms for Recovery and Isolation Exploiting Semantics - Detailed Pedia ...Create log records of the form (Sequence Number, Tr
阅读全文
摘要：#if 0 #include "set.h" // github.com/Kronuz/cpp-btree using namespace btree; #else #include <set> // en.cppreference.com/w/cpp/container/multiset #end
阅读全文
摘要：https://www.sqlite.org/testing.html 8.2. Valgrind Valgrind is perhaps the most amazing and useful developer tool in the world. Valgrind is a simulator
阅读全文
摘要：SQLite 触发器 - 菜鸟教程 (runoob.com) CREATE TRIGGER - sqlite.org Both the WHEN clause and the trigger actions may access elements of the row being inserted,
阅读全文
摘要：$sqlite3 t.db .CREATE TABLE d (id INT PRIMARY KEY, name TEXT ); .INSERT INTO d VALUES(1, 'sales'), (2,'r&d'), (3, 'unknown'); .CREATE TABLE e (name TE
阅读全文
摘要：sqlite3.c 8413KB 243617行，平均每行34.53个字节。行与行之间用\n (0x0a)分隔。 最后一行是： /************************** End of sqlite3.c ******************************/ 在一台很老的笔记本
阅读全文
摘要：Range Queries: R-tree | Pedagogic Modules (nau.edu) An R-tree (Rectange-tree) stores objects in rectangles. The main idea of the R-tree is to construc
阅读全文
摘要：SQLite Foreign Key Support 讲得挺清楚的啊。 更短的例子： CREATE TABLE person(name TEXT /* PRIMARY KEY */, addr TEXT); INSERT INTO person VALUES ('tom', 'somewhere')
阅读全文
摘要：SQLite 简介 | About SQLite | Architecture of SQLite | SQLite Bytecode Engine | How To Compile SQLite poetry.csv: author,title,text 王维,送别,下马饮君酒，问君何所之。君言不
阅读全文
和4