database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,100 Commits 1,570 Branches 183 Tags
optimize-null-values
Commit Graph

226 Commits

Author SHA1 Message Date
danielk1977
b4e9af9ff9 First approximation of incremental blob IO API. (CVS 3892) 
FossilOrigin-Name: c444836e7b690c16dd6acff571c613a23beb42dc
 2007-05-01 17:49:49 +00:00
danielk1977
dddbcdcc68 Add largely untested code for the incremental vacuum function. (CVS 3876) 
FossilOrigin-Name: f6a6d2b8872c05089810b1e095f39011f3035408
 2007-04-26 14:42:34 +00:00
drh
80e35f4640 Refactoring the btree and pager routines into distinct two-phase commit 
routines.  We've always done a two-phase commit - this change is just
making that more apparent in the code. (CVS 3762)

FossilOrigin-Name: 66b3ad09ea657d25d48cb75ec2671ea2dc1b6005
 2007-03-30 14:06:34 +00:00
drh
e4d9081307 Change BtreeMoveto so that it can be biased to the right or to the center. 
Use a right bias when appending and a center bias when searching.  This
gives about a 15% reduction in calls to sqlite3VdbeRecordCompare. (CVS 3741)

FossilOrigin-Name: ad4a6b1a91bcefd8a4c75e8dc99c1153c72c31a3
 2007-03-29 05:51:49 +00:00
drh
1dcdbc0639 Limit the number of errors returned by PRAGMA integrity_check to 100 by 
default.  Specify an alternative limit using an argument to the pragma.
Ticket #2176. (CVS 3609)

FossilOrigin-Name: d564a039f27be2bb2c3973e79dc99b25869139da
 2007-01-27 02:24:54 +00:00
danielk1977
2372c2b165 Prevent databases from being DETACHed while they are in use. Fix for #1873. (CVS 3312) 
FossilOrigin-Name: 70a48b250bab99c5d9b4ad17c471663b8628e8d2
 2006-06-27 16:34:56 +00:00
drh
ac530b1ab4 Add support and documentation for the fullfsync pragma. Also include 
some other unrelated documentation updates. (CVS 3080)

FossilOrigin-Name: f2069d0bf3161591535e68b7389792e9cb7fe043
 2006-02-11 01:25:50 +00:00
danielk1977
c00da10565 In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881) 
FossilOrigin-Name: 23b587b05b89727248805e6d9e5141e018cf2152
 2006-01-07 13:21:04 +00:00
danielk1977
c87d34d05d Add some simple tests and fixes for shared-schema locking. (CVS 2869) 
FossilOrigin-Name: d054bed15aee3edef93cc84c83be443cdd489946
 2006-01-06 13:00:28 +00:00
danielk1977
da18423620 Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) 
FossilOrigin-Name: deeda0dc06c1595aedd8d06a0c4e88a8abf78cf7
 2006-01-05 11:34:32 +00:00
danielk1977
aef0bf6429 Add part of the btree layer of the shared-cache feature. (CVS 2848) 
FossilOrigin-Name: 2afcad990190af97d1ad0010f211a5ca8f0fd745
 2005-12-30 16:28:01 +00:00
danielk1977
f3f06bb30c Verify that the rollback-hook is invoked correctly when a malloc() failure occurs. (CVS 2824) 
FossilOrigin-Name: 83c8ae5bee3b6bdb556d2e85fa260ba855742601
 2005-12-16 15:24:28 +00:00
drh
2c8997b9a5 Disable synchronous writes to the master journal when PRAGMA synchronous=OFF 
for all database files.  Ticket #1375. (CVS 2630)

FossilOrigin-Name: 644b96aa23de7e828280d35785db840a4fa9413d
 2005-08-27 16:36:48 +00:00
danielk1977
6b456a2b46 Add function to recover from a malloc() failure. (CVS 2414) 
FossilOrigin-Name: 1f9d10d7965c95d1e35f64cf4c3f128adabd41f2
 2005-03-21 04:04:02 +00:00
drh
7bec505e26 Add the (highly experimental) omit_readlock pragma that disables the use 
of readlocks on read-only databases that are connected using ATTACH. (CVS 2317)

FossilOrigin-Name: 2155448d2128119f74241da0ea07d6713b71765c
 2005-02-06 02:45:41 +00:00
