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
13,071 Commits 1,785 Branches 392 Tags
threadtest3
Commit Graph

887 Commits

Author SHA1 Message Date
drh
73b64e4d2e Initial code for incremental checkpoint in WAL mode. This check-in compiles 
on unix and runs as long as you do not engage WAL mode.  WAL mode crashes and
burns.  Consider this check-in a baseline implementation for getting the new
capability up and running.

FossilOrigin-Name: ef3ba7a17ff90674d702e5694b9e792851ab6998
 2010-05-30 19:55:15 +00:00
drh
286a288493 Add a new xShmBarrier method to the VFS - a shared-memory fence operation. 
Implement the same in both unix and win32.  Use it to make the WAL subsystem
more robust.

FossilOrigin-Name: 1bd011c9fed5ef29fb616b4d0a52df3b82221b1f
 2010-05-20 23:51:06 +00:00
drh
9ff27ecdb2 Add the SQLITE_FCNTL_SIZE_HINT operator to sqlite3_file_control() and use it 
to give the VFS hints about the ultimate size of a database file when the
file is growing.

FossilOrigin-Name: 2b7e3b4a30d6a7c4a8a4b8e7dd2ed728b565c96d
 2010-05-19 19:26:05 +00:00
drh
5939f44375 Mark the shared-memory in the WAL implementation as volatile. 
FossilOrigin-Name: 0a6787908e989bd5e6af25acbdc59ebc8fa61d6d
 2010-05-18 13:27:12 +00:00
dan
982d4c0c72 Add a note to the documentation of sqlite3_wal_hook() to say not to return SQLITE_ROW or SQLITE_DONE. Or any other value that is not a valid SQLite error code. 
FossilOrigin-Name: 2f0b6cbf7b4fa31242ff4f6163226c22ae4f8c9b
 2010-05-15 10:24:46 +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
6a2607a131 Additional tweaks to API documentation. No functional code changes. 
FossilOrigin-Name: e1230782a371f09cd46dacc8ecbc6a0c5baab2d5
 2010-05-07 18:23:24 +00:00
drh
005e19c4c1 Updates to documentation on the C interfaces supporting WAL. No functional 
changes to code.

FossilOrigin-Name: 681ba20cf077e9a0fccd51ed50101ad0f2c67eb3
 2010-05-07 13:57:11 +00:00
drh
5def0843f1 Change the behavior of the sqlite3_wal_hook() callback. It should now return 
SQLITE_OK or an error code and the error code is propagated back up the 
stack.  If a checkpoint is desired, the callback should invoke
sqlite3_wal_callback() itself.

FossilOrigin-Name: 1b14195e05fe5551992a39246ec3bcf6a33bbfac
 2010-05-05 20:00:25 +00:00
drh
ccd13d1f80 Further simplifications to the SHM locking logic. Remove the SQLITE_SHM_QUERY 
option.  Unify the WRITE to READ and RECOVER to READ transitions.

FossilOrigin-Name: e9bfa6e4ce7d1edc6be8b9173ac3b6bfd180632a
 2010-05-05 19:09:49 +00:00
drh
3289c5efc8 Prohibit backup if the destination is using WAL and has a different page 
size from the source.

FossilOrigin-Name: 7bd44794c482beee16c684712545275e2bf63dfa
 2010-05-05 16:23:26 +00:00
drh
324e46d424 Documentation stubs for sqlite3_wal_autocheckpoint and sqlite3_wal_checkpoint. 
FossilOrigin-Name: 313762427d96954667909887a797ea996dc6304a
 2010-05-03 18:51:41 +00:00
drh
1fbe0f2a8f Change the VFS definition so that all methods take a VFS object pointer as 
their first parameter.

FossilOrigin-Name: 43b5b07f0d996d7ef7426346b1792e9ca898f487
 2010-05-03 16:30:27 +00:00
dan
11398e5e54 Merge two wal leaves. 
FossilOrigin-Name: 23c0e6c3f333e878fe5a2ae5d61df0d765f437b4
 2010-05-03 08:19:34 +00:00
dan
586b9c8a94 Add the sqlite3_wal_checkpoint() and sqlite3_wal_autocheckpoint() APIs. 
FossilOrigin-Name: 9803196dec85e3aa4105cc477e9cfe98d370e486
 2010-05-03 08:04:49 +00:00
