database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-20 08:47:46 +03:00
Code
29,836 Commits 1,540 Branches 176 Tags
Commit Graph

1192 Commits

Author SHA1 Message Date
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
164c957b09 Add the SQLITE_EXTRA_DURABLE compile-time option. 
FossilOrigin-Name: 30671345b1c1ee55a2d1aa17273213f1849efd81
 2016-01-25 13:55:47 +00:00
drh
b4acd6a8d6 Fix the build so that it works for SQLITE_OMIT_WAL again. 
FossilOrigin-Name: d55a557bc70460c46a67ae5acd9f8a8356a580c2
 2016-01-14 01:56:43 +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
5596eb3020 Return immediately if sqlite3PagerWrite() is called when the pager is in PAGER_ERROR state. 
FossilOrigin-Name: a6695b008487aeb7badf572fa32bfcba3c9fab03
 2015-10-30 14:28:16 +00:00
dan
9fb13abc6e Do not attempt to flush the pages of an in-memory database to disk if sqlite3_db_cacheflush() is called. 
FossilOrigin-Name: 9b79a390440a23542a370b591e567b31ebb35c42
 2015-10-29 21:11:22 +00:00
dan
dbf6773e88 Avoid automatically rolling back the transaction if an SQLITE_IOERR or SQLITE_FULL error occurs within sqlite3_db_cacheflush(). 
FossilOrigin-Name: 370b5d520c6523526988d0db5299f1bd09567782
 2015-10-29 18:16:40 +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
95a0b37156 Change the pcache module to keep track of the total number of references to 
all pages rather than the number of pages references, for a performance
improvement and size reduction.

FossilOrigin-Name: f00a9e1e998c4bd249a45444dc2d71a7e4903b8b
 2015-09-03 20:43:55 +00:00
drh
98c5f8795a A simple optimization and size reduction in sqlite3PagerAcquire(). 
FossilOrigin-Name: 618d8dd4ff44cce10cc4688a2134715ff66cc562
 2015-09-03 18:20:10 +00:00
drh
c98a4cc8b6 Change the Pager.hasBeenUsed flag into Pager.hasHeldSharedLock in order to 
take it off the critical path in sqlite3PagerAcquire().

FossilOrigin-Name: b79096be7cb02aae2f303db33a8bf19e69204374
 2015-09-03 17:54:32 +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
3169906d06 Change an unreachable branch into an assert() in sqlite3PagerAcquire() 
and optimize sqlite3PcacheOpenSavepoint() by factoring out rarely used code
into a subroutine.

FossilOrigin-Name: b406b20ecdf0bff63c5c222fab11cb9acee86765
 2015-06-30 11:07:32 +00:00
drh
d8c0ba3b02 Optimization to the sqlite3PcacheFetch() logic. 
FossilOrigin-Name: d9a0481ce0fd9824b1566f182d68ec46ef091b1b
 2015-06-30 03:57:59 +00:00
drh
50642b1deb Put all variable declarations for sqlite3PagerWrite() 
at the beginning of the block.  Syntax only - no logic changes.

FossilOrigin-Name: a0fa6b3ba59716e53b8c035b497602050ed0ccb8
 2015-06-30 03:34:13 +00:00
drh
b34755308c Add a bypass path in sqlite3PagerWrite() for pages with the PGHDR_WRITEABLE 
bit set, for about a 1% performance increase.

FossilOrigin-Name: ba425a6abb9886e6af87b5f6205202db450beba8
 2015-06-29 20:53:18 +00:00
drh
60e32edba5 Combine subjRequiresPage() and subjournalPage() into a single 
subjournalPageIfRequired() routine.

FossilOrigin-Name: 3b65eb56c422855ca47f709247205f0c77d98a5c
 2015-06-29 19:08:18 +00:00
drh
1aacbdb374 Add the PGHDR_WRITEABLE bit for PgHdr.flags which is used to 
distinguish between pages that are on the dirty list and pages that are
safe to modify.

FossilOrigin-Name: 7c4ef7b7c8744af19075bb96d1e0b63e35978ed1
 2015-06-29 18:29:10 +00:00
drh
e399ac2e1e Fix over-length source code lines in pager.c. 
FossilOrigin-Name: 14de3d39267a4005a0fa900bab4adc4c104e4084
 2015-06-29 18:14:02 +00:00
drh
82ef8775c7 Simplifications and performance improvement in pager_write(). 
FossilOrigin-Name: ab7aeeead395a05b91a921ef9ebe9252fffad667
 2015-06-29 14:11:50 +00:00
drh
b84c14d07c Comment typo fix and minor cleanup in the pager. No logic changes. 
FossilOrigin-Name: 94ef17012855b7be725594c34bcea75f34c40190
 2015-06-28 17:33:11 +00:00
drh
af80a1c8e7 Fix an obsolete comment - no changes to code. 
FossilOrigin-Name: 4e4228c47f862c7f1fb078bf1b8c1d604f09d365
 2015-05-25 10:29:52 +00:00
dan
929b923388 Fix an assert() failure caused by setting "PRAGMA journal_mode=off" on an database in exclusive-mode that has already opened the journal file. 
FossilOrigin-Name: 40db3e40126db1035fcc12989026915744dc5651
 2015-05-01 16:57:24 +00:00
mistachkin
8e18922f12 Fix harmless compiler warnings seen with MSVC 2015. 
FossilOrigin-Name: d05becd873a03a366843a34e7f4c732dd8f88c86
 2015-04-19 21:43:16 +00:00
