summary refs log tree commit diff
path: root/synapse/storage (follow)
Commit message (Expand)AuthorAgeFilesLines
* Get current state by using current_state_events tableErik Johnston2017-03-102-11/+21
* Noop repated delete device inbox calls from /syncErik Johnston2017-03-101-1/+35
* Remove spurious SQL logging (#1972)Richard van der Hoff2017-03-081-8/+0
* Select distinct devices from DBErik Johnston2017-03-061-1/+1
* Fix upErik Johnston2017-03-032-8/+8
* Add index to device_lists_streamErik Johnston2017-03-013-4/+28
* Clobber old device list stream entriesErik Johnston2017-03-011-0/+10
* Merge pull request #1959 from matrix-org/erikj/intern_onceErik Johnston2017-02-281-3/+2
|\
| * Intern table column names onceErik Johnston2017-02-281-3/+2
* | Add stream_id index to device_lists_outbound_pokesErik Johnston2017-02-282-1/+17
|/
* Fix up txn nameErik Johnston2017-02-281-1/+1
* Remove needless checkErik Johnston2017-02-271-2/+0
* It should be allErik Johnston2017-02-271-1/+1
* Don't fetch current state in common caseErik Johnston2017-02-271-0/+17
* Merge pull request #1954 from matrix-org/erikj/cache_device2Erik Johnston2017-02-271-45/+73
|\
| * Cache get_user_devices_from_cacheErik Johnston2017-02-271-45/+73
* | Strip newlines from SQL queriesErik Johnston2017-02-231-0/+6
* | Remove lock from rotate notifsErik Johnston2017-02-221-3/+0
|/
* Store looping callErik Johnston2017-02-211-1/+3
* Fix up notif rotationErik Johnston2017-02-181-14/+22
* Use TEXT rather than VARCHARDavid Baker2017-02-171-6/+6
* Make the pushers lang field column longerDavid Baker2017-02-171-0/+39
* CommentErik Johnston2017-02-161-1/+4
* CommentErik Johnston2017-02-161-7/+14
* Store the default push actions in a more efficient mannerErik Johnston2017-02-161-11/+40
* Merge pull request #1916 from matrix-org/erikj/push_actions_deleteErik Johnston2017-02-163-57/+248
|\
| * Less aggressive timersErik Johnston2017-02-141-2/+2
| * Aggregate event push actionsErik Johnston2017-02-143-57/+248
* | Merge pull request #1921 from matrix-org/rav/fix_key_changesRichard van der Hoff2017-02-152-2/+29
|\ \ | |/ |/|
| * Fix bugs in the /keys/changes apiRichard van der Hoff2017-02-142-2/+29
* | Merge pull request #1873 from matrix-org/erikj/delete_push_actionsErik Johnston2017-02-141-3/+8
|\ \ | |/ |/|
| * Be more agressive about purging old room event_push_actionsErik Johnston2017-02-011-3/+8
* | Cache get_presence storageErik Johnston2017-02-131-3/+11
* | Make None check explicitErik Johnston2017-02-081-1/+1
* | Merge pull request #1892 from matrix-org/erikj/rejection_fwd_extremErik Johnston2017-02-081-9/+6
|\ \
| * | Ignore new rejected events when working out forward extremeties.Erik Johnston2017-02-081-9/+6
* | | Merge pull request #1784 from morteza-araby/user-adminErik Johnston2017-02-062-0/+235
|\ \ \ | |/ / |/| |
| * | admin,storage: added more administrator functionalitiesMorteza Araby2017-02-022-0/+235
| |/
* | Bump cache sizes for common membership queriesErik Johnston2017-02-021-3/+3
* | CommentErik Johnston2017-02-021-1/+2
* | Make presence.get_new_events a bit fasterErik Johnston2017-02-021-0/+16
|/
* Doc argsErik Johnston2017-02-011-0/+4
* CommentErik Johnston2017-02-011-0/+3
* Include newly joined users in /keys/changes APIErik Johnston2017-02-011-0/+7
* Merge pull request #1870 from matrix-org/erikj/cache_get_all_new_eventsErik Johnston2017-02-011-0/+2
|\
| * Add a small cache get_all_new_eventsErik Johnston2017-02-011-0/+2
* | Merge pull request #1868 from matrix-org/erikj/replication_cacheErik Johnston2017-02-012-22/+0
|\ \
| * | Only invalidate membership caches based on the cache streamErik Johnston2017-01-312-22/+0
* | | Add m.room.member type to queryErik Johnston2017-02-011-1/+1
* | | Merge pull request #1867 from matrix-org/erikj/member_indexErik Johnston2017-02-013-1/+26
|\ \ \ | |_|/ |/| |
| * | Add an index to make membership queries fasterErik Johnston2017-01-313-1/+26
| |/
* / Up get_latest_event_ids_in_room cacheErik Johnston2017-02-011-1/+1
|/
* Merge pull request #1864 from matrix-org/erikj/device_list_fixesErik Johnston2017-01-311-8/+26
|\
| * Fix deletion of old sent devices correctlyErik Johnston2017-01-311-5/+17
| * Only fetch with row ts and count > 1Erik Johnston2017-01-311-1/+2
| * Fix clearing out old device list outbound pokesErik Johnston2017-01-311-2/+7
* | Merge pull request #1862 from matrix-org/erikj/presence_updateErik Johnston2017-01-311-2/+6
|\ \ | |/ |/|
| * Stream cache invalidations for room membership storage functionsErik Johnston2017-01-301-2/+6
* | Don't have such a large cacheErik Johnston2017-01-301-1/+1
* | Fix unit testsErik Johnston2017-01-301-2/+10
* | Noop device key changes if they're the sameErik Johnston2017-01-302-11/+40
* | Fix queryErik Johnston2017-01-301-1/+1
|/
* Use get_users_in_room and declare it iterableErik Johnston2017-01-301-1/+1
* Rename funcErik Johnston2017-01-301-1/+1
* Clear out old destination pokes.Erik Johnston2017-01-301-0/+42
* Always use the latest stream_id, sent or unsentErik Johnston2017-01-301-4/+4
* Add ts column to device_lists_outbound_pokesErik Johnston2017-01-272-1/+5
* Hook device list updates to replicationErik Johnston2017-01-271-0/+15
* CommentErik Johnston2017-01-271-0/+2
* CommentErik Johnston2017-01-271-0/+2
* SQL param orderingErik Johnston2017-01-271-1/+1
* User if rather than forErik Johnston2017-01-271-1/+4
* Better nameErik Johnston2017-01-271-1/+1
* Remove unused paramErik Johnston2017-01-271-2/+1
* Fix on sqlite: use left rather than outer joinErik Johnston2017-01-261-3/+3
* Handle users leaving roomsErik Johnston2017-01-261-0/+8
* Add commentsErik Johnston2017-01-262-3/+42
* Implement device key caching over federationErik Johnston2017-01-263-26/+199
* Fix up sending of m.device_list_update edusErik Johnston2017-01-251-20/+20
* Add basic implementation of local device list changesErik Johnston2017-01-255-21/+244
* TypoErik Johnston2017-01-231-1/+1
* Refactor to calculate state delta outside transactionErik Johnston2017-01-231-87/+118
* CommentsErik Johnston2017-01-201-8/+19
* Insert delta of current_state_events to be more efficientErik Johnston2017-01-202-78/+52
* SpellingErik Johnston2017-01-201-1/+1
* Update all call sites after renameErik Johnston2017-01-201-1/+1
* CommentsErik Johnston2017-01-201-0/+11
* Calculate the forward extremeties onceErik Johnston2017-01-202-126/+92
* Derive current_state_events from state groupsErik Johnston2017-01-201-70/+118
* Lower loading events log to DEBUGErik Johnston2017-01-171-2/+2
* Increase state_group_cache_sizeErik Johnston2017-01-171-1/+1
* Up cache max entries for stateErik Johnston2017-01-162-2/+2
* Increase cache size limitErik Johnston2017-01-162-2/+2
* Optionally measure size of cache by sum of length of valuesErik Johnston2017-01-132-2/+3
* Merge pull request #1793 from matrix-org/erikj/change_device_inbox_indexErik Johnston2017-01-133-3/+55
|\
| * Add commentErik Johnston2017-01-131-0/+1
| * Explicitly close the cursorErik Johnston2017-01-101-0/+1
| * Don't disable autocommitErik Johnston2017-01-101-8/+4
| * Change device_inbox stream index to include userErik Johnston2017-01-103-3/+57
* | Limit number of entries to prefill from cacheErik Johnston2017-01-102-3/+6
|/
* Merge branch 'release-v0.18.6' into developMatthew Hodgson2017-01-052-3/+3
|\
| * fix annoying typosMatthew Hodgson2017-01-052-3/+3
* | Merge branch 'release-v0.18.6' into developMatthew Hodgson2017-01-051-0/+2
|\|
| * More logging for the linearizer and for get_eventsMark Haines2017-01-051-0/+2
* | Add /account/3pid/delete endpointDavid Baker2016-12-201-0/+11
|/
* Add some logging for syncing to_device eventsRichard van der Hoff2016-12-151-1/+2
* Fixup membership queryErik Johnston2016-12-141-2/+2
* Merge pull request #1697 from matrix-org/erikj/fix_bg_memberErik Johnston2016-12-121-1/+1
|\
| * Fix background update that prematurely stoppedErik Johnston2016-12-121-1/+1
* | Merge pull request #1676 from matrix-org/erikj/room_listErik Johnston2016-12-122-20/+196
|\ \ | |/ |/|
| * Add cache to get_public_room_ids_at_stream_idErik Johnston2016-12-121-0/+2
| * Notify replication. Use correct network_idErik Johnston2016-12-121-1/+3
| * DocstringErik Johnston2016-12-121-0/+12
| * CommentsErik Johnston2016-12-071-0/+2
| * Add new API appservice specific public room listErik Johnston2016-12-062-20/+178
* | Merge pull request #1680 from matrix-org/erikj/joined_roomsErik Johnston2016-12-094-3/+123
|\ \
| * | Add /room/<room_id>/joined_members APIErik Johnston2016-12-081-3/+13
| * | Add profile data to the room_membership table for joinsErik Johnston2016-12-084-0/+110
| |/
* / Fix result of insert_receiptRichard van der Hoff2016-12-081-1/+1
|/
* Rip out more refresh_token codeRichard van der Hoff2016-11-302-67/+0
* Don't send old events as federationErik Johnston2016-11-241-1/+1
* CommentErik Johnston2016-11-231-1/+3
* More efficient notif count queriesErik Johnston2016-11-232-8/+48
* Merge pull request #1635 from matrix-org/erikj/split_out_fed_txnErik Johnston2016-11-238-29/+156
|\
| * Merge branch 'develop' of github.com:matrix-org/synapse into erikj/split_out_...Erik Johnston2016-11-231-0/+8
| |\
| * | Fix tests and flake8Erik Johnston2016-11-221-1/+0
| * | Invalidate retry cache in both directionsErik Johnston2016-11-221-12/+36
| * | Fix testsErik Johnston2016-11-211-2/+2
| * | Store federation stream positions in the databaseErik Johnston2016-11-213-4/+52
| * | Handle sending events and device messages over federationErik Johnston2016-11-174-13/+62
| * | Hook up the send queue and create a federation sender workerErik Johnston2016-11-161-0/+7
* | | Ignore AS users when fetching push rulesErik Johnston2016-11-232-2/+18
| |/ |/|
* | Fail with a coherent error message if `/sync?filter=` is invalidKegan Dougal2016-11-211-0/+8
|/
* Merge pull request #1617 from matrix-org/erikj/intern_state_dictErik Johnston2016-11-151-1/+4
|\
| * Correctly intern keys in state cacheErik Johnston2016-11-081-1/+4
* | New Flake8 fixesErik Johnston2016-11-151-0/+1
|/
* CommentErik Johnston2016-11-041-0/+1
* Remove unused but buggy functionErik Johnston2016-11-041-11/+1
* Remove spurious commentErik Johnston2016-11-031-2/+2
* Replace postgres GIN with GISTErik Johnston2016-11-033-1/+45
* Continue to clean up received_transactionsErik Johnston2016-11-011-0/+14
* Removed unused stuffErik Johnston2016-10-311-163/+3
* Increase batching of sent transaction insertsErik Johnston2016-10-311-1/+1
* Use most recently added binding, not most recently seen user.Erik Johnston2016-10-271-19/+11
* Fix user_threepids schema deltaErik Johnston2016-10-271-1/+38
* Fix incredubly slow back pagination queryErik Johnston2016-10-241-6/+13
* Merge pull request #1164 from pik/error-codesErik Johnston2016-10-191-1/+0
|\
| * Refactor test_filter to use real DataStorepik2016-10-181-1/+0
* | Latest delta is now 37David Baker2016-10-191-0/+0
* | Merge remote-tracking branch 'origin/develop' into dbkr/password_reset_case_i...David Baker2016-10-193-2/+82
|\ \
| * | Bump schema versionErik Johnston2016-10-172-1/+1
| * | Remove TODOErik Johnston2016-10-171-2/+0
| * | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/remove_authErik Johnston2016-10-1712-72/+429
| |\ \
| * | | Drop some unused indicesErik Johnston2016-10-173-17/+83
| * | | Remove redundant event_auth indexErik Johnston2016-09-131-0/+16
* | | | Convert emails to lowercase when storingDavid Baker2016-10-191-1/+8
* | | | Revert part of 6207399David Baker2016-10-141-20/+10
* | | | Merge remote-tracking branch 'origin/develop' into dbkr/password_reset_case_i...David Baker2016-10-141-0/+3
|\ \ \ \ | | |/ / | |/| |
| * | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/replicatio...Erik Johnston2016-10-113-44/+64
| |\ \ \
| * | | | Reduce DB hits for replicationErik Johnston2016-09-231-0/+3
* | | | | Make password reset email field case insensitiveDavid Baker2016-10-142-10/+36
| |/ / / |/| | |
* | | | storage/appservice: make appservice methods only relying on the cache synchro...Patrik Oldsberg2016-10-061-6/+6
| |_|/ |/| |
* | | Merge pull request #1145 from matrix-org/erikj/fix_reindexErik Johnston2016-09-291-15/+29
|\ \ \
| * | | Fix background reindex of origin_server_tsErik Johnston2016-09-271-15/+29
| |/ /
* | | Remove duplicationErik Johnston2016-09-271-31/+19
* | | Remove unused variableErik Johnston2016-09-271-3/+0
* | | Fix perf of fetching state in SQLiteErik Johnston2016-09-261-20/+41
|/ /
* | Match against event_id, rather than room_idErik Johnston2016-09-211-1/+1
* | Remove spurious AS clauseErik Johnston2016-09-211-1/+1
* | Update correct tableErik Johnston2016-09-211-6/+10
* | Readd entries to public_room_list_stream that were deletedErik Johnston2016-09-212-1/+23
* | Fix _delete_old_forward_extrem_cache queryErik Johnston2016-09-211-5/+4
* | CommentErik Johnston2016-09-161-0/+2
* | Filter remote rooms lists locallyErik Johnston2016-09-161-1/+1
* | Handling expiring stream extrems correctly.Erik Johnston2016-09-152-3/+22
* | Change get_pos_of_last_change to return upper boundErik Johnston2016-09-151-3/+2
* | Use stream_change cache to make get_forward_extremeties_for_room cache more e...Erik Johnston2016-09-151-1/+10
* | Add cache to get_forward_extremeties_for_roomErik Johnston2016-09-151-0/+1
* | Merge pull request #1121 from matrix-org/erikj/public_room_paginateErik Johnston2016-09-156-15/+288
|\ \
| * | Stream public room changes down replicationErik Johnston2016-09-151-0/+16
| * | Base public room list off of public_rooms streamErik Johnston2016-09-151-0/+52
| * | Calculate the public room list from a stream_orderingErik Johnston2016-09-141-0/+3
| * | Add a room visibility streamErik Johnston2016-09-144-16/+100
| * | Add a DB index to figure out past state at a stream ordering in a roomErik Johnston2016-09-142-0/+118
| |/
* | Fix reindexErik Johnston2016-09-141-15/+16
* | Ensure we don't mutate state cache entriesErik Johnston2016-09-141-20/+25
|/
* Remove where clauseErik Johnston2016-09-121-1/+0
* Index contains_url for file search queriesErik Johnston2016-09-122-0/+25
* Add WHERE clause support to index creationErik Johnston2016-09-122-10/+17
* Merge pull request #1106 from matrix-org/erikj/state_reindex_concurrentErik Johnston2016-09-121-1/+1
|\
| * Create new index concurrentlyErik Johnston2016-09-121-1/+1
* | Merge pull request #1105 from matrix-org/erikj/make_notif_highlight_query_fastErik Johnston2016-09-122-1/+29
|\ \ | |/ |/|
| * Change the index to be stream_ordering, highlightErik Johnston2016-09-121-1/+1
| * Remove unused importErik Johnston2016-09-121-1/+0
| * Use register_background_index_updateErik Johnston2016-09-121-24/+4
| * Add back in query changeErik Johnston2016-09-121-1/+3
| * Merge branch 'develop' of github.com:matrix-org/synapse into erikj/make_notif...Erik Johnston2016-09-128-22/+60
| |\
| * | Make reindex happen in bgErik Johnston2016-09-122-3/+32
* | | Merge pull request #1104 from matrix-org/markjh/direct_to_device_federation_syncMark Haines2016-09-121-0/+2
|\ \ \ | |_|/ |/| |
| * | Fix direct to device messages recieved over federation to notify syncMark Haines2016-09-121-0/+2
* | | Add comments to existing schema deltas that used "CREATE INDEX" directlyMark Haines2016-09-126-0/+24
|/ /
* | Revert "Add index to event_push_actions"Erik Johnston2016-09-122-21/+1
* | Change state fetch query for postgres to be fasterErik Johnston2016-09-121-19/+35
|/
* Merge remote-tracking branch 'origin/develop' into dbkr/make_notif_highlight_...David Baker2016-09-099-40/+360
|\
| * Use the previous MAX value if any to set the stream_idMark Haines2016-09-091-1/+2
| * Track the max_stream_device_id in a separate table, since we delete from the ...Mark Haines2016-09-093-3/+36
| * Merge pull request #1087 from matrix-org/markjh/reapply_deltaMark Haines2016-09-091-1/+4
| |\
| | * Just move the schema and add some DROPsMark Haines2016-09-092-35/+4
| | * Only catch databas errorsMark Haines2016-09-081-1/+1
| | * Add a stub run_upgradeMark Haines2016-09-081-0/+4
| | * Reapply 34/device_outbox in 35/device_outbox_again.py since the schema was bu...Mark Haines2016-09-081-0/+30
| * | Merge branch 'release-v0.17.3' of github.com:matrix-org/synapse into developErik Johnston2016-09-091-1/+1
| |\ \
| | * | Reduce batch size to be under SQL limitErik Johnston2016-09-091-1/+1
| * | | Merge pull request #1081 from matrix-org/dbkr/notifications_only_highlightMatthew Hodgson2016-09-091-1/+8
| |\ \ \
| * \ \ \ Merge pull request #1080 from matrix-org/dbkr/fix_notifications_api_with_fromDavid Baker2016-09-081-1/+1
| |\ \ \ \
| | * | | | Fix /notifications API when used with `from` paramDavid Baker2016-09-081-1/+1
| * | | | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/reindex_st...Erik Johnston2016-09-081-18/+36
| |\ \ \ \ \ | | | |_|_|/ | | |/| | |
| | * | | | Support wildcard device_ids for direct to device messagesMark Haines2016-09-081-18/+36
| * | | | | Add delta fileErik Johnston2016-09-081-0/+20
| * | | | | Reindex state_groups_state after pruningErik Johnston2016-09-082-2/+37
| |/ / / /
| * | | | Merge branch 'develop' into markjh/direct_to_device_federationMark Haines2016-09-086-75/+444
| |\ \ \ \
| * | | | | Fix the stream change cache to work over replicationMark Haines2016-09-071-1/+1
| * | | | | Add stream change caches for device messagesMark Haines2016-09-072-0/+49
| * | | | | Comment the add_messages storage functionsMark Haines2016-09-071-8/+16
| * | | | | Send device messages over federationMark Haines2016-09-062-14/+9
| * | | | | Add storage methods for federated device messagesMark Haines2016-09-061-7/+132
| * | | | | Add tables for federated device messagesMark Haines2016-09-061-0/+38
| * | | | | Move _add_messages_to_device_inbox_txn into a separate methodMark Haines2016-09-061-37/+32
| | |_|_|/ | |/| | |
* | | | | Add index to event_push_actionsDavid Baker2016-09-092-1/+21
| |_|_|/ |/| | |
* | | | Implement `only=highlight` on `/notifications`David Baker2016-09-081-1/+8
| |/ / |/| |
* | | Log delta files we're applyingErik Johnston2016-09-081-2/+2
* | | Temporarily disable sequential scans for state fetchingErik Johnston2016-09-081-0/+4
| |/ |/|
* | Merge pull request #1077 from matrix-org/markjh/device_loggingMark Haines2016-09-071-2/+6
|\ \
| * | Log the types and values when failing to store devicesMark Haines2016-09-071-2/+6
| |/
* | CommentErik Johnston2016-09-071-0/+4
* | Add appopriate framing clauseErik Johnston2016-09-071-0/+1
* | Use windowing function to make use of indexErik Johnston2016-09-071-5/+5
* | Scale the batch size so that we're not bitten by the minimumErik Johnston2016-09-051-1/+5
* | Correctly handle reindexing state groups that already have an edgeErik Johnston2016-09-051-0/+19
* | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/state_storageErik Johnston2016-09-051-13/+9
|\|
| * Remove unused importsErik Johnston2016-09-051-1/+0
| * Only fetch local pushersErik Johnston2016-09-051-1/+3
| * Make bulk_get_push_rules_for_room use get_joined_users_from_context cacheErik Johnston2016-09-051-12/+7
* | Take value in a better wayErik Johnston2016-09-052-3/+3
* | Comment about sqlite and WITH RECURSIVEErik Johnston2016-09-051-0/+4
* | Correctly delete old state groups in purge history APIErik Johnston2016-09-052-20/+80
* | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/state_storageErik Johnston2016-09-051-3/+5
|\|
| * Merge pull request #1066 from matrix-org/markjh/direct_to_device_lowerboundMark Haines2016-09-021-3/+5
| |\
| | * Only return new device messages in /syncMark Haines2016-09-021-3/+5
* | | Add commentsErik Johnston2016-09-051-41/+38