database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-07-29 08:01:23 +03:00
Code Activity
30,154 Commits 1,567 Branches 182 Tags
empty-table-optimizations
Commit Graph

5135 Commits

Author SHA1 Message Date
drh
32c6a48b5e Add support for the extra parameter on the sqlite3_set_authorizer() callback 
and support for failing an ATTACH with an authentication-required database
using bad credentials.  The extension is now feature complete, but much
testing and bug-fixing remains.

FossilOrigin-Name: 596e728b0eb19a34c888e33d4d37978ca2bf1e00
 2014-09-11 13:44:52 +00:00
drh
d39c40ff5e Reorder parameters on the sqlite3_user_*() interfaces for consistency. 
Add the first TCL test cases.

FossilOrigin-Name: 2f6d8f32eef526b5912f42ab467e3c7812480d8b
 2014-09-11 00:27:53 +00:00
drh
09e60541ae Complete the implementation of the various APIs. Fix several problems. 
This is another incremental check-in that does not completely work.

FossilOrigin-Name: 4eaaa7fa87aa912d24f8b35440ab60310dc08310
 2014-09-10 22:46:46 +00:00
drh
f442e33e3a Add the ".user" shell command and implement the sqlite3_user_add() 
routine.  Incremental check-in.  The code compiles but does not work.

FossilOrigin-Name: a0455f9deb603bf91684158d911269622720fc1a
 2014-09-10 19:01:14 +00:00
drh
e933b83f02 Further ideas on user authentication. Not yet working code. 
FossilOrigin-Name: c8171ecd0d6f097c9e95d5f6643bae8d67f44750
 2014-09-10 17:34:28 +00:00
drh
d45309796b Non-working preliminary implementation attempts on user authentication. 
FossilOrigin-Name: 8440f093bac19a41d44ee352744354eab897fe4e
 2014-09-09 14:47:53 +00:00
dan
a690402b4c Add support for update statements to sqlite3ota.c. 
FossilOrigin-Name: e109b27e4d66b83e1a804e7556d9c91aa37fea28
 2014-09-08 17:50:35 +00:00
dan
9295d21bfd Add support for delete operations to the ota extension. 
FossilOrigin-Name: f988234ba54d7c667f7deef1d04beed4e7fe6182
 2014-09-06 20:19:38 +00:00
dan
4e9246e9db Switch back to using a single database connection in sqlite3ota.c. 
FossilOrigin-Name: 3c2f4a078132992e33cc675173c84f8385af9cb5
 2014-09-05 19:52:42 +00:00
dan
0c4ba2662e Reorganize the code in sqlite3ota.c in preparation for adding support for update and delete operations. 
FossilOrigin-Name: 98387f05697526c7740e91d8a846a31f77639406
 2014-09-05 19:31:15 +00:00
dan
8fa7f590cc Avoid calling sqlite3OsFetch() on a file-handle for which the xFetch method is NULL. 
FossilOrigin-Name: 071f7f2decd2f786c0201a4219e9c2cc9d227085
 2014-09-04 11:03:35 +00:00
dan
19b465a0ae Split part of "PRAGMA ota_mode" off into "PRAGMA pager_ota_mode". This allows some specialized custom VFS implementations to intercept and implement the expected pager-related effects of this pragma. 
FossilOrigin-Name: 209f672e588b54dfbfb83c7859cacdc4497f0f2b
 2014-09-03 19:30:32 +00:00
dan
98231c054b Add a command line program that uses the extension. This serves as example code and is also useful for performance testing. 
FossilOrigin-Name: ffa1524ef2a4c32652183eb4745685f0d1c93af2
 2014-09-03 08:25:09 +00:00
dan
b0083756f2 Add an experimental extension for applying bulk updates to databases. 
FossilOrigin-Name: 2954ab501049968430011b63d046eb42ff37a56c
 2014-09-02 19:59:40 +00:00
drh
e1ed0b0e17 Merge recent performance enhancements and the CAST operator enhancements 
into the sessions branch.

FossilOrigin-Name: 08ae974ac80fabe53f515bbbd93ccf55de8ee671
 2014-08-26 02:15:07 +00:00
dan
4aee5dff83 Add documentation for tokenizer api to fts5.h. Also add a script to extract extension API docs and format them as html. 
FossilOrigin-Name: e240d467e60b7755486aae5e8b0824f7c741f852
 2014-08-25 19:58:54 +00:00
