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
25,662 Commits 1,570 Branches 184 Tags
branch-3.28
Commit Graph

172 Commits

Author SHA1 Message Date
drh
746a1515b2 Remove the sqlite3PagerUseWal() routine which was made obsolete by 
the [81629ba91475938b6ad] change.

FossilOrigin-Name: 4331b4990cbc1221d94fadd376dfc6efe83f67836aef00912126da4c924bf659
 2018-11-27 14:41:07 +00:00
dan
09236755ee Fix a problem reading from temp databases in SQLITE_DIRECT_OVERFLOW_READ 
builds.

FossilOrigin-Name: 81629ba91475938b6ad528e7b1dbef4ad22239782bb2e9c1bb59413aba11da87
 2018-11-22 19:10:14 +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
drh
fd72563d0a Avoid a race condition that might cause a busy_timeout to last longer than 
it should.

FossilOrigin-Name: b81960561b47a1b49646f2f8870dd0684dc4ca7c0b9e11076fd713de66b75972
 2018-03-26 20:43:05 +00:00
drh
80262896d6 Refactor some internal object element names used by the busy handler, to 
simplify analysis.

FossilOrigin-Name: 6c40c5574f4ae9795a142d01a8f84afd1b72678ea5f6bfca14a8646c4e862605
 2018-03-26 16:37:53 +00:00
drh
3908fe90b1 Add the new sqlite3PagerUnrefPageOne() pager method to deal with the special 
case of unreferencing page1.

FossilOrigin-Name: b2e2100cf766da1cb499aec0ca0a9969d7af5d93312ab8cf895fbf4a6ffb9b2f
 2017-09-01 14:50:19 +00:00
drh
d930b5cb06 Make SQLITE_DIRECT_OVERFLOW_READ work for in WAL mode as long as the page 
being read is not in the the -wal file.

FossilOrigin-Name: 9879be1899adf5634f551a2077b15ccb1133e4e3
 2017-01-26 02:26:02 +00:00
dan
1158498dce Add experimental sqlite3_snapshot_recover() API. 
FossilOrigin-Name: 174a6076a8d7bebe5efebf55f3fdc5d87c589cc7
 2016-11-18 20:49:43 +00:00
dan
e24452edef 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.

FossilOrigin-Name: b54c15f11796a75683eec4b502a22ccb87d621c6
 2016-10-21 10:49:39 +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
dan
43c1ce390f Undo commit [f250166bb]. It is required to handle IO and other errors that occur within a VACUUM of a Zipvfs database. 
FossilOrigin-Name: ae72513af37cd806a6d94aaa7c47a740e119d3b1
 2016-08-05 16:16:26 +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
drh
d20b2a4109 Remove the sqlite3PagerClearCache() routine, which does not accomplish anything 
useful.

FossilOrigin-Name: f250166bb3c1b0c58e703b334825cf6210758fda
 2016-05-20 18:09:01 +00:00
drh
497116007e Add the SF_HasAgg constant (currently unused). Also enhance the comments on 
many other constant definitions to detail constraints on their values.

FossilOrigin-Name: 7b7a69d098f7581a43b818c251717c2450b797de
 2016-04-14 16:40:13 +00:00
drh
b052958657 Remove code not needed now that synchronous=OFF database files no longer 
trigger the use of a master journal.

FossilOrigin-Name: aa9f4c622af191edbeb6a535942944f8c91f5c37
 2016-02-22 23:44:42 +00:00
drh
6841b1cb3d 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.

FossilOrigin-Name: af92401826f5cf49e62c278f344ab75252a18da2
 2016-02-03 19:20:15 +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
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
790f287c53 Add the SQLITE_FCNTL_VFS_POINTER file control which obtains a pointer to 
the top-level VFS in use by a database connection.

FossilOrigin-Name: 7c6a809e25138950f50554e1fb96e0b6ebbe0bd4
 2015-11-28 18:06:36 +00:00
drh
9b0cf34f81 First attempt at enhancing the "PRAGMA cache_spill" statement to accept a 
cache threashold size.

FossilOrigin-Name: 549d42be0dac87dc04c3eeccfdc60615c3a6ad3f
 2015-11-12 14:57:19 +00:00
drh
9584f58cc2 Rename the sqlite3PagerAcquire() function to sqlite3PagerGet(). The former 
macro called sqlite3PagerGet() has been removed.

FossilOrigin-Name: 708253be34084b89987efe955c34557516171a3a
 2015-11-04 20:22:37 +00:00
dan
6fa255fd5c Add experimental API sqlite3_db_cacheflush(). 
FossilOrigin-Name: 65b86dc1fa4a57cc3cde86a820d9f848aa288a15
 2015-10-28 19:46:57 +00:00
drh
58cb6dbe0d 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.

FossilOrigin-Name: 5b61b72f5424a2d9bb4e68eb95026cd63f003db9
 2015-09-23 19:17:23 +00:00
drh
e05b3f8f0b Simplification of PRAGMA integrity_check logic. Make sure that the depth 
of the right-most subtree is correct.  Size reduction and performance increase,
with no change in output.

FossilOrigin-Name: 550705fcb64e7ad637686e47cabe2621d65851bf
 2015-07-01 17:53:49 +00:00
