/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of src/pager.h

2018-12-03
20:49
Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. file: [d8cf37b3] check-in: [b7281a1c] user: dan branch: begin-concurrent-wal2, size: 9891
18:15
Bring up to date with version 3.26.0. file: [389ba8f5] check-in: [f0ddb358] user: drh branch: begin-concurrent, size: 9389
2018-12-01
20:14
Sync this branch with the latest trunk. file: [3abf6d65] check-in: [7a44fa5a] user: dan branch: wal2, size: 9392
2018-11-30
18:22
Merge the pre-3.26.0 fixes from trunk. file: [0acf77fd] check-in: [2c76ce4f] user: drh branch: apple-osx, size: 8940
2018-11-27
14:41
Remove the sqlite3PagerUseWal() routine which was made obsolete by the [81629ba91475938b6ad] change. file: [217921e8] check-in: [4331b499] user: drh branch: trunk, size: 8890
2018-11-26
23:35
Merge recent enhancements from trunk. file: [44492867] check-in: [e8c20a88] user: drh branch: apple-osx, size: 9072
07:21
Merge latest trunk changes into this branch. file: [18b01912] check-in: [28a615a2] user: dan branch: begin-concurrent, size: 9521
2018-11-22
19:10
Fix a problem reading from temp databases in SQLITE_DIRECT_OVERFLOW_READ builds. file: [1bffa1ba] check-in: [81629ba9] user: dan branch: trunk, size: 9022
2018-10-09
22:50
Merge changes for the 3.25.0 release. file: [a2e68663] check-in: [ddf6a54e] user: drh branch: apple-osx, size: 8971
2018-09-28
20:58
Merge latest trunk into this branch. file: [e0adb223] check-in: [86750c92] user: dan branch: begin-concurrent, size: 9420
2018-09-27
14:24
Minor enhancement to the pager so that it remembers if the underlying database files is immutable. file: [d141d2f2] check-in: [64db614e] user: drh branch: immutable-pager, size: 9168
2018-08-06
17:12
Allow sqlite3_snapshot_open() to be called to change the snapshot after a read transaction is already open on database. file: [ecc554a5] check-in: [051ac015] user: dan branch: exp-snapshot-open, size: 8921
2018-04-24
19:21
Merge latest trunk changes into this branch. file: [abf96ba7] check-in: [b27bd799] user: dan branch: begin-concurrent, size: 9293
2018-04-10
18:05
Merge all version 3.23.1 changes and enhancements from trunk. file: [340c4396] check-in: [e20fcb51] user: drh branch: apple-osx, size: 8844
2018-03-28
15:41
Update this branch with latest trunk changes. file: [d0fcb55b] check-in: [df52e89f] user: dan branch: server-process-edition, size: 9028
2018-03-26
20:43
Avoid a race condition that might cause a busy_timeout to last longer than it should. file: [c571b064] check-in: [b8196056] user: drh branch: lowlevel-lock-timeout, size: 8794
16:37
Refactor some internal object element names used by the busy handler, to simplify analysis. file: [868d177d] check-in: [6c40c557] user: drh branch: trunk, size: 8655
2017-10-04
20:57
Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". file: [e11e5162] check-in: [e2fc5c81] user: dan branch: wal2, size: 9157
2017-09-22
10:49
Merge latest trunk changes into this branch. file: [72e1a294] check-in: [307b802e] user: dan branch: begin-concurrent, size: 9154
2017-09-09
06:10
Merge trunk enhancements file: [e9718b1a] check-in: [6a0b9d9d] user: drh branch: apple-osx, size: 8705
2017-09-01
14:50
Add the new sqlite3PagerUnrefPageOne() pager method to deal with the special case of unreferencing page1. file: [581698f2] check-in: [b2e2100c] user: drh branch: trunk, size: 8655
2017-07-29
17:01
Update test program "tserver" to use a native pthreads mutex/condition variable to efficiently manage wal file checkpoints without the wal file growing indefinitely. file: [316dac06] check-in: [8299bdb7] user: dan branch: server-process-edition, size: 8849
2017-07-20
18:56
Fix a faulty #ifdef on the previous check-in file: [403b7d24] check-in: [7355e742] user: drh branch: begin-concurrent, size: 9114
18:28
Get the build working with SQLITE_OMIT_CONCURRENT. file: [13713b18] check-in: [a29401e9] user: drh branch: begin-concurrent, size: 9115
2017-07-08
20:46
Support read-only MVCC transactions in server-mode. Started using "BEGIN READONLY". file: [857d21f7] check-in: [5a043aa8] user: dan branch: server-process-edition, size: 8892
2017-06-27
20:23
Support clients within a single process only. file: [81d2c28e] check-in: [dfa9a4d5] user: dan branch: server-process-edition, size: 8877
2017-05-29
19:23
Instead of a root page number, log the object (table or index) name if a page level locking conflict is detected. file: [ba7b3fbb] check-in: [9ad846e5] user: dan branch: begin-concurrent, size: 9045
2017-05-27
18:05
Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). file: [e430a536] check-in: [214d238a] user: dan branch: btree-debug, size: 8726
2017-05-23
19:23
Add experimental new API sqlite3_wal_info(). file: [1afb4b77] check-in: [5b9d498f] user: dan branch: begin-concurrent, size: 9038
2017-04-29
15:48
Avoid reading the file-size before page 1 is read-locked. file: [ea05992c] check-in: [f6b025bf] user: dan branch: server-edition, size: 8797
2017-04-28
17:32
Fix various bugs revealed by running performance tests. file: [c14a05a9] check-in: [a40b42c4] user: dan branch: server-edition, size: 8839
10:20
Use a different free-list format for server-mode databases in order to reduce contention. file: [4ef462a0] check-in: [778e8a10] user: dan branch: server-edition, size: 8793
2017-04-26
20:45
Experimental implementation of pessimistic page-level locking based on rollback mode. file: [54f5321b] check-in: [64ecf7c7] user: dan branch: server-edition, size: 8700
2017-03-24
15:09
Merge all recent enhancements from trunk. file: [5e7b4e5a] check-in: [fd5676fe] user: drh branch: begin-concurrent, size: 8976
2017-01-27
16:39
Merge all recent trunk enhancements into the apple-osx branch. file: [32adb801] check-in: [0e14fe1b] user: drh branch: apple-osx, size: 8665
2017-01-26
02:26
Make SQLITE_DIRECT_OVERFLOW_READ work for in WAL mode as long as the page being read is not in the the -wal file. file: [f2a99646] check-in: [9879be18] user: drh branch: trunk, size: 8615
2017-01-18
20:14
Add temporary code to record and report on the set of b-tree pages read and written by the current transaction. This is likely still buggy. file: [f15b4fe1] check-in: [2a8f6c89] user: dan branch: transaction-pages, size: 8659
2017-01-09
06:33
Upgrade this branch to 3.16 plus the various fixes that appeared after its release. file: [0105583b] check-in: [d0e212d0] user: dan branch: begin-concurrent, size: 8924
2016-11-26
20:44
Merge all recent trunk changes, and especially the new sqlite3_snapshot_recover() interface. file: [366f586b] check-in: [41a3af54] user: drh branch: apple-osx, size: 8613
2016-11-18
20:49
Add experimental sqlite3_snapshot_recover() API. file: [d1e94429] check-in: [174a6076] user: dan branch: serializable-snapshot, size: 8563
2016-11-04
19:09
Merge recent trunk changes, including all the fixes that appeared in version 3.15.1. file: [a409efec] check-in: [0e5ffd91] user: drh branch: apple-osx, size: 8563
2016-11-03
18:30
Avoid using the "direct overflow read" optimization to read large blobs if the pager layer has a wal file open - even if the database header indicates that the db is not a wal database. file: [ec9140e5] check-in: [63cfe197] user: drh branch: branch-3.15, size: 8483
2016-10-21
10:49
Avoid using the "direct overflow read" optimization to read large blobs if the pager layer has a wal file open - even if the database header indicates that the db is not a wal database. file: [07d6938d] check-in: [b54c15f1] user: dan branch: trunk, size: 8513
2016-08-12
16:21
Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. file: [0a19b1e2] check-in: [8a5f41c7] user: dan branch: interruptible-checkpoint, size: 8433
2016-08-11
19:12
Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. file: [3ae6549e] check-in: [d9f8918c] user: drh branch: begin-concurrent, size: 8764
2016-08-08
14:21
Merge all changes from the 3.14 release. file: [16644d79] check-in: [c3cd543f] user: drh branch: apple-osx, size: 8453
2016-08-05
16:16
Undo commit [f250166bb]. It is required to handle IO and other errors that occur within a VACUUM of a Zipvfs database. file: [966d2769] check-in: [ae72513a] user: dan branch: trunk, size: 8403
2016-07-25
17:31
Merge 3.14 alpha changes from trunk. file: [0bd89bac] check-in: [e98cefb1] user: drh branch: apple-osx, size: 8416
2016-07-09
16:14
Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". file: [031a8744] check-in: [5471aca0] user: drh branch: trunk, size: 8366
2016-05-23
02:57
Merge changes from trunk. file: [156c60a0] check-in: [815cc2bb] user: drh branch: apple-osx, size: 8401
2016-05-20
18:09
Remove the sqlite3PagerClearCache() routine, which does not accomplish anything useful. file: [8ab6b6fe] check-in: [f250166b] user: drh branch: trunk, size: 8351
2016-04-21
15:35
Merge all recent enhancements from trunk. file: [7b855891] check-in: [a15c49ae] user: drh branch: apple-osx, size: 8439
2016-04-20
12:16
Merge all recent enhancements from trunk. file: [66564361] check-in: [1f709fbf] user: drh branch: begin-concurrent, size: 8750
2016-04-14
16:40
Add the SF_HasAgg constant (currently unused). Also enhance the comments on many other constant definitions to detail constraints on their values. file: [329bdf07] check-in: [7b7a69d0] user: drh branch: trunk, size: 8389
2016-04-05
00:44
Avoid unnecessary memset() operations in sqlite3PagerGet(). file: [97f153d1] check-in: [0c97b802] user: drh branch: pager-get-noinit, size: 8062
2016-03-16
19:34
Merge the latest enhancements from trunk. file: [bb26afd6] check-in: [a7978ab6] user: drh branch: begin-concurrent, size: 8352
2016-02-26
16:14
Merge all recent enhancements from trunk, and in particular the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER change. file: [ff4c0c4b] check-in: [4fb4aee8] user: drh branch: apple-osx, size: 8041
2016-02-22
23:44
Remove code not needed now that synchronous=OFF database files no longer trigger the use of a master journal. file: [e1d38a2f] check-in: [aa9f4c62] user: drh branch: trunk, size: 7991
2016-02-05
14:34
Merge PRAGMA synchronous=EXTRA and OOM performance enhancements from trunk. file: [6dec8fe4] check-in: [332c8036] user: drh branch: begin-concurrent, size: 8384
14:29
Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as other enhancements from trunk. file: [3de08f90] check-in: [201fcbee] user: drh branch: apple-osx, size: 8073
2016-02-03
19:20
Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. file: [f3eb324a] check-in: [af924018] user: drh branch: trunk, size: 8023
2016-01-14
15:46
Merge the latest enhancements and fixes from trunk. file: [4a489a63] check-in: [fccc5f20] user: dan branch: begin-concurrent, size: 8312
15:03
Merge the latest enhancements and fixes from trunk. file: [fe401b66] check-in: [d85774e0] user: drh branch: apple-osx, size: 8001
2016-01-09
16:39
If a single page is written to the wal file more than once, have each subsequent copy overwrite the original frame. file: [bbbfe276] check-in: [5d113aef] user: dan branch: wal-overwrite-frames, size: 7956
2016-01-08
02:27
Add the experimental SQLITE_FCNTL_JOURNAL_POINTER file control for obtaining the sqlite3_file pointer associated with a rollback journal or WAL file. file: [1c2a4914] check-in: [a02ace9a] user: drh branch: file-control-journal, size: 7951
2015-12-16
19:55
Merge recent enhancements from trunk. file: [d72d174e] check-in: [cb22efaf] user: drh branch: begin-concurrent, size: 8268
2015-12-11
12:53
Merge recent trunk enhancements, and in particular the snapshot interface. file: [a038f5d7] check-in: [7e7b2406] user: drh branch: apple-osx, size: 7957
2015-12-05
20:51
Add untested implementations of experimental APIs sqlite3_snapshot_get(), _open() and _free(). file: [bf25005b] check-in: [0715eb00] user: dan branch: snapshot-get, size: 7907
2015-12-02
20:53
Merge recent enhancements from trunk. file: [c6b437a6] check-in: [9130661a] user: drh branch: begin-concurrent, size: 8076
20:22
Merge all recent trunk enhancements, especially the unix VFS changes. file: [3bb11e11] check-in: [e1fb33c7] user: drh branch: apple-osx, size: 7765
2015-11-28
18:06
Add the SQLITE_FCNTL_VFS_POINTER file control which obtains a pointer to the top-level VFS in use by a database connection. file: [9153c71a] check-in: [7c6a809e] user: drh branch: trunk, size: 7715
2015-11-20
13:49
Merge all the latest enhancements and fixes from trunk. file: [f392409a] check-in: [41c8b8e3] user: drh branch: begin-concurrent, size: 8082
2015-11-12
16:51
Merge the latest enhancements from trunk, and in particular the "PRAGMA cache_spill=N" change. file: [22bbab15] check-in: [e72331c7] user: drh branch: apple-osx, size: 7771
14:57
First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. file: [87c4118a] check-in: [549d42be] user: drh branch: cache_spill=N, size: 7721
2015-11-07
01:57
Merge recent enhancements and fixes from trunk. file: [86484ef4] check-in: [5429f99b] user: drh branch: apple-osx, size: 7728
2015-11-04
20:22
Rename the sqlite3PagerAcquire() function to sqlite3PagerGet(). The former macro called sqlite3PagerGet() has been removed. file: [7fc069c0] check-in: [708253be] user: drh branch: trunk, size: 7678
2015-10-30
17:17
Merge the sqlite3_db_cacheflush() enhancements and other changes from trunk. file: [6f280ca6] check-in: [f2cde4cf] user: drh branch: begin-concurrent, size: 8107
16:23
Merge latest trunk changes, including sqlite3_db_cacheflush(), with this branch. file: [33a0e40f] check-in: [6e4306ef] user: dan branch: apple-osx, size: 7796
2015-10-28
19:46
Add experimental API sqlite3_db_cacheflush(). file: [1c4fa826] check-in: [65b86dc1] user: dan branch: cacheflush, size: 7746
2015-09-24
15:17
Merge all recent trunk enhancements and fixes into the begin-concurrent branch. file: [4d9e5ec2] check-in: [c63c1e15] user: drh branch: begin-concurrent, size: 8076
14:43
Merge recent trunk enhancements into the apple-osx branch. file: [9c77ab70] check-in: [4dd06d8b] user: drh branch: apple-osx, size: 7765
2015-09-23
19:17
Take care that the number of reserved bits per page is consistent between the source and destination databases when doing the back-copy on a VACUUM. file: [ac213f81] check-in: [5b61b72f] user: drh branch: trunk, size: 7715
2015-09-03
15:17
Changes from ENABLE_CONCURRENT (default off) to OMIT_CONCURRENT (default on). This is not a clear-cut decision and might be changed back. file: [244606cc] check-in: [f8ae9bfd] user: drh branch: begin-concurrent, size: 7999
2015-09-01
17:48
Fixes so that it builds without warnings both with and without SQLITE_ENABLE_CONCURRENT. file: [174fd2cd] check-in: [5ed2a445] user: drh branch: begin-concurrent, size: 8000
2015-08-28
02:12
Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. file: [c2471a08] check-in: [da864658] user: drh branch: apple-osx, size: 7688
2015-08-27
17:42
Fix a problem whereby concurrent transactions would not consider pages read by the transaction before the first write statement. file: [f00930ca] check-in: [fc17f731] user: dan branch: begin-concurrent, size: 7969
2015-08-24
19:56
Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". file: [1335b624] check-in: [ba1ab858] user: dan branch: begin-concurrent, size: 7842
2015-08-21
20:11
Fix many minor issues in the unlocked transaction code. file: [1e7b0fc3] check-in: [53aaeea6] user: dan branch: begin-concurrent, size: 7840
2015-08-19
20:27
When committing an unlocked transaction, relocate newly allocated database pages within the file to avoid conflicting with committed transactions. There are lots of things still to fix in this code. file: [3fc23bca] check-in: [3bbc31d5] user: dan branch: begin-concurrent, size: 7874
2015-08-10
20:22
Add the sqlite3_experimental_log_open() interface. This is for diagnostic use only and is not intended to ever go on trunk. file: [ad181d41] check-in: [ac5d2e9d] user: drh branch: experimentalIoLog, size: 7699
2015-07-29
12:14
Only allow UNLOCKED transactions to commit if none of the pages read by the transaction have been modified since it was opened. file: [41938212] check-in: [0b971842] user: dan branch: begin-concurrent, size: 7730
2015-07-27
19:31
Add an experimental "BEGIN UNLOCKED" command. file: [b6cf6e95] check-in: [80794216] user: dan branch: begin-concurrent, size: 7746
2015-07-01
17:13
Rework the PRAGMA integrity_check logic. Simplify the checkTreePage() routine and clean up the error messages generated. file: [6d435f56] check-in: [1c522123] user: drh branch: integrity-check-refactor, size: 7638
2015-02-07
19:17
Remove "PRAGMA pager_ota_mode". file: [20954a3f] check-in: [8ac58e46] user: dan branch: ota-update-no-pager_ota_mode, size: 7690
2015-01-28
12:00
Merge in all changes from trunk. file: [19d83e27] check-in: [17c69be8] user: drh branch: ota-update, size: 7796
2015-01-02
19:17
Merge the latest changes from trunk into the apple-osx branch. file: [5ead19ac] check-in: [df3cdf9f] user: drh branch: apple-osx, size: 7659
2014-12-19
19:28
Experimental "PRAGMA data_version" command for detecting when another process has changed the database file. file: [c3476e7c] check-in: [43db1f44] user: drh branch: data_version_pragma, size: 7609
2014-11-21
14:37
Merge latest trunk changes with this branch. file: [c6157af6] check-in: [7ef44c5b] user: dan branch: ota-update, size: 7759
2014-10-27
18:42
Merge latest enhancements, including the SQLITE_ENABLE_API_ARMOR patch, from trunk. file: [78ba46ce] check-in: [10aaf3b1] user: drh branch: apple-osx, size: 7622
2014-10-24
16:40
Fix some minor formatting and code organization issues. file: [d1eee3c3] check-in: [eab8706d] user: dan branch: defrag-opt, size: 7572
2014-10-20
16:24
Have the ota extension perform an incremental checkpoint after generating the wal file. file: [997a4aa3] check-in: [0bf1301a] user: dan branch: ota-update, size: 7714
2014-10-09
19:35
Change the balance_nonroot() routine to reduce the amount of memcpy work that takes place. This is a work in progress. file: [8b6707cb] check-in: [29304499] user: dan branch: defrag-opt, size: 7567
2014-09-16
20:02
Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. file: [b62e645e] check-in: [decaccc3] user: dan branch: ota-update, size: 7634
2014-09-15
19:34
Remove the experimental sqlite3_transaction_save() and restore() APIs. file: [5c139278] check-in: [48d201cd] user: dan branch: ota-update, size: 7581
2014-09-03
19:30
Split part of "PRAGMA ota_mode" off into "PRAGMA pager_ota_mode". This allows some specialized custom VFS implementations to intercept and implement the expected pager-related effects of this pragma. file: [6a08df06] check-in: [209f672e] user: dan branch: ota-update, size: 7731
2014-09-02
19:59
Add an experimental extension for applying bulk updates to databases. file: [1acd367a] check-in: [2954ab50] user: dan branch: ota-update, size: 7682
2014-05-08
23:01
Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. file: [8feb18f8] check-in: [9411d7dc] user: drh branch: apple-osx, size: 7577
2014-04-24
13:20
Add sqlite3_log() diagnostic messages for a specific type of corruption where the file size is reported to be too small relative to the size in the header. This branch is intended to help debug a specific problem reported from the wild and is not for general use. file: [99612397] check-in: [34155c40] user: drh branch: filesize-debug, size: 6400
2013-12-13
19:35
Create and use a new pager interface sqlite3PagerUnrefNotNull() that works just like sqlite3PagerUnref() but guarantees that its argument is not a NULL pointer. file: [ffd5607f] check-in: [e00f37e2] user: drh branch: trunk, size: 7527
2013-12-09
20:42
Modify the way some internal file-controls are invoked. In order to support multi-file transactions in the zipvfs extension. file: [6a790b64] check-in: [32fb1784] user: dan branch: zipvfs-multifile-commit, size: 7487
2013-08-21
23:42
Simplify the btreeGetPage() routine so that it uses a single flag parameter in place of two boolean parameters. file: [f094af9f] check-in: [617e23ec] user: drh branch: trunk, size: 7466
2013-08-16
20:42
Add the cache_spill pragma. file: [66e42d69] check-in: [cdb181c0] user: drh branch: cache_spill, size: 7474
2013-03-25
23:09
Memory-mapped I/O is now on by default. The "PRAGMA mmap_limit(N)" can be used to issue a hint to the VFS to limit mmap space to N bytes. The VFS is free to ignore that hint if desired. However, if "PRAGMA mmap_limit(0)" is used, xFetch is never called. file: [5cb78b8e] check-in: [1b37c4ef] user: drh branch: experimental-mmap, size: 6853
2013-03-23
21:00
Replace the sqlite3_io_methods.xMremap interface with sqlite3_io_methods.xFetch and xUnfetch. file: [faf4bed7] check-in: [1431be95] user: dan branch: experimental-mmap, size: 6885
2013-03-22
18:20
Allow the database file to be memory mapped in wal mode. file: [bbc91702] check-in: [d190ddab] user: dan branch: experimental-mmap, size: 7004
2013-03-20
14:26
When possible, use memory mapping when appending new pages to a database file. file: [241d72dc] check-in: [14135da3] user: dan branch: experimental-mmap, size: 6842
2013-03-15
18:29
Allow read-only cursors to use mmap pages even if there is an open write transaction. file: [81ac95f4] check-in: [b387e2f9] user: dan branch: experimental-mmap, size: 6798
2012-10-10
09:46
Move a couple of WAL-related function declarations in sqliteInt.h and pager.h into "#ifndef SQLITE_OMIT_WAL" blocks. Otherwise, the amalgamation fails to build using some compilers with SQLITE_OMIT_WAL (static function declared but not defined). file: [1109a065] check-in: [f7437153] user: dan branch: trunk, size: 6575
2012-10-01
06:50
Ensure that the value returned by xSectorSize() is reasonable (currently defined as between 2^5 and 2^16 bytes) before using it to calculate the amount of padding to add to a wal file. file: [bdbc3795] check-in: [6b4ff83b] user: dan branch: trunk, size: 6533
2012-06-08
01:13
Merge trunk changes into the apple-osx branch. file: [491e782f] check-in: [9d1b8515] user: drh branch: apple-osx, size: 6544
2012-05-27
01:19
Have user interfaces report out the filename of in-memory databases as an empty string, as it always has. This simplifies the changes. file: [8b8c9bc0] check-in: [595dfdbf] user: drh branch: shared-cache-memdb, size: 6494
2012-05-09
22:36
Added support for SQLITE_ENABLE_PERSIST_WAL compile time macro, retrieving lastErrno from WAL file and setting last errno when writes fail due to space constraints file: [42926ac0] check-in: [65479294] user: adam branch: apple-osx, size: 6539
2012-02-24
14:33
Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. file: [ef1eaf85] check-in: [3130275c] user: drh branch: trunk, size: 6489
2012-02-23
15:35
Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs. file: [0ccc8260] check-in: [786e24dc] user: dan branch: trunk, size: 6453
2012-01-17
15:29
Remove the undocumented PRAGMA omit_readlock hack. file: [a435da84] check-in: [96900c47] user: drh branch: trunk, size: 6407
2011-11-16
19:29
Add the sqlite3_db_release_memory() interface and the shrink_memory pragma. file: [5cd76085] check-in: [3f58e7c8] user: drh branch: trunk, size: 6484
2011-11-14
12:34
Further work on mmap(). Still does not work right - autovacuum tests are the first to fail. file: [13fd98ed] check-in: [638a39bb] user: drh branch: mmap-experimental, size: 6447
01:55
Begin making experimental changes to use mmap() for reading content from a database. The code compiles, but crashes on the test suite. file: [a29eabed] check-in: [09be42d5] user: drh branch: mmap-experimental, size: 6449
2011-10-21
14:27
If an error occurs while writing to the database file during a VACUUM, discard the contents of the in-memory cache. This is required as if the database is a zipvfs database, the contents of the cache may be inconsistent with respect to the database as stored on disk. file: [9f81b08e] check-in: [07159e84] user: dan branch: trunk, size: 6451
2011-09-22
14:41
Add the SQLITE_DB_STATUS_CACHE_HIT and MISS options. For querying the number of cache hits and misses on a per-connection basis. file: [dbcaa791] check-in: [5100b6e9] user: dan branch: trunk, size: 6413
2011-09-20
15:53
Add SQLITE_STMTSTATUS_CACHE_HIT/MISS and SQLITE_DB_STATUS_CACHE_HIT/MISS. For querying the number of pager cache hits and misses on a statement or connection basis. file: [f79a313f] check-in: [89272357] user: dan branch: cache-stats, size: 6411
2011-09-02
21:42
Remove some dead code. Fix a faulty assert(). Improve some variable names. file: [6bea8d19] check-in: [a9a64592] user: drh branch: merge-sort, size: 6438
2011-08-26
00:34
Create a new pager type, PAGER_SORTER, for use in the external merge sort. Such pagers are always held in memory but do report when they are under memory pressure by calling pagerStress. file: [2bab1b2e] check-in: [c71d7320] user: drh branch: trunk, size: 6513
2011-05-11
14:57
Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). file: [34c6b029] check-in: [671ba5fc] user: dan branch: wal-readonly, size: 6438
2010-11-19
18:51
Merge the checkpoint_fullfsync pragma and the superlock demonstration into the checkpoint-v2 experimental branch. file: [3f8c783d] check-in: [ebf74015] user: drh branch: blocking-checkpoint, size: 6359
18:23
Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint operations only, not during ordinary commit fsyncs. file: [0ea59db2] check-in: [a0698673] user: drh branch: trunk, size: 6342
2010-11-18
12:11
Modify the interface to the blocking wal-checkpoint functionality. file: [e2485f2f] check-in: [72787c01] user: dan branch: blocking-checkpoint, size: 6355
2010-11-16
18:56
Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. file: [ad7d8db0] check-in: [7e3fc2c8] user: dan branch: blocking-checkpoint, size: 6343
2010-08-30
15:02
Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. file: [8167a1e7] check-in: [0900e353] user: drh branch: trunk, size: 6338
2010-08-14
17:12
Change sqlite3PagerPagecount() to return void, since the return value was always SQLITE_OK and was never used. file: [ef8c8f71] check-in: [7dd78eb7] user: drh branch: trunk, size: 6275
2010-08-12
02:41
Increase the maximum page size from 32k to 64k. file: [985a83d3] check-in: [45362437] user: drh branch: trunk, size: 6274
2010-07-30
11:20
Cherry-pick the multi-file transaction fix for ticket [f3e5abed55] out of the experimental branch. file: [80726162] check-in: [40f7f0a5] user: drh branch: trunk, size: 6274
2010-06-22
21:15
Disable code used only by the codec when the codec is not deployed. file: [879fdde5] check-in: [2c90276e] user: drh branch: trunk, size: 6235
15:18
Add codec support to wal mode. file: [051ed521] check-in: [393741eb] user: dan branch: trunk, size: 6281
2010-06-11
17:01
Refactor and simplify the logic used to change journalmode. file: [ca1f23c0] check-in: [95cc3f6f] user: drh branch: trunk, size: 6133
2010-05-12
18:01
Refactoring the VFS-SHM methods used by WAL. This version compiles and runs non-WAL test cases but crashes and burns on wal.test. file: [76466c3a] check-in: [2b00152c] user: drh branch: wal-refactor, size: 6022
2010-04-29
22:34
Refactor wal.c to use the VFS. This check-in compiles and links and works ok as long as you leave WAL turned off, but WAL does not work. file: [934b5985] check-in: [62db5fa3] user: drh branch: wal, size: 5977
2010-04-20
18:53
Use the read and write version fields of the database header to mark a database as operating in wal-mode. file: [cee4487a] check-in: [96bef18c] user: dan branch: wal, size: 5977
2010-04-19
18:03
Add the sqlite3_log_hook() interface for scheduling checkpoints. file: [aeaee9ce] check-in: [9bda6014] user: dan branch: wal, size: 5882
2010-04-13
11:56
Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". file: [ce5d076f] check-in: [27dc5977] user: dan branch: wal, size: 5837
2010-04-12
19:00
Import experimental write-ahead-logging code. file: [80c57ba6] check-in: [409d61ba] user: dan branch: wal, size: 5794
2010-03-10
21:42
Add the SQLITE_DBSTATUS_CACHE_SIZE verb for sqlite3_db_status(). The highwater mark does not yet work on this verb. file: [ef8a2cf1] check-in: [418c6d81] user: drh branch: trunk, size: 5722
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [1b32faf2] check-in: [f6c045f6] user: drh branch: trunk, size: 5689
2009-07-24
19:01
Further simplifications to pager.c in support of structural coverage testing. (CVS 6929) file: [11852d04] check-in: [866216c0] user: drh branch: trunk, size: 5751
2009-07-21
19:25
Change getAndInitPage() (btree.c) to use only PagerAcquire(), not PagerLookup() and PagerAcquire(). (CVS 6916) file: [5bd96ed8] check-in: [0b41dfc0] user: danielk1977 branch: trunk, size: 5780
2009-06-18
17:22
Move codec management from database connections into the pager so that it will work together with shared cache. (CVS 6782) file: [5aec418b] check-in: [ed08b53c] user: drh branch: trunk, size: 5729
2009-04-30
09:10
When SQLite is configured to use in-memory temp files (either by setting SQLITE_TEMP_STORE during compilation or using the temp_store pragma at run time), store statement/savepoint journals in memory also. Ticket #3825. (CVS 6575) file: [73f481a3] check-in: [38f8c5a1] user: danielk1977 branch: trunk, size: 5875
2009-02-03
16:51
Commit first version of the 'backup' feature. (CVS 6241) file: [0c9f3520] check-in: [663479b4] user: danielk1977 branch: trunk, size: 5870
2009-01-31
14:54
Avoid a segfault when running vacuum on an in-memory database. Ticket #3620. (CVS 6221) file: [eccf5cde] check-in: [407830c6] user: danielk1977 branch: trunk, size: 5823
2009-01-24
11:30
Fix some minor compiler warnings. Added sqlite3Isalpha() for use in the soundex() function. (CVS 6203) file: [59e3b500] check-in: [bfc71edc] user: drh branch: trunk, size: 5875
2009-01-23
16:45
Optimization: When loading a new page into the cache, avoid redundant memset() calls to zero it. (CVS 6201) file: [869b7027] check-in: [9c0b9f88] user: danielk1977 branch: trunk, size: 5924
2009-01-20
17:06
Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197) file: [95b9802f] check-in: [12f7346c] user: danielk1977 branch: trunk, size: 5924
2009-01-16
16:23
Revert (6187). (CVS 6188) file: [3345547d] check-in: [a353c1ab] user: danielk1977 branch: trunk, size: 4921
15:21
This commit is an error. Reverted by (6188). (CVS 6187) file: [61a5259a] check-in: [aa67fd0c] user: danielk1977 branch: trunk, size: 5925
2009-01-07
15:18
Fix for 'truncate file' operations on in-memory databases. (CVS 6131) file: [9870acb2] check-in: [83d1eafb] user: danielk1977 branch: trunk, size: 4921
2009-01-06
14:19
Fix compiler warnings. (CVS 6117) file: [0793c5e4] check-in: [da770a8d] user: drh branch: trunk, size: 4952
2009-01-02
18:10
Fix compiler warnings in pager.c (CVS 6102) file: [75396879] check-in: [78dd7909] user: drh branch: trunk, size: 5061
2008-12-27
15:23
Fix a problem with savepoint and incremental-vacuum. (CVS 6066) file: [0579740d] check-in: [08352f9e] user: danielk1977 branch: trunk, size: 5075
2008-12-17
17:30
Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) file: [71912944] check-in: [34b56600] user: danielk1977 branch: trunk, size: 4950
2008-12-10
16:45
Add explicit casts to silence nuisance warnings from VC++. (CVS 6004) file: [37f51736] check-in: [da1cbfa7] user: drh branch: trunk, size: 4822
2008-11-19
10:22
Simplify the way the pager layer invokes the busy-handler callback. (CVS 5922) file: [a02ef8e6] check-in: [7bd1ac18] user: danielk1977 branch: trunk, size: 4831
2008-10-17
18:51
Add "pragma journal_mode=memory". Change the way rollback works for in-memory databases so that it reuses the journal_mode=memory code. (CVS 5830) file: [4a57b219] check-in: [39ebf01a] user: danielk1977 branch: trunk, size: 4834
2008-09-29
11:49
Instead of storing a pointer to the parent page in the MemPage structure, have each B-Tree cursor keep track of the ancestry of the current page. (CVS 5747) file: [9c1917be] check-in: [40425e93] user: danielk1977 branch: trunk, size: 4763
2008-09-26
21:08
Add the "truncate" journal mode which commits transactions by truncating the rollback journal file to zero length and not calling fsync(). (CVS 5745) file: [30e71f44] check-in: [7c561f2e] user: drh branch: trunk, size: 4734
2008-09-18
17:34
Avoid parsing the structure of b-tree pages (in sqlite3BtreeInitPage) more than is necessary. (CVS 5720) file: [1ef5a3f8] check-in: [6b998f30] user: danielk1977 branch: trunk, size: 4665
2008-09-01
17:23
Remove an unused function declaration from a header file. Ticket #3349. (CVS 5651) file: [c45380ca] check-in: [7a577428] user: drh branch: trunk, size: 4661
2008-08-27
15:16
Use a bitvec object to store the set of pages with the 'always-rollback' property for a transaction. (CVS 5622) file: [914103bb] check-in: [9e932599] user: danielk1977 branch: trunk, size: 4717
2008-08-22
17:34
Remove dead code. (CVS 5601) file: [3b9c138d] check-in: [6de9c084] user: drh branch: trunk, size: 4710
2008-08-21
12:19
Fix the functionality associated with sqlite3_release_memory() and sqlite3_soft_heap_limit(). It is automatically disabled if the SQLITE_CONFIG_PAGECACHE option is used. (CVS 5576) file: [3778bea7] check-in: [d025866b] user: danielk1977 branch: trunk, size: 4780
2008-08-20
14:49
Add the pcache module from the experimental branch. Also change things so that most of the built-in SQL functions are kept in single static hash-table, rather than creating and populating a separate hash table for each open database connection. (CVS 5566) file: [fb9376af] check-in: [cb494e10] user: danielk1977 branch: trunk, size: 4903
2008-07-16
18:17
Eliminate some unnecessary IO during a commit in full auto-vacuum mode. (CVS 5426) file: [588c1ac1] check-in: [1d01c02a] user: danielk1977 branch: trunk, size: 4837
2008-06-07
08:58
Change the signature of sqlite3PagerPagecount() so that it can return an error code. (CVS 5195) file: [6aa3050a] check-in: [e9f01c01] user: danielk1977 branch: trunk, size: 4833
2008-06-06
11:11
Remove the xGetTempname() method from the vfs structure. Temp files are now opened by passing a NULL pointer as the filename to xOpen(). (CVS 5190) file: [7b1de4bf] check-in: [5173b3e8] user: danielk1977 branch: trunk, size: 4827
2008-06-04
06:45
Add "pragma journal_size_limit", used to limit the space consumed by persistent journal files left in the file-system after a transaction has concluded in exclusive (or journal_mode=persist) mode. (CVS 5185) file: [71c58cd6] check-in: [5c59f469] user: danielk1977 branch: trunk, size: 4792
2008-05-27
18:11
Explicitly typedef Pgno as 'u32' instead of 'unsigned int' to remove a few warnings/errors from native x86_64 compile. (CVS 5163) file: [1ccde540] check-in: [b5fd8a23] user: shane branch: trunk, size: 4489
2008-05-01
17:03
Fix harmless compiler warnings. (CVS 5073) file: [4f051fd8] check-in: [227a6f67] user: drh branch: trunk, size: 4496
2008-04-17
17:02
Add the journal_mode pragma. This is currently just syntax - it is not operational. (CVS 5024) file: [45ec2188] check-in: [8eaa0c71] user: drh branch: trunk, size: 4556
2008-03-20
11:04
Allow a VACUUM operation to change the page-size in the same way as it can be used to change a database between auto-vacuum and normal mode. (CVS 4896) file: [b1e2258f] check-in: [871df0e7] user: danielk1977 branch: trunk, size: 4177
2008-02-02
20:47
Delete unused "pager3_refinfo_enable" flag and its associated debugging macros. Ticket #2923. (CVS 4774) file: [8174615f] check-in: [fccb217d] user: drh branch: trunk, size: 4127
2007-11-28
16:19
Change the BTree so that it uses the Pagers temporary page space when reorganizing the rows on a page, rather than mallocing for space of its own. In this way, we avoid having to deal with a malloc failure deep down inside the page reorganizer. Ticket #2806 (CVS 4577) file: [f504f7ae] check-in: [98960132] user: drh branch: trunk, size: 4156
2007-09-03
15:19
Honor the SQLITE_OPEN_ flags passed into sqlite3_open_v2(). Some test cases added but more are needed. Ticket #2616. (CVS 4376) file: [d783e7f1] check-in: [020a2b10] user: drh branch: trunk, size: 4119
2007-08-31
18:34
Remove the xLockState method for sqlite3_io_methods. Replace it with a defined call to xFileControl(). This simplifies the interface and also gives us coverage testing of sqlite3_file_control(). (CVS 4355) file: [f204c1a9] check-in: [306586c4] user: drh branch: trunk, size: 4117
16:11
Initial implementation of the sqlite3_file_control() interface. Compiles and passes all historical tests but the new method is itself untested. (CVS 4353) file: [80fcf521] check-in: [d3ab3e39] user: drh branch: trunk, size: 4212
2007-08-29
12:31
Modifications to the malloc failure tests to test transient and persistent failures. (CVS 4321) file: [1ac44680] check-in: [e38ef81b] user: danielk1977 branch: trunk, size: 4180
2007-08-28
22:24
Clean up the locking in the btree logic. (CVS 4316) file: [a9872db1] check-in: [967ab229] user: drh branch: trunk, size: 4171
2007-08-17
15:53
Begin migration to using sqlite3_vfs interface. (CVS 4240) file: [53087c6f] check-in: [af3e3c7a] user: danielk1977 branch: trunk, size: 4135
2007-05-08
21:45
Remove compiler warnings in the amalgamation. (CVS 3960) file: [94110a55] check-in: [c5754530] user: drh branch: trunk, size: 4155
14:51
Add the max_page_count pragma used to limit the maximum size of a database file. Untested. (CVS 3948) file: [db316917] check-in: [b1b74f06] user: drh branch: trunk, size: 4055
01:08
Begin implementing a new system of upper bounds on the capabilities of SQLite. By clearly defining the upper bounds, we make those upper bounds explicitly testable. This check-in is just infrastructure. The upper bounds are not yet enforced. (CVS 3941) file: [236e4065] check-in: [93b623b2] user: drh branch: trunk, size: 4012
2007-04-13
02:14
Fix multiple performance regressions (ticket #2298 among them) and add tests to make sure they do not come back. (CVS 3839) file: [d652ddf0] check-in: [32bb2d58] user: drh branch: trunk, size: 4819
2007-03-30
14:06
Refactoring the btree and pager routines into distinct two-phase commit routines. We've always done a two-phase commit - this change is just making that more apparent in the code. (CVS 3762) file: [e79a24cf] check-in: [66b3ad09] user: drh branch: trunk, size: 4824
2007-03-27
16:19
Test handling of IO errors that occur in OsDelete() or OsTruncate() operations. Also use an anonymous file for temporary storage during a VACUUM. (CVS 3729) file: [f1b17bf8] check-in: [b24a6e7b] user: danielk1977 branch: trunk, size: 4814
2007-03-24
16:45
Changes for exclusive access mode. There are still some bugs. (CVS 3712) file: [3c16500c] check-in: [b6c70037] user: danielk1977 branch: trunk, size: 4625
2007-03-19
17:44
Modify the interface to the pager sub-system in preparation for performing IO in blocks based on sector-size, not database page-size. (CVS 3705) file: [9f6b5ef4] check-in: [7dc76588] user: danielk1977 branch: trunk, size: 4386
2007-03-04
13:15
Changes to the btree and pager that reduce the amount of I/O when dealing with the freelist. (1) Avoid journaling pages of a table that is being deleted. (2) Do not read the original content of pages being pulled off of the freelist. (CVS 3671) file: [8881591c] check-in: [2ba5be31] user: drh branch: trunk, size: 4274
2006-11-06
21:20
Use the difference between the SQLITE_IOERR_SHORT_READ and SQLITE_IOERR_READ returns from sqlite3OsRead() to make decisions about what to do with the error. (CVS 3503) file: [2e6d42f4] check-in: [6324ea81] user: drh branch: trunk, size: 4195
2006-08-08
13:51
Remove most static and global variables from a pure build. There are still a number of static and global variables used for testing. (CVS 3342) file: [0cff9de5] check-in: [76e4d418] user: drh branch: trunk, size: 4196
2006-03-06
18:23
Pager performance enhancements. (CVS 3125) file: [43f32f38] check-in: [9c265707] user: drh branch: trunk, size: 4161
2006-02-11
01:25
Add support and documentation for the fullfsync pragma. Also include some other unrelated documentation updates. (CVS 3080) file: [425a9e52] check-in: [f2069d0b] user: drh branch: trunk, size: 4160
2005-12-19
14:18
Add some very simple test cases (and resulting bug fixes) for release_memory(). (CVS 2826) file: [e0acb095] check-in: [154282fc] user: danielk1977 branch: trunk, size: 4164
2005-12-18
08:51
Add the (untested) sqlite3_release_memory() function. (CVS 2825) file: [5c148739] check-in: [345addaa] user: danielk1977 branch: trunk, size: 4126
2005-09-19
19:05
Set the default maximum page size to 32768, not 8192. (CVS 2724) file: [e7b41ce8] check-in: [b32e9ec2] user: drh branch: trunk, size: 4057
2005-08-27
16:36
Disable synchronous writes to the master journal when PRAGMA synchronous=OFF for all database files. Ticket #1375. (CVS 2630) file: [17b13225] check-in: [644b96aa] user: drh branch: trunk, size: 4056
2005-05-20
20:01
Do not allow the pagesize of :memory: databases to be changed. Silently ignore PRAGMA page_size=N requests for :memory: databases. Ticket #1144 and #1252. (CVS 2466) file: [0d9153d6] check-in: [f29a1d88] user: drh branch: trunk, size: 4023
2005-03-31
21:02
Update comments and documentation to give the true maximum page size as 32K, not 64K as was previously (and erroneously) reported. Ticket #1194. (CVS 2437) file: [94bb4270] check-in: [58dd436b] user: drh branch: trunk, size: 4024
2005-03-21
04:04
Add function to recover from a malloc() failure. (CVS 2414) file: [9a417a1e] check-in: [1f9d10d7] user: danielk1977 branch: trunk, size: 3928
2005-02-06
02:45
Add the (highly experimental) omit_readlock pragma that disables the use of readlocks on read-only databases that are connected using ATTACH. (CVS 2317) file: [70d496f3] check-in: [2155448d] user: drh branch: trunk, size: 3888
2004-11-05
16:37
Do not truncate a database file until after fsync() has been called on the journal. (CVS 2068) file: [9eba8c53] check-in: [cfee7f4a] user: danielk1977 branch: trunk, size: 3598
2004-11-02
12:56
Code to auto-vacuum the database if all root pages happen to be in the right place. Not active by default and largely untested. (CVS 2037) file: [cbe4ba35] check-in: [d12481f0] user: danielk1977 branch: trunk, size: 3592
2004-10-05
02:41
Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) file: [774d1973] check-in: [81ff8107] user: drh branch: trunk, size: 3538
2004-07-22
01:19
Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) file: [67739fe6] check-in: [4cf6e9db] user: drh branch: trunk, size: 3526
2004-06-30
08:20
Fixes for compiler warnings. Also more coverage. (CVS 1775) file: [269b6cfc] check-in: [fa19c77b] user: danielk1977 branch: trunk, size: 3859
2004-06-26
08:38
Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737) file: [fe818866] check-in: [4e207209] user: danielk1977 branch: trunk, size: 3829
2004-06-14
06:03
Ensure the master journal directory is synced. Also, change the master journal format to store journal file names. (CVS 1583) file: [bc58d32a] check-in: [73cd0aab] user: danielk1977 branch: trunk, size: 3833
2004-06-09
17:37
Fixes to the file locking. 109 tests are now failing. (CVS 1548) file: [ca8f293e] check-in: [dc076345] user: drh branch: trunk, size: 3737
14:17
Add the "lock_status" pragma - only available when SQLITE_DEBUG is defined. Used for testing only. (CVS 1547) file: [3576e5f1] check-in: [0ecbba78] user: drh branch: trunk, size: 3677
2004-06-04
06:22
Move the 'busy-callback' logic to the pager layer. (CVS 1527) file: [0c7b5ac4] check-in: [ff70b6d2] user: danielk1977 branch: trunk, size: 3621
2004-06-03
16:08
Untested updates to support atomic multi-file transactions (CVS 1526) file: [ade5bee4] check-in: [d57e5252] user: danielk1977 branch: trunk, size: 3580
2004-05-14
01:58
Changes to btree and pager in preparation for moving to run-time page size determination. (CVS 1374) file: [78a00ac2] check-in: [f63fb6dd] user: drh branch: trunk, size: 3517
2004-05-08
08:23
Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) file: [0c95b18f] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 3525
2004-04-26
14:10
Pager tests working. (CVS 1308) file: [138ca7f7] check-in: [910067a2] user: drh branch: trunk, size: 3514
2004-02-11
02:18
Pass all (relevant) regression tests when using the codec. (CVS 1223) file: [82332878] check-in: [5200e9ed] user: drh branch: trunk, size: 3568
2004-02-10
01:54
Allow SQLITE_PAGE_SIZE to be redefined on the compiler command-line. (CVS 1217) file: [b618354f] check-in: [4c7bf714] user: drh branch: trunk, size: 3563
2004-02-09
01:20
Add an optional codec to the pager layer. (CVS 1214) file: [767867c8] check-in: [2f0c122c] user: drh branch: trunk, size: 2831
2003-04-25
13:22
Make VACUUM work even if multiple processes have the database open at once. (CVS 933) file: [5da62c83] check-in: [caa96028] user: drh branch: trunk, size: 2732
2003-04-06
20:44
Simplify the BTree interface by shortening names. Added two new methods for accessing the current filename and for changing the name of the database file. (CVS 900) file: [e3702f7d] check-in: [185d8dc8] user: drh branch: trunk, size: 2693
2003-03-19
03:14
Modifications to the VDBE to support more than one database file. (CVS 878) file: [97d9a8cc] check-in: [875da9ee] user: drh branch: trunk, size: 2597
2003-02-12
14:09
Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) file: [e5b8e301] check-in: [792a9e15] user: drh branch: trunk, size: 2537
2003-02-11
14:55
Modify the journal format to be more robust against garbage that might appear in the file after a power failure. The changes are mostly working but more testing is still required. This check-in is to checkpoint the changes so far. (CVS 861) file: [ce264d55] check-in: [8ec56325] user: drh branch: trunk, size: 2490
2002-12-02
04:25
Change to the pager to avoid opening journal files unnecessarily. This can sometimes results in a significant speed improvement. (CVS 791) file: [540833e8] check-in: [fa5c0425] user: drh branch: trunk, size: 2492
2002-08-12
12:29
Fix for ticket #9 (again). The rollback journal files should now also be byte-order independent. (CVS 705) file: [6991c9c2] check-in: [2fb3fdcd] user: drh branch: trunk, size: 2449
2002-03-05
12:41
Change the pager locking mechanism so that we don't have to write page 1 to the journal and to the database unless it actually changes. (CVS 419) file: [6fddfddd] check-in: [480eef1a] user: drh branch: trunk, size: 2427
2002-03-02
20:41
Pager optimization: do not write or journal free pages. This results in a 2x performance gain for large INSERTs and a 5x performance gain for large DELETEs. (CVS 410) file: [feb18aab] check-in: [cf1ebcfb] user: drh branch: trunk, size: 2397
2002-02-02
15:01
Checkpoint code added to the pager. Regression tests work but the new APIs have not been tested yet. (CVS 361) file: [b28f004e] check-in: [aaa53e11] user: drh branch: trunk, size: 2315
2001-12-15
14:22
Comment and documentation changes. (CVS 331) file: [f78d064c] check-in: [e8595579] user: drh branch: trunk, size: 2203
2001-11-10
13:51
Comment changes (CVS 308) file: [df1fb8a7] check-in: [2d2ad264] user: drh branch: trunk, size: 2112
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [a0d4c5ae] check-in: [4e926efe] user: drh branch: trunk, size: 1867
2001-09-15
13:15
Limit the total data in a single row to 2^16-1 bytes. (CVS 248) file: [61573be9] check-in: [8fdec4d8] user: drh branch: trunk, size: 2416
2001-09-14
18:54
Added a PRAGMA statement. Took out the special comment parsing. (CVS 245) file: [bb9136e8] check-in: [5e372460] user: drh branch: trunk, size: 2265
2001-09-13
13:46
The code is in place to replace GDBM with BTree. But I have not yet attempted to compile it. I am sure the code contains bugs. (CVS 238) file: [238aa88b] check-in: [6ecc8b20] user: drh branch: trunk, size: 2220
2001-07-02
17:51
BTree and pager are working pretty well now. (CVS 234) file: [ee84c00c] check-in: [a84fb078] user: drh branch: trunk, size: 2184
2001-06-28
01:54
Got a lot of BTree tests working. Still lots more needed. (CVS 230) file: [d85259a2] check-in: [9cfeeb58] user: drh branch: trunk, size: 2148
2001-06-22
19:15
The BTree code compiles and links now, but it does not work yet. (CVS 226) file: [724ac5a7] check-in: [b31c4902] user: drh branch: trunk, size: 2061
2001-05-24
21:06
Continued work on btree (CVS 219) file: [e527411d] check-in: [18500cdc] user: drh branch: trunk, size: 2033
2001-04-28
16:52
:-) (CVS 214) file: [ed12ac3d] check-in: [73a1ed61] user: drh branch: trunk, size: 1977
2001-04-15
00:37
Pager is working, mostly. (CVS 211) file: [8678d9a9] check-in: [f82fa707] user: drh branch: trunk, size: 1919
2001-04-03
16:53
Bug fixes from Oleg Oleinick (CVS 195) file: [889c5cf5] check-in: [1f0197d5] user: drh branch: trunk, size: 1907 Added