Log

plugins/mod_storage_sql.lua @ 12019:a0b6896bb538

description author age
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
mod_storage_sql: Remove unused return values (should those actually be used?) Kim Alvefur Sat, 01 Apr 2017 19:47:02 +0200
mod_storage_sql: Ignore name clash [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:45:47 +0200
mod_storage_sql: Split long lines [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:45:37 +0200
mod_storage_sql: Ignore name clash [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:45:20 +0200
mod_storage_sql: Pass SQL engine as an argument to upgrade and table creator functions Kim Alvefur Sat, 01 Apr 2017 19:39:20 +0200
mod_storage_sql: Move SQL queries into multiline strings for readability [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:26:27 +0200
mod_storage_sql: Rename variables to avoid name clashes [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:25:34 +0200
mod_storage_sql: Sensible defaults for 'when' and 'with' arguments Kim Alvefur Sat, 01 Apr 2017 19:04:54 +0200
mod_storage_sql: Remove compat for argument order change Kim Alvefur Sat, 01 Apr 2017 19:02:27 +0200
Merge 0.10->trunk Kim Alvefur Mon, 20 Feb 2017 01:46:54 +0100
mod_storage_sql: Make archive:append() to return the id (or key) as first return value Kim Alvefur Mon, 20 Feb 2017 01:26:03 +0100
Merge 0.10->trunk Kim Alvefur Tue, 24 Jan 2017 19:27:17 +0100
mod_storage_sql: Fix to use correct order for return values from transaction (thanks postblue) Kim Alvefur Tue, 24 Jan 2017 19:26:40 +0100
Merge 0.10->trunk Kim Alvefur Mon, 23 Jan 2017 19:34:14 +0100
mod_storage_sql: Return number of affected items from archive:delete Kim Alvefur Tue, 22 Nov 2016 18:13:21 +0100
Merge 0.10->trunk Kim Alvefur Fri, 02 Dec 2016 11:13:05 +0100
mod_storage_sql: Normalize parameters for upgrade command Kim Alvefur Thu, 01 Dec 2016 10:02:57 +0100
mod_storage_sql: List available commands if no commands given (currenly only one available) Kim Alvefur Thu, 01 Dec 2016 10:02:26 +0100
mod_storage_sql: Don't say 'Unknown command' if no command was given (fixes attempt to concatenate nil) Kim Alvefur Thu, 01 Dec 2016 10:02:01 +0100
mod_storage_sql: Include missing parameter table key 'port' Kim Alvefur Thu, 01 Dec 2016 03:22:42 +0100
mod_storage_sql: Create a new table to hold normalized database parameters (fixes #636) Kim Alvefur Tue, 29 Nov 2016 08:20:42 +0100
mod_storage_sql: Use is_stanza() from util.stanza Kim Alvefur Mon, 28 Nov 2016 07:30:39 +0100
Update every link to the documentation to use HTTPS Emmanuel Gil Peyrot Sat, 16 Apr 2016 21:08:05 +0100
mod_storage_sql: Make sure all serialization errors are propagated Kim Alvefur Mon, 21 Mar 2016 09:33:12 +0100
mod_storage_sql: Allow loops over results to end on their own Kim Alvefur Sun, 13 Mar 2016 17:43:33 +0100
mod_storage_sql: Add LIMIT clause to queries where only a single row is expected Kim Alvefur Sun, 13 Mar 2016 17:42:22 +0100
mod_storage_sql: Treat non-existent archive IDs as beyound the end of the archive (fixes #624) (tested on sqlite3 only) Kim Alvefur Mon, 22 Feb 2016 15:23:27 +0100
mod_storage_sql: Remove debug logging of archive queries Kim Alvefur Sun, 21 Feb 2016 19:29:00 +0100
mod_storage_sql: Lower message about new engine creation to debug level Kim Alvefur Sun, 21 Feb 2016 19:01:26 +0100
mod_storage_sql: Share SQL connections with same parameters across VirtualHosts (fixes #576) Kim Alvefur Sun, 21 Feb 2016 14:53:19 +0100
mod_storage_sql: Fix setting value to false in map store Kim Alvefur Fri, 19 Feb 2016 19:22:18 +0100
mod_storage_sql: Silence some harmless luacheck warnings Kim Alvefur Tue, 09 Feb 2016 17:24:04 +0100
mod_storage_sql: Implement map:set_keys, allowing multiple keys to be set in the same transaction Kim Alvefur Tue, 09 Feb 2016 16:56:27 +0100
mod_storage_sql: Support non-string keys in map store Kim Alvefur Mon, 08 Feb 2016 20:23:12 +0100
mod_storage_sql: Fix use of SQLite3 in-memory database (no path expansion) Kim Alvefur Tue, 15 Dec 2015 13:15:30 +0100
mod_storage_sql: Add map store (backported from trunk) Matthew Wild Thu, 03 Dec 2015 15:03:24 +0000
mod_storage_sql: Whitespace fix (backported from trunk) Matthew Wild Thu, 03 Dec 2015 15:02:50 +0000
storagemanager, mod_storage_sql, mod_storage_sql2: Rename mod_storage_sql2 -> mod_storage_sql, mod_storage_sql -> mod_storage_sql1 (temporarily), and emit warning for configs using sql2 Matthew Wild Thu, 03 Dec 2015 14:57:49 +0000
mod_storage_{none,internal,sql}: Return error for unsupported (everything but keyval) store types Kim Alvefur Fri, 20 Jun 2014 16:22:23 +0200
core.certmanager, core.moduleapi, mod_storage_sql, mod_storage_sql2: Import from util.paths Kim Alvefur Fri, 09 May 2014 19:35:29 +0200
Remove all trailing whitespace Florian Zeitz Fri, 09 Aug 2013 17:48:21 +0200
mod_storage_sql: Return actual error string on commit failure. Waqas Hussain Fri, 30 Nov 2012 08:50:03 +0500
mod_storage_sql: Add support for iterating over users with data in a store Kim Alvefur Fri, 21 Sep 2012 17:24:06 +0200
Merge 0.9->trunk Matthew Wild Wed, 19 Sep 2012 12:14:08 +0100
mod_storage_sql: Remove obsolete comment Matthew Wild Wed, 19 Sep 2012 12:09:27 +0100