database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
10,307 Commits 1,785 Branches 392 Tags
winFileMapping
Commit Graph

134 Commits

Author SHA1 Message Date
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
drh
c97d84638e Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint 
operations only, not during ordinary commit fsyncs.

FossilOrigin-Name: a069867301de3ca2e1753bd4d2e426d27365be4c
 2010-11-19 18:23:35 +00:00
dan
cdc1f049bf Modify the interface to the blocking wal-checkpoint functionality. 
FossilOrigin-Name: 72787c010c8944e8fcf9c98aa4482f129142d8e9
 2010-11-18 12:11:05 +00:00
dan
a58f26f93f 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. 
FossilOrigin-Name: 7e3fc2c833a5baa08820c499867b6902bdc2ed5a
 2010-11-16 18:56:51 +00:00
drh
75c014c321 Remove the sqlite3BtreeFactor() wrapper routine. All modules now call 
sqlite3BtreeOpen() directly.

FossilOrigin-Name: 0900e35348f4b9bf327d6ae2884c4ddbb6345d8d
 2010-08-30 15:02:28 +00:00
drh
8fb8b53728 Change sqlite3PagerPagecount() to return void, since the return value was 
always SQLITE_OK and was never used.

FossilOrigin-Name: 7dd78eb7974ec7c40af3fcf2b125ca5bc0766b5c
 2010-08-14 17:12:04 +00:00
drh
b2eced5de2 Increase the maximum page size from 32k to 64k. 
FossilOrigin-Name: 45362437d491fbe0f033a67b398f8ba68cbf1b3b
 2010-08-12 02:41:12 +00:00
drh
abfb62f9bd Cherry-pick the multi-file transaction fix for ticket [f3e5abed55] out of 
the experimental branch.

FossilOrigin-Name: 40f7f0a583e6bba66cd006253a0ef4623ea74f17
 2010-07-30 11:20:35 +00:00
drh
a715211820 Disable code used only by the codec when the codec is not deployed. 
FossilOrigin-Name: 2c90276e340aa19d78d2e33c9f759f8eda0b82a3
 2010-06-22 21:15:49 +00:00
dan
47ee386f06 Add codec support to wal mode. 
FossilOrigin-Name: 393741eba353d5d242b8e3c96db3ea2b92228036
 2010-06-22 15:18:44 +00:00
drh
0b9b4301b8 Refactor and simplify the logic used to change journalmode. 
FossilOrigin-Name: 95cc3f6fdec5494560c3cd4439d06870d1c62506
 2010-06-11 17:01:24 +00:00
drh
d9e5c4f6ed Refactoring the VFS-SHM methods used by WAL. This version compiles and 
runs non-WAL test cases but crashes and burns on wal.test.

FossilOrigin-Name: 2b00152c1ac0b3735aa6cfab61259ff04d81c701
 2010-05-12 18:01:39 +00:00
drh
7ed91f2344 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.

FossilOrigin-Name: 62db5fa3b61be885b2d94e9b9ce3877b2c588350
 2010-04-29 22:34:07 +00:00
dan
e04dc88be5 Use the read and write version fields of the database header to mark a database as operating in wal-mode. 
FossilOrigin-Name: 96bef18c1411c3e0348295886f105e1646c46320
 2010-04-20 18:53:15 +00:00
dan
8d22a17411 Add the sqlite3_log_hook() interface for scheduling checkpoints. 
FossilOrigin-Name: 9bda601455705475075e33bfa85687bce34b15ff
 2010-04-19 18:03:51 +00:00
dan
f05c86dd73 Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". 
FossilOrigin-Name: 27dc5977c19e717afd65d3805557e38dec7bedcb
 2010-04-13 11:56:03 +00:00
dan
7c24610e64 Import experimental write-ahead-logging code. 
FossilOrigin-Name: 409d61baeb0a19d1700c973f16c8acef7b8506cd
 2010-04-12 19:00:29 +00:00
drh
63da089314 Add the SQLITE_DBSTATUS_CACHE_SIZE verb for sqlite3_db_status(). The 
highwater mark does not yet work on this verb.

FossilOrigin-Name: 418c6d8113bc337556b0d47acfd6a7d865d1121f
 2010-03-10 21:42:07 +00:00
drh
c81c11f62c Remove the obsolete "$Id:$" RCS identifier strings from the source code. 
FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
 2009-11-10 01:30:52 +00:00
drh
4775ecd06a Further simplifications to pager.c in support of structural coverage testing. (CVS 6929) 
FossilOrigin-Name: 866216c0b6ba23b66483046fb402ddbe4f9a7b14
 2009-07-24 19:01:19 +00:00
