History log of /plugin/sqlite/SQLiteDB.php (Results 1 – 25 of 29)
Revision Date Author Comments
# e062c247 05-Mar-2024 splitbrain <splitbrain@users.noreply.github.com>

�� Automatic code style fixes


# 48c6692f 25-Jan-2024 Anna Dabrowska <dabrowska@cosmocode.de>

Throw an exception if contructor gets called on a disabled plugin


# 9ac2cb9b 25-Jan-2024 Andreas Gohr <andi@splitbrain.org>

Merge pull request #86 from cosmocode/gh-tests

Update GitHub workflows


# a7a40fb2 25-Jan-2024 Anna Dabrowska <dabrowska@cosmocode.de>

Automatic code style fixes


# 549d6b89 25-Jan-2024 Anna Dabrowska <dabrowska@cosmocode.de>

Try optimizing the database before closing the connection


# f71fd150 17-Aug-2023 Andreas Gohr <andi@splitbrain.org>

don't log errors when opts table does not exist

This is to be expected on new setups and not an error. Other errors
would be problematic though.

This should be the last commit related to #80


# 74c4ec25 01-Aug-2023 Andreas Gohr <andi@splitbrain.org>

Set busy timeout and use WAL mode. #80

The busy timout should tell the Sqlite driver to wait to acquire locks
instead of aborting immeadiately.

The Write-Ahead Logging mode should make parallel acc

Set busy timeout and use WAL mode. #80

The busy timout should tell the Sqlite driver to wait to acquire locks
instead of aborting immeadiately.

The Write-Ahead Logging mode should make parallel accesses to the
database more efficient. https://www.sqlite.org/wal.html

show more ...


# e49844fb 22-Jul-2023 Andreas Gohr <andi@splitbrain.org>

add exception logging for #80

This should help to pinpoint the problem


# fe64ba38 22-Jul-2023 Andreas Gohr <andi@splitbrain.org>

never set db version to 0. related to #80

There is no need to initially set the database version to 0, returning 0
is enough to run the appropriate migrations.

This will partially fix #80. The unde

never set db version to 0. related to #80

There is no need to initially set the database version to 0, returning 0
is enough to run the appropriate migrations.

This will partially fix #80. The underlying problem is probably a
temporary database lock that causes an exception in getOpt(). This still
needs to be addressed.

show more ...


# c70cffc9 20-Jul-2023 Andreas Gohr <andi@splitbrain.org>

abort migration handling early

We especially do not need to run VACUUM on every initialization.


# 27eb38da 21-Jun-2023 Andreas Gohr <andi@splitbrain.org>

Allow passing parameters as multiple function args

This is what the old query methods allowed. Passing in an array is still
somewhat cleaner, but allowing separate arguments should make porting
olde

Allow passing parameters as multiple function args

This is what the old query methods allowed. Passing in an array is still
somewhat cleaner, but allowing separate arguments should make porting
older code a bit more convenient.

show more ...


# 0290deae 15-Jun-2023 Andreas Gohr <andi@splitbrain.org>

log slow queries to the debug log


# 33e488b3 13-Jun-2023 Andreas Gohr <andi@splitbrain.org>

Added queryKeyValueList convenience method

This is a common use case in plugins


# 10cb854a 13-Jun-2023 Andreas Gohr <andi@splitbrain.org>

renamed getDB to getPdo

This is clearer in what to expect as a return value


# 03f14a77 12-Jun-2023 Andreas Gohr <andi@splitbrain.org>

ensure we always get PDOExceptions

PDO::prepare sometimes throws ValueErrors (and maybe other Throwables)
so we convert them to PDOExceptions


# 7ddaad11 12-Jun-2023 Andreas Gohr <andi@splitbrain.org>

Fix import/export handling, always split multi-statements

Even though mutliple statements can be passed to $sth->execute(),
failures will only be checked in the very first statement. Failures
later

Fix import/export handling, always split multi-statements

Even though mutliple statements can be passed to $sth->execute(),
failures will only be checked in the very first statement. Failures
later on will lead to the rest of the statements to be silently ignored
rendering 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 and
fix entry exports.

show more ...


# e22957e9 22-Mar-2023 Szymon Olewniczak <szyolewn@pg.edu.pl>

keep only getDb method instead of pdo for compatibility


# 1fe23cd5 21-Mar-2023 Szymon Olewniczak <szyolewn@pg.edu.pl>

minor comment fix


# 801b921e 21-Mar-2023 Szymon Olewniczak <szyolewn@pg.edu.pl>

backwards compatibility fixes


# aeccf717 20-Mar-2023 Szymon Olewniczak <szyolewn@pg.edu.pl>

Merge remote-tracking branch 'upstream/devel' into feature-event-query-execute


# b8ae4891 20-Mar-2023 Szymon Olewniczak <szyolewn@pg.edu.pl>

extend the event data


# c9d29def 19-Mar-2023 Andreas Gohr <andi@splitbrain.org>

added tests for SQLiteDB class


# a7a36cdb 19-Mar-2023 Andreas Gohr <andi@splitbrain.org>

save and query record improvements


# 2832a62c 18-Mar-2023 Andreas Gohr <andi@splitbrain.org>

Merge pull request #74 from gkrid/feature-event-query-execute

PLUGIN_SQLITE_QUERY_EXECUTE


# aae177f9 18-Mar-2023 Andreas Gohr <andi@splitbrain.org>

fix serialization support


12