drh
5ab567078a Enhance the spellfix extension with the ability to specify a rowid when 
inserting new rows.

FossilOrigin-Name: 369c480cda6fa66394b995346bbf51f3298446e1
 2014-08-22 11:11:30 +00:00
drh
2571e4eddd Merge all recent trunk changes, especially the fix for 
ticket [369d57fb8e5ccdff06f1], but also the skip-scan improvement and
performance improvements in the b-tree code.

FossilOrigin-Name: 0b9e2c3269695713b538561d999c68097db70f0c
 2014-08-21 16:09:36 +00:00
drh
b6b4b79f34 Fix a faulty assert() statement. Add comments to clarify the behavior of 
the sqlite3OpenTableAndIndices() routine in insert.c.  Add test cases to
verify that the assert() statement is not firing inappropriately.
Ticket [369d57fb8e5ccdff06f1].

FossilOrigin-Name: 7029b3404d3f5f698a496934f3a3f2972051b257
 2014-08-21 14:10:23 +00:00
drh
2967e0cc9c Improved response to error conditions in the ".session" shell command and 
in the "changeset" command-line program.

FossilOrigin-Name: b69f7dd1f35846c3bb9f4f160d50c4f03796f887
 2014-08-19 00:26:17 +00:00
drh
f5ab08c779 Fix a harmless compiler warning in the sessionAppendDelete() function. 
FossilOrigin-Name: 1324d08d0c639378cf1b03bd6410db81947747ac
 2014-08-18 20:14:30 +00:00
drh
5f77b89ecd Add the "changeset" command-line tool for analyzing and manipulating 
changesets in files on disk.  Add the ".session" command to the command-line
tool.

FossilOrigin-Name: 31addb627fdbaeb908e0611ad82f6db7537428ea
 2014-08-18 20:08:25 +00:00
drh
03168cacd5 A reasonably complete implementation of the "changeset" command-line tool 
and the ".sessions" command in the command-line shell.

FossilOrigin-Name: 7b12f1f9c012f33d376242920583807b014b3287
 2014-08-18 20:01:31 +00:00
dan
6885bbc713 Add an "automerge=0" mode that disables auto-merging and falls back to fts4-style crisis merges. 
FossilOrigin-Name: 2397404e152b908d838e6491294b263b05943b3f
 2014-08-18 19:30:01 +00:00
drh
3a67b0453e Add the "changeset" command-line utility for getting an ASCII dump of 
change sets.

FossilOrigin-Name: 55bb3544a6b474c04853270067a35ca4b0079f52
 2014-08-18 17:56:31 +00:00
dan
082c96dffa Add miscellaneous test cases to improve coverage of sessions module. 
FossilOrigin-Name: 0fac6cfffe628ea02c78ebad065307309ec9eaa1
 2014-08-18 16:03:46 +00:00
dan
2e934cd40c Add tests for sessions module. 
FossilOrigin-Name: 82fdb1975f5b29a751089a8582713372999ae56e
 2014-08-18 08:42:36 +00:00
dan
a71d2371d0 Fix some missing and out-of-date comments in the sessions module. 
FossilOrigin-Name: 05c1d9149b27c68e2654ed28491722927d2176f5
 2014-08-16 19:01:00 +00:00
dan
64277f4a70 Fixes for the sqlite3changeset_concat() API regarding patchsets. 
FossilOrigin-Name: dccb34859508eac8146ae5b19c447673d04be3b0
 2014-08-16 16:47:55 +00:00
dan
73b3c05590 Begin adding the sqlite3session_patchset() API to the sessions extension. This is an interim commit. 
FossilOrigin-Name: 60a4565a8c44762a002cd02979317df5ca47e899
 2014-08-15 20:15:49 +00:00
drh
d0738004ca Merge the trunk changes for 3.8.6 beta3 into the sessions branch. 
FossilOrigin-Name: d49455d9a972fc2224d9beb97165a998ca56e838
 2014-08-13 14:43:32 +00:00
dan
0bbd9c27c2 Cache the value of the "totals" record in memory during transactions. 
FossilOrigin-Name: 05dfdad445b22f375b71abe0b1fa1bf7ca331be7
 2014-08-12 16:07:35 +00:00
