database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
30,720 Commits 1,570 Branches 184 Tags
bedrock
Commit Graph

68 Commits

Author SHA1 Message Date
dan
a7866eefb5 Merge latest changes from the wal2 branch into this one. 
FossilOrigin-Name: 4d8df0c426b8ce3db6cfb71e23f752026ef886b9bb833dc4be9717db9955b1db
 2023-08-21 18:31:53 +00:00
dan
cc74eafee5 Merge latest trunk changes into this branch. 
FossilOrigin-Name: 135bf72c6b5f436b11463dd40b3a73bcc610bf9c2dcbe6646dbedd0d9325f6a9
 2023-08-21 18:02:57 +00:00
drh
ba481c3756 ifdef adjustments so that SQLITE_OMIT_WAL works with SQLITE_USE_SEH. 
FossilOrigin-Name: 0462a2612d1fc1d077acf60ef415f358aa2c44174c4ef28f4bbfdbcbf03d3b7c
 2023-08-21 15:29:21 +00:00
dan
f08877f094 Merge latest wal2 changes, including support for handling of structured-exceptions in MSVC builds, with this branch. 
FossilOrigin-Name: 331f2f3e5db9b6139be984f1b959cd0d51563adaa68452aa2f42741c69bc6319
 2023-08-11 19:36:24 +00:00
dan
45d92dd539 Merge latest trunk changes, including support for handling of structured-exceptions in MSVC builds, with this branch. 
FossilOrigin-Name: 00bfae9ffafd71dfd0bbdbdc174e4ed7d7a850b385416f83be36a4f4a55d1873
 2023-08-11 19:33:54 +00:00
dan
d095b2c3d5 Add the sqlite3_commit_status() API. For querying a connection for (a) the ranges of wal/wal2 frames written after a successful commit, and (b) the conflicting frame following a failed commit of a BEGIN CONCURRENT transaction. 
FossilOrigin-Name: 4b08d4dad6b254a342353e3f765066c85cbc5450fe13501665c648627cca21cd
 2023-06-19 18:16:19 +00:00
dan
9023444fea If an EXCEPTION_IN_PAGE_ERROR exception is caught, make the underlying OS error code available via sqlite3_system_errno(). 
FossilOrigin-Name: fdb20e9ee48465b94aa6ac3c5e263ecaa7c3b10f4a193e79f965b7c35944b08b
 2021-09-10 21:28:56 +00:00
dan
9019e39d0d Merge latest trunk changes into this branch. 
FossilOrigin-Name: 5dc355ccf6ecf0af61e73efbf65bc5e1e192f748568344afbf8bca014ef98df9
 2020-05-18 19:55:43 +00:00
dan
69105498b9 Merge latest trunk changes into this branch. 
FossilOrigin-Name: 16b1eca922d6e10a0ebce1deb559c6c7dd74f8655e3456bad8384c6f4637e6d6
 2020-05-18 17:18:28 +00:00
dan
861fb1e9dc Block on the WRITER lock when attempting to run recovery. 
FossilOrigin-Name: 105d6c9bbcadc64faa2b24e315cb13227b17cfc6bf1b3512713f80ce56976a3d
 2020-05-06 19:14:41 +00:00
dan
58021b237a 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. 
FossilOrigin-Name: d6f819a9e6b35f3fd558bd93255a6a24ad690a0fa15a82b009ca9c641db983c6
 2020-05-05 20:30:07 +00:00
dan
8714de97c0 Changes to avoid deadlock in SQLITE_ENABLE_SETLK_TIMEOUT builds. 
FossilOrigin-Name: 553423c23142cf0ec219192315d57ce8a0e10c3d8678d28bc110a1a9a7c17cee
 2020-05-04 19:42:35 +00:00
dan
5a19f287dc Merge changes from begin-concurrent-wal2. Also modify the unix-excl shm-locks 
on this branch so that it is not an error to attempt to release an EXCLUSIVE
lock that is not held.

FossilOrigin-Name: 86685679b4cff94704fe4b52364f25f579d98ee725407cfe3bd2bbf7ecd651a8
 2019-01-02 19:46:46 +00:00
dan
d080e84c81 Merge latest begin-concurrent changes with this branch. 
FossilOrigin-Name: 1625887c0240eb1cb37e41d79e789c4ff311352c5708e6a2d3ed1b223ff382e3
 2018-12-29 20:47:45 +00:00
dan
ff9e9b27d5 Fix a problem causing a corrupt pager-cache if an OOM or IO error was 
encountered while committing a concurrent transacation.