drh
542d55865c Make sure PRAGMA data_version is updated even if the cache is empty when 
another connection changes the database.

FossilOrigin-Name: cf48eb608af9102a8def2a5b7f5f7b348548116f
 2014-12-31 14:18:48 +00:00
drh
d7107b3852 Update the PRAGMA data_version command so that it reponse to changes made 
by a shared-cache database connection, and also to changes made by the same
database connection.  Add test cases to verify the new behavior.

FossilOrigin-Name: 44ee538374940c50198949f2cbb9213ba2375b6a
 2014-12-20 14:34:02 +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
drh
dd90d7ee81 Add evidence marks and assert()s used as evidence for checkpoint requirements. 
FossilOrigin-Name: b2da8afc7657266fbe8e683c6e50fe18216cbcf3
 2014-12-03 19:25:41 +00:00
drh
113762a284 Add new requirements marks associated with the file format documentation. 
No changes to code.

FossilOrigin-Name: 6d00bcca6ed1903fb17275752cab71c14392355b
 2014-11-19 16:36:25 +00:00
dan
31f4e99d44 Ensure that the "Any prior cache entry associated with newKey is guaranteed not to be pinned" guarantee made to xRekey implementations is not violated. 
FossilOrigin-Name: ecc3544e712041736af7c7b4f34864a1f2e30ff7
 2014-10-24 20:57:03 +00:00
dan
e6593d8e8c Fix some minor formatting and code organization issues. 
FossilOrigin-Name: eab8706dc47aa0a44caf73619de858397c3e0b4e
 2014-10-24 16:40:49 +00:00
dan
cc8490d2cd Merge latest trunk with this branch. 
FossilOrigin-Name: 854a54c6c21e800b0cd999023014813f7c50b23f
 2014-10-22 18:42:31 +00:00
drh
442c5cd3cf Call fsync() right after ftruncate() when in journal_mode=TRUNCATE and 
when synchronous=FULL in order to ensure that transactions are durable
across a power loss that happens moments after the commit.  Proposed
fix for [https://bugzilla.mozilla.org/show_bug.cgi?id=1072773].

FossilOrigin-Name: 3e922208b68563489c7766abb9afb4885113e7b8
 2014-10-21 21:56:06 +00:00
dan
d0b8f93b5f Merge trunk changes into this branch. 
FossilOrigin-Name: d5b7c5a88dd58de85b3060a1f28b6d96e6e21207
 2014-10-13 18:09:13 +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
6a15440378 Ensure that the Pager.pTmpSpace allocation is correct even if an OOM error 
occurs while reducing the page size.

FossilOrigin-Name: e4b43967fd9a0b4944be9ab5575bff3678be8ed5
 2014-10-08 13:34:21 +00:00
dan
9675d5dabc Modify an assert() within sqlite3PagerWalFramesize(), a function only ever used by zipvfs, to account for recent zipvfs changes. 
FossilOrigin-Name: 3bd7c1b2faa2d4cc95b255633204006849bfd5e0
 2014-09-18 09:59:28 +00:00
drh
da4ca9d19c Add new APIs that take 64-bit length parameters: 
sqlite3_malloc64(),
sqlite3_realloc64(),
sqlite3_bind_blob64(),
sqlite3_bind_texte64(),
sqlite3_result_blob64(),
and sqlite3_result_texte64().
Internal memory allocation routines also now use 64-bit unsigned length
parameters for safety.
Also add the sqlite3_msize() interface.
Fix the sqlite3_get_table() to use sqlite3_realloc64() to avoid a
integer overflow problem.

FossilOrigin-Name: 94954850cf2e1ec0b7f590c7f46cdc54c72558ce
 2014-09-09 17:27:35 +00:00
peter.d.reid
60ec914c74 Fix typos in comments. No code changes. 
FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
 2014-09-06 16:39:46 +00:00
drh
60da72741a Do not require a page-size change if the attempt to change the page size 
failed due to an OOM error.

FossilOrigin-Name: 4d4fb197dc438a486cf5d967cf435f1132902c63
 2014-09-06 03:38:51 +00:00
drh
bc59ac0e26 Refactor the sqlite3PcacheFetch() routine into three separate routines, 
which are significantly faster overall and about 100 bytes smaller in
size as well.

FossilOrigin-Name: bdb6e4978d1a26d5f795262172605184264ede9c
 2014-08-27 23:18:01 +00:00
drh
c3031c61ef Change the page cache so that a new sqlite3_pcache object is allocated as 
soon as the page cache is opened, not delayed until the first fetch request.
This give a noticable performance boost.  The interface between pager and
the page cache has changed slightly, which might break ZIPVFS.

FossilOrigin-Name: f1f94a971e031e784f8c30a6faf829df58709329
 2014-08-26 15:06:49 +00:00
drh
c137807a87 Remove the pager_lookup() function since it is redundant with 
sqlite3PagerLookup().

FossilOrigin-Name: 54164ce47cfc3ad5dd8797114e4ba78811f23bef
 2014-08-25 11:33:41 +00:00
drh
f063e08fd9 Patch the sqlite3PagerWrite() method in the Pager to run a bit faster. 
FossilOrigin-Name: c63311e2f3344363a5ed99838fb5850004eaee30
 2014-08-24 01:32:43 +00:00
drh
6451c2b04e Fix nolock and immutable so that they work even if READONLY is requested. 
FossilOrigin-Name: e193aced2942e7405d0f45f90d4954b5663b4ba5
 2014-05-07 15:32:03 +00:00