danielk1977
b5402fbf05 Tests to improve coverage of vdbemem.c. (CVS 2200) 
FossilOrigin-Name: 319bb4a9064deb062a888fdc31067619c9b749bb
 2005-01-12 07:15:04 +00:00
danielk1977
951af8050b Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) 
FossilOrigin-Name: b9d5f007fc32d4f471e0e11cc4baadb100612878
 2004-11-05 15:45:09 +00:00
danielk1977
a0bf265269 Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054) 
FossilOrigin-Name: 1da361fae82d420be63c53f8e3efaccac24f348a
 2004-11-04 14:30:04 +00:00
drh
3e27c02625 First cut at a analysis tool for version 3.0 databases. (CVS 1862) 
FossilOrigin-Name: 7c7f698b2eda7b1b34f5ca7fe104145d8bbd8f56
 2004-07-23 00:01:38 +00:00
drh
2011d5f5e5 Changes in support of using a codec. (CVS 1844) 
FossilOrigin-Name: b77bec35742f07d79da3e85baee09a90c1494415
 2004-07-22 02:40:37 +00:00
drh
90f5ecb39d Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) 
FossilOrigin-Name: 4cf6e9db757931aba2f300b7869305434d6f2d2b
 2004-07-22 01:19:35 +00:00
danielk1977
40b38dcdf8 Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737) 
FossilOrigin-Name: 4e20720984e1fd6822ead785d758374d2704b7fb
 2004-06-26 08:38:24 +00:00
danielk1977
5865e3d54f Ensure the master journal directory is synced. Also, change the master journal 
format to store journal file names. (CVS 1583)

FossilOrigin-Name: 73cd0aabb24f7b663c8b55cf5e8fcb34fd48c032
 2004-06-14 06:03:57 +00:00
danielk1977
24162fe668 Move the 'busy-callback' logic to the pager layer. (CVS 1527) 
FossilOrigin-Name: ff70b6d2b60c143e3ada0606ceff97571998c7e3
 2004-06-04 06:22:00 +00:00
danielk1977
13adf8a071 Untested updates to support atomic multi-file transactions (CVS 1526) 
FossilOrigin-Name: d57e5252c8baaf615c2cd218a33356ea5d95a5e2
 2004-06-03 16:08:41 +00:00
danielk1977
ee5741ea78 Add read-transactions to the btree and vdbe. The compiler doesn't invoke 
them yet. (CVS 1502)

FossilOrigin-Name: 6b43633a96c674a5d470578ef80ebf2227da0682
 2004-05-31 10:01:34 +00:00
danielk1977
1d850a72c2 Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) 
FossilOrigin-Name: b8ed812c92f2dbb4431d45aeb41646ceb53e0cbc
 2004-05-31 08:26:49 +00:00
drh
e51c44f481 Various speed enhancements. (CVS 1498) 
FossilOrigin-Name: a0db15bba64af0c529d5be366659bca1165ff21b
 2004-05-30 20:46:09 +00:00
danielk1977
bf3b721fab Fix many problems with manifest types and column affinity. Most things are 
working now. (CVS 1393)

FossilOrigin-Name: ad4a964158ba9ca9d221cf7ea0439577f3894890
 2004-05-18 10:06:24 +00:00
drh
8b18dd4fb5 Implement a B+tree option (all data stored on leaves). (CVS 1365) 
FossilOrigin-Name: b8f70d17f06531269caa0a127efb2d25ad0f3e1c
 2004-05-12 19:18:15 +00:00
drh
4a1c380a4b Btree uses signed integers for the rowid. The intToKey() and keyToInt() macros 
are now no-ops. (CVS 1364)

FossilOrigin-Name: fb3c80301441f0d255164578601439db3e0c7a61
 2004-05-12 15:15:47 +00:00
drh
0e1c19e2b6 Updates to sqlite3BtreeKeyFetch() and sqlite3BtreeDataFetch(). (CVS 1347) 
FossilOrigin-Name: a675ac49882887dfcbf671e9092a29aca9eb694e
 2004-05-11 00:58:56 +00:00
drh
f328bc80ce Work toward getting the new btree.c integrated with vdbe.c. (CVS 1345) 
FossilOrigin-Name: bc5a2dafa1df74ba6403b4751ac1c33b0fee2884
 2004-05-10 23:29:49 +00:00