FossilOrigin-Name: 48ca30f9d7817d87a5e9a069fdc51b1a34e00585f8a35771895dd743c7bfe07c
 2018-12-29 20:42:12 +00:00
dan
0ba73a6e4d Merge the wal2 feature into this branch. 
FossilOrigin-Name: a2c618c0a45e1b1d271a4a981ee1e3b368dfcce94eda5c2d7d08f794784046d9
 2018-12-18 18:01:17 +00:00
dan
079ae546fe Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode 
(wal instead of wal2) under some circumstances.

FossilOrigin-Name: bf309107dfc4d2abd68b9339c68aeaaffd278096bb2a5912e4a0b0c124fd6345
 2018-12-05 17:20:47 +00:00
dan
e05f922583 Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode 
(wal instead of wal2) under some circumstances.

FossilOrigin-Name: 1d8d4f689653ce80157740e339f7f1b42479bf90d82b176d8202d0a49f428398
 2018-12-05 17:14:03 +00:00
dan
4d8517e500 Merge the wal2 and begin-concurrent code. Both features work, but not at the 
same time.

FossilOrigin-Name: b7281a1caa574870a071bea3e96b1d8210c28c17f9094449b3ce1a42b311e6a1
 2018-12-03 20:49:34 +00:00
dan
8eed108df1 Sync this branch with the latest trunk. 
FossilOrigin-Name: 7a44fa5a350a3f19b8e9f5196d22535788885f8c0e849572202bf64a055ddc2d
 2018-12-01 20:14:06 +00:00
dan
2dd93c8838 Merge latest trunk into this branch. 
FossilOrigin-Name: 86750c927cb5ba36acad33d5279629699c42b598e70fdc4887b40a1a16771ff6
 2018-09-28 20:58:10 +00:00
dan
fa3d4c19a9 Allow sqlite3_snapshot_open() to be called to change the snapshot after a 
read transaction is already open on database.

FossilOrigin-Name: 051ac0152048ef52723196c26ca5f2629dafb782aec1c66fc30531bf54335043
 2018-08-06 17:12:36 +00:00
dan
055cc1e431 Add experimental mode that uses two wal files. Activated using "PRAGMA 
journal_mode = wal2".

FossilOrigin-Name: e2fc5c814cf6862d536aacb9eca66ecd31ba7e3e3033fa4c5564d533f4a18dfc
 2017-10-04 20:57:14 +00:00
drh
b25057c291 Merge recent enhancements from trunk. 
FossilOrigin-Name: d53108e76307fb24ef1d8f75fe82c180f5588ad8e65eeceace92f4cecadfa452
 2017-08-28 17:19:35 +00:00
drh
daaae7b9d1 Update the mechanism used to keep track of what kind of syncing to do for 
WAL transaction commits and checkpoint operations.  Use the checkpoint-style
of syncing to sync the header of a new or restarted WAL file.

FossilOrigin-Name: bf65dae8d4297c57ac63228ccf0100f9fabf2fb600438c9f2e10a29c4b118168
 2017-08-25 01:14:43 +00:00
dan
995b2457e2 Instead of a root page number, log the object (table or index) name if a page 
level locking conflict is detected.

FossilOrigin-Name: 9ad846e57bd427adc7c29768cabca18905f7f978168e0642a5917d894fda8bfd
 2017-05-29 19:23:56 +00:00
dan
aa59505ae8 Add experimental new API sqlite3_wal_info(). 
FossilOrigin-Name: 5b9d498f6e9de6ee2ab86370c02c28a2a8b83d717b96d23b1fc52107677e45a2
 2017-05-23 19:23:45 +00:00
dan
e32c7c2b64 Upgrade this branch to 3.16 plus the various fixes that appeared after its 
release.

FossilOrigin-Name: d0e212d08f82dfb5e42a156b3e2bb03dd8e21258
 2017-01-09 06:33:50 +00:00
dan
1158498dce Add experimental sqlite3_snapshot_recover() API. 
FossilOrigin-Name: 174a6076a8d7bebe5efebf55f3fdc5d87c589cc7
 2016-11-18 20:49:43 +00:00
dan
7fb8990688 Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. 
FossilOrigin-Name: 8a5f41c7b1718507524adef1a2730e99cf53270a
 2016-08-12 16:21:15 +00:00
drh
3d4ad18cbe Merge version 3.14 plus some subsequent patches (including the page-cache 
performance patch) from trunk.

FossilOrigin-Name: d9f8918c5b7b6c8540b3f433142e1b4aa4433885
 2016-08-11 19:12:25 +00:00
drh
43f58d6a17 Fix various internal #defines to conform to new C-language naming restrictions, 
specifically that private-use macros names must not begin with "_".

