Log

plugins/mod_storage_sql.lua @ 13270:14bbfb2cc8dd default tip

description author age
mod_storage_sql: Spell out missing dependencies Kim Alvefur Sat, 22 Jul 2023 16:15:48 +0200
mod_storage_sql: Pass variables as arguments instead of upvalues Kim Alvefur Sat, 22 Jul 2023 15:22:54 +0200
plugins: Use boolean config method in some places Kim Alvefur Tue, 18 Jul 2023 12:38:16 +0200
mod_storage_sql: Use integer config option for cache size Kim Alvefur Tue, 18 Jul 2023 11:53:31 +0200
mod_storage_sql: Use config enum for 'sqlite_tune' Kim Alvefur Tue, 18 Jul 2023 11:53:12 +0200
mod_storage_sql: Allow higher precision timestamps in SQLite3 Kim Alvefur Mon, 17 Jul 2023 04:52:50 +0200
plugins: Use integer config API with interval specification where sensible Kim Alvefur Mon, 17 Jul 2023 01:38:54 +0200
mod_storage_sql: Remove completed TODO (testing UPSERT on PostgreSQL) Kim Alvefur Wed, 12 Jul 2023 22:51:37 +0200
mod_storage_sql: Fix column name in index check for PostgreSQL Kim Alvefur Sat, 17 Jun 2023 13:37:33 +0200
mod_storage_sql: Adjust indentation to align with surrounding code Kim Alvefur Sat, 17 Jun 2023 13:36:42 +0200
mod_storage_sql: Only remove old index if it exists Kim Alvefur Sat, 17 Jun 2023 00:22:45 +0200
mod_storage_sql: Be more specific when checking for old index in SQLite3 Kim Alvefur Sat, 17 Jun 2023 00:00:21 +0200
mod_storage_sql: Improve check for old table index on PostgreSQL Kim Alvefur Fri, 16 Jun 2023 23:57:15 +0200
mod_storage_sql: Enable UPSERT with PostgreSQL Kim Alvefur Fri, 16 Jun 2023 13:03:34 +0200
mod_storage_sql: Add some TODO comments for future UPSERT work Kim Alvefur Sun, 11 Jun 2023 20:25:50 +0200
mod_storage_sql: Do not keep track of quota when no quota is set Kim Alvefur Sun, 11 Jun 2023 20:05:32 +0200
mod_storage_sql: Add setting to tune SQLite3 performance vs safety Kim Alvefur Sun, 11 Jun 2023 17:04:11 +0200
mod_storage_sql: Record all SQLite3 compile options for potential use Kim Alvefur Sat, 10 Jun 2023 14:01:56 +0200
mod_storage_sql: Compose a keyval+ store out of keyval and map store methods Kim Alvefur Sat, 10 Jun 2023 16:39:48 +0200
mod_storage_sql: Add UPSERT support Kim Alvefur Sat, 10 Jun 2023 15:44:09 +0200
plugins: Prefix module imports with prosody namespace Kim Alvefur Fri, 24 Mar 2023 13:15:28 +0100
mod_storage_sql: Remove module status on unknown 'debug' level Kim Alvefur Tue, 31 Jan 2023 07:52:33 +0100
mod_storage_sql: Silence luacheck warning Kim Alvefur Mon, 30 Jan 2023 00:40:47 +0100
mod_storage_sql: Record connection to database as module status Kim Alvefur Mon, 30 Jan 2023 00:38:26 +0100
mod_storage_sql: Support SQLite3 without LuaDBI Kim Alvefur Thu, 19 Jan 2023 16:56:12 +0100
Merge 0.12->trunk Kim Alvefur Fri, 06 Jan 2023 23:53:50 +0100
mod_storage_sql: Fix #1639 0.12 Kim Alvefur Sun, 01 Jan 2023 16:20:58 +0100
Merge 0.12->trunk Kim Alvefur Thu, 29 Dec 2022 18:28:50 +0100
mod_storage_sql: Don't avoid initialization under prosodyctl (fix #1787) 0.12 Kim Alvefur Thu, 29 Dec 2022 18:06:35 +0100
mod_storage_sql: Strip timestamp precision in queries to fix error (thanks muppeth) Kim Alvefur Wed, 07 Sep 2022 12:27:12 +0200
mod_storage_sql: Drop archive timestamp precision pending schema update Kim Alvefur Sun, 14 Aug 2022 17:29:39 +0200
Merge 0.12->trunk Kim Alvefur Fri, 29 Jul 2022 17:10:31 +0200
mod_storage_sql: Fix summary API with Postgres (fixes #1766) 0.12 Kim Alvefur Fri, 22 Jul 2022 19:09:50 +0200
Merge 0.12->trunk Kim Alvefur Wed, 27 Jul 2022 00:10:08 +0200
mod_storage_sql: Fix bypass of load procedure under prosodyctl 0.12 Kim Alvefur Tue, 26 Jul 2022 00:39:16 +0200
compat: Remove handling of Lua 5.1 location of 'unpack' function Kim Alvefur Mon, 11 Jul 2022 19:07:38 +0200
mod_storage_sql: Remove Lua 5.1 compatibility hack Kim Alvefur Sat, 02 Jul 2022 17:30:06 +0200
mod_storage_sql: Return cached total where it makes sense Kim Alvefur Tue, 30 Nov 2021 16:26:01 +0100
mod_storage_sql: Adjust handling of 'total' for multi-id queries Kim Alvefur Tue, 30 Nov 2021 15:58:23 +0100
mod_storage_sql: Fix traceback on multi-user deletion Kim Alvefur Tue, 30 Nov 2021 15:24:17 +0100
mod_storage_sql: Expose multi-user deletion capability Kim Alvefur Tue, 30 Nov 2021 01:21:02 +0100
mod_storage_sql: Fix for move of yes/no function (Thanks Kasim) Kim Alvefur Mon, 21 Jun 2021 17:31:17 +0200
mod_storage_sql: Implement map-like API for archives Kim Alvefur Mon, 01 Feb 2021 12:47:05 +0100
mod_storage_sql: Fix compatibilty with Lua 5.1 Kim Alvefur Wed, 13 Jan 2021 15:33:44 +0100
mod_storage_sql: Support query for set of IDs Kim Alvefur Tue, 12 Jan 2021 18:46:17 +0100
mod_storage_sql: Advertise support for id range query Kim Alvefur Sat, 09 Jan 2021 21:08:33 +0100
mod_storage_sql: Measure hits/misses on the item count cache Kim Alvefur Thu, 02 Jul 2020 19:03:59 +0200
mod_storage_sql: Fix incorrect results when fetching items before specific archive id Matthew Wild Fri, 12 Jun 2020 16:54:38 +0100
mod_storage_sql: Log database connection parameters when creating engine Kim Alvefur Sat, 02 May 2020 14:13:02 +0200
Merge 0.11->trunk Kim Alvefur Sun, 22 Mar 2020 21:13:09 +0100
mod_storage_sql: Add index covering sort_id to improve performance (fixes #1505) 0.11 Kim Alvefur Sun, 22 Mar 2020 21:05:59 +0100
storagemanager, mod_storage_sql: Rename methods to :get_all() and :delete_all() Matthew Wild Wed, 11 Mar 2020 16:32:41 +0000
mod_storage_sql: Add map_store:find_key() and map_store:delete_key() (+ tests) Matthew Wild Wed, 11 Mar 2020 15:57:53 +0000
Merge 0.11->trunk Kim Alvefur Sat, 22 Feb 2020 16:26:20 +0100
mod_storage_sql: Move update limit check back one step, fixes traceback 0.11 Kim Alvefur Sat, 22 Feb 2020 16:23:43 +0100
Merge 0.11->trunk Kim Alvefur Fri, 21 Feb 2020 23:01:43 +0100
mod_storage_sql: Fix check for deletion limits (fixes #1494) 0.11 Kim Alvefur Fri, 21 Feb 2020 23:00:44 +0100
mod_storage_sql: Remove unused and not actually returned return value [luacheck] Kim Alvefur Tue, 24 Dec 2019 00:49:43 +0100
mod_storage_*: Also include timestmap of first message in :summary API Kim Alvefur Fri, 23 Aug 2019 01:15:44 +0200
mod_storage_*: Include timestamp of latest message in :summary API Kim Alvefur Fri, 23 Aug 2019 01:10:27 +0200
mod_storage_*: Tweak :summary API to allow future expansion with more fields Kim Alvefur Fri, 23 Aug 2019 01:04:00 +0200
mod_storage_sql: Ignore shadowed error variable [luacheck] Kim Alvefur Tue, 28 May 2019 00:56:30 +0200
mod_storage_sql: Fix to use correct arguments to archive id lookup Kim Alvefur Tue, 28 May 2019 00:47:50 +0200
mod_storage_sql: Correctly return item-not-found error Kim Alvefur Tue, 28 May 2019 00:46:24 +0200
mod_storage_sql: Look up archive IDs in separate queries (fixes #1325) Kim Alvefur Sat, 23 Mar 2019 00:51:10 +0100
Merge 0.11->trunk Kim Alvefur Sun, 26 May 2019 19:41:58 +0200
mod_storage_sql: Handle SQLite DELETE with LIMIT being optional (fixes #1359) 0.11 Kim Alvefur Mon, 13 May 2019 14:39:38 +0200
mod_storage_sql: Move code out of if-else chain 0.11 Kim Alvefur Mon, 13 May 2019 14:47:41 +0200
mod_storage_sql: Add support for iterating over users in archive stores Kim Alvefur Sun, 05 May 2019 16:26:01 +0200
mod_storage_sql: Implement archive summary API Kim Alvefur Mon, 25 Feb 2019 15:51:55 +0100
mod_storage_sql: No archive item limit by default Kim Alvefur Fri, 22 Mar 2019 16:30:53 +0100
mod_storage_sql: Return cached count if only this is queried for Kim Alvefur Fri, 22 Mar 2019 02:18:54 +0100
mod_storage_sql: Cache total count if it's calculated as part of the current query Kim Alvefur Fri, 22 Mar 2019 02:13:27 +0100
mod_storage_sql: Skip cache write Kim Alvefur Fri, 22 Mar 2019 02:12:02 +0100
mod_storage_sql: Fix to use currently queried store Kim Alvefur Fri, 22 Mar 2019 02:10:46 +0100
mod_storage_sql: Don't increment counter twice (fixes accounting error) Kim Alvefur Fri, 22 Mar 2019 02:09:38 +0100
mod_storage_internal,_sql: Key item count cache on both username and store Kim Alvefur Fri, 22 Mar 2019 18:02:27 +0100
mod_storage_internal,_sql: Expose archive capabilities feature set Kim Alvefur Fri, 22 Mar 2019 18:01:24 +0100
mod_storage_internal,_sql: Add limit to number of items in an archive store (fixes #733) Matthew Wild Fri, 20 Oct 2017 12:53:53 +0200
various: Don't rely on _G.unpack existing Kim Alvefur Sat, 08 Dec 2018 17:09:55 +0100
mod_storage_sql: Catch errors during schema upgrade (thanks Nothing4You) 0.11 Matthew Wild Thu, 15 Nov 2018 21:55:16 +0000
mod_storage_sql: Handle Lua 5.3 move of unpack function Kim Alvefur Sun, 21 Oct 2018 21:12:38 +0200
mod_storage_sql: Fix issue number in comment that was fixed by 55b40f3fa659 (fixes #1073) Matthew Wild Sat, 13 Oct 2018 08:17:58 +0100
mod_storage_sql: Keep prosodyarchive_index unique constraint on non-MySQL DBs Matthew Wild Fri, 12 Oct 2018 21:59:15 +0100
mod_storage_sql: Change prosodyarchive_index to be non-unique (fixes #1087) Matthew Wild Thu, 11 Oct 2018 19:23:21 +0100
mod_storage_sql: Have :users() throw an error on failure instead of returning non-iterator values Matthew Wild Thu, 11 Oct 2018 19:15:46 +0100
mod_storage_sql: Workaround MySQL not supporting LIMIT subquery in archive truncate operations, fixes #1200 Matthew Wild Thu, 11 Oct 2018 18:20:09 +0100
mod_storage_sql: Remove unused function argument [luacheck] Kim Alvefur Wed, 10 Oct 2018 21:23:35 +0200
mod_storage_sql: Catch and report value deserialization errors Kim Alvefur Sat, 24 Feb 2018 11:50:08 +0100
Merge 0.10->trunk Kim Alvefur Fri, 22 Dec 2017 01:02:05 +0100
mod_storage_sql: Index over contact and timestamp (happy now Ge0rg?) Kim Alvefur Tue, 12 Dec 2017 01:40:09 +0100
mod_storage_sql: Remove ability to override name of key-value table (unreachable and would not work) Kim Alvefur Mon, 11 Dec 2017 22:45:03 +0100
Merge 0.10->trunk Kim Alvefur Tue, 21 Nov 2017 23:16:16 +0100
mod_storage_sql: Add indices that include the with and when columns of archives Kim Alvefur Tue, 21 Nov 2017 14:46:21 +0100
mod_storage_sql: Add support for truncating deletion Kim Alvefur Thu, 09 Nov 2017 16:50:36 +0100
Merge 0.10->trunk Kim Alvefur Thu, 05 Oct 2017 18:06:04 +0200
mod_storage_sql: Also clear the prosodyarchive table when an user is deleted (fixes #1009) Kim Alvefur Thu, 05 Oct 2017 17:44:47 +0200
mod_storage_sql: Remove return values from purge method Kim Alvefur Thu, 05 Oct 2017 17:22:42 +0200
Merge 0.10->trunk Kim Alvefur Wed, 17 May 2017 01:06:20 +0200
mod_storage_sql: Fix logic error introduced by variable rename in aa9f198cb3c9 (thanks waqas) Matthew Wild Sun, 30 Apr 2017 10:44:53 +0100
Merge 0.10->trunk Kim Alvefur Thu, 13 Apr 2017 01:30:24 +0200
mod_storage_sql: Limit encoding check to current database Kim Alvefur Thu, 13 Apr 2017 01:29:35 +0200
mod_storage_sql: Break long lines Kim Alvefur Wed, 12 Apr 2017 23:16:23 +0200
mod_storage_sql: Pass charset and collation names via variable binding Kim Alvefur Wed, 12 Apr 2017 21:53:21 +0200
mod_storage_sql: Quote some field names Kim Alvefur Wed, 12 Apr 2017 21:51:17 +0200
Merge 0.10->trunk Kim Alvefur Wed, 12 Apr 2017 20:59:18 +0200
mod_storage_sql: Raise error if encoding check query fails Kim Alvefur Wed, 12 Apr 2017 17:26:13 +0200
Merge 0.10->trunk Kim Alvefur Mon, 10 Apr 2017 23:16:13 +0200
SQL: Use standard quotes for columns and other identifiers, rewrite to grave accents for MySQL only (fixes #885) Kim Alvefur Mon, 10 Apr 2017 23:13:39 +0200
Merge 0.10->trunk Kim Alvefur Mon, 03 Apr 2017 00:59:44 +0200
mod_storage_sql: Fix to use correct SQL query (thanks carlos) Kim Alvefur Mon, 03 Apr 2017 00:34:37 +0200
Merge 0.10->trunk Kim Alvefur Sat, 01 Apr 2017 21:48:54 +0200