SQLite

Timeline
Login

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

101 events for the month beginning 2004-05-01 by user drh

Following month ↑
2004-05-31
23:13
Synchronize lemon.c to the version on the 2.8 branch. (CVS 1513) (check-in: 6ab3af88 user: drh tags: trunk)
19:34
Change the name of the sqlite3_freemem API function to just sqlite3_free. (CVS 1512) (check-in: f3b80bbb user: drh tags: trunk)
18:51
Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511) (check-in: adf7e29f user: drh tags: trunk)
18:23
Change the name of the include file to "sqlite3.h". The names of the shell command and static library become "sqlite3" and "libsqlite3.a". (CVS 1510) (check-in: 4c37b6d2 user: drh tags: trunk)
18:22
Begin adding documentation for version 3.0. (CVS 1509) (check-in: 2005bfda user: drh tags: trunk)
18:21
Get the attach.test working on windows. (CVS 1508) (check-in: 48226a73 user: drh tags: trunk)
16:04
More website updates. (CVS 1507) (check-in: 460f2361 user: drh tags: trunk)
15:06
Website redesign in preparation for adding version 3 documentation. (CVS 1506) (check-in: 2052911b user: drh 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)
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)
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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
13:13
Bug fixes in where.c. The where.test test works again. (CVS 1406) (check-in: 7c31e257 user: drh tags: trunk)
11:31
Really remove the OP_StrEq opcode this time - appearently I didn't save the file out of the editor before doing the check-in (1397). (CVS 1405) (check-in: 821b0b29 user: drh tags: trunk)
11:24
Variable name change: azVar to apVar. (CVS 1404) (check-in: 45169ce0 user: drh tags: trunk)
2004-05-18
23:21
Add definitions of the CollSeq and KeyInfo structures. (CVS 1399) (check-in: cd1be815 user: drh tags: trunk)
22:38
Remove dead code from vdbeaux.c. Add comments describing desired changes to OP_Sort processing in select.c (CVS 1398) (check-in: ae37e8a0 user: drh tags: trunk)
22:17
Remove the OP_StrEq opcodes. (CVS 1397) (check-in: 238442bb user: drh tags: trunk)
22:03
Remove dead code from util.c (CVS 1396) (check-in: 3ce42e85 user: drh tags: trunk)
15:57
New varint encoding gives a maximum varint length of 9 instead of 10. (CVS 1395) (check-in: 61bdb53a user: drh tags: trunk)
12:50
Additional debugging output from btree.c (CVS 1394) (check-in: b2def185 user: drh tags: trunk)
2004-05-16
16:24
Fix a bug in the BTree balancing routine. (CVS 1387) (check-in: 6c73544b user: drh tags: trunk)
2004-05-15
00:29
More speed improvements to btree. (CVS 1384) (check-in: aab4b794 user: drh tags: trunk)
2004-05-14
21:59
Allocates VDBE cursors one by one in separate memory so that pointers to cursors can persist through a realloc(). (CVS 1383) (check-in: d8bacc16 user: drh tags: trunk)
21:12
Cache record headers in the OP_Column opcode. (CVS 1382) (check-in: 8d9eab17 user: drh tags: trunk)
19:08
More speed improvements. (CVS 1381) (check-in: cf75cac9 user: drh tags: trunk)
16:50
Optimized varint routines and tests added. (CVS 1380) (check-in: d4e0933d user: drh tags: trunk)
15:27
Performance improvements (CVS 1379) (check-in: cad47917 user: drh tags: trunk)
12:17
Table 1 of a database (the sqlite_master table) defaults to use B+trees. (CVS 1378) (check-in: 45b60de5 user: drh tags: trunk)
01:58
Changes to btree and pager in preparation for moving to run-time page size determination. (CVS 1374) (check-in: f63fb6dd user: drh tags: trunk)
2004-05-13
01:12
Allocate more overflow data onto overflow pages, thus wasting less disk space. (CVS 1367) (check-in: 1d52a4bb user: drh tags: trunk)
2004-05-12
21:11
Fix a problem with B+trees. (CVS 1366) (check-in: 64a75c4c user: drh tags: trunk)
19:18
Implement a B+tree option (all data stored on leaves). (CVS 1365) (check-in: b8f70d17 user: drh tags: trunk)
15:15
Btree uses signed integers for the rowid. The intToKey() and keyToInt() macros are now no-ops. (CVS 1364) (check-in: fb3c8030 user: drh tags: trunk)
13:30
The pager now handles file ":memory:" complete in memory with no disk I/O. (CVS 1363) (check-in: 97de9f7c user: drh tags: trunk)
2004-05-11
10:04
Change sqlite_ to sqlite3_ in the attach2.test test script. (CVS 1360) (check-in: 98f756e6 user: drh tags: trunk)
09:57
A different fix for the problem with opening existing files. See also check-in (1358). (CVS 1359) (check-in: 93deaf54 user: drh tags: trunk)
09:31
Fix an offset problem in the meta values that was causing problems for many tests. (CVS 1357) (check-in: 6d378cb7 user: drh tags: trunk)
09:05
Remove the unused upgrade_3_schema subroutine from main.c. (CVS 1356) (check-in: b5d2771e user: drh tags: trunk)
01:18
Update the main.mk makefile so that it builds everything again. (CVS 1348) (check-in: e6e52fc2 user: drh tags: trunk)
00:58
Updates to sqlite3BtreeKeyFetch() and sqlite3BtreeDataFetch(). (CVS 1347) (check-in: a675ac49 user: drh tags: trunk)
2004-05-10
23:29
Work toward getting the new btree.c integrated with vdbe.c. (CVS 1345) (check-in: bc5a2daf user: drh tags: trunk)
20:27
Improvements to testing of sqlite_interrupt. More checking for interrupt inside of VACUUM. (CVS 1344) (check-in: d596f513 user: drh tags: version_2)
18:45
The btree.c module passes all tests and is ready for integration. Still need to go back and do coverage testing. (CVS 1343) (check-in: 84506b23 user: drh tags: trunk)
16:18
The btree.c module now passes all the historical regression tests. New tests for new functionality still need to be added. (CVS 1342) (check-in: 433ae0d3 user: drh tags: trunk)
12:07
Add flags values to the Mem structure to accomodate BLOBs and to show the representation of strings. (CVS 1341) (check-in: 3af283f4 user: drh tags: trunk)
2004-05-09
20:40
More btree.c bug fixing. It's getting closer but still not there yet. Move obsolete test scripts into the attic. (CVS 1331) (check-in: 9379c7c9 user: drh tags: trunk)
11:51
The btree.test test is no working with integrity_check enabled. (CVS 1330) (check-in: 9f1caa53 user: drh tags: trunk)
01:35
Begin trying to get integrity checking working on the new btree.c. (CVS 1329) (check-in: 499569da user: drh tags: trunk)
00:40
All tests in btree.test now pass (but only because I commented out the btree_integrity_check test.) (CVS 1328) (check-in: ee706e9c user: drh tags: trunk)
2004-05-08
20:07
More btree.c bug fixes. (CVS 1327) (check-in: e9f84ff3 user: drh tags: trunk)
10:56
Get the code back to the point where it will compile the btree.c tests. Move the default key comparison routine from btree.c into vdbeaux.c. Commented out code in vdbe.c that will need to be fixed. (CVS 1326) (check-in: 2bca9224 user: drh tags: trunk)
10:11
Minor change to main.c so that it will compile with GCC 2.96. (CVS 1325) (check-in: 1a09a1ad user: drh tags: trunk)
02:03
More bug fixes in btree.c. (CVS 1323) (check-in: 2d64cba3 user: drh tags: trunk)
2004-05-07
23:50
More bug fixes in btree.c. (CVS 1322) (check-in: a80939ef user: drh tags: trunk)
17:57
The btree.c module compiles and links and passes some tests. Many tests still fail, though. (CVS 1321) (check-in: d394b2b2 user: drh tags: trunk)
13:30
New btree.c module compiles and links. (CVS 1320) (check-in: dcd6b55f user: drh tags: trunk)
02:26
Trying to synchronize the test3.c module with the new btree.c code. (CVS 1319) (check-in: 7fd1a660 user: drh tags: trunk)
01:46
Fix a memory leak in DETACH when using the codec. (CVS 1317) (check-in: c4bd99b7 user: drh tags: version_2)
00:57
Add the sqlite_temp_directory global variable which, if set, defines the directory in which temporary files are created. (CVS 1316) (check-in: c90ed20d user: drh tags: version_2)
2004-05-04
17:27
Update test3.c to work with the new btree.c API. (CVS 1314) (check-in: bfb3234d user: drh tags: trunk)
15:00
Added template for the utf.c file containing conversion routines. (CVS 1313) (check-in: 89b42c46 user: drh tags: trunk)
2004-05-03
19:49
Incremental btree.c changes. (CVS 1312) (check-in: fdc629db user: drh tags: trunk)
2004-05-02
21:12
Changes to btree for the new file format are mostly complete. Still need to test and debug. (CVS 1311) (check-in: 0eee3b5c user: drh tags: trunk)
Previous month ↓