๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. 0dbb3db Sync w/trunk, pickup fts3corrupt6.test change. by larrybr ยท 3 years, 6 months ago dbinfo-guard
  2. 8fca1c7 fiddle: replaced the huge file selection widget with a smaller proxy button. by stephan ยท 3 years, 6 months ago
  3. fd80fa9 Fix a test case in fts3corrupt6.test. Was failing due to [f1dfbc4f]. by dan ยท 3 years, 6 months ago
  4. 626aa48 shell: in WASM mode, permit ATTACH because the filesystem is a virtual sandbox and ATTACH can be used to provide more import/export options. Minor doc updates in sqlite3-api.js. by stephan ยท 3 years, 6 months ago
  5. f3d6e8f In CLI, drop .dbinfo command when build options prevent it from working. by larrybr ยท 3 years, 6 months ago
  6. b61c242 Create new branch named "dbinfo-guard" by larrybr ยท 3 years, 6 months ago
  7. 93a4b41 Fix to test case in fts3corrupt.test. No changes to source code. by dan ยท 3 years, 7 months ago
  8. 181d75e Fix a 1-byte overread in fts3 that could occur when processing corrupt records. by dan ยท 3 years, 7 months ago
  9. 410fac3 Fix a problem with flattening and window functions causing an "IS <column>" to be transformed to "IS TRUE" or "IS FALSE" when <column> is a view or sub-select expression that is the literal value "TRUE" or "FALSE". by dan ยท 3 years, 7 months ago
  10. bf15436 Avoid a direct use of abort() in debug builds to prevent a compilation issue for Windows CE. by mistachkin ยท 3 years, 7 months ago
  11. 4861916 New test cases for row values and RIGHT JOIN. by drh ยท 3 years, 7 months ago
  12. f89f4ef Ensure that subqueries associated with row-values are invoked before being by drh ยท 3 years, 7 months ago
  13. 4e5aeb5 fiddle: added another UI element to the list of those which are disabled during long-running activities. Added DB.close() binding to the Worker-based wasm binding. by stephan ยท 3 years, 7 months ago
  14. a5d06a3 Ensure that all necessary row-value subqueries are invoked while running by drh ยท 3 years, 7 months ago row-value-right-join
  15. 23aa8ff Minor tweaks to, and consolidation of, the wasm-related build flags. by stephan ยท 3 years, 7 months ago
  16. f74f4ed Fix a minor problem in the Tcl "incrblob" command. This does not affect the SQLite core. by dan ยท 3 years, 7 months ago
  17. 0f4b534 Candidate fix for the problem with row-value WHERE clause constraints on by drh ยท 3 years, 7 months ago
  18. 6d013d8 Only include the code for sqlite_offset() if compiled with by drh ยท 3 years, 7 months ago
  19. 1324b28 Fix a typo in a comment in a test case. No changes to code. by drh ยท 3 years, 7 months ago
  20. 0286cdb Additional enhancements to the test cases. by drh ยท 3 years, 7 months ago
  21. 47b4969 Fix test cases in the previous check-in to make them postgres-compatible. by drh ยท 3 years, 7 months ago
  22. 36c19f7 Test case for [forum:/forumpost/087de2d9ec|forum post 087de2d9ec] showing by drh ยท 3 years, 7 months ago
  23. ea7a4e4 The Worker-specific variants of the most significant DB-class JS bindings are implemented, most notably various uses of DB.exec(). by stephan ยท 3 years, 7 months ago
  24. 645682a Move the sqlite_offset() function implementation to be an in-line function, by drh ยท 3 years, 7 months ago
  25. 6ffa895 Initial proof of concept code for a JavaScript binding which runs in the main window thread but acts on a db handle running in a Worker thread. Expanded the DB.exec() and DB() constructor to simplify certain use cases. by stephan ยท 3 years, 7 months ago
  26. bff17db Initial bits for a JS API variant in which the client operates in the main thread and sqlite3 in a Worker. This is far from complete. by stephan ยท 3 years, 7 months ago
  27. c7fc08f New FULL JOIN test cases. No changes to code. by drh ยท 3 years, 7 months ago
  28. aa03c69 More JOIN test cases inspired by the problem fixed in [3869fd9a2b9483cb]. by drh ยท 3 years, 7 months ago
  29. f51672a Fix an assert that is incorrect for a corrupt database. by drh ยท 3 years, 7 months ago
  30. d69820c Many new PG-confirmed test cases in joinD.test. by drh ยท 3 years, 7 months ago
  31. 9f67cc2 Restore an ON-clause test case (removed by [3869fd9a2b9483cb]) that turns out by drh ยท 3 years, 7 months ago
  32. c9dfe2b Add back in a test case for ON-clauses that was removed yesterday by by drh ยท 3 years, 7 months ago right-join-bug-20220531
  33. b1f08bc Add test cases for by drh ยท 3 years, 7 months ago
  34. 5fd9f03 Updated the wasm builds to generate gzip'ed copies of relevant files to take advantage of althttpd's new capability of substituting gzip files in place of requested files. This cuts over-the-wire size of the fiddle app by more than half. by stephan ยท 3 years, 7 months ago
  35. 404bf6b For an outer join, then ON-clause constraints need to be evaluated at just by drh ยท 3 years, 7 months ago
  36. 1943005 Apply the UPDATE-FROM file from check-in [98b3816bbaf539ea] to by drh ยท 3 years, 7 months ago
  37. 1a66ff3 fiddle: changed the internal key of the session/local storage to avoid conflicts with the pikchr fiddle app (which is derived from this one) when running from the same HTTP origin as an instance of that app in a dev environment. by stephan ยท 3 years, 7 months ago
  38. e9ab04a fiddle: corrected a piece of far-corner-case error handling and made the various checkbox config options persistent. by stephan ยท 3 years, 7 months ago
  39. 5af8a86 Mark an always-true conditional as ALWAYS(). by drh ยท 3 years, 7 months ago
  40. abe1ff3 Minor simplification to ALTER TABLE logic. by drh ยท 3 years, 7 months ago
  41. 23b34bb Corrected a broken HTML comment (was using a C-style comment closer). by stephan ยท 3 years, 7 months ago
  42. ca29bbc Fix another problem with ALTER TABLE and UPDATE...FROM in triggers. by dan ยท 3 years, 7 months ago
  43. 4209d55 Fix further issues with ALTER TABLE and triggers that contain UPDATE..FROM statements. by dan ยท 3 years, 7 months ago
  44. 8d2f661 Omit an unnecessary branch. by drh ยท 3 years, 7 months ago
  45. cd69784 fiddle: added an option to completely wipe/reset the db. The Options area can now be toggled on/off via tapping the label at its top. Running the input SQL is now limited to the selected area if any text is currently selected, per suggestion in the forum. by stephan ยท 3 years, 7 months ago
  46. b8bbe3e Fix issues with ALTER TABLE and triggers containing "UPDATE...FROM" statements. by dan ยท 3 years, 7 months ago
  47. 26c4df0 Correct handling of outer joins in the FROM clause of an UPDATE statement by drh ยท 3 years, 7 months ago
  48. e91bde4 Clarification of the meaning of the N parameter in sqlite3_db_name(). by drh ยท 3 years, 7 months ago
  49. 78907bb Fixed a minor cut/paste mistake in the previous checkin. Affects only internal docs. by stephan ยท 3 years, 7 months ago
  50. c121e08 Makefile.in: added explanations, intended for maintainers and hackers, of the various emcc flags used for building the wasm files. No code or build rule changes. by stephan ยท 3 years, 7 months ago
  51. 724e298 Slight increase in the accuracy of log10(). by drh ยท 3 years, 7 months ago
  52. 7bfbd25 Do not allow the right operand of a RIGHT JOIN to be reordered with other by drh ยท 3 years, 7 months ago
  53. 361e0ed Add in a VdbeCoverage() macro accidentally omitted from [d64ae49a1f251317]. by drh ยท 3 years, 7 months ago
  54. ddcdf0b Fix the UPDATE-FROM logic so that it works the same as PostgreSQL when the by drh ยท 3 years, 7 months ago
  55. 26542e7 Got the sqlite3-api JS bits wrapped up in deferred-load module. Whether that's going to be easier to use, in practice, remains to be seen. Consolidated two of the test-related JS files. by stephan ยท 3 years, 7 months ago
  56. e599cc4 Renamed EXPORTED_FUNCTIONS.sqlite3 to EXPORTED_FUNCTIONS.sqlite3-api to avoid any potential confusion about that file (not) being an sqlite3 database. by stephan ยท 3 years, 7 months ago
  57. 085c5c6 Add the ability to import/export db files into/from fiddle. by stephan ยท 3 years, 7 months ago
  58. d0b22b8 Further minor cleanups and docs in the fiddle app and worker. by stephan ยท 3 years, 7 months ago fiddle-local-db
  59. 79669c2 fiddle: refactored so that it no longer exposes any global symbols. Doing so with the main sqlite3.api module will be much tricker. by stephan ยท 3 years, 7 months ago
  60. fb98dac An attempt to get UPDATE FROM working when the FROM clause contains a by drh ยท 3 years, 7 months ago update-from-right-join
  61. 80bf869 fiddle: added support for exporting (downloading) the current db file. To do this we had to fall back to named dbs, instead of defaulting to an in-memory one, but the virtual filesystem is an in-memory FS, so the end effect is the same. by stephan ยท 3 years, 7 months ago
  62. de1e02e fiddle: initial work on loading a client-side db file. Works but requires some cleanup. Export is not yet implemented. by stephan ยท 3 years, 7 months ago
  63. 6af03b4 When an ON clause on an INNER JOIN references a table to the right of by drh ยท 3 years, 7 months ago
  64. 73c6ad1 MoUse re descriptive var names in ext/fiddle/Makefile. by stephan ยท 3 years, 7 months ago
  65. 400ee2e fiddle: lots of generic refactoring, restructuring, and cleanup in the higher-level code. Added push-fiddle ext/fiddle/Makefile target to push the fiddle app to a remote server via rsync. by stephan ยท 3 years, 7 months ago
  66. 2f6a729 wasm/JS: minor doc updates, corrected bind()ing of the undefined value to behave as documented, removed some superfluous code. by stephan ยท 3 years, 7 months ago
  67. 64f0e93 wasm/JS: documented DB.selectValue() and corrected the fetching of NULL columns via Stmt.get(). by stephan ยท 3 years, 7 months ago
  68. a240a24 wasm/JS: added support for scalar UDFs. Fixed a deallocation problem with bind()ed strings/blobs. by stephan ยท 3 years, 7 months ago
  69. e145136 wasm: minor refactoring and doc updates. by stephan ยท 3 years, 7 months ago
  70. 325b56b fiddle: cleaned up and documented the status-loading progress mechanism in prep for reusing it in the sqlite3-api worker. by stephan ยท 3 years, 7 months ago
  71. dc5888e wasm: added missing 'use strict' and fixed an undeclared var use caught by that. by stephan ยท 3 years, 7 months ago
  72. 192201d wasm: corrected isSupportedBindType() to behave as documented. by stephan ยท 3 years, 7 months ago
  73. ea488b1 New test cases to further demonstrate the difference in name matching rules by drh ยท 3 years, 7 months ago
  74. 51e5d44 Add an assert() to clear a harmless static-analyzer warning. by drh ยท 3 years, 7 months ago
  75. 43baa1d Do not run the subroutine that materializes a view or subquery until just by drh ยท 3 years, 7 months ago
  76. 71eacea WASM: removed the in64-related bindings, as MDN says that calling a wasm function which has an int64 type in its signature will currently throw because JS has no 64-bit integer support. Those bindings now use doubles and simply hope that the user doesn't exceed their integer precision (2^53-1, approx 9 quadrillion). by stephan ยท 3 years, 7 months ago
  77. c21c0e2 WASM: an arg handling fix for DB.exec({multi:true...}). by stephan ยท 3 years, 7 months ago
  78. 744a65c WASM: added exec(), execMulti(), and several getters. Various touchups and fixes. by stephan ยท 3 years, 7 months ago
  79. f686856 Implemented Stmt.get() and friends for WASM OO #1 wrapper. Added basic tests for prepare/step/get. Restructured module init output to introduce only 1 global-scope symbol instead of 2. by stephan ยท 3 years, 7 months ago
  80. 40b5b19 WASM: added bindings for sqlite3_compileoption_get/used(), moved OO #1 into sqlite3-api.js since it can only be used from the same thread as that API and separating them complicates client-side use. Started adding test utilities and tests for the OO1 API. by stephan ยท 3 years, 7 months ago
  81. d60b727 WASM OO wrapper #1: prepare() and bind() APIs are in place but are untested, pending fetch/get APIs. by stephan ยท 3 years, 7 months ago
  82. 166542c Build refactoring for the fiddle/wasm bits. Set up wasm binding of a chunk of the core C API and added some infastructure for creating test pages for it. by stephan ยท 3 years, 7 months ago
  83. 4ec29fc Minor fiddle-related build restructuring to support upcoming development of the C-style wasm sqlite3 interface, plus some commentary about the plans and goals for that. by stephan ยท 3 years, 7 months ago
  84. 40822eb Defer materializing a view or subquery until the materialization is actually by drh ยท 3 years, 7 months ago deferred-materialize
  85. 660dfbd Fix a typo in a comment. by drh ยท 3 years, 7 months ago
  86. b800bd6 Use the newer OP_BeginSubrtn opcode instead of OP_Integer to start the by drh ยท 3 years, 7 months ago
  87. 4257373 fiddle: refactor into main thread (UI) and worker thread (wasm module). Added bits needed to support triggering sqlite3_interrupt() but do not yet have a second SharedWorker to test it with. by stephan ยท 3 years, 7 months ago
  88. 0592b20 fiddle: add a selection list of example queries. by stephan ยท 3 years, 7 months ago
  89. 2eb4541 In the shell WASM build, call open_db() early so that we can get access to the global db handle from certain experimentation-only function without having to first run some SQL code. by stephan ยท 3 years, 7 months ago
  90. 056b72a Added the standard sqlite license header to the the fiddle JS files. Minor internal renamings in those same files. by stephan ยท 3 years, 7 months ago
  91. e26d162 #if'd out the '.nonce' and '.check' commends in WASM builds. by stephan ยท 3 years, 7 months ago
  92. 1c0dcec #if'd out the the '.cd' and '.clone' commands for WASM builds. by stephan ยท 3 years, 7 months ago
  93. 2f72d71 fiddle: consolidated two duplicate CSS rules. Internal doc typo fix. by stephan ยท 3 years, 7 months ago
  94. 091fb16 Added a disclaimer about fiddle's experimental and subject-to-change/removal nature. by stephan ยท 3 years, 7 months ago
  95. 9d023c2 Merge the changes to support the "fiddle" extension. by drh ยท 3 years, 7 months ago
  96. d59ac28 When building fiddle from its own directory (e.g. from emacs instead of the normal build process), force -O0 the sake of compilation speed. The top-level build now defaults to -Oz, which is more appropriate for that case. by stephan ยท 3 years, 7 months ago fiddle
  97. 7db1289 Tweaks to the fiddle make target so that it builds with all of the same by drh ยท 3 years, 7 months ago
  98. 2d0a85c Added a toggle to swap input/output field positions and simplified setup of checkboxes which toggle a CSS class on a given element. by stephan ยท 3 years, 7 months ago
  99. e9e0208 Default to top/bottom layout with input on the bottom. Offer a toggle to swap input/output positions. by stephan ยท 3 years, 7 months ago
  100. 3824059 Numerous layout tweaks, the most significant being that the layout now adapts to the window size. Swapped positions of the input/output areas. This version supports, by uncommenting a few bits, a jquery.terminal-based view but alternatives to that 300kb dependency are still under investigation. by stephan ยท 3 years, 7 months ago