danielk1977
189621d81f Add a temporary sqlite2BtreeKeyCompare() function to help get 
regression tests passing again. (CVS 1332)

FossilOrigin-Name: d8d1c91e55f24d17233414facaa03136b3b320d5
 2004-05-09 23:23:56 +00:00
drh
c12fc0d85f All tests in btree.test now pass (but only because I commented out the 
btree_integrity_check test.) (CVS 1328)

FossilOrigin-Name: ee706e9c74c3fb32fc3369db226fad9ed4db7596
 2004-05-09 00:40:52 +00:00
drh
c8629a13e1 More btree.c bug fixes. (CVS 1327) 
FossilOrigin-Name: e9f84ff3fe45a014ab60fabbfd91d19e6d353477
 2004-05-08 20:07:40 +00:00
danielk1977
4adee20fcb Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the 
library links again. It doesn't work yet, due to changes in the btree layer
calling convention. (CVS 1324)

FossilOrigin-Name: 8af6474c49263ae26216dff9465b33f76b500cf4
 2004-05-08 08:23:19 +00:00
drh
c39e000bbf More bug fixes in btree.c. (CVS 1322) 
FossilOrigin-Name: a80939ef714ec884950b4a1f4f809ffa37fdfa59
 2004-05-07 23:50:57 +00:00
drh
a34b676483 New btree.c module compiles and links. (CVS 1320) 
FossilOrigin-Name: dcd6b55f932a7ade4ad058534651e198b56370ad
 2004-05-07 13:30:42 +00:00
drh
3aac2dd7bc Pager tests working. (CVS 1308) 
FossilOrigin-Name: 910067a200c4b25b5d813a84146673d3d1c80952
 2004-04-26 14:10:20 +00:00
drh
57ced9186a Make the pager accessible from the btree structure always, not just during 
debugging. (CVS 1219)

FossilOrigin-Name: 9c6b4758a4b13a91f71be17751a76c0c14b4d4c3
 2004-02-10 02:57:59 +00:00
drh
a0217ba720 Add the ability to INSERT or UPDATE using the "rowid" column even on tables 
that lack an integer primary key. (CVS 991)

FossilOrigin-Name: 903adbe802ca0e987b867e5ad33aae02ad2a43d4
 2003-06-01 01:10:33 +00:00
drh
9c05dc6298 Work around a name collision problem on windows. (CVS 934) 
FossilOrigin-Name: c3b1f84dfce13b2523c9923e4270577862ca0595
 2003-04-25 13:28:02 +00:00
drh
f7c5753174 Make VACUUM work even if multiple processes have the database open at once. (CVS 933) 
FossilOrigin-Name: caa960289f3d1f5e8f35a94e9e4321996c211ed2
 2003-04-25 13:22:51 +00:00
drh
45a304ee8c Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) 
FossilOrigin-Name: 5afb88008fed253e6d1fc0ed5172370b61d3727b
 2003-04-25 02:43:08 +00:00
drh
144f9eadf6 Remove some unnecessary code and complication from the btree interface. (CVS 909) 
FossilOrigin-Name: 35cc7c7d37d9ca486e7f300efe80a78a7f1064e2
 2003-04-16 01:28:16 +00:00
drh
73509eee84 Simplify the BTree interface by shortening names. Added two new methods 
for accessing the current filename and for changing the name of the
database file. (CVS 900)

FossilOrigin-Name: 185d8dc8d0c26cef36aeba6992823e5124af4056
 2003-04-06 20:44:45 +00:00
paul
b95a8864c9 Add infrastructure to suport multiple btree implementations (CVS 894) 
FossilOrigin-Name: 79b3aed2a74a67cbad631c4e2e4a43469d80c162
 2003-04-01 21:16:41 +00:00
drh
001bbcbb8f Modifications to the VDBE to support more than one database file. (CVS 878) 
FossilOrigin-Name: 875da9eed981bfa27b98e95025f9fdbed74b4098
 2003-03-19 03:14:00 +00:00
drh
973b6e333d Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) 
FossilOrigin-Name: 792a9e157dd066fcaffd4f5b373010151fb4ca61
 2003-02-12 14:09:42 +00:00