aboutsummaryrefslogtreecommitdiffstats
path: root/plugins/mod_storage_sql.lua
Commit message (Collapse)AuthorAgeFilesLines
* mod_storage_sql: Measure hits/misses on the item count cacheKim Alvefur2020-07-021-0/+7
| | | | | A cache miss can be expensive so having numbers on how often this occurs may be valuable.
* mod_storage_sql: Fix incorrect results when fetching items before specific ↵Matthew Wild2020-06-121-1/+1
| | | | | | archive id Copy/paste error, introduced in deb68066c7aa
* mod_storage_sql: Log database connection parameters when creating engineKim Alvefur2020-05-021-2/+3
| | | | | | This is meant to help trace down an issue where Prosody apparently creates multiple conflicting SQL engines, causing problems especially with SQLite3, e.g. #616 #784.
* Merge 0.11->trunkKim Alvefur2020-03-221-0/+1
|\
| * mod_storage_sql: Add index covering sort_id to improve performance (fixes #1505)Kim Alvefur2020-03-221-0/+1
| |
* | storagemanager, mod_storage_sql: Rename methods to :get_all() and :delete_all()Matthew Wild2020-03-111-4/+4
| |
* | mod_storage_sql: Add map_store:find_key() and map_store:delete_key() (+ tests)Matthew Wild2020-03-111-0/+44
| |
* | Merge 0.11->trunkKim Alvefur2020-02-221-6/+6
|\|
| * mod_storage_sql: Move update limit check back one step, fixes tracebackKim Alvefur2020-02-221-6/+6
| | | | | | | | | | 0c00274528a4 moved it one step too far, so the check was performed before connecting to the database instead of after.
* | Merge 0.11->trunkKim Alvefur2020-02-211-7/+7
|\|
| * mod_storage_sql: Fix check for deletion limits (fixes #1494)Kim Alvefur2020-02-211-7/+7
| | | | | | | | | | The check was only performed if sql_manage_tables was set to true (the default) It should always be performed
* | mod_storage_sql: Remove unused and not actually returned return value [luacheck]Kim Alvefur2019-12-241-1/+1
| | | | | | | | The :delete throws an error, it does not return one like this.
* | mod_storage_*: Also include timestmap of first message in :summary APIKim Alvefur2019-08-231-3/+5
| | | | | | | | | | For completeness along with most recent timestamp. Might be nice to be able to order by oldest unread message.
* | mod_storage_*: Include timestamp of latest message in :summary APIKim Alvefur2019-08-231-1/+4
| | | | | | | | | | | | | | Clients may want to show a list of conversations ordered by how timestamp of most recent message. The counts allow a badge with unread message counter.
* | mod_storage_*: Tweak :summary API to allow future expansion with more fieldsKim Alvefur2019-08-231-3/+5
| | | | | | | | Eg might want to include last message, timestamp, chat state or other info.
* | mod_storage_sql: Ignore shadowed error variable [luacheck]Kim Alvefur2019-05-281-1/+1
| |
* | mod_storage_sql: Fix to use correct arguments to archive id lookupKim Alvefur2019-05-281-2/+2
| |
* | mod_storage_sql: Correctly return item-not-found errorKim Alvefur2019-05-281-2/+3
| | | | | | | | `return ok, err` comes out as `transaction_ok, ok, err`
* | mod_storage_sql: Look up archive IDs in separate queries (fixes #1325)Kim Alvefur2019-03-231-29/+29
| | | | | | | | This is probably not good for performance.
* | Merge 0.11->trunkKim Alvefur2019-05-261-14/+22
|\|
| * mod_storage_sql: Handle SQLite DELETE with LIMIT being optional (fixes #1359)Kim Alvefur2019-05-131-6/+15
| |
| * mod_storage_sql: Move code out of if-else chainKim Alvefur2019-05-131-9/+8
| |
* | mod_storage_sql: Add support for iterating over users in archive storesKim Alvefur2019-05-051-0/+13
| |
* | mod_storage_sql: Implement archive summary APIKim Alvefur2019-02-251-0/+35
| |
* | mod_storage_sql: No archive item limit by defaultKim Alvefur2019-03-221-4/+6
| |
* | mod_storage_sql: Return cached count if only this is queried forKim Alvefur2019-03-221-1/+5
| |
* | mod_storage_sql: Cache total count if it's calculated as part of the current ↵Kim Alvefur2019-03-221-0/+3
| | | | | | | | query
* | mod_storage_sql: Skip cache writeKim Alvefur2019-03-221-1/+0
| | | | | | | | | | This would cause the cache to be wrong in case the the later INSERT fails and the transaction is aborted.
* | mod_storage_sql: Fix to use currently queried storeKim Alvefur2019-03-221-2/+2
| | | | | | | | | | Was using the previously queried store due to this being cached in an upvalue.
* | mod_storage_sql: Don't increment counter twice (fixes accounting error)Kim Alvefur2019-03-221-1/+0
| |
* | mod_storage_internal,_sql: Key item count cache on both username and storeKim Alvefur2019-03-221-5/+8
| |
* | mod_storage_internal,_sql: Expose archive capabilities feature setKim Alvefur2019-03-221-0/+2
| | | | | | | | This was planned to be added long ago but was forgotten.
* | mod_storage_internal,_sql: Add limit to number of items in an archive store ↵Matthew Wild2017-10-201-1/+38
| | | | | | | | (fixes #733)
* | various: Don't rely on _G.unpack existingKim Alvefur2018-12-081-1/+1
|/
* mod_storage_sql: Catch errors during schema upgrade (thanks Nothing4You)Matthew Wild2018-11-151-4/+4
|
* mod_storage_sql: Handle Lua 5.3 move of unpack functionKim Alvefur2018-10-211-1/+1
|
* mod_storage_sql: Fix issue number in comment that was fixed by 55b40f3fa659 ↵Matthew Wild2018-10-131-1/+1
| | | | (fixes #1073)
* mod_storage_sql: Keep prosodyarchive_index unique constraint on non-MySQL DBsMatthew Wild2018-10-121-1/+1
|
* mod_storage_sql: Change prosodyarchive_index to be non-unique (fixes #1087)Matthew Wild2018-10-111-8/+25
| | | | | | MySQL requires that the first 20 bytes are unique, even if they differ after the first 20 bytes. This breaks e.g. pubsub/PEP nodes longer than 20 characters that have common prefixes.
* mod_storage_sql: Have :users() throw an error on failure instead of ↵Matthew Wild2018-10-111-1/+1
| | | | returning non-iterator values
* mod_storage_sql: Workaround MySQL not supporting LIMIT subquery in archive ↵Matthew Wild2018-10-111-3/+9
| | | | truncate operations, fixes #1200
* mod_storage_sql: Remove unused function argument [luacheck]Kim Alvefur2018-10-101-1/+1
| | | | What was the intent of this argument anyways?
* mod_storage_sql: Catch and report value deserialization errorsKim Alvefur2018-02-241-8/+19
|
* Merge 0.10->trunkKim Alvefur2017-12-221-1/+1
|\
| * mod_storage_sql: Index over contact and timestamp (happy now Ge0rg?)Kim Alvefur2017-12-121-1/+1
| |
* | mod_storage_sql: Remove ability to override name of key-value table ↵Kim Alvefur2017-12-111-1/+1
| | | | | | | | (unreachable and would not work)
* | Merge 0.10->trunkKim Alvefur2017-11-211-0/+2
|\|
| * mod_storage_sql: Add indices that include the with and when columns of archivesKim Alvefur2017-11-211-0/+2
| |
* | mod_storage_sql: Add support for truncating deletionKim Alvefur2017-11-091-1/+29
| |
* | Merge 0.10->trunkKim Alvefur2017-10-051-2/+2
|\|
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-01 01:09:26 +0000