๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. eddfa98 Improvements to the description of the OPFLAG_TYPEOFARG option to OP_Column. by drh ยท 3 years, 2 months ago isnull-opt
  2. bd1c634 Adjust the implementation of sqlite3VdbeTypeofColumn() to make it easier by drh ยท 3 years, 2 months ago
  3. e995d2c Proposed optimization to the IS NULL and NOT NULL operators that avoids by drh ยท 3 years, 2 months ago
  4. 7be51f5 Merge trunk into fiddle-opfs as a preliminary step for a clean merge in the other direction. by stephan ยท 3 years, 2 months ago fiddle-opfs
  5. 47996ea Add the sqlite3_value_encoding() interface. by drh ยท 3 years, 2 months ago
  6. c2777ab Enhance the OP_IsType opcode so that it is slightly smaller and faster and by drh ยท 3 years, 2 months ago
  7. 7d23d15 Improved the ability of the CLI to handle very long input lines. by drh ยท 3 years, 2 months ago
  8. c9ef12f Code clean-up for the integrity_check enhancement. by drh ยท 3 years, 2 months ago integrity_check_datatypes
  9. db6940a Fix corner-case bugs in the new integrity_check logic. All tests pass now. by drh ยท 3 years, 2 months ago
  10. 49d77ee An attempt to enhance PRAGMA integrity check so that it does data type by drh ยท 3 years, 2 months ago
  11. 005c9d8 Improved detection of database corrupting when moving pages on an by drh ยท 3 years, 2 months ago
  12. d35b558 Refactor os_kv.c so that the kvvfs read/write/delete methods can be swapped out at runtime by JS implementations. This eliminates the kvvfs dependency on Emscripten. Checkin part 1 of 2, to account for cherrypicking. by stephan ยท 3 years, 2 months ago
  13. 211a1a7 When casting an odd-length BLOB into a TEXT with encoding UTF16, omit the by drh ยท 3 years, 2 months ago
  14. 73c586b Fix a problem causing the seek-scan optimization to skip over valid rows that could occur when it is used with expressions of the form (a IN (?,?..) AND b >= ?). dbsqlfuzz ab1db6dc0efb04cba1cd3431ee6da4894fdc4520. by dan ยท 3 years, 2 months ago
  15. 8a2254f Improved tracing output for showing all registers used by the by drh ยท 3 years, 2 months ago
  16. 73ac958 Fix a problem that occurred when using a bloom filter to optimize an (ipk = ?) lookup in the case where the RHS of the expression is a TEXT value. First reported by [forum:/forumpost/f61a8b7053|forum post f61a8b7053]. by dan ยท 3 years, 2 months ago
  17. 2eca061 Attempt to clarify the operation of the xLock and xUnlock VFS I/O methods. by drh ยท 3 years, 2 months ago
  18. a4b2f41 Change the name of the autoconf-generated configuration file from "config.h" by drh ยท 3 years, 2 months ago
  19. 4b07469 Omit WAL mode from the wasm build. by stephan ยท 3 years, 2 months ago
  20. a4c357f Reimplement fiddle_reset_db() so that it works with all VFSes. by stephan ๏ฟฝ๏ฟฝ 3 years, 2 months ago
  21. 65e6522 Minor doc typo fix in sqlite.h.in. by stephan ยท 3 years, 2 months ago
  22. 7d34b8d Performance optimization in sqlite3_prepare() (discovered while working by drh ยท 3 years, 2 months ago
  23. 3278142 Fiddle: fix makefile dependency issue and duplicate inclusion of post-js.js. Reimplement db export using sqlite3_serialize(). by stephan ยท 3 years, 2 months ago
  24. be9d203 Merge trunk into fiddle-opfs branch. by stephan ยท 3 years, 2 months ago
  25. c9099d2 Tweak sqlite3-worker1.js to be able to load either sqlite3.js or sqlite3-wasmfs.js, noting that the latter still does not load in a Worker because of an Emscripten loader bug. by stephan ยท 3 years, 2 months ago
  26. 7424aef Replace the Parse.disableVtab field with Parse.prepFlags for increased by drh ยท 3 years, 2 months ago
  27. 7bc6a81 Remove one of the NEVER() macros added by [5166acf3f0040459] because it by drh ยท 3 years, 2 months ago
  28. 2d3261f Fix a bug in the demoDelete fix from [d76a301e22e05722]. by drh ยท 3 years, 2 months ago
  29. 0a803bd Add NEVER() to two error-detection tests that were made unreachable by by drh ยท 3 years, 2 months ago
  30. ad658b2 Better handle a case of database corruption where a b-tree page is one of its own ancestor pages. by dan ยท 3 years, 2 months ago
  31. cb57716 Improvements to the "demoDelete" method in the demovfs, suggested by by drh ยท 3 years, 2 months ago
  32. 5d48e0c Provide the SQLITE_MAX_ALLOCATION_SIZE compile-time option for limiting the by drh ยท 3 years, 3 months ago
  33. 80cf891 Enhance defensive mode so that it disallows CREATE TRIGGER statements if the by drh ยท 3 years, 3 months ago
  34. 278d3fa Fiddle: replace db export routine with a C-side one which works for both Emscripten FS-hosted and OPFS-hosted db files. Minor code-adjacent cleanups. by stephan ยท 3 years, 3 months ago
  35. 1f095d4 Get fiddle db export working for OPFS VFS. Add root dir handle to the main OPFS VFS worker to enable creation of certain utility functions without delegating to the async worker. Add sqlite3.capi.sqlite3_wasm_rc_str() to map integer result codes back to their SQLITE_xxx counterparts. Minor doc touchups. by stephan ยท 3 years, 3 months ago
  36. 60d9aa7 Refactoring towards getting fiddle to support OPFS as a first-class citizen. Certain operations, e.g. import, export, and unlink, are not OPFS-aware. by stephan ยท 3 years, 3 months ago
  37. f333370 Reduced and improved comments on the constraintCompatibleWithOuterJoin() by drh ยท 3 years, 3 months ago
  38. 6502271 shell.c.in: when building in fiddle mode, define _POSIX_SOURCE (ifndef) so that emcc's string.h reveals strdup(). by stephan ยท 3 years, 3 months ago
  39. faaacd3 Break out the decision of whether or not a constraint term is usable by by drh ยท 3 years, 3 months ago flattener-omit-restriction-29
  40. 0f51aa3 Do not allow EP_InnerON terms to be used on a outer join. by drh ยท 3 years, 3 months ago
  41. 8b9a3d1 Modify the OP_IfNotOpen opcode so that the jump is taken if the cursor is open by drh ยท 3 years, 3 months ago
  42. 5a0771a Remove code that has been previously commented out. by drh ยท 3 years, 3 months ago
  43. 40c9bec Is the query flattener restriction 29 (do not allow both EP_InnerON and by drh ยท 3 years, 3 months ago
  44. c3b6fda When compiled with SQLITE_OS_KV_OPTIONAL, the magic names ":localStorage:" by drh ยท 3 years, 3 months ago kv-vfs-magic-names
  45. b22b493 Clarify comments that describe query flattener restrictions associated with by drh ยท 3 years, 3 months ago
  46. 316cd40 Fix a minor comment typo. No changes to code or documentation. by drh ยท 3 years, 3 months ago
  47. bcdb4cc Remove a NEVER macro in defragmentPage() that dbsqlfuzz discovered can be by drh ยท 3 years, 3 months ago
  48. a50d3b7 Fix an uninitialized variable in the decoder kv-vfs. by drh ยท 3 years, 3 months ago
  49. 20a9ed1 Include the kv-vfs as an optional VFS on unix builds if the by drh ยท 3 years, 3 months ago
  50. b9fbc55 Merge the latest trunk enhancements into the kv-vfs branch. by drh ยท 3 years, 3 months ago
  51. 756440f Corrections to the xRead method for databases in the os_kv.c VFS so that it by drh ยท 3 years, 3 months ago
  52. 84e5076 Fix os_kv.c so that it uses SQLITE_FCNTL_SYNC and hence by drh ยท 3 years, 3 months ago
  53. d22cfa8 Pull the src/os_kv.c part of [13839759f8f4] into the kv-vfs branch. by stephan ยท 3 years, 3 months ago
  54. 5fd8f27 Remove an extraneous key-copy op in the EM_JS impl of kvstorageDelete(). by stephan ยท 3 years, 3 months ago
  55. b126ec1 Fix the <sys/time.h> include in os_kv.c. by drh ยท 3 years, 3 months ago
  56. d8bb0b5 Add a gettimeofday()-based implementation of xCurrentTimeInt64() to os_kv.c. by drh ยท 3 years, 3 months ago
  57. bb19512 Fix a debugging/testing edit in the previous check-in. by drh ยท 3 years, 3 months ago
  58. 6acd7b0 Faster text decoder for kv_os.c. by drh ยท 3 years, 3 months ago
  59. 1ad51ff Fix uninitialized variable in rollback-journal processing in os_kv.c by drh ยท 3 years, 3 months ago
  60. 6b013af Fix the amalgamation so that it builds with the standard unix backend again. by drh ยท 3 years, 3 months ago
  61. ad5125a Initial build of kvvfs in wasm. It loads but cannot find the VFS for as-yet-unknown reasons (sqlite3 shell works fine), and most APIs throw "null function or function signature mismatch" from deep within wasm, presumably as a side effect of the "missing" VFS. by stephan ยท 3 years, 3 months ago
  62. c6c9c6a Improved comments in os_kv.c. Better names for the key/value name spaces. by drh ยท 3 years, 3 months ago
  63. 7585f49 Move the vfskv.c extension to src/os_kv.c and make it part of the amalgamation, by drh ยท 3 years, 3 months ago
  64. bdb6368 Fix harmless compiler warning seen with MSVC. by mistachkin ยท 3 years, 3 months ago
  65. b53e099 Enhance an assert() to impose for tighter constraints on the operation of pcache. by drh ยท 3 years, 3 months ago
  66. 8c983dd An improved technique for ensuring that the Rekey() operation does not by drh ยท 3 years, 3 months ago
  67. 6e440ab Fix the windows build so that it works with -DSQLITE_OMIT_AUTOINIT. by drh ยท 3 years, 3 months ago
  68. ad617b4 Ensure the Pager.journalOff variable is zeroed if an error occurs while writing the initial header to the journal file. by dan ยท 3 years, 3 months ago
  69. 173b418 Fix an assert() associated with the dbsqlfuzz error at [8372468bb5d8922c]. by drh ยท 3 years, 3 months ago
  70. 5fc3a8a If sqlite3PcacheMove() really performs a swap, then be sure to renumber the by drh ยท 3 years, 3 months ago
  71. 4e9bf5a Enhance the pcache1 implementation so that during an xRekey operation if by drh ยท 3 years, 3 months ago
  72. e04c9f4 Mutex protect access to the sqlite3_test_directory and sqlite3_data_directory by drh ยท 3 years, 3 months ago
  73. fee6431 Improved mutex protection of the sqlite3_temp_directory and by drh ยท 3 years, 3 months ago tempdir-mutex
  74. 18a3a48 Experimental changes to put sqlite3_temp_directory behind a mutex. by drh ยท 3 years, 3 months ago
  75. 4413224 Defer deleting a transient SELECT statement associated with a flattening by drh ยท 3 years, 3 months ago
  76. a3fc683 In the query planner, add a heuristic that will reduce the cost of a full by drh ยท 3 years, 3 months ago
  77. 9c3a114 Enhance the b-tree page sorting code to ensure that sqlite3PagerRekey() never by drh ยท 3 years, 3 months ago
  78. 78d15f0 Improved comments in pcache1.c. No changes to code. by drh ยท 3 years, 3 months ago
  79. 4d28830 Any function call can abort. Take this into account when deciding if a DML by drh ยท 3 years, 4 months ago
  80. f0f025b More assert() statements in the page cache. by drh ยท 3 years, 4 months ago
  81. f6e3e31 Ensure that every pcache page always has either the PGHDR_DIRTY or the by drh ยท 3 years, 4 months ago
  82. aa07b36 Remove a NEVER() macro for a condition that is actually reachable following an OOM. dbsqlfuzz crash-6ef3cd3b18ccc5de86120950a0498641acd90a33.txt. by dan ยท 3 years, 4 months ago
  83. 7383f5a Add a mutex to the sqlite3_db_config() interface so that it is threadsafe by drh ยท 3 years, 4 months ago
  84. 2ce2b77 Fix an inefficiency in the ".dump" command when outputing large blob literals. by dan ยท 3 years, 4 months ago
  85. e5928b1 Change the names of the Vdbe.pVNext and Vdbe.ppVPrev fields to make them by drh ยท 3 years, 4 months ago
  86. 35908b1 Enhance assert() statements to enforce tighter bounds on the P5 operand of by drh ยท 3 years, 4 months ago
  87. 376860b Performance enhancement for sqlite3DbFree(). by drh ยท 3 years, 4 months ago
  88. 41ce47c Add the new internal interface sqlite3DbNNFreeNN(db,ptr) where both the by drh ยท 3 years, 4 months ago
  89. 00378fd Enhance the enforcement of SQLITE_VTAB_DIRECTONLY so that it applies to by drh ยท 3 years, 4 months ago
  90. 78ed74e In the ".dump" command of the CLI, if a schema statement ends with an by drh ยท 3 years, 4 months ago
  91. 16b03c0 Enhance the "PRAGMA integrity_check" statement so that it verifies the rows of by drh ยท 3 years, 4 months ago
  92. 0348fc7 Minor code simplification in the code generator for PRAGMA integrity check. by drh ยท 3 years, 4 months ago
  93. a8771a1 Change the legacy RC4-based PRNG to use the RFC-7539 chacha20 algorithm. by drh ยท 3 years, 4 months ago
  94. cd05aaf Fix obsolete comments. Add new comments. Fix non-standard spacing. by drh ยท 3 years, 4 months ago chacha20-prng
  95. 534945a Fix an off-by-one error in the ChaCha20 initialization code. by drh ยท 3 years, 4 months ago
  96. 2756f80 Add assert() statements to verify that the SQLITE_OPEN_EXCLUSIVE flag is always passed to the VFS when opening a temporary file. by dan ยท 3 years, 4 months ago
  97. 9113c87 Replace the RC4-based PRNG with one based on ChaCha20. 3x faster. by drh ๏ฟฝ๏ฟฝ 3 years, 4 months ago
  98. 9c5e1e4 In the documentation emphasize that the use of shared cache is discouraged. by drh ยท 3 years, 4 months ago
  99. 087f143 Add the (undocumented) SQLITE_DEFAULT_UNIX_VFS compile-time option. by drh ยท 3 years, 4 months ago
  100. f0d12d8 Fix another harmless comment typo that causes a typo in the documentation. by drh ยท 3 years, 4 months ago