summary refs log tree commit diff
path: root/synapse/storage/database.py (follow)
Commit message (Expand)AuthorAgeFilesLines
* Move towards using `MultiWriterIdGenerator` everywhere (#17226)Erik Johnston2024-05-291-3/+18
* Bump mypy from 1.5.1 to 1.8.0 (#16901)dependabot[bot]2024-03-131-3/+3
* Bump black from 23.10.1 to 24.2.0 (#16936)dependabot[bot]2024-03-131-16/+8
* Correctly mention previous copyright (#16820)Erik Johnston2024-01-231-0/+2
* Update license headersPatrick Cloke2023-11-211-12/+16
* Convert simple_select_one_txn and simple_select_one to return tuples. (#16612)Patrick Cloke2023-11-091-5/+5
* Bulk-invalidate e2e cached queries after claiming keys (#16613)David Robertson2023-11-091-1/+1
* Avoid updating the same rows multiple times with simple_update_many_txn. (#16...Patrick Cloke2023-11-071-4/+1
* Avoid executing no-op queries. (#16583)Patrick Cloke2023-11-071-9/+23
* More tests for the simple_* methods. (#16596)Patrick Cloke2023-11-071-9/+4
* Remove remaining usage of cursor_to_dict. (#16564)Patrick Cloke2023-10-311-15/+0
* Claim fallback keys in bulk (#16570)David Robertson2023-10-301-0/+10
* Remove more usages of cursor_to_dict. (#16551)Patrick Cloke2023-10-261-27/+3
* Convert simple_select_list and simple_select_list_txn to return lists of tupl...Patrick Cloke2023-10-261-15/+16
* Convert simple_select_many_batch, simple_select_many_txn to tuples. (#16444)Patrick Cloke2023-10-111-6/+12
* Inline simple_search_list/simple_search_list_txn. (#16434)Patrick Cloke2023-10-101-62/+0
* Convert simple_select_list_paginate_txn to return tuples. (#16433)Patrick Cloke2023-10-061-3/+3
* Bump types-psycopg2 from 2.9.21.11 to 2.9.21.14 (#16381)dependabot[bot]2023-09-251-13/+1
* Convert `_insert_graph_receipts_txn` to `simple_upsert` (#16299)Jason Little2023-09-151-0/+3
* Log values at DEBUG level with execute_values (#16281)David Robertson2023-09-081-2/+3
* Bump mypy-zope & mypy. (#16188)Patrick Cloke2023-08-291-1/+16
* Revert "Stop writing to column `user_id` of tables `profiles` and `user_filte...Shay2023-07-181-2/+0
* Stop writing to column `user_id` of tables `profiles` and `user_filters` (#15...Shay2023-07-071-0/+2
* Add foreign key constraint to `event_forward_extremities`. (#15751)Erik Johnston2023-07-051-0/+37
* Don't always lock "user_ips" table when performing non-native upsert (#15788)Andrew Morgan2023-06-161-1/+1
* Quick & dirty metric for background update status (#15740)David Robertson2023-06-071-1/+7
* Rename blacklist/whitelist internally. (#15620)Patrick Cloke2023-05-191-3/+2
* Speed up rebuilding of the user directory for local users (#15529)Erik Johnston2023-05-031-2/+11
* More precise type for LoggingTransaction.execute (#15432)David Robertson2023-04-141-3/+17
* Bump ruff from 0.0.252 to 0.0.259 (#15328)dependabot[bot]2023-03-281-2/+2
* Add missing type hints to `synapse.storage.database`. (#15230)Patrick Cloke2023-03-091-5/+16
* Split up txn for fetching device keys (#15215)Erik Johnston2023-03-071-1/+9
* Add final type hint to synapse.server. (#15035)Patrick Cloke2023-02-091-0/+1
* Batch look-ups to see if rooms are partial stated. (#14917)Patrick Cloke2023-01-261-1/+1
* Add experimental support for MSC3391: deleting account data (#14714)Andrew Morgan2023-01-011-1/+32
* Enable `--warn-redundant-casts` option in mypy (#14671)David Robertson2022-12-121-1/+2
* Remove option to skip locking of tables during emulated upserts (#14469)Sean Quah2022-11-281-38/+18
* Track unconverted device list outbound pokes using a position instead (#14516)Sean Quah2022-11-221-6/+7
* Fix check to ignore blank lines in incoming TCP replication (#14449)Andrew Morgan2022-11-171-3/+3
* When restarting a partial join resync, prioritise the server which actioned a...David Robertson2022-10-181-1/+1
* Track notification counts per thread (implement MSC3773). (#13776)Patrick Cloke2022-10-041-1/+1
* Refactor `_get_e2e_device_keys_txn` to split large queries (#13956)Sean Quah2022-10-031-0/+60
* Update mypy and mypy-zope, attempt 3 (#13993)David Robertson2022-09-301-16/+6
* Revert "Update mypy and mypy-zope (#13925)"David Robertson2022-09-301-6/+16
* Update mypy and mypy-zope (#13925)David Robertson2022-09-301-16/+6
* Update UPSERT comment now that native upserts are the default (#13924)David Robertson2022-09-291-10/+50
* Snapshot schema 72 (#13873)David Robertson2022-09-261-0/+8
* Accept & store thread IDs for receipts (implement MSC3771). (#13782)Patrick Cloke2022-09-231-0/+2
* Support providing an index predicate for upserts. (#13822)Patrick Cloke2022-09-151-7/+23
* Require SQLite >= 3.27.0 (#13760)David Robertson2022-09-091-26/+21
* Revert "Update locked versions of mypy and mypy-zope (#13521)"David Robertson2022-08-151-6/+16
* Update locked versions of mypy and mypy-zope (#13521)David Robertson2022-08-151-16/+6
* Track DB txn times w/ two counters, not histogram (#13342)David Robertson2022-07-211-3/+5
* Safe async event cache (#13308)Nick Mills-Barrett2022-07-191-6/+48
* Async get event cache prep (#13242)Nick Mills-Barrett2022-07-151-4/+6
* Don't actually one-line the SQL statements we send to the DB (#13129)Brendan Abolivier2022-06-301-3/+4
* Speed up `get_unread_event_push_actions_by_room` (#13005)Erik Johnston2022-06-151-0/+1
* Fix media thumbnails being unusable before the index had been added in the ba...reivilibre2022-05-231-0/+2
* Reduce the number of "untyped defs" (#12716)David Robertson2022-05-121-13/+31
* Use `ParamSpec` in a few places (#12667)David Robertson2022-05-091-11/+20
* Use `Concatenate` to annotate `do_execute` (#12666)David Robertson2022-05-091-5/+14
* Update `delay_cancellation` to accept any awaitable (#12468)Sean Quah2022-04-221-2/+1
* Optimise `_update_client_ips_batch_txn` to batch together database operations...reivilibre2022-04-081-3/+98
* Prefill more stream change caches. (#12372)Erik Johnston2022-04-051-16/+27
* Update `LoggingTransaction.call_after` and `call_on_exception` docstrings (#1...Sean Quah2022-03-291-3/+20
* Bump `black` and `click` versions (#12320)David Robertson2022-03-291-1/+1
* Improve type annotations for `execute_values`. (#12311)reivilibre2022-03-281-10/+7
* Use psycopg2 type stubs (#12269)David Robertson2022-03-231-3/+11
* Handle cancellation in `DatabasePool.runInteraction()` (#12199)Sean Quah2022-03-161-24/+37
* Pass `isolation_level` to `runWithConnection` (#11847)Brendan Abolivier2022-01-271-0/+1
* Db txn set isolation level (#11799)Nick Barrett2022-01-251-0/+10
* Replace uses of simple_insert_many with simple_insert_many_values. (#11742)Patrick Cloke2022-01-131-52/+2
* Use auto_attribs/native type hints for attrs classes. (#11692)Patrick Cloke2022-01-131-4/+4
* Require Collections as the parameters for simple_* methods. (#11580)Patrick Cloke2021-12-151-18/+10
* checks for generators in database functions (#11564)Richard van der Hoff2021-12-131-4/+46
* Type hint the constructors of the data store classes (#11555)Sean Quah2021-12-131-1/+1
* skip some dict munging in event persistence (#11560)Richard van der Hoff2021-12-101-5/+54
* Add type annotations to `synapse.metrics` (#10847)Sean Quah2021-11-171-3/+3
* Add some background update admin APIs (#11263)Erik Johnston2021-11-081-0/+4
* Add metrics to the threadpools (#11178)Erik Johnston2021-11-011-1/+6
* Add type hints for most `HomeServer` parameters (#11095)Sean Quah2021-10-221-1/+5
* Fix remove_stale_pushers job on SQLite. (#10843)reivilibre2021-09-201-9/+12
* Use `execute_values` more in PostgreSQL (#10754)Erik Johnston2021-09-031-19/+42
* Add support for MSC2716 marker events (#10498)Eric Eastwood2021-08-041-7/+7
* Allow setting transaction limit for db connections (#10440)Toni Spets2021-08-021-0/+21
* Replace `or_ignore` in `simple_insert` with `simple_upsert` (#10442)Erik Johnston2021-07-221-31/+20
* [pyupgrade] `synapse/` (#10348)Jonathan de Jong2021-07-191-1/+1
* Use inline type hints in `http/federation/`, `storage/` and `util/` (#10381)Jonathan de Jong2021-07-151-7/+7
* Add script for getting info about recently registered users (#10290)Erik Johnston2021-07-061-1/+1
* Fix logging context when opening new DB connection (#10141)Erik Johnston2021-06-081-3/+9
* More database opentracing (#10136)Richard van der Hoff2021-06-071-2/+5
* Add OpenTracing for database activity. (#10113)Richard van der Hoff2021-06-031-33/+53
* Use the parent's logging context name for runWithConnection. (#9895)Patrick Cloke2021-04-281-1/+3
* Remove various bits of compatibility code for Python <3.6 (#9879)Andrew Morgan2021-04-271-9/+6
* Remove `synapse.types.Collection` (#9856)Richard van der Hoff2021-04-221-1/+1
* Remove redundant "coding: utf-8" lines (#9786)Jonathan de Jong2021-04-141-1/+0
* Bump black configuration to target py36 (#9781)Dan Callahan2021-04-131-4/+4
* Bugbear: Add Mutable Parameter fixes (#9682)Jonathan de Jong2021-04-081-6/+14
* remove unused param on `make_tuple_comparison_clause`Richard van der Hoff2021-04-081-4/+1
* Drop support for sqlite<3.22 as wellRichard van der Hoff2021-04-081-55/+7
* Add a storage method for returning all current presence from all users (#9650)Andrew Morgan2021-03-251-2/+9
* Enable addtional flake8-bugbear linting checks. (#9659)Jonathan de Jong2021-03-241-1/+1
* Refactor to ensure we call check_consistency (#9470)Erik Johnston2021-02-241-12/+4
* Update black, and run auto formatting over the codebase (#9381)Eric Eastwood2021-02-161-8/+19
* Update type hints for Cursor to match PEP 249. (#9299)Jonathan de Jong2021-02-051-5/+9
* Use execute_batch in more places (#9188)Erik Johnston2021-01-211-0/+6
* Use execute_batch instead of executemany in places (#9181)Erik Johnston2021-01-211-3/+2
* Fix chain cover background update to work with split out event persisters (#9...Erik Johnston2021-01-141-0/+11
* Use a chain cover index to efficiently calculate auth chain difference (#8868)Erik Johnston2021-01-111-4/+18
* Add type hints to the logging context code. (#8939)Patrick Cloke2021-01-051-3/+5
* Enable reconnection in DB pool (#8726)Erik Johnston2020-11-121-1/+6
* Tell Black to format code for Python 3.5 (#8664)Dan Callahan2020-10-271-2/+2
* Pre-emptively fix synapse.storage.types.Connection for future mypy release (#...Jonathan de Jong2020-10-171-1/+1
* Use autocommit mode for single statement DB functions. (#8542)Erik Johnston2020-10-141-8/+91
* Reduce serialization errors in MultiWriterIdGen (#8456)Erik Johnston2020-10-071-6/+63
* Add logging on startup/shutdown (#8448)Erik Johnston2020-10-021-15/+74
* Catch-up after Federation Outage (split, 1) (#8230)reivilibre2020-09-041-2/+2
* Fix type signature in simple_select_one_onecol and friends (#8241)reivilibre2020-09-041-10/+7
* Stop sub-classing object (#8249)Patrick Cloke2020-09-041-2/+2
* Add an overload for simple_select_one_onecol_txn. (#8235)Patrick Cloke2020-09-021-0/+24
* Convert runInteraction to async/await (#8156)Patrick Cloke2020-09-021-15/+14
* Add StreamStore to mypy (#8232)Erik Johnston2020-09-021-0/+34
* Convert simple_delete to async/await. (#8191)Patrick Cloke2020-08-271-8/+55
* simple_search_list_txn should return None, not 0. (#8187)Patrick Cloke2020-08-271-4/+3
* Convert additional database methods to async (select list, search, insert_man...Patrick Cloke2020-08-271-62/+37
* Convert simple_update* and simple_select* to async (#8173)Patrick Cloke2020-08-271-14/+15
* Convert simple_select_one and simple_select_one_onecol to async (#8162)Patrick Cloke2020-08-261-6/+30
* Add more types to synapse.storage.database. (#8127)Patrick Cloke2020-08-201-219/+358
* Convert runWithConnection to async. (#8121)Patrick Cloke2020-08-191-14/+13
* Convert some of the general database methods to async (#8100)Patrick Cloke2020-08-171-14/+9
* Rename database classes to make some sense (#8033)Erik Johnston2020-08-051-1/+1
* Move some log lines from default logger to sql/transaction loggers (#7952)Andrew Morgan2020-07-281-8/+10
* Replace all remaining six usage with native Python 3 equivalents (#7704)Dagfinn Ilmari Mannsåker2020-06-161-2/+1
* Replace iteritems/itervalues/iterkeys with native versions. (#7692)Patrick Cloke2020-06-151-7/+6
* Replace device_27_unique_idx bg update with a fg one (#7562)Richard van der Hoff2020-05-261-1/+0
* Remove `exception_to_unicode`Richard van der Hoff2020-05-151-12/+3
* Fix new flake8 errors (#7470)Erik Johnston2020-05-121-2/+2
* use an upsert to update device_lists_outbound_last_successRichard van der Hoff2020-05-061-0/+1
* Better type annotations for simple_upsert_txnRichard van der Hoff2020-05-061-30/+43
* bg update to clear out duplicate outbound_device_list_pokes (#7193)Richard van der Hoff2020-04-071-1/+82
* Clean up some LoggingContext stuff (#7120)Richard van der Hoff2020-03-241-6/+5
* Hopefully mypy is happy nowBrendan Abolivier2020-03-101-2/+8
* Add some type annotations in `synapse.storage` (#6987)Richard van der Hoff2020-02-271-59/+84
* Clarify list/set/dict/tuple comprehensions and enforce via flake8 (#6957)Patrick Cloke2020-02-211-2/+2
* Minor perf fixes to `get_auth_chain_ids`.Erik Johnston2020-02-191-1/+1
* Reduce performance logging to DEBUG (#6833)Michael Kaye2020-02-051-1/+1
* Add database config class (#6513)Erik Johnston2019-12-181-3/+42
* Pass Database into the data storeErik Johnston2019-12-061-22/+16
* Merge branch 'develop' of github.com:matrix-org/synapse into erikj/make_datab...Erik Johnston2019-12-061-23/+28
* Remove unused varErik Johnston2019-12-061-2/+0
* Move background update handling out of storeErik Johnston2019-12-051-0/+3
* CommentsErik Johnston2019-12-051-0/+5
* Move DB pool and helper functions into dedicated Database classErik Johnston2019-12-051-0/+1485