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 | |