database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
30,201 Commits 1,570 Branches 184 Tags
wasm-build-parallel
Commit Graph

5163 Commits

Author SHA1 Message Date
dan
fa29ecc4ed Fix a problem with concatenating patchsets containing DELETE and INSERT operations on the same row. 
FossilOrigin-Name: 4d8537eafb40e3687abc057ba26a1f7014f2c2d9
 2014-09-26 10:52:21 +00:00
dan
cbf6d2d2aa Add streaming version of sqlite3changeset_concat(). 
FossilOrigin-Name: 88eb6656bdb047a104837a2e15e7fe18c0a7a159
 2014-09-25 20:43:28 +00:00
dan
fa122adac1 Add streaming version of sqlite3changeset_invert() to sessions module. 
FossilOrigin-Name: 8ded6a46794c7bff1c8b790c662ba7e92f576380
 2014-09-25 14:54:20 +00:00
dan
4757c65866 Add streaming version of sqlite3changeset_apply(). Tests and fixes for the same and sqlite3changeset_start_str(). 
FossilOrigin-Name: b917fc146876f764442de08d5ec36e5b4cf5ab52
 2014-09-24 17:13:20 +00:00
dan
ef7a630496 Begin adding 'streaming' APIs to sessions module. This is a work in progress. 
FossilOrigin-Name: 3c7d3d950bbf5f5ed3696ebc61c77ca48bafe2b5
 2014-09-23 20:39:55 +00:00
drh
6b011d83b4 Merge all recent trunk changes into the sessions branch. 
FossilOrigin-Name: 6406b77f2c447751a2fbb16f01c61cdcfd6af59e
 2014-09-21 22:49:20 +00:00
drh
249489331c Add the "showauth" extension in ext/misc. 
FossilOrigin-Name: 28d52c1c38d849f099bc777f5987d1ef89680c2a
 2014-09-21 17:51:37 +00:00
dan
93fdbfa64f Add further tests to ota5.test. Add "ota.test", for running all ota tests. 
FossilOrigin-Name: 95ffdaa542df1c28fac97422e5a4b2c5cb81d50a
 2014-09-19 18:08:39 +00:00
dan
d1193a9893 Add extra tests for the ota extension. 
FossilOrigin-Name: 1e468fe1e408e513a1e1bbe72fe2a240f2991b3d
 2014-09-19 15:06:23 +00:00
dan
be758ce3ae Update the ota extension to support SQLITE_ENABLE_8_3_NAMES builds. 
FossilOrigin-Name: 718da6de870231d358384473b40e81c4394b8067
 2014-09-18 17:57:46 +00:00
dan
6c5984a950 Use quotes instead of angle-brackets to include sqlite3.h from sqlite3ota.h. 
FossilOrigin-Name: fce9c6ccf101d28492a84b85463433f32ef569fb
 2014-09-18 16:38:10 +00:00
dan
318e63c60b Remove some c++isms from sqlite3ota.c. 
FossilOrigin-Name: 0da1862b1b68f15c7c14286a982dda886d1e3b4a
 2014-09-18 15:57:22 +00:00
dan
ed18c96107 Add new file ext/ota/README.txt, containing notes regarding the implementation of the ota extension. 
FossilOrigin-Name: 3c6e1cbb4baaebc5958ab7276f27ff0ba14f4fa2
 2014-09-18 15:22:48 +00:00
dan
4caa8fbc1e Add an API to query an ota handle for the total number of key/value operations performed so far. 
FossilOrigin-Name: e3943fa7bbbfc5e16f73a494d8fa54d19e9cfcf9
 2014-09-18 14:48:38 +00:00
dan
c6c3d00f33 Fix an ota bug causing attempts to write to tables with more than 8 columns to fail. 
FossilOrigin-Name: 7da98ca2422166dc5d68607541707f41b77b5784
 2014-09-18 11:15:17 +00:00
dan
44ed6bc5c1 Fix an unintialized variable problem in sqlite3ota.c. 
FossilOrigin-Name: 01268607515a30d07559648c43034e522605748a
 2014-09-17 19:05:46 +00:00
dan
abc0788663 Add tests and fixes for "PRAGMA ota_mode". 
FossilOrigin-Name: 39df35c4ac65ffba76ba2c6f6727cf5e843e7517
 2014-09-17 15:20:24 +00:00
dan
1b95de09bc Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. 
FossilOrigin-Name: decaccc37cbdcd2a663233469efdf4982a810513
 2014-09-16 20:02:41 +00:00
dan
15e1ec4c5b Remove the experimental sqlite3_transaction_save() and restore() APIs. 
FossilOrigin-Name: 48d201cd8b68c0377cf8a2cc6439b893f9462fe2
 2014-09-15 19:34:04 +00:00
dan
d4a80e6742 Merge latest trunk changes with this branch. 
FossilOrigin-Name: 55b8011d5b455927f5b92a3cb911fd909fb0edab
 2014-09-15 15:34:31 +00:00
dan
ee8d0b4111 Have sqlite3ota.c use grave accents instead of double-quotes to enclose identifiers in generated SQL. To avoid having the SQL engine substitute a literal string if a column reference cannot be resolved. 
FossilOrigin-Name: 79f2418429aa05c56069c56d51b4d72f662a6970
 2014-09-15 15:22:32 +00:00
dan
02cf6e1681 Ensure the correct collation sequences are used when sorting data in sqlite3ota.c. 
FossilOrigin-Name: 473a72d7009a22ea514a98ee8869e7e7bca14cf5
 2014-09-15 14:54:07 +00:00
dan
13ce7931f7 Have the sqlite3_index_writer() VMs check that the final values of records inserted into indexes on rowid tables are integers. 
FossilOrigin-Name: cca376bff3510dc5e99fc5824862c3471ceced16
 2014-09-15 12:18:29 +00:00
dan
d54e06ca5e Add OP_Affinity opcodes to the VMs generated by sqlite3_index_writer(). 
FossilOrigin-Name: b9b38cb8e21826ddfb4c87a1f166ad33c3c7b6eb
 2014-09-15 10:44:24 +00:00
drh
c891c6c7ad Clean up some #includes in the extension API implementation. 
FossilOrigin-Name: b149ef5c639e6bcff7bd1c7866353e7f7f468070
 2014-09-11 17:14:54 +00:00
drh
7883ecfcd4 Enhance the sqlite3_user_add() interface to initialize the user 
authentication logic.  Add test cases for the extra argument on the
end of the authorizer callback.

FossilOrigin-Name: 842c6da8f1a62bd13a1b4089a98b0835a46a2285
 2014-09-11 16:19:31 +00:00
drh
9d5b0df132 Get the sqlite3_user_delete() interface working. 
FossilOrigin-Name: 974a9c65583f7ab438d5673dc00c347ab8322855
 2014-09-11 14:56:45 +00:00
drh
570f187f78 Fix the sqlite3_user_change() interface so that it does allow a 
non-admin user to change their own password.

FossilOrigin-Name: 52d440c7e1b07fc03f14ed5fa4cc4c89a75cd430
 2014-09-11 14:40:27 +00:00
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