Fossil

Check-in [f5c81a6c]
Login

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:f5c81a6c4f36c51da6b715691a90d39ac6b4da1884bf1b6b86841271a4b2face
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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"