/ All files named "src/pager.h"
Login

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

History for src/pager.h

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