Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Make the default page size on SQL archives 512 bytes. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | f5c81a6c4f36c51da6b715691a90d39a |
| User & Date: | drh 2017-12-04 21:49:18 |
Context
|
2017-12-05
| ||
| 01:29 | Add the "main.js" javascript file. Load that script on every page just before the </body> element, and use it to reduce the need for inline JS and CSS. check-in: 8394d2fe user: drh tags: trunk | |
|
2017-12-04
| ||
| 21:49 | Make the default page size on SQL archives 512 bytes. check-in: f5c81a6c user: drh tags: trunk | |
| 21:29 | Add the /sqlar webpage. Link to this page from the /info page. check-in: 768e1921 user: drh tags: trunk | |
Changes
Changes to src/zip.c.
404 405 406 407 408 409 410 411 412 413 414 415 416 417 |
sqlite3_vfs_register(&p->vfs, 0);
sqlite3_open_v2("file:xyz.db", &p->db,
SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE, p->vfs.zName
);
assert( p->db );
blob_zero(&p->tmp);
sqlite3_exec(p->db,
"PRAGMA journal_mode = off;"
"PRAGMA cache_spill = off;"
"BEGIN;"
"CREATE TABLE sqlar("
"name TEXT PRIMARY KEY, -- name of the file\n"
"mode INT, -- access permissions\n"
"mtime INT, -- last modification time\n"
|
> |
404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 |
sqlite3_vfs_register(&p->vfs, 0);
sqlite3_open_v2("file:xyz.db", &p->db,
SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE, p->vfs.zName
);
assert( p->db );
blob_zero(&p->tmp);
sqlite3_exec(p->db,
"PRAGMA page_size=512;"
"PRAGMA journal_mode = off;"
"PRAGMA cache_spill = off;"
"BEGIN;"
"CREATE TABLE sqlar("
"name TEXT PRIMARY KEY, -- name of the file\n"
"mode INT, -- access permissions\n"
"mtime INT, -- last modification time\n"
|