SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around 143c502a59e72797.

2004-05-31
15:06
Website redesign in preparation for adding version 3 documentation. (CVS 1506) (check-in: 2052911b user: drh tags: trunk)
12:34
Some test cases for read locks (CVS 1505) (check-in: 0e070067 user: danielk1977 tags: trunk)
11:51
Use read-only transactions. (CVS 1504) (check-in: 6c100887 user: danielk1977 tags: trunk)
10:08
Bugfix for previous checkin. (CVS 1503) (check-in: 5f869fbf user: danielk1977 tags: trunk)
10:01
Add read-transactions to the btree and vdbe. The compiler doesn't invoke them yet. (CVS 1502) (check-in: 6b43633a user: danielk1977 tags: trunk)
08:55
Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) (check-in: 9029274b user: danielk1977 tags: trunk)
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: b8ed812c user: danielk1977 tags: trunk)
2004-05-30
21:14
Add 3-byte and 6-byte integer serial types. This makes databases smaller and faster. Should we go ahead and add 5- and 7-byte integer types too? (CVS 1499) (check-in: e6685af8 user: drh tags: trunk)
20:46
Various speed enhancements. (CVS 1498) (check-in: a0db15bb user: drh tags: trunk)
19:19
Improved comments and speed tweaks to btree.c. (CVS 1497) (check-in: c86b7c06 user: drh tags: trunk)
02:14
Additional minor speed improvements. (CVS 1496) (check-in: a90264c0 user: drh tags: trunk)
01:51
Faster version of sqlite3VdbeSerialGet. (CVS 1495) (check-in: 80985505 user: drh tags: trunk)
01:38
Do not include the P3 parameter on OP_Integer opcodes if the integer will fit in 32 bits. The P3 conversion is slow. (CVS 1494) (check-in: fcd84eba user: drh tags: trunk)
2004-05-29
21:46
A file format change for btree.c makes it between 10 and 20% faster. (CVS 1493) (check-in: cbcaece7 user: drh tags: trunk)
11:24
Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492) (check-in: 3225de89 user: danielk1977 tags: trunk)
10:43
Ensure vacuum handles table names with spaces in them. (CVS 1491) (check-in: 0a6689be user: danielk1977 tags: trunk)
10:23
Fix vacuum so that it works with blobs. (CVS 1490) (check-in: 4feb4b9a user: danielk1977 tags: trunk)
02:44
Avoid arithmetic on void pointers. (CVS 1489) (check-in: 3d68703e user: danielk1977 tags: trunk)
02:37
Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488) (check-in: 4060a37d user: danielk1977 tags: trunk)
2004-05-28
16:00
Factor common code for generating index keys into a procedure. Other speed improvements and bug fixes. (CVS 1487) (check-in: 6661bb5f user: drh tags: trunk)
13:13
Fix a bug in the sqlite3_column_decltype() API. (CVS 1486) (check-in: c8a40218 user: danielk1977 tags: trunk)
12:33
Allow CREATE and DROP VIEW on attached databases. (CVS 1485) (check-in: ad879a95 user: danielk1977 tags: trunk)
12:11
Allow DROP TABLE and DROP INDEX on attached databases. (CVS 1484) (check-in: 2fb3708e user: danielk1977 tags: trunk)
11:37
Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483) (check-in: 4984a130 user: danielk1977 tags: trunk)
08:21
Tables and indices use the same record format. (CVS 1482) (check-in: 1b15b32b user: drh tags: trunk)
08:21
Tables and indices use the same record format. (CVS 1481) (check-in: ebd564d1 user: drh tags: trunk)
01:39
Remove the encoding argument from sqlite3VdbeSerialGet. Use the 32-bit version of sqlite3GetVarint for schema-level parameters. (CVS 1480) (check-in: 321f8c46 user: drh tags: trunk)
2004-05-27
23:56
Add API functions sqlite3_open_varargs(), sqlite3_open16_varargs() and sqlite3_complete16(). (CVS 1479) (check-in: 203af2b2 user: danielk1977 tags: trunk)
19:59
Change the record format to include an extra varint at the beginning to record the number of bytes in the header. (CVS 1478) (check-in: 0c4d1388 user: drh tags: trunk)
17:22
Remove the COPY command. (CVS 1477) (check-in: 287f8673 user: drh tags: trunk)
14:23
Enhance the C function used to test sqlite3_create_function() from Tcl. (CVS 1476) (check-in: c85e5f15 user: danielk1977 tags: trunk)
13:55
Test sqlite3_bind_blob(). (CVS 1475) (check-in: 42247b2f user: danielk1977 tags: trunk)
13:35
A couple of test cases and fixes for blob literals. (CVS 1474) (check-in: 6d552af6 user: danielk1977 tags: trunk)
12:11
Alter the Tcl eval sub-command so that it supports blobs. (CVS 1473) (check-in: b5d5f0ad user: danielk1977 tags: trunk)
10:30
A few more bugfixes. Test cases pass now. (CVS 1472) (check-in: c9e3015f user: danielk1977 tags: trunk)
09:28
Various bugfixes. 68 Test cases still fail. (CVS 1471) (check-in: 67a140cf user: danielk1977 tags: trunk)
03:12
Fixes to the MEM changes. The library now links. (CVS 1470) (check-in: f33d15d9 user: drh tags: trunk)
01:53
More MEM changes in the vdbe.c. Still will not compile. (CVS 1469) (check-in: dbdd1a7f user: drh tags: trunk)
01:49
More test cases for the new query API. (CVS 1468) (check-in: 74097ecd user: danielk1977 tags: trunk)
01:04
Add TCL test bindings and some more test cases for the new query API. (CVS 1467) (check-in: d72adf0c user: danielk1977 tags: trunk)
2004-05-26
23:43
Break Mem.flags into Mem.type and Mem.enc. (CVS 1466) (check-in: 68ef1702 user: drh tags: trunk)
23:25
Refactoring of the vdbe Mem functions and the APIs that deal with them. The code will not compile in its current state. (CVS 1465) (check-in: bba6684d user: drh tags: trunk)
16:54
Remove dataType and includeTypes flags from function definitions. Added new P3_FUNCDEF type for P3 arguments on opcodes. Fixes to several user functions. 28 tests fail now. (CVS 1464) (check-in: 36e03162 user: drh tags: trunk)
13:27
Ensure the type of an sqlite3_value* is not modified by calls to sqlite3_value_*() calls. (CVS 1463) (check-in: ce8b1520 user: danielk1977 tags: trunk)
10:11
Add some tests for the new API. Many more to come. (CVS 1462) (check-in: d5659f2e user: danielk1977 tags: trunk)
06:58
Remove the show_datatypes pragma. (CVS 1461) (check-in: 93bb958d user: danielk1977 tags: trunk)
06:18
Use the new form of the sqlite3_create_function() API. (CVS 1460) (check-in: 0317bef4 user: danielk1977 tags: trunk)
02:04
Use the new API calls more consistently. (CVS 1459) (check-in: 17e7db48 user: danielk1977 tags: trunk)
00:07
More changes to do with the new sqlite3_step() API. (CVS 1458) (check-in: e8313825 user: danielk1977 tags: trunk)
00:01
Minor code fixes in btree.c and pragma.c to help with watcom C. (CVS 1457) (check-in: 143c502a user: drh tags: trunk)
00:01
Add file legacy.c with old APIs. (CVS 1456) (check-in: ae18fcb7 user: danielk1977 tags: trunk)
2004-05-25
23:35
Move the sqlite3_exec() function to legacy.c. (CVS 1455) (check-in: 9385ad5c user: danielk1977 tags: trunk)
12:05
Change a couple of symbol names for the new user function API. (CVS 1454) (check-in: 8f6b20c2 user: danielk1977 tags: trunk)
11:47
Use the new API for returning values and errors from user functions. (CVS 1453) (check-in: 4eccae03 user: danielk1977 tags: trunk)
01:13
Add manifest type aware versions of the min() and max() aggregates. (CVS 1452) (check-in: b77c268e user: danielk1977 tags: trunk)
2004-05-24
23:48
Aggregate functions also use sqlite_value* instead of const char * for arguments. (CVS 1451) (check-in: 5c28ed5e user: danielk1977 tags: trunk)
12:55
Update the typeof() operator to respect manifest types. (CVS 1450) (check-in: 162cf42e user: danielk1977 tags: trunk)
12:39
Non-aggregate SQL functions use sqlite_value* instead of const char * for argument values. (CVS 1449) (check-in: 1e47d738 user: danielk1977 tags: trunk)
09:15
Fix typo in vdbe.c from previous commit. (CVS 1448) (check-in: a554bf6c user: danielk1977 tags: trunk)
09:10
Add the sqlite3_value_*() access functions. (CVS 1447) (check-in: 4bf925fc user: danielk1977 tags: trunk)
07:34
Fix for retrieving UTF-16 little-endian text from a big-endian database. (CVS 1446) (check-in: 8104baf2 user: danielk1977 tags: trunk)
07:04
Have the vdbe handle strings in the same encoding as the database. (CVS 1445) (check-in: b7155db2 user: danielk1977 tags: trunk)
2004-05-23
13:30
Begin changing the vdbe so all stack values use the database encoding. (CVS 1444) (check-in: f47de3a9 user: danielk1977 tags: trunk)
2004-05-22
21:30
Remove the OP_SetInsert opcode. (CVS 1443) (check-in: 18e690e4 user: drh tags: trunk)
17:46
Move btree_rb.c into the attic. (CVS 1442) (check-in: 4159ef23 user: drh tags: trunk)
17:41
Split up os.c into separate files, one for each platform. (CVS 1441) (check-in: 5c61be1c user: drh tags: trunk)
11:09
Bug fix in vdbe.c - variable declarations must come before code in ANSI C. (CVS 1440) (check-in: c36203de user: drh tags: trunk)
10:33
Add a couple of tests for UTF-16 databases. (CVS 1439) (check-in: 891be63a user: danielk1977 tags: trunk)
10:33
Add a couple of tests for UTF-16 databases. (CVS 1438) (check-in: d7551df8 user: danielk1977 tags: trunk)
09:21
Use the new form of the sqlite3_open() API everywhere. (CVS 1437) (check-in: b4492173 user: danielk1977 tags: trunk)
08:16
Tests for the functions in utf.c. (CVS 1436) (check-in: 802d65af user: danielk1977 tags: trunk)
08:09
Store the text encoding in the database (as meta value 4). (CVS 1435) (check-in: 7f00ca58 user: danielk1977 tags: trunk)
07:27
A few bugfixes related to UTF-16 databases. sqlite3_open() still assumes a UTF-8 database, and sqlite3_open16() still assumes a UTF-16 db. (CVS 1434) (check-in: b3581d27 user: danielk1977 tags: trunk)
03:05
Steps towards UTF-16 databases. Some tests are failing because of this commit. (CVS 1433) (check-in: c4a82468 user: danielk1977 tags: trunk)
02:55
Update comments and remove dead code from btree.c (CVS 1432) (check-in: 8069caca user: drh tags: trunk)
2004-05-21
21:12
Floating point values are serialized in big-endian byte order. (CVS 1431) (check-in: acb65297 user: drh tags: trunk)
13:39
Remove the OP_SetFound opcode and its cousins. (CVS 1430) (check-in: 5524075e user: drh tags: trunk)
11:39
Eliminate some unused code (CVS 1429) (check-in: 550a53b3 user: danielk1977 tags: trunk)
10:49
Pretty-print blobs in vdbe-traces. (CVS 1428) (check-in: 5eb94c97 user: danielk1977 tags: trunk)
10:08
Further work on the new API. All the functions to execute queries are there now. (CVS 1427) (check-in: fc94575d user: danielk1977 tags: trunk)
03:01
Eliminate the OP_SortMakeRec and OP_SortCallback opcodes. Sort using the standard record format. (CVS 1426) (check-in: 25643a01 user: drh tags: trunk)
02:14
Most sorting problems are fixed. Dead code has been removed. 3 test failures remain but will be fixed by the new function API once it gets implemented. (CVS 1425) (check-in: 3b55095e user: drh tags: trunk)
02:11
Fix typo in bind.test that was causing a seg-fault. (CVS 1424) (check-in: d1af1a4a user: danielk1977 tags: trunk)
01:47
Add new sqlite3_open() and sqlite3_open16() APIs. (CVS 1423) (check-in: 307b5500 user: danielk1977 tags: trunk)
01:29
Sorting bug fixes. Now only 17 tests fail. (CVS 1422) (check-in: 0736b7e8 user: drh tags: trunk)
2004-05-20
23:37
Fix a bug that prevented sorting by index. Down to 162 failed tests. (CVS 1421) (check-in: b032b646 user: drh tags: trunk)
22:16
Add internal support for collating sequences. This breaks 244 tests. (CVS 1420) (check-in: a6cb09d7 user: drh tags: trunk)
13:54
sqlite3MemCompare now takes a CollSeq* argument. (CVS 1419) (check-in: 5c1e47a2 user: drh tags: trunk)
12:41
Fix problems with types and the recognition of BLOB as having no affinity. (CVS 1418) (check-in: 8411718f user: drh tags: trunk)
12:10
Default type affinity is now NUMERIC. The affinity.html file checked into the doc directory. (CVS 1417) (check-in: 948307f0 user: drh tags: trunk)
11:00
Add some more elements of the new API. (CVS 1416) (check-in: 2821767b user: danielk1977 tags: trunk)
03:30
Fix the misc3.test test file. (CVS 1415) (check-in: 478836f4 user: drh tags: trunk)
03:02
Bug fix associated with misc3.test. (CVS 1414) (check-in: a7f02db7 user: drh tags: trunk)
02:42
Bug fix associated with OP_SetNumColumns in insert.c. Also changed a variable name in OP_Column. (CVS 1413) (check-in: bf2181f1 user: drh tags: trunk)
02:01
VACUUM works again. (CVS 1412) (check-in: c4e1d02f user: drh tags: trunk)
01:40
Add some comments for sqlite3_bind_*() APIs. (CVS 1411) (check-in: 46b09422 user: danielk1977 tags: trunk)
01:12
Add support for the new sqlite3_bind_*() APIs. (CVS 1410) (check-in: e8f980d8 user: danielk1977 tags: trunk)
2004-05-19
21:09
Get more tests running. (CVS 1409) (check-in: 7eb3f29e user: drh tags: trunk)
20:41
Correctly handle 64-bit integers in SQL statements. (CVS 1408) (check-in: 34f03ba6 user: drh tags: trunk)
14:56
Change opcode names and comments to better describe the operation of the incrKey flag. OP_MoveTo becomes OP_MoveGe. (CVS 1407) (check-in: 8f249c45 user: drh tags: trunk)