dan
e2fb318e34 Automatically resize the hash table used by fts5. 
FossilOrigin-Name: f1cb48f412a5f200f1fe04f91072864f379db08f
 2014-08-12 08:36:00 +00:00
dan
1a669f84a1 Simplify the way position lists are copied when merging data. 
FossilOrigin-Name: 9f8d678a0ea75e169daf8b3f00bd05f52a050ea6
 2014-08-11 20:26:34 +00:00
dan
c7fe7a969b Replace the hash table borrowed from fts3. 
FossilOrigin-Name: 617e2fac1c128212254f71b1a8fddaf0d1d90262
 2014-08-11 19:44:52 +00:00
drh
490fe86f1a Fix harmless compiler warnings. 
FossilOrigin-Name: 52b03f045edf6fc29f9ba9a5cac53a59f0feb0eb
 2014-08-11 14:21:32 +00:00
dan
c45f24b281 Fix an uninitialized variable causing a problem during fts5 table initialization. 
FossilOrigin-Name: a14fa876f0eb66028e302b908967cc4a05ede9fc
 2014-08-09 18:22:59 +00:00
dan
b191db8390 Use multiple memory allocations for a single Fts5Structure object. This is probably less efficient but much easier to get right. 
FossilOrigin-Name: 2821825f7a481755a333dcdcad780b3e24448f20
 2014-08-09 18:02:27 +00:00
dan
1d3ed1f46a Add "segment promotion" to fts5. This prevents the FTS index from growing indefinitely as data is added and deleted. 
FossilOrigin-Name: ba359d78e166d78e0dc89e3c63a9a41e9ffea989
 2014-08-07 18:47:33 +00:00
dan
d90aab8f94 Avoid writing delete markers to the oldest segment in an FTS index. 
FossilOrigin-Name: 1baeb1cee61d9c56c718b50af034a24f1018a322
 2014-08-06 20:04:14 +00:00
drh
858b638d1f A couple more harmless compiler warnings eliminated. 
FossilOrigin-Name: bcf6d775f90f4d1ba018a1b965f2f710df130f01
 2014-08-06 18:50:51 +00:00
drh
e8f2c9dc71 Fix two more harmless compiler warnings. Make sure the fts3_unicode2.c file 
is in sync with mkunicode.tcl.

FossilOrigin-Name: a2a60307ea68a3230952a56cb65369ba0a208967
 2014-08-06 17:49:13 +00:00
dan
7b71fbaf93 Add support for savepoints to fts5. 
FossilOrigin-Name: 3b19eba042bb2eeb1be60f8d58ebaa0a045d6a5c
 2014-08-06 16:30:21 +00:00
dan
192d413e95 Use doclist indexes for AND queries as well as phrases. 
FossilOrigin-Name: 5d38e6edc40ef188fbf96505073797036aa6783a
 2014-08-05 19:35:20 +00:00
dan
d5997d80cb Use doclist-indexes with "ORDER BY rowid ASC" fts5 queries as well. 
FossilOrigin-Name: d028ba6589f3122b635474c2683c0f93d5bc6c7c
 2014-08-05 19:00:22 +00:00
dan
9a67058a63 Fix fts5_index.c to use doclist-indexes when possible. Only some cases work so far. 
FossilOrigin-Name: 90b82d3ef613b2915e0e280dc1d2e5a2b617d59c
 2014-08-04 20:07:40 +00:00
dan
9af0705e84 Start changing things to use doclist indexes as required. code is not activated yet. 
FossilOrigin-Name: b8864da95db2c0e611116304d607e35a86c9247d
 2014-08-02 20:49:36 +00:00
dan
ff31da03e5 Add a special case to the integrity-check code to check that the final integer in a doclist index is as expected. 
FossilOrigin-Name: c98934155cb48adfda57bd0fd1b950226d45f67a
 2014-08-01 20:13:49 +00:00
dan
d34742901d Have the fts5 integrity-check verify that doclist indexes match the contents of the leaf pages that they index. 
FossilOrigin-Name: 37a7d3035eb4bbad7e32fe550321ac9fae611a57
 2014-08-01 19:27:07 +00:00
dan
a29284d65f Add "doclist index" records to the database. These are to make navigating within very large doclists faster. They are not yet used by queries. 
FossilOrigin-Name: 89377421ff69f2450364987afe781b6d8bcbf087
 2014-08-01 11:16:25 +00:00