summary refs log tree commit diff
path: root/synapse/storage/engines/sqlite.py (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Correctly mention previous copyright (#16820)Erik Johnston2024-01-231-0/+1
| | | | | During the migration the automated script to update the copyright headers accidentally got rid of some of the existing copyright lines. Reinstate them.
* Update license headersPatrick Cloke2023-11-211-10/+16
|
* Delete device messages asynchronously and in staged batches (#16240)Mathieu Velten2023-09-061-0/+4
|
* Speed up SQLite unit test CI (#15334)Erik Johnston2023-03-301-1/+16
| | | Tests now take 40% of the time.
* Make sqlite database migrations transactional again, part two (#14926)Sean Quah2023-01-311-2/+4
| | | | | | | | | | | | | | | | #14910 fixed the regression introduced by #13873 where sqlite database migrations would no longer run inside a transaction. However, it committed the transaction before Synapse updated its bookkeeping of which migrations have been run, which means that migrations may be run again after they have completed successfully. Leave the transaction open at the end of `executescript`, to restore the old, correct behaviour. Also make the PostgreSQL behaviour consistent with SQLite. Fixes #14909. Signed-off-by: Sean Quah <seanq@matrix.org>
* Make sqlite database migrations transactional again (#14910)Sean Quah2023-01-251-2/+3
| | | | | | | | | | #13873 introduced a regression which causes sqlite database migrations to no longer run inside a transaction. Wrap them in a transaction again, to avoid database corruption when migrations are interrupted. Fixes #14909. Signed-off-by: Sean Quah <seanq@matrix.org>
* Enable WAL for SQLite (#13897)asymmetric2022-10-251-0/+4
| | | Signed-off-by: Lorenzo Manacorda <lorenzo@mailbox.org>
* Snapshot schema 72 (#13873)David Robertson2022-09-261-1/+20
| | | Including another batch of fixes to the schema dump script
* Require SQLite >= 3.27.0 (#13760)David Robertson2022-09-091-11/+2
|
* 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