FossilOrigin-Name: 5471aca0158851d3fb0a2517306917536deb38bb
 2016-07-09 16:14:45 +00:00
dan
f687ba597f Merge the latest enhancements and fixes from trunk. 
FossilOrigin-Name: fccc5f20c360fa17c3692a9f1fc1d16612632a7f
 2016-01-14 15:46:31 +00:00
drh
21d61853e7 Add the experimental SQLITE_FCNTL_JOURNAL_POINTER file control for obtaining 
the sqlite3_file pointer associated with a rollback journal or WAL file.

FossilOrigin-Name: a02ace9a746ff02fc1a5969bf13939b568624f93
 2016-01-08 02:27:01 +00:00
drh
8c9ea487d0 Merge recent enhancements from trunk. 
FossilOrigin-Name: cb22efaf50d83d9a73fdf8d986e6ea2fc6500cfb
 2015-12-16 19:55:57 +00:00
dan
fc1acf33b8 Add untested implementations of experimental APIs sqlite3_snapshot_get(), _open() and _free(). 
FossilOrigin-Name: 0715eb00aa8891400cd50a15509d3d7b13789626
 2015-12-05 20:51:54 +00:00
drh
01be463eeb Changes from ENABLE_CONCURRENT (default off) to OMIT_CONCURRENT (default on). 
This is not a clear-cut decision and might be changed back.

FossilOrigin-Name: f8ae9bfd05abc35293ad6bc62ab1bdbe357d964e
 2015-09-03 15:17:12 +00:00
drh
3f531da564 Fixes so that it builds without warnings both with and without 
SQLITE_ENABLE_CONCURRENT.

FossilOrigin-Name: 5ed2a445a164f0f0c2669c6681ea76618e639961
 2015-09-01 17:48:54 +00:00
dan
654a965367 Fix another problem involving unlocked transactions and wal-file restarts. 
FossilOrigin-Name: 4460764ea8fc948fe02f0a09476857839b3aa1ae
 2015-08-24 06:43:25 +00:00
dan
b87b25f219 Fix many minor issues in the unlocked transaction code. 
FossilOrigin-Name: 53aaeea6c98f82f3b55d4b3ab139ee41b727243c
 2015-08-21 20:11:23 +00:00
dan
7b3d71e9cc 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. 
FossilOrigin-Name: 3bbc31d515ba9fc920c5cbc7059d3eb1ba9c7f8e
 2015-08-19 20:27:05 +00:00
dan
773d2d6c09 Only allow UNLOCKED transactions to commit if none of the pages read by the transaction have been modified since it was opened. 
FossilOrigin-Name: 0b9718426e44df092850c5d095ce1b84a1e567cf
 2015-07-29 12:14:28 +00:00
dan
3d39434c36 Add an experimental "BEGIN UNLOCKED" command. 
FossilOrigin-Name: 8079421604dbd40d03471dad6d12115119b554c2
 2015-07-27 19:31:45 +00:00
dan
32c12fe2bb Minor fixes for compilation with SQLITE_OMIT_WAL defined. 
FossilOrigin-Name: b81e87e72b976e7157a53a50abc5422e2a6c4c39
 2013-05-02 17:37:31 +00:00
dan
f23da96636 Replace the sqlite3_io_methods.xMremap interface with sqlite3_io_methods.xFetch and xUnfetch. 
FossilOrigin-Name: 1431be95579160fb70408d43e17fc23c7b69ab4a
 2013-03-23 21:00:41 +00:00
dan
99bd10979a Allow the database file to be memory mapped in wal mode. 
FossilOrigin-Name: d190ddabc386bc9654b99e33fb81b2f6e67b54d6
 2013-03-22 18:20:14 +00:00
drh
70708600b5 Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only 
used by ZIPVFS.

FossilOrigin-Name: 3130275c64a60c5cfacbd11123305e6d99ea866d
 2012-02-24 14:33:28 +00:00
dan
b3bdc72ded Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs. 
FossilOrigin-Name: 786e24dc56504d1958db0618e645610f2600a087
 2012-02-23 15:35:49 +00:00
dan
0420b74a94 Minor changes to fix compilation with SQLITE_OMIT_WAL and SQLITE_OMIT_WSD defined. 
FossilOrigin-Name: 26a513a8d2dddfde82f5fd0a0e1cc186c9b0df94
 2011-12-30 10:54:24 +00:00
drh
4eb02a4556 Enhance the WAL header sync so that it honors the various synchronous 
pragmas, settings, and device characteristics.

FossilOrigin-Name: 9799241f7de952c4d1ea8bf6508b577d2b57a370
 2011-12-16 21:26:26 +00:00