drh
2d536e187f Change the SHM interface so that it does not take the name of the shared 
object but rather the name of the WAL file and derives its own name from
that.  Remove the xShmDelete method from the VFS and replace it with a
delete flag on xShmClose.

FossilOrigin-Name: 94dea5f9c11a68564220cec76ac3fae2ba90e907
 2010-05-01 20:17:30 +00:00
drh
f72a8751c9 Remove the xShmPush and xShmPull methods from the VFS. 
FossilOrigin-Name: 69e07fdbde5054593de948b76dfac157cf5d4058
 2010-05-01 18:23:08 +00:00
drh
5530b764a8 Separate the concepts of underlying storage size and mapped size in the 
VFS shared-memory implementation.

FossilOrigin-Name: 4cbe49f13fed288f94ff305bcfd99df907bf7baf
 2010-04-30 14:39:50 +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
drh
7b6944047e Progress towards a VFS that will support WAL. Locking code is in place 
but is untested.  Still no support for the DMS.

FossilOrigin-Name: 1bde41cf081570ad257f927b641e752dff4ed014
 2010-04-29 15:17:48 +00:00
drh
9beb1584bd Changes to the interface design for the xShmLock method of the VFS. 
FossilOrigin-Name: 348409de26eafe12f5cb1236e8e167a4183d4051
 2010-04-28 17:21:33 +00:00
drh
833bf968e3 Rename the sqlite3_log_hook() to sqlite3_wal_hook(). Added comments to 
wal.h.

FossilOrigin-Name: bbc385111b19071e20fe963fab814262c815b3e9
 2010-04-28 14:42:19 +00:00
drh
af75c8695b Add the xShmRelease() method to the VFS. The os_unix.c implementation of 
the shared memory logic is still non-functional.

FossilOrigin-Name: ed715b47c5f7657fbf901805981867898054b14d
 2010-04-27 11:49:27 +00:00
drh
f2424c521b Begin moving WAL-specific I/O into the VFS. This checkin contains VFS 
infrastructure but it is untested and is not yet hooked up to the WAL.
The version number is bumped to 3.7.0 because of the VFS extension.

FossilOrigin-Name: f5e615c28c7035a7e6d896790b51cf9bc7371d5f
 2010-04-26 00:04:55 +00:00
dan
8d22a17411 Add the sqlite3_log_hook() interface for scheduling checkpoints. 
FossilOrigin-Name: 9bda601455705475075e33bfa85687bce34b15ff
 2010-04-19 18:03:51 +00:00
drh
3674bfd1b6 Change sqlite3_step() so that it automatically calls sqlite3_reset() instead 
of returning SQLITE_MISUSE when invoked on a prepared statement that
previously returned any value other than SQLITE_ROW.

FossilOrigin-Name: 3e646e3f4cd0ca288e444561e951cecfdaee2ab5
 2010-04-17 12:53:19 +00:00
dan
c9206ed56e Test that the rollback-hook is invoked if a commit-hook implementation returns non-zero (causing a rollback). Remove documentation comment that says otherwise from sqlite.h.in. 
FossilOrigin-Name: 012cf101bf8be9e39c138786ea5a5039b8131e55
 2010-04-13 06:18:02 +00:00
drh
a21a64dd0c Veryquick.test is now working. The SQLITE_STMTSTATUS_AUTOINDEX counter 
added.

FossilOrigin-Name: abbf16e5e7895971710fb3a8fd9c782fc1218a77
 2010-04-06 22:33:55 +00:00
drh
d3d986d329 Documentation enhancements for the sqlite3_log() interface. No functional 
changes to code.

FossilOrigin-Name: ba13a11108d7852c61f959cc8a5fc39c25202cae
 2010-03-31 13:57:56 +00:00
drh
d454214ddd Change an #if into an #ifdef. 
FossilOrigin-Name: 371bab5d6534860ce908e52129c64a49946be33a
 2010-03-30 11:57:01 +00:00