danielk1977
89bc4bc645 Change getAndInitPage() (btree.c) to use only PagerAcquire(), not PagerLookup() and PagerAcquire(). (CVS 6916) 
FossilOrigin-Name: 0b41dfc066b60ccabbf1a9ab4db41ebcb73a2799
 2009-07-21 19:25:24 +00:00
drh
fa9601a9a6 Move codec management from database connections into the pager so that it 
will work together with shared cache. (CVS 6782)

FossilOrigin-Name: ed08b53cd64c4ff2c94ef4e48441c5236041c9ca
 2009-06-18 17:22:39 +00:00
danielk1977
d829335e42 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) 
FossilOrigin-Name: 38f8c5a14cd221af9e115a0fea689f2ff39e30e5
 2009-04-30 09:10:37 +00:00
danielk1977
0410302e58 Commit first version of the 'backup' feature. (CVS 6241) 
FossilOrigin-Name: 663479b417fc06ba1790a544f28694f8797cee57
 2009-02-03 16:51:24 +00:00
danielk1977
64beba4338 Avoid a segfault when running vacuum on an in-memory database. Ticket #3620. (CVS 6221) 
FossilOrigin-Name: 407830c6839a81fa0a1010940740df3011713a88
 2009-01-31 14:54:06 +00:00
drh
dc86e2b2cd Fix some minor compiler warnings. Added sqlite3Isalpha() for use in 
the soundex() function. (CVS 6203)

FossilOrigin-Name: bfc71edca471221add6b32b867d0b15171974eaf
 2009-01-24 11:30:42 +00:00
danielk1977
e1fd508a28 Optimization: When loading a new page into the cache, avoid redundant memset() calls to zero it. (CVS 6201) 
FossilOrigin-Name: 9c0b9f881367871105965d4268e2f2cde7f4d884
 2009-01-23 16:45:00 +00:00
danielk1977
bea2a94850 Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197) 
FossilOrigin-Name: 12f7346c13c180ed73d7a2e3b590be457360254a
 2009-01-20 17:06:27 +00:00
danielk1977
45d6882fd9 Revert (6187). (CVS 6188) 
FossilOrigin-Name: a353c1ab376b159c4d12532412365318cdbdcc60
 2009-01-16 16:23:38 +00:00
danielk1977
443c0597fe This commit is an error. Reverted by (6188). (CVS 6187) 
FossilOrigin-Name: aa67fd0cdb4f53a0c6e15c001d37554d15006718
 2009-01-16 15:21:05 +00:00
danielk1977
f90b7260b3 Fix for 'truncate file' operations on in-memory databases. (CVS 6131) 
FossilOrigin-Name: 83d1eafbde556f56969c6f285b6767d2c658dbfc
 2009-01-07 15:18:20 +00:00
drh
1c8781f43b Fix compiler warnings. (CVS 6117) 
FossilOrigin-Name: da770a8dff183b28aca287cafb9c8b82b98ea968
 2009-01-06 14:19:36 +00:00
drh
49b9d33892 Fix compiler warnings in pager.c (CVS 6102) 
FossilOrigin-Name: 78dd7909da15a9b2cbcdb9cbe86798cfc24f3230
 2009-01-02 18:10:42 +00:00
danielk1977
3460d19c85 Fix a problem with savepoint and incremental-vacuum. (CVS 6066) 
FossilOrigin-Name: 08352f9ea9d2a1759320efc46e418079000855cb
 2008-12-27 15:23:13 +00:00
danielk1977
fd7f045225 Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) 
FossilOrigin-Name: 34b56600ec0c5cd7b5faab265750252bc9850e3e
 2008-12-17 17:30:26 +00:00
drh
f49661a4eb Add explicit casts to silence nuisance warnings from VC++. (CVS 6004) 
FossilOrigin-Name: da1cbfa766f7f379c01f4ac9c1210462d8d7c590
 2008-12-10 16:45:50 +00:00
danielk1977
1ceedd3736 Simplify the way the pager layer invokes the busy-handler callback. (CVS 5922) 
FossilOrigin-Name: 7bd1ac189906d87ed360875551d50147dd2186f6
 2008-11-19 10:22:33 +00:00
danielk1977
b3175389c7 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) 
FossilOrigin-Name: 39ebf01addf9d0867daafd06a38719e725128f9c
 2008-10-17 18:51:52 +00:00
danielk1977
71d5d2cd49 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) 
FossilOrigin-Name: 40425e93421286cca1965d7a5769084526210c7a
 2008-09-29 11:49:47 +00:00