drh
9161856495 Experimental "PRAGMA data_version" command for detecting when another process 
has changed the database file.

FossilOrigin-Name: 43db1f44bce5a0ee50197b95ab0d844540b69d86
 2014-12-19 19:28:02 +00:00
dan
e6593d8e8c Fix some minor formatting and code organization issues. 
FossilOrigin-Name: eab8706dc47aa0a44caf73619de858397c3e0b4e
 2014-10-24 16:40:49 +00:00
dan
33ea486603 Change the balance_nonroot() routine to reduce the amount of memcpy work that takes place. This is a work in progress. 
FossilOrigin-Name: 29304499ea4b72dbb6701e10cc19b5d41f7e5ac9
 2014-10-09 19:35:37 +00:00
drh
da8a330a03 Create and use a new pager interface sqlite3PagerUnrefNotNull() that works 
just like sqlite3PagerUnref() but guarantees that its argument is not a
NULL pointer.

FossilOrigin-Name: e00f37e2333cac5b53e17cf764ab56c4fcd5f617
 2013-12-13 19:35:21 +00:00
dan
999cd08aae Modify the way some internal file-controls are invoked. In order to support multi-file transactions in the zipvfs extension. 
FossilOrigin-Name: 32fb1784af4594161d954343e3787db702000a4d
 2013-12-09 20:42:03 +00:00
drh
b00fc3b14e Simplify the btreeGetPage() routine so that it uses a single flag parameter 
in place of two boolean parameters.

FossilOrigin-Name: 617e23ec283d3147fc3fd29c474ccedf4915cdc7
 2013-08-21 23:42:32 +00:00
drh
40c3941cfa Add the cache_spill pragma. 
FossilOrigin-Name: cdb181c04fa99c6c29f23eb68ccb5475e7f6bf9c
 2013-08-16 20:42:20 +00:00
drh
0d0614bdc6 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.

FossilOrigin-Name: 1b37c4effdd03aa2ea938a71b4f22ed27391689b
 2013-03-25 23:09:28 +00:00
dan
a1afc7425a Fix a case in the pager where an xFetch() reference was being leaked following an OOM error. 
FossilOrigin-Name: 5885ba6ce768658ec25b60747430d147b315b55c
 2013-03-25 13:50:49 +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
dan
eb97b29345 When possible, use memory mapping when appending new pages to a database file. 
FossilOrigin-Name: 14135da3cdbafd699563a29608f32347cda28338
 2013-03-20 14:26:59 +00:00
dan
11dcd11913 Allow read-only cursors to use mmap pages even if there is an open write transaction. 
FossilOrigin-Name: b387e2f9d24dccac1fd040e309f6fc7ec1cfffba
 2013-03-15 18:29:18 +00:00
dan
06a2d82566 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). 
FossilOrigin-Name: f7437153b90b25a1b77294a0f8d1b0bd4bd08c08
 2012-10-10 09:46:29 +00:00
dan
c9a5326974 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. 
FossilOrigin-Name: 6b4ff83bff07d427af585c9fd03be90abf2fc82f
 2012-10-01 06:50:55 +00:00
drh
d4e0bb0e65 Have user interfaces report out the filename of in-memory databases as an 
empty string, as it always has.  This simplifies the changes.

FossilOrigin-Name: 595dfdbffefb2598cba89980f885289d1c5f5833
 2012-05-27 01:19:04 +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
drh
33f111dc72 Remove the undocumented PRAGMA omit_readlock hack. 
FossilOrigin-Name: 96900c47e4fc6ed55cefc10d55d3d8d16bcb1d31
 2012-01-17 15:29:14 +00:00
drh
09419b4bae Add the sqlite3_db_release_memory() interface and the shrink_memory pragma. 
FossilOrigin-Name: 3f58e7c8895d1252eff56282c08b1a6f1194452c
 2011-11-16 19:29:17 +00:00
dan
1a83bc5b1a 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. 
FossilOrigin-Name: 07159e84b40b01fa40cac5fad1f433888e5984f8
 2011-10-21 14:27:32 +00:00
dan
58ca31c905 Add the SQLITE_DB_STATUS_CACHE_HIT and MISS options. For querying the number of cache hits and misses on a per-connection basis. 
FossilOrigin-Name: 5100b6e9dc5107f0f835d0aac26fe6d4938ffc73
 2011-09-22 14:41:16 +00:00
dan
73ac46da31 Remove a stray merge-sort related change from pager.c and pager.h. 
FossilOrigin-Name: 69823ed163049d6fa1e24a9810c3c99f2a8fdd46
 2011-09-19 11:57:34 +00:00
drh
34163c6831 Remove some dead code. Fix a faulty assert(). Improve some variable names. 
FossilOrigin-Name: a9a64592cf88580cb254fb0aac65a2f2085976ec
 2011-09-02 21:42:33 +00:00
drh
2a5d9908f9 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.

FossilOrigin-Name: c71d73201d950355862dd8d5de142c9673888755
 2011-08-26 00:34:45 +00:00
drh
27f9aba18c Merge the checkpoint_fullfsync pragma and the superlock demonstration into 
the checkpoint-v2 experimental branch.

FossilOrigin-Name: ebf74015f09fe241c1c6902dc8954f2b59ab41ec
 2010-11-19 18:51:31 +00:00