dan
98f0c3619f Change the formatting of the preprocessor macros surrounding the compileoption interface in sqlite.h.in. This is so the documentation produced by parsing this part of sqlite.h.in is formatted similarly to the docs for the deprecated interfaces (with the #ifndef visible on the webpage). 
FossilOrigin-Name: 161958d11f2ef6ce4d7ba69afea03e0a6764cc1b
 2010-03-22 04:32:13 +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
9f8da32662 Remove the "experimental" markings on most interfaces that have been around 
for multiple releases.

FossilOrigin-Name: d670e8bd51c794e2d7ea365ca553c2b74cf5a3a3
 2010-03-10 20:06:37 +00:00
drh
7c0c460fff Modify the sqlite3_log() interface and implementation so that it never 
uses dynamic memory allocation - to avoid deadlocking when called while
holding the memory allocator mutex.

FossilOrigin-Name: 28d1bc98d60319b10af427072037a0121bc76259
 2010-03-03 22:25:18 +00:00
drh
71caabf0cc Remove the compile_option pragma (retaining compile_options - with an "s"). 
Updates to documentation.

FossilOrigin-Name: 733778df996a2dda7c31ff7b544cb6f9a6ed4c97
 2010-02-26 15:39:24 +00:00
drh
bee8065e37 Test coverage enhancements. Additional documentation detail on the new 
sqlite3_log() interface.

FossilOrigin-Name: d986e9289388fd72257b26cb2f9c972177255cd4
 2010-02-25 21:27:58 +00:00
drh
380083ce18 Merge the compile-time option introspection interfaces into the trunk. 
FossilOrigin-Name: 9f429434c0404f03a3e5c6741b769afe98a5c6c9
 2010-02-23 20:32:15 +00:00
shaneh
dc97a8cdc1 Refactored compile time option diagnostic support to use strings identifiers instead of bitmask. 
FossilOrigin-Name: 76a0294ab4208a0858a13bab0858e1bc1448b651
 2010-02-23 20:08:35 +00:00
shaneh
bdea6d1368 Test new api to report which options (defines) were used to compile SQLite. 
FossilOrigin-Name: 84c9756993caf82710a0905ed1987d144bc764fd
 2010-02-23 04:19:54 +00:00
drh
a756466349 Log all error messages if logging is enabled. 
FossilOrigin-Name: a8076aede33c07e9a2aaa05be8a888f37b45e41c
 2010-02-22 19:32:31 +00:00
drh
3f28070109 Add a new, experimental logging interface designed to aid in debugging of 
deeply embedded projects that use SQLite.

FossilOrigin-Name: 103321e37ae46eacfad4e127d13477ad5dd02bab
 2010-02-18 18:45:09 +00:00
shaneh
959dda6d94 Tweaks for consistency to the SEE and CEROD API declarations in sqlite3.h. 
FossilOrigin-Name: 299f74567b1b97a1fdc0a620ef382cfd24941809
 2010-01-28 19:56:27 +00:00
drh
7ed97b9de9 Move the Apple OS-X VFS changes into the trunk. 
FossilOrigin-Name: 571594bfbe89d9949bdb8b07712e96d0a3467c6e
 2010-01-20 13:07:21 +00:00
drh
0e857739c4 Add a new sqlite3_test_control() verb that facilitates testing that all 
keywords are shown in the documentation.  (Two keywords were found to
be missing while testing the change.)

FossilOrigin-Name: d3cdc4b12be7f1ed2249ad210482200868956d12
 2010-01-02 03:21:35 +00:00
drh
07096f68ae Move the query flattener turn-off from a pragma to an sqlite3_test_control() 
call.  Make provisions (not yet implemented) to turn off other optimizers
using the same call.

FossilOrigin-Name: 4a97c623f4e190134de4b2ca406e311034a74797
 2009-12-22 23:52:32 +00:00
drh
7a98b853da Additional corrections to documentation comments. No functional code changes. 
FossilOrigin-Name: b3740b0aa0a7c6932e33e02b37baed5a5960a0bd
 2009-12-13 23:03:01 +00:00
drh
df6473aa7a Minor documentation updates. No functional changes. 
FossilOrigin-Name: 6ae7e40ba0f710609cf1bc8baa54e7839eb7a2d7
 2009-12-13 22:20:08 +00:00
drh
9be37f691b Fix some documentation comments in sqlite.h.in. No functional code changes. 
FossilOrigin-Name: c16b9bec77c8b9120b728f8431648d95175a83b8
 2009-12-12 23:57:36 +00:00
drh
fb43403641 Additional changes to C-language interface documentation. 
FossilOrigin-Name: 1342916fd350d06e1c1f3d7d380249f0c9282c7b
 2009-12-11 23:11:26 +00:00
drh
d68eee04b4 Extensive edits to the comments in the sqlite.h.in source file to identify 
testable statements of truth about the C-language interface.

FossilOrigin-Name: ea884e1ed8dba1aa0f3cf68fc71923954983f6c6
 2009-12-11 03:44:18 +00:00