en Copyright 2025 Java http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#e062c24746ec4c9c598cea7cb12f0486c953293e �� Automatic code style fixes List of files: /plugin/sqlite/SQLiteDB.php Tue, 05 Mar 2024 07:40:43 +0000 splitbrain <splitbrain@users.noreply.github.com> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#48c6692f46b1b980c8f8f6230a4e58d0973ee205 Throw an exception if contructor gets called on a disabled plugin List of files: /plugin/sqlite/SQLiteDB.php Thu, 25 Jan 2024 14:40:55 +0000 Anna Dabrowska <dabrowska@cosmocode.de> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#9ac2cb9b115760cc073da49cbd0528e9b762f6a3 Merge pull request #86 from cosmocode/gh-testsUpdate GitHub workflows List of files: /plugin/sqlite/SQLiteDB.php Thu, 25 Jan 2024 14:34:21 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#a7a40fb292e55f99ed1ae34981feed1314e2696b Automatic code style fixes List of files: /plugin/sqlite/SQLiteDB.php Thu, 25 Jan 2024 12:06:49 +0000 Anna Dabrowska <dabrowska@cosmocode.de> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#549d6b89b978a64afd5c9843bf382a945e384b56 Try optimizing the database before closing the connection List of files: /plugin/sqlite/SQLiteDB.php Thu, 25 Jan 2024 09:58:59 +0000 Anna Dabrowska <dabrowska@cosmocode.de> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#f71fd1504a934bce9abc4f30fd9269859aa51cf0 don't log errors when opts table does not existThis is to be expected on new setups and not an error. Other errorswould be problematic though.This should be the last commit related to #80 List of files: /plugin/sqlite/SQLiteDB.php Thu, 17 Aug 2023 07:42:23 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#74c4ec254943736f39f1acd6435b4a9dfb4f5b40 Set busy timeout and use WAL mode. #80The busy timout should tell the Sqlite driver to wait to acquire locksinstead of aborting immeadiately.The Write-Ahead Logging mode should make parallel accesses to thedatabase more efficient. https://www.sqlite.org/wal.html List of files: /plugin/sqlite/SQLiteDB.php Tue, 01 Aug 2023 07:10:27 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#e49844fb9312b6135b8528c7da0d1b780d9f6573 add exception logging for #80This should help to pinpoint the problem List of files: /plugin/sqlite/SQLiteDB.php Sat, 22 Jul 2023 17:25:00 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#fe64ba38fa37088a76bcd0dbf03809dc650557a7 never set db version to 0. related to #80There is no need to initially set the database version to 0, returning 0is enough to run the appropriate migrations.This will partially fix #80. The underlying problem is probably atemporary database lock that causes an exception in getOpt(). This stillneeds to be addressed. List of files: /plugin/sqlite/SQLiteDB.php Sat, 22 Jul 2023 17:16:15 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#c70cffc97c5abb2b3e3e14118aec25ca00a85865 abort migration handling earlyWe especially do not need to run VACUUM on every initialization. List of files: /plugin/sqlite/SQLiteDB.php Thu, 20 Jul 2023 19:28:59 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#27eb38dad6ac16ba55cb051804719e1c950a9e0a Allow passing parameters as multiple function argsThis is what the old query methods allowed. Passing in an array is stillsomewhat cleaner, but allowing separate arguments should make portingolder code a bit more convenient. List of files: /plugin/sqlite/SQLiteDB.php Wed, 21 Jun 2023 06:40:34 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#0290deae916e3095ecc953614b9aeb5c71dde053 log slow queries to the debug log List of files: /plugin/sqlite/SQLiteDB.php Thu, 15 Jun 2023 13:08:03 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#33e488b3fffebc85f02333885d5d0ead1dd65c8b Added queryKeyValueList convenience methodThis is a common use case in plugins List of files: /plugin/sqlite/SQLiteDB.php Tue, 13 Jun 2023 07:39:31 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#10cb854a8655178cc593cb88ee5d9592dba3d277 renamed getDB to getPdoThis is clearer in what to expect as a return value List of files: /plugin/sqlite/SQLiteDB.php Tue, 13 Jun 2023 05:42:44 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#03f14a77fbab4e0107baf03f5e5281eb8a1d51a8 ensure we always get PDOExceptionsPDO::prepare sometimes throws ValueErrors (and maybe other Throwables)so we convert them to PDOExceptions List of files: /plugin/sqlite/SQLiteDB.php Mon, 12 Jun 2023 09:04:15 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#7ddaad1152dc0f87d85ab16db7c7c5e825f3ce1f Fix import/export handling, always split multi-statementsEven though mutliple statements can be passed to $sth->execute(),failures will only be checked in the very first statement. Failureslater on will lead to the rest of the statements to be silently ignoredrendering our rollback strategy moot.We now always split multiline statements and run them separately(affects import and migrations).The export was adjusted to not include the transaction handling andfix entry exports. List of files: /plugin/sqlite/SQLiteDB.php Mon, 12 Jun 2023 07:58:57 +0000 Andreas Gohr <andi@splitbrain.org> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#e22957e91a8b380c2e6bc9a88afe859eef12d3fc keep only getDb method instead of pdo for compatibility List of files: /plugin/sqlite/SQLiteDB.php Wed, 22 Mar 2023 11:09:41 +0000 Szymon Olewniczak <szyolewn@pg.edu.pl> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#1fe23cd5659bf16733a5ae15e04c1d2759dc0d54 minor comment fix List of files: /plugin/sqlite/SQLiteDB.php Tue, 21 Mar 2023 14:48:37 +0000 Szymon Olewniczak <szyolewn@pg.edu.pl> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#801b921e6f88fe064002875409bc4d648ab42718 backwards compatibility fixes List of files: /plugin/sqlite/SQLiteDB.php Tue, 21 Mar 2023 14:47:02 +0000 Szymon Olewniczak <szyolewn@pg.edu.pl> http://127.0.0.1:8080/history/plugin/sqlite/SQLiteDB.php#aeccf717e96982614e71e0858e8ebf4e370518fa Merge remote-tracking branch 'upstream/devel' into feature-event-query-execute List of files: /plugin/sqlite/SQLiteDB.php Mon, 20 Mar 2023 08:14:33 +0000 Szymon Olewniczak <szyolewn@pg.edu.pl>