summary refs log tree commit diff
path: root/synapse/storage/engines/sqlite.py (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Tidy up and type-hint the database engine modules (#12734)David Robertson2022-05-171-36/+36
| | | Co-authored-by: Sean Quah <8349537+squahtx@users.noreply.github.com>
* Db txn set isolation level (#11799)Nick Barrett2022-01-251-0/+7
| | | Co-authored-by: Brendan Abolivier <babolivier@matrix.org>
* Fix the inbound PDU metric (#10279)Erik Johnston2021-06-301-0/+5
| | | This broke in #10272
* Remove redundant "coding: utf-8" lines (#9786)Jonathan de Jong2021-04-141-1/+0
| | | | | | | Part of #9744 Removes all redundant `# -*- coding: utf-8 -*-` lines from files, as python 3 automatically reads source code as utf-8 now. `Signed-off-by: Jonathan de Jong <jonathan@automatia.nl>`
* Drop support for sqlite<3.22 as wellRichard van der Hoff2021-04-081-10/+5
|
* Update black, and run auto formatting over the codebase (#9381)Eric Eastwood2021-02-161-3/+5
| | | | | | | - Update black version to the latest - Run black auto formatting over the codebase - Run autoformatting according to [`docs/code_style.md `](https://github.com/matrix-org/synapse/blob/80d6dc9783aa80886a133756028984dbf8920168/docs/code_style.md) - Update `code_style.md` docs around installing black to use the correct version
* Add experimental support for PyPy. (#9123)Jonathan de Jong2021-02-041-0/+6
| | | | * Adds proper dependencies. * Minor fixes in database layer.
* Reduce serialization errors in MultiWriterIdGen (#8456)Erik Johnston2020-10-071-0/+10
| | | | | | We call `_update_stream_positions_table_txn` a lot, which is an UPSERT that can conflict in `REPEATABLE READ` isolation level. Instead of doing a transaction consisting of a single query we may as well run it outside of a transaction.
* Use SequenceGenerator for state group ID allocationRichard van der Hoff2020-07-161-13/+0
|
* Persist user interactive authentication sessions (#7302)Patrick Cloke2020-04-301-0/+1
| | | | | By persisting the user interactive authentication sessions to the database, this fixes situations where a user hits different works throughout their auth session and also allows sessions to persist through restarts of Synapse.
* Only import sqlite3 when type checking (#7155)David Vo2020-03-271-2/+5
| | | | Fixes: #7127 Signed-off-by: David Vo <david@vovo.id.au>
* Add some type annotations in `synapse.storage` (#6987)Richard van der Hoff2020-02-271-5/+8
| | | | | I cracked, and added some type definitions in synapse.storage.
* Warn if postgres database has non-C locale. (#6734)Erik Johnston2020-01-281-0/+5
| | | As using non-C locale can cause issues on upgrading OS.
* Refuse to start if sqlite is older than 3.11.0Richard van der Hoff2020-01-091-2/+5
|
* Modify check_database to take a connection rather than a cursorRichard van der Hoff2020-01-091-1/+1
| | | | We might not need the cursor at all.
* Add database config class (#6513)Erik Johnston2019-12-181-3/+13
| | | | | This encapsulates config for a given database and is the way to get new connections.
* Fix SQLiteErik Johnston2019-10-101-1/+1
|
* Remove add_in_list_sql_clauseErik Johnston2019-10-101-0/+6
|
* Fix `devices_last_seen` background update.Erik Johnston2019-09-301-0/+8
| | | | Fixes #6134.
* Run Black. (#5482)Amber Brown2019-06-201-1/+1
|
* Run black on the rest of the storage module (#4996)Amber Brown2019-04-031-2/+3
|
* Add database version to phonehome stats. (#4753)Richard van der Hoff2019-02-271-0/+9
|
* Fix UPSERTs on SQLite 3.24+ (#4477)Amber Brown2019-01-281-7/+3
|
* Merge branch 'develop' of github.com:matrix-org/synapse into ↵Erik Johnston2019-01-251-2/+1
|\ | | | | | | erikj/sqlite_native_upsert
| * Don't require sqlite3 when using postgres (#4466)Andrew Morgan2019-01-251-2/+1
| |
* | Disable native upserts for sqlite, as they don't workErik Johnston2019-01-251-3/+7
|/
* Use native UPSERTs where possible (#4306)Amber Brown2019-01-241-0/+96