Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | Add index to device_lists_stream | Erik Johnston | 2017-03-01 | 1 | -0/+17 |
| | |||||
* | Add stream_id index to device_lists_outbound_pokes | Erik Johnston | 2017-02-28 | 1 | -0/+16 |
| | | | | As this is used for replication streaming | ||||
* | Use TEXT rather than VARCHAR | David Baker | 2017-02-17 | 1 | -6/+6 |
| | | | | While we're changing anyway | ||||
* | Make the pushers lang field column longer | David Baker | 2017-02-17 | 1 | -0/+39 |
| | | | | | | To accommodate things like zh-Hans-CN Fixes https://github.com/vector-im/riot-ios/issues/1031 | ||||
* | Aggregate event push actions | Erik Johnston | 2017-02-14 | 1 | -0/+37 |
| | |||||
* | Add an index to make membership queries faster | Erik Johnston | 2017-01-31 | 1 | -0/+17 |
| | |||||
* | Add ts column to device_lists_outbound_pokes | Erik Johnston | 2017-01-27 | 1 | -1/+2 |
| | |||||
* | Add comments | Erik Johnston | 2017-01-26 | 1 | -1/+7 |
| | |||||
* | Implement device key caching over federation | Erik Johnston | 2017-01-26 | 1 | -12/+8 |
| | |||||
* | Add basic implementation of local device list changes | Erik Johnston | 2017-01-25 | 1 | -0/+56 |
| | |||||
* | Add comment | Erik Johnston | 2017-01-13 | 1 | -0/+1 |
| | |||||
* | Change device_inbox stream index to include user | Erik Johnston | 2017-01-10 | 1 | -0/+20 |
| | | | | | This makes fetching the nost recently changed users much tricker, and brings it in line with e.g. presence_stream indices. | ||||
* | Merge pull request #1676 from matrix-org/erikj/room_list | Erik Johnston | 2016-12-12 | 1 | -0/+29 |
|\ | | | | | Add new API appservice specific public room list | ||||
| * | Comments | Erik Johnston | 2016-12-07 | 1 | -0/+2 |
| | | |||||
| * | Add new API appservice specific public room list | Erik Johnston | 2016-12-06 | 1 | -0/+27 |
| | | |||||
* | | Add profile data to the room_membership table for joins | Erik Johnston | 2016-12-08 | 1 | -0/+20 |
|/ | |||||
* | Don't send old events as federation | Erik Johnston | 2016-11-24 | 1 | -1/+1 |
| | |||||
* | More efficient notif count queries | Erik Johnston | 2016-11-23 | 1 | -0/+17 |
| | |||||
* | Store federation stream positions in the database | Erik Johnston | 2016-11-21 | 1 | -0/+22 |
| | |||||
* | Handle sending events and device messages over federation | Erik Johnston | 2016-11-17 | 1 | -0/+16 |
| | |||||
* | Replace postgres GIN with GIST | Erik Johnston | 2016-11-03 | 1 | -0/+17 |
| | | | | | This is because GIN can be slow to write too, especially when the table gets large. | ||||
* | Use most recently added binding, not most recently seen user. | Erik Johnston | 2016-10-27 | 1 | -19/+11 |
| | |||||
* | Fix user_threepids schema delta | Erik Johnston | 2016-10-27 | 1 | -1/+38 |
| | | | | | | | | | | | The delta `37/user_threepids.sql` aimed to update all the email addresses to be lower case, however duplicate emails may exist in the table already. This commit adds a step where the delta moves the duplicate emails to a new `medium` `email_old`. Only the most recently used account keeps the binding intact. We move rather than delete so that we retain some record of which emails were associated with which account. | ||||
* | Latest delta is now 37 | David Baker | 2016-10-19 | 1 | -0/+0 |
| | |||||
* | Merge remote-tracking branch 'origin/develop' into ↵ | David Baker | 2016-10-19 | 1 | -0/+81 |
|\ | | | | | | | dbkr/password_reset_case_insensitive | ||||
| * | Bump schema version | Erik Johnston | 2016-10-17 | 1 | -0/+0 |
| | | |||||
| * | Remove TODO | Erik Johnston | 2016-10-17 | 1 | -2/+0 |
| | | |||||
| * | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/remove_auth | Erik Johnston | 2016-10-17 | 4 | -1/+97 |
| |\ | |||||
| * | | Drop some unused indices | Erik Johnston | 2016-10-17 | 2 | -16/+83 |
| | | | |||||
| * | | Remove redundant event_auth index | Erik Johnston | 2016-09-13 | 1 | -0/+16 |
| | | | |||||
* | | | Convert emails to lowercase when storing | David Baker | 2016-10-19 | 1 | -1/+8 |
| | | | | | | | | | | | | And db migration sql to convert existing addresses. | ||||
* | | | Make password reset email field case insensitive | David Baker | 2016-10-14 | 1 | -0/+16 |
| |/ |/| | |||||
* | | Match against event_id, rather than room_id | Erik Johnston | 2016-09-21 | 1 | -1/+1 |
| | | |||||
* | | Update correct table | Erik Johnston | 2016-09-21 | 1 | -6/+10 |
| | | |||||
* | | Readd entries to public_room_list_stream that were deleted | Erik Johnston | 2016-09-21 | 1 | -0/+22 |
| | | |||||
* | | Add a room visibility stream | Erik Johnston | 2016-09-14 | 1 | -0/+33 |
| | | |||||
* | | Add a DB index to figure out past state at a stream ordering in a room | Erik Johnston | 2016-09-14 | 1 | -0/+37 |
|/ | |||||
* | Index contains_url for file search queries | Erik Johnston | 2016-09-12 | 1 | -0/+17 |
| | |||||
* | Merge branch 'develop' of github.com:matrix-org/synapse into ↵ | Erik Johnston | 2016-09-12 | 6 | -0/+24 |
|\ | | | | | | | erikj/make_notif_highlight_query_fast | ||||
| * | Add comments to existing schema deltas that used "CREATE INDEX" directly | Mark Haines | 2016-09-12 | 6 | -0/+24 |
| | | |||||
| * | Revert "Add index to event_push_actions" | Erik Johnston | 2016-09-12 | 1 | -18/+0 |
| | | |||||
* | | Make reindex happen in bg | Erik Johnston | 2016-09-12 | 1 | -3/+2 |
|/ | |||||
* | Merge remote-tracking branch 'origin/develop' into ↵ | David Baker | 2016-09-09 | 3 | -0/+80 |
|\ | | | | | | | dbkr/make_notif_highlight_query_fast | ||||
| * | Use the previous MAX value if any to set the stream_id | Mark Haines | 2016-09-09 | 1 | -1/+2 |
| | | |||||
| * | Track the max_stream_device_id in a separate table, since we delete from the ↵ | Mark Haines | 2016-09-09 | 1 | -0/+20 |
| | | | | | | | | inbox table | ||||
| * | Merge pull request #1087 from matrix-org/markjh/reapply_delta | Mark Haines | 2016-09-09 | 1 | -1/+4 |
| |\ | | | | | | | Reapply 34/device_outbox in 35/device_outbox_again.py since the schem… | ||||
| | * | Just move the schema and add some DROPs | Mark Haines | 2016-09-09 | 2 | -35/+4 |
| | | | |||||
| | * | Only catch databas errors | Mark Haines | 2016-09-08 | 1 | -1/+1 |
| | | | |||||
| | * | Add a stub run_upgrade | Mark Haines | 2016-09-08 | 1 | -0/+4 |
| | | | |||||
| | * | Reapply 34/device_outbox in 35/device_outbox_again.py since the schema was ↵ | Mark Haines | 2016-09-08 | 1 | -0/+30 |
| | | | | | | | | | | | | bumped before it landed on develop | ||||
| * | | Add delta file | Erik Johnston | 2016-09-08 | 1 | -0/+20 |
| |/ | |||||
| * | Merge branch 'develop' into markjh/direct_to_device_federation | Mark Haines | 2016-09-08 | 2 | -0/+39 |
| |\ | |||||
| * | | Send device messages over federation | Mark Haines | 2016-09-06 | 1 | -3/+1 |
| | | | |||||
| * | | Add tables for federated device messages | Mark Haines | 2016-09-06 | 1 | -0/+38 |
| | | | | | | | | | | | | | | | Adds tables for storing the messages that need to be sent to a remote device and for deduplicating messages received. | ||||
* | | | Add index to event_push_actions | David Baker | 2016-09-09 | 1 | -0/+18 |
| |/ |/| | | | | | | | | | and remove room_id caluse so it uses it Mostly from @negativemjark | ||||
* | | Correctly delete old state groups in purge history API | Erik Johnston | 2016-09-05 | 1 | -0/+1 |
| | | |||||
* | | Add upgrade script that will slowly prune state_groups_state entries | Erik Johnston | 2016-09-05 | 1 | -0/+17 |
| | | |||||
* | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/state_storage | Erik Johnston | 2016-09-02 | 1 | -0/+32 |
|\| | |||||
| * | Clean up old sent transactions | Erik Johnston | 2016-08-31 | 1 | -0/+32 |
| | | |||||
* | | Move to storing state_groups_state as deltas | Erik Johnston | 2016-09-01 | 1 | -0/+21 |
|/ | |||||
* | Add store-and-forward direct-to-device messaging | Mark Haines | 2016-08-25 | 1 | -0/+24 |
| | |||||
* | Delete old received_transactions | Erik Johnston | 2016-08-22 | 1 | -0/+32 |
| | |||||
* | Make AppserviceHandler stream events from database | Erik Johnston | 2016-08-18 | 1 | -0/+23 |
| | | | | | | | | | This is for two reasons: 1. Suppresses duplicates correctly, as the notifier doesn't do any duplicate suppression. 2. Makes it easier to connect the AppserviceHandler to the replication stream. | ||||
* | Fix push_display_name_rename schema update | Erik Johnston | 2016-08-17 | 1 | -0/+3 |
| | |||||
* | Add migration script | David Baker | 2016-08-16 | 1 | -0/+17 |
| | | | | To port existing rule actions & enable entries to the new name | ||||
* | Rename table. Add docs. | Erik Johnston | 2016-08-15 | 1 | -2/+4 |
| | |||||
* | Add some invalidations to a cache_stream | Erik Johnston | 2016-08-15 | 1 | -0/+44 |
| | |||||
* | Default device_display_name to null | Richard van der Hoff | 2016-08-03 | 2 | -1/+21 |
| | | | | | | It turns out that it's more useful to return a null device display name (and let clients decide how to handle it: eg, falling back to device_id) than using a constant string like "unknown device". | ||||
* | SQL syntax fix | Richard van der Hoff | 2016-07-27 | 1 | -1/+1 |
| | |||||
* | Make the device id on e2e key upload optional | Richard van der Hoff | 2016-07-26 | 1 | -0/+19 |
| | | | | | | | | | | | | We should now be able to get our device_id from the access_token, so the device_id on the upload request is optional. Where it is supplied, we should check that it matches. For active access_tokens without an associated device_id, we ought to register the device in the devices table. Also update the table on upgrade so that all of the existing e2e keys are associated with real devices. | ||||
* | Implement deleting devices | Richard van der Hoff | 2016-07-26 | 2 | -0/+34 |
| | |||||
* | Create index on user_ips in the background | Richard van der Hoff | 2016-07-22 | 1 | -1/+2 |
| | | | | | | | | user_ips is kinda big, so really we want to add the index in the background once we're running. Replace the schema delta with one which will do that. I've done this in a way that's reasonably easy to reuse as there a few other indexes I need, and I don't suppose they will be the last. | ||||
* | GET /devices endpoint | Richard van der Hoff | 2016-07-20 | 1 | -0/+16 |
| | | | | | | | implement a GET /devices endpoint which lists all of the user's devices. It also returns the last IP where we saw that device, so there is some dancing to fish that out of the user_ips table. | ||||
* | Merge pull request #922 from matrix-org/erikj/file_api2 | Erik Johnston | 2016-07-20 | 1 | -0/+60 |
|\ | | | | | Feature: Add filter to /messages. Add 'contains_url' to filter. | ||||
| * | Add sender and contains_url field to events table | Erik Johnston | 2016-07-14 | 1 | -0/+60 |
| | | |||||
* | | schema fix | Richard van der Hoff | 2016-07-19 | 1 | -1/+1 |
| | | | | | | | | device_id should be text, not bigint. | ||||
* | | Add device_id support to /login | Richard van der Hoff | 2016-07-18 | 2 | -0/+37 |
|/ | | | | | | | | | | | | | Add a 'devices' table to the storage, as well as a 'device_id' column to refresh_tokens. Allow the client to pass a device_id, and initial_device_display_name, to /login. If login is successful, then register the device in the devices table if it wasn't known already. If no device_id was supplied, make one up. Associate the device_id with the access token and refresh token, so that we can get at it again later. Ensure that the device_id is copied from the refresh token to the access_token when the token is refreshed. | ||||
* | Track approximate last access time for remote media | Erik Johnston | 2016-06-29 | 1 | -0/+31 |
| | |||||
* | Fix synapse/storage/schema/delta/30/as_users.py | Mark Haines | 2016-05-31 | 1 | -2/+2 |
| | |||||
* | Remove topics table | Erik Johnston | 2016-05-13 | 1 | -1/+0 |
| | |||||
* | Annotate the removed indicies with why they were removed. | Mark Haines | 2016-05-13 | 1 | -18/+15 |
| | |||||
* | Remove unused indices | Erik Johnston | 2016-05-13 | 1 | -0/+42 |
| | | | | | This includes removing both unused indices and indices that are subsets of other indices. | ||||
* | unbreak schema | Matrix | 2016-05-10 | 2 | -0/+0 |
| | |||||
* | Merge remote-tracking branch 'origin/develop' into dbkr/email_notifs | David Baker | 2016-05-10 | 2 | -0/+34 |
|\ | |||||
| * | Add an openidish mechanism for proving to third parties that you own a given ↵ | Mark Haines | 2016-05-05 | 1 | -0/+9 |
| | | | | | | | | user_id | ||||
| * | Add primary key | Erik Johnston | 2016-05-04 | 1 | -1/+1 |
| | | |||||
| * | Add timestamp and auto incrementing ID | Erik Johnston | 2016-05-04 | 1 | -0/+2 |
| | | |||||
| * | Add /report endpoint | Erik Johnston | 2016-05-04 | 1 | -0/+23 |
| | | |||||
* | | Merge remote-tracking branch 'origin/develop' into dbkr/email_notifs | David Baker | 2016-04-29 | 1 | -0/+65 |
|\| | |||||
| * | Order NULLs first | Erik Johnston | 2016-04-21 | 1 | -2/+2 |
| | | |||||
| * | Use special UPDATE syntax | Erik Johnston | 2016-04-21 | 1 | -2/+2 |
| | | |||||
| * | Create index concurrently | Erik Johnston | 2016-04-21 | 1 | -5/+1 |
| | | |||||
| * | Add missing run_upgrade | Erik Johnston | 2016-04-21 | 1 | -0/+4 |
| | | |||||
| * | Optimise event_search in postgres | Erik Johnston | 2016-04-21 | 1 | -0/+65 |
| | | |||||
* | | First bits of emailpusher | David Baker | 2016-04-19 | 2 | -0/+39 |
|/ | | | | Mostly logic of when to send an email | ||||
* | Add index | Erik Johnston | 2016-04-14 | 1 | -0/+18 |
| | |||||
* | Merge pull request #705 from matrix-org/dbkr/pushers_use_event_actions | David Baker | 2016-04-11 | 1 | -0/+79 |
|\ | | | | | Change pushers to use the event_actions table | ||||
| * | pep8 | David Baker | 2016-04-07 | 1 | -0/+1 |
| | | |||||
| * | Fix port script for changes merged from develop | David Baker | 2016-04-07 | 1 | -1/+4 |
| | | |||||
| * | Merge remote-tracking branch 'origin/develop' into ↵ | David Baker | 2016-04-07 | 5 | -5/+23 |
| |\ | | | | | | | | | | dbkr/pushers_use_event_actions | ||||
| * | | Make pushers use the event_push_actions table instead of listening on an ↵ | David Baker | 2016-04-06 | 1 | -0/+75 |
| | | | | | | | | | | | | | | | | | | | | | event stream & running the rules again. Sytest passes, but remaining to do: * Make badges work again * Remove old, unused code | ||||
* | | | move local_media_repository_url_cache.sql to schema v31 | Matthew Hodgson | 2016-04-08 | 1 | -0/+0 |
| | | | |||||
* | | | Merge branch 'develop' into matthew/preview_urls | Matthew Hodgson | 2016-04-07 | 6 | -5/+65 |
|\ \ \ | | |/ | |/| | |||||
| * | | Don't require config to create database | Erik Johnston | 2016-04-06 | 5 | -5/+23 |
| |/ | |||||
| * | Docs and indents | Erik Johnston | 2016-04-04 | 1 | -11/+11 |
| | | |||||
| * | Add upgrade path, rename table | Erik Johnston | 2016-04-04 | 1 | -3/+17 |
| | | |||||
| * | Store invites in a separate table. | Erik Johnston | 2016-04-04 | 1 | -0/+28 |
| | | |||||
* | | Merge branch 'develop' into matthew/preview_urls | Matthew Hodgson | 2016-04-04 | 1 | -0/+38 |
|\| | |||||
| * | Add replication streams for ex outliers and current state resets | Mark Haines | 2016-03-30 | 1 | -0/+38 |
| | | |||||
* | | add a persistent cache of URL lookups, and fix up the in-memory one to work | Matthew Hodgson | 2016-04-03 | 1 | -0/+27 |
|/ | |||||
* | Comment about weird SQL | Erik Johnston | 2016-03-23 | 1 | -1/+3 |
| | |||||
* | SQLite and postgres doesn't share a true literal | Erik Johnston | 2016-03-23 | 1 | -1/+1 |
| | |||||
* | Ensure all old public rooms have aliases | Erik Johnston | 2016-03-23 | 1 | -0/+21 |
| | |||||
* | Add a comment to offer a hint to an explanation for why we have a unique ↵ | Mark Haines | 2016-03-16 | 1 | -0/+1 |
| | | | | constraint on (app_id, pushkey, user_id) | ||||
* | Add replication stream for pushers | Mark Haines | 2016-03-15 | 1 | -0/+24 |
| | |||||
* | Update users table in a batched manner | Erik Johnston | 2016-03-10 | 1 | -9/+14 |
| | |||||
* | Merge branch 'develop' into daniel/ick | Daniel Wagner-Hall | 2016-03-08 | 2 | -0/+54 |
|\ | |||||
| * | s/stream_ordering/event_stream_ordering/ in push | Mark Haines | 2016-03-04 | 1 | -1/+1 |
| | | |||||
| * | Merge branch 'develop' into markjh/pushrule_stream | Mark Haines | 2016-03-04 | 2 | -0/+75 |
| |\ | |||||
| | * | Merge pull request #614 from matrix-org/erikj/alias_delete | Erik Johnston | 2016-03-04 | 1 | -0/+16 |
| | |\ | | | | | | | | | Allow alias creators to delete aliases | ||||
| | | * | Allow alias creators to delete aliases | Erik Johnston | 2016-03-01 | 1 | -0/+16 |
| | | | | |||||
| * | | | Add a stream for push rule updates | Mark Haines | 2016-03-01 | 1 | -0/+38 |
| | |/ | |/| | |||||
* | | | Idempotent-ise schema update script | Daniel Wagner-Hall | 2016-03-08 | 1 | -1/+5 |
| |/ |/| | | | | | | | If any ASes don't have an ID, the schema will fail, and then it will error when trying to add the column again. | ||||
* | | Merge pull request #571 from matrix-org/daniel/asids | Daniel Wagner-Hall | 2016-03-03 | 1 | -0/+59 |
|\ \ | |/ |/| | Mark AS users with their AS's ID | ||||
| * | Mark AS users with their AS's ID | Daniel Wagner-Hall | 2016-02-11 | 1 | -0/+59 |
| | | |||||
* | | Generate guest access token on 3pid invites | Daniel Wagner-Hall | 2016-02-24 | 1 | -0/+24 |
| | | | | | | | | | | | | | | | | | | This means that following the same link across multiple sessions or devices can re-use the same guest account. Note that this is somewhat of an abuse vector; we can't throw up captchas on this flow, so this is a way of registering ephemeral accounts for spam, whose sign-up we don't rate limit. | ||||
* | | Prefix TS fields with _ts | Erik Johnston | 2016-02-18 | 1 | -3/+3 |
| | | |||||
* | | Initial cut | Erik Johnston | 2016-02-17 | 1 | -0/+30 |
|/ | |||||
* | Merge pull request #554 from matrix-org/erikj/event_push | Erik Johnston | 2016-02-03 | 1 | -0/+31 |
|\ | | | | | Change event_push_actions_rm_tokens schema | ||||
| * | Change event_push_actions_rm_tokens schema | Erik Johnston | 2016-02-03 | 1 | -0/+31 |
| | | |||||
* | | Change the way we do public room list fetching | Erik Johnston | 2016-02-02 | 1 | -0/+16 |
|/ | |||||
* | Add events index | Erik Johnston | 2016-01-28 | 1 | -0/+16 |
| | |||||
* | Add index to event_push_actions | Erik Johnston | 2016-01-25 | 1 | -0/+1 |
| | |||||
* | Add index by user id on receipts_linearized | David Baker | 2016-01-20 | 1 | -0/+18 |
| | |||||
* | Remove rogue 'admin' | David Baker | 2016-01-11 | 1 | -1/+1 |
| | |||||
* | Merge pull request #456 from matrix-org/store_event_actions | David Baker | 2016-01-08 | 2 | -0/+48 |
|\ | | | | | Send unread notification counts | ||||
| * | Add schema change file for is_guest flag | David Baker | 2016-01-06 | 1 | -0/+22 |
| | | |||||
| * | Add is_guest flag to users db to track whether a user is a guest user or ↵ | David Baker | 2016-01-06 | 1 | -0/+0 |
| | | | | | | | | not. Use this so we can run _filter_events_for_client when calculating event_push_actions. | ||||
| * | Merge remote-tracking branch 'origin/develop' into store_event_actions | David Baker | 2016-01-05 | 1 | -0/+21 |
| |\ | |||||
| * | | Rename event-actions to event_push_actions as per PR request | David Baker | 2016-01-04 | 1 | -2/+2 |
| | | | |||||
| * | | still very WIP, but now sends unread_notifications_count in the room object ↵ | David Baker | 2015-12-16 | 1 | -2/+3 |
| | | | | | | | | | | | | on sync (only actually corrrect in a full sync: hardcoded to 0 in incremental syncs). | ||||
| * | | Save event actions to the db | David Baker | 2015-12-10 | 1 | -0/+25 |
| | | | |||||
* | | | copyrights | Matthew Hodgson | 2016-01-07 | 53 | -53/+53 |
| |/ |/| | |||||
* | | Allow guests to upgrade their accounts | Daniel Wagner-Hall | 2016-01-05 | 1 | -0/+21 |
|/ | |||||
* | Bump schema version. | Mark Haines | 2015-12-04 | 4 | -23/+36 |
| | | | | As we released version 26 in v0.11.1 | ||||
* | Merge pull request #414 from matrix-org/erikj/if_not_exists | Erik Johnston | 2015-12-03 | 1 | -1/+1 |
|\ | | | | | Older versions of SQLite don't like IF NOT EXISTS in virtual tables | ||||
| * | Older versions of SQLite don't like IF NOT EXISTS in virtual tables | Erik Johnston | 2015-12-02 | 1 | -1/+1 |
| | | |||||
* | | Just replace the table definition with the one from full_schema 16 | David Baker | 2015-12-02 | 1 | -11/+10 |
| | | |||||
* | | Fix schema delta 15 on postgres in the very unlikley event that anyone ↵ | David Baker | 2015-12-02 | 1 | -1/+1 |
|/ | | | | upgrades to 15... | ||||
* | Add API for setting account_data globaly or on a per room basis | Mark Haines | 2015-12-01 | 1 | -0/+23 |
| | |||||
* | Allow paginating search ordered by recents | Erik Johnston | 2015-11-30 | 1 | -0/+57 |
| | |||||
* | Remove size specifier for database column | Daniel Wagner-Hall | 2015-11-23 | 1 | -1/+3 |
| | | | | | | Postgres doesn't support them like this. We don't have a bool type in common between postgres and sqlite. | ||||
* | Merge branch 'develop' into daniel/forgetrooms | Paul "LeoNerd" Evans | 2015-11-19 | 1 | -0/+17 |
|\ | |||||
| * | Rename the database table | Mark Haines | 2015-11-18 | 1 | -0/+17 |
| | | |||||
* | | Allow users to forget rooms | Daniel Wagner-Hall | 2015-11-17 | 1 | -0/+24 |
|/ | |||||
* | Merge pull request #359 from matrix-org/markjh/incremental_indexing | Erik Johnston | 2015-11-11 | 2 | -75/+47 |
|\ | | | | | Incremental background updates for db indexes | ||||
| * | Fix param style to work on both sqlite and postgres | Mark Haines | 2015-11-11 | 1 | -2/+6 |
| | | |||||
| * | Fix the background update | Mark Haines | 2015-11-11 | 1 | -4/+3 |
| | | |||||
| * | Use a background task to update databases to use the full text search | Mark Haines | 2015-11-10 | 1 | -76/+24 |
| | | |||||
| * | Add storage module for tracking background updates. | Mark Haines | 2015-11-09 | 1 | -0/+21 |
| | | | | | | | | | | | | | | The progress for each background update is stored as a JSON blob in the database. Each background update is broken up into separate batches. The batch size is automatically tuned to try avoid blocking single threaded databases for too long. | ||||
* | | Return world_readable and guest_can_join in /publicRooms | Daniel Wagner-Hall | 2015-11-10 | 1 | -0/+25 |
|/ | |||||
* | Remove accidentally added ID column | Daniel Wagner-Hall | 2015-11-06 | 1 | -1/+0 |
| | |||||
* | Open up /events to anonymous users for room events only | Daniel Wagner-Hall | 2015-11-05 | 1 | -0/+26 |
| | | | | Squash-merge of PR #345 from daniel/anonymousevents | ||||
* | Merge pull request #335 from matrix-org/markjh/room_tags | Mark Haines | 2015-11-03 | 1 | -0/+38 |
|\ | | | | | Add APIs for adding and removing tags from rooms | ||||
| * | Store room tag content and return the content in the m.tag event | Mark Haines | 2015-11-02 | 1 | -0/+1 |
| | | |||||
| * | Add APIs for adding and removing tags from rooms | Mark Haines | 2015-10-28 | 1 | -0/+37 |
| | | |||||
* | | Add missing column | Daniel Wagner-Hall | 2015-10-30 | 1 | -1/+1 |
|/ | |||||
* | Pull out sender when computing search results | Erik Johnston | 2015-10-23 | 1 | -14/+17 |
| | |||||
* | Implement rank function for SQLite FTS | Erik Johnston | 2015-10-23 | 1 | -1/+1 |
| | |||||
* | PEP8 | Erik Johnston | 2015-10-22 | 1 | -1/+2 |
| | |||||
* | Move FTS to delta 25 | Erik Johnston | 2015-10-22 | 1 | -2/+2 |
| | |||||
* | Split up run_upgrade | Erik Johnston | 2015-10-16 | 1 | -5/+11 |
| | |||||
* | Merge branch 'erikj/store_engine' into erikj/search | Erik Johnston | 2015-10-13 | 1 | -1/+1 |
|\ | |||||
* | | Merge branch 'erikj/store_engine' into erikj/search | Erik Johnston | 2015-10-13 | 1 | -1/+1 |
|\| | |||||
* | | Add sqlite schema | Erik Johnston | 2015-10-13 | 1 | -5/+64 |
| | | |||||
* | | Keep FTS indexes up to date. Only search through rooms currently joined | Erik Johnston | 2015-10-12 | 1 | -1/+2 |
| | | |||||
* | | Add basic full text search impl. | Erik Johnston | 2015-10-09 | 1 | -0/+57 |
|/ | |||||
* | Implement configurable stats reporting | Daniel Wagner-Hall | 2015-09-22 | 1 | -0/+22 |
| | | | | | | | | | | SYN-287 This requires that HS owners either opt in or out of stats reporting. When --generate-config is passed, --report-stats must be specified If an already-generated config is used, and doesn't have the report_stats key, it is requested to be set. | ||||
* | Drop unused index | Erik Johnston | 2015-09-14 | 1 | -0/+16 |
| | |||||
* | Remove autoincrement since we incrementing the ID in the storage layer | Mark Haines | 2015-08-24 | 1 | -1/+1 |
| | |||||
* | Merge branch 'develop' into refresh | Daniel Wagner-Hall | 2015-08-20 | 1 | -0/+19 |
|\ | | | | | | | | | Conflicts: synapse/rest/client/v1/login.py | ||||
| * | Merge pull request #211 from matrix-org/email_in_use | Mark Haines | 2015-08-20 | 1 | -0/+19 |
| |\ | | | | | | | Changes for unique emails | ||||
| | * | Add endpoint that proxies ID server request token and errors if the given ↵ | David Baker | 2015-08-04 | 1 | -0/+19 |
| | | | | | | | | | | | | email is in use on this Home Server. | ||||
* | | | /tokenrefresh POST endpoint | Daniel Wagner-Hall | 2015-08-20 | 1 | -0/+21 |
|/ / | | | | | | | | | | | | | | | This allows refresh tokens to be exchanged for (access_token, refresh_token). It also starts issuing them on login, though no clients currently interpret them. | ||||
* / | Add index receipts_linearized_room_stream | Erik Johnston | 2015-08-17 | 1 | -0/+18 |
|/ | |||||
* | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/receipts | Erik Johnston | 2015-07-13 | 1 | -0/+34 |
|\ | |||||
| * | Uniquely name unique constraint | Erik Johnston | 2015-07-10 | 1 | -2/+2 |
| | | |||||
| * | Don't bother with a timeout for one time keys on the server. | Mark Haines | 2015-07-09 | 1 | -1/+0 |
| | | |||||
| * | Add store for client end to end keys | Mark Haines | 2015-07-06 | 1 | -0/+35 |
| | | |||||
* | | Change format of receipts to allow inclusion of data | Erik Johnston | 2015-07-09 | 1 | -10/+6 |
| | | |||||
* | | Add stream_id index | Erik Johnston | 2015-07-02 | 1 | -1/+5 |
| | | |||||
* | | Add basic storage functions for handling of receipts | Erik Johnston | 2015-07-01 | 1 | -14/+17 |
| | | |||||
* | | Add tables for receipts | Erik Johnston | 2015-06-30 | 1 | -0/+35 |
|/ | |||||
* | Add a dummy.sql into delta/20 as pip isn't packinging the pushers.py | Erik Johnston | 2015-06-13 | 1 | -0/+1 |
| | |||||
* | pep8 | David Baker | 2015-06-04 | 1 | -1/+0 |
| | |||||
* | Add script to (re)convert the pushers table to changing the unique key. Also ↵ | David Baker | 2015-06-04 | 2 | -1/+78 |
| | | | | give the python db upgrade scripts the database engine so they can convert parameter strings, and add *args **kwargs to the upgrade function so we can add more args in future and previous scripts will ignore them. | ||||
* | Newline, remove debug logging | Erik Johnston | 2015-05-18 | 1 | -1/+1 |
| | |||||
* | Add index on events | Erik Johnston | 2015-05-13 | 1 | -0/+19 |
| | |||||
* | Drop the old table not the new table | Mark Haines | 2015-05-08 | 1 | -1/+1 |
| | |||||
* | Rename unique constraint | Mark Haines | 2015-05-08 | 1 | -1/+1 |
| | |||||
* | Remove unsigned | Mark Haines | 2015-05-08 | 1 | -2/+2 |
| | |||||
* | Make the timestamps in server_keys_json bigints | Mark Haines | 2015-05-08 | 1 | -0/+32 |
| | |||||
* | Remove some unused indexes | Erik Johnston | 2015-05-01 | 1 | -0/+18 |
| | |||||
* | Oops, update the contraint too | David Baker | 2015-04-29 | 1 | -1/+1 |
| | |||||
* | Be more postgressive | David Baker | 2015-04-29 | 1 | -2/+2 |
| | |||||
* | Be postgressive | David Baker | 2015-04-29 | 1 | -4/+3 |
| | |||||
* | Oops, forgot the schema delta file | David Baker | 2015-04-29 | 1 | -0/+10 |
| | |||||
* | pushers table requires an access_token | Erik Johnston | 2015-04-29 | 1 | -0/+1 |
| | |||||
* | bump database schema version | Mark Haines | 2015-04-29 | 1 | -0/+0 |
| | |||||
* | Use bytea rather than BLOB | Mark Haines | 2015-04-29 | 1 | -1/+1 |
| | |||||
* | Merge branch 'develop' into key_distribution | Mark Haines | 2015-04-29 | 38 | -190/+1074 |
|\ | | | | | | | | | Conflicts: synapse/config/homeserver.py | ||||
| * | Merge branch 'develop' of github.com:matrix-org/synapse into postgres | Erik Johnston | 2015-04-28 | 1 | -0/+25 |
| |\ | |||||
| | * | Merge pull request #126 from matrix-org/csauth | Mark Haines | 2015-04-28 | 1 | -0/+25 |
| | |\ | | | | | | | | | Client / Server Auth Refactor | ||||
| | | * | Merge branch 'develop' into csauth | David Baker | 2015-04-17 | 1 | -0/+30 |
| | | |\ | |||||
| | | * | | Allow multiple pushers for a single app ID & pushkey, honouring the 'append' ↵ | David Baker | 2015-03-25 | 1 | -2/+25 |
| | | | | | | | | | | | | | | | | | | | | flag in the API. | ||||
| | | * | | 1) Pushers are now associated with an access token | David Baker | 2015-03-24 | 1 | -0/+2 |
| | | | | | | | | | | | | | | | | | | | | 2) Change places where we mean unauthenticated to 401, not 403, in C/S v2: hack so it stays as 403 in v1 because web client relies on it. | ||||
| * | | | | Use TEXT instead of VARCHAR(n), since PostgreSQL treats them the same except ↵ | Erik Johnston | 2015-04-28 | 32 | -289/+289 |
| | | | | | | | | | | | | | | | | | | | | for a limit | ||||
| * | | | | Merge branch 'develop' of github.com:matrix-org/synapse into postgres | Erik Johnston | 2015-04-27 | 2 | -0/+28 |
| |\| | | | |||||
| * | | | | Add unique index to room_aliases, remove duplicates on upgrade. Convert some ↵ | Erik Johnston | 2015-04-17 | 7 | -4/+19 |
| | | | | | | | | | | | | | | | | | | | | columns back to TEXT from bytea | ||||
| * | | | | Go back to storing JSON in TEXT | Erik Johnston | 2015-04-16 | 4 | -10/+10 |
| | | | | | |||||
| * | | | | Remove mysql/maria support | Erik Johnston | 2015-04-15 | 1 | -1/+1 |
| | | | | | |||||
| * | | | | Change full_schemas/11 to work with postgres | Erik Johnston | 2015-04-15 | 13 | -84/+90 |
| | | | | | |||||
| * | | | | Add index on events (topological_ordering, stream_ordering) to help with ↵ | Erik Johnston | 2015-04-15 | 2 | -0/+2 |
| | | | | | | | | | | | | | | | | | | | | ORDER BY clauses | ||||
| * | | | | Rename user_ips.user -> user_id | Erik Johnston | 2015-04-14 | 2 | -6/+6 |
| | | | | | |||||
| * | | | | Add support for postgres instead of mysql. Change sql accourdingly. blob + ↵ | Erik Johnston | 2015-04-14 | 13 | -105/+103 |
| | | | | | | | | | | | | | | | | | | | | varbinary -> bytea. No support for UNSIGNED or CREATE INDEX IF NOT EXISTS. | ||||
| * | | | | For backwards compat, make state_groups.id have a type of int, not varchar | Erik Johnston | 2015-04-13 | 1 | -1/+1 |
| | | | | | |||||
| * | | | | Remove duplicate rows | Erik Johnston | 2015-04-10 | 1 | -0/+9 |
| | | | | | |||||
| * | | | | DROP indexes before recreating them | Erik Johnston | 2015-04-10 | 2 | -1/+9 |
| | | | | | |||||
| * | | | | Use LONGBLOB and TEXT for arbitary length rows | Erik Johnston | 2015-04-10 | 12 | -34/+34 |
| | | | | | |||||
| * | | | | Use unsigned bigint | Erik Johnston | 2015-04-10 | 19 | -50/+50 |
| | | | | | |||||
| * | | | | SQLite wants INTEGER and not BIGINT for primary keys | Erik Johnston | 2015-04-10 | 6 | -9/+9 |
| | | | | | |||||
| * | | | | Update full_schemas/16 to match delta files. Add delta/16 scripts | Erik Johnston | 2015-04-10 | 6 | -0/+245 |
| | | | | | |||||
| * | | | | Revert non-trivial changes to upgrade scripts | Erik Johnston | 2015-04-10 | 3 | -5/+5 |
| | | | | | |||||
| * | | | | Fix schema again | Erik Johnston | 2015-04-10 | 2 | -3/+3 |
| | | | | | |||||
| * | | | | Revert non-trivial schema changes and move them to a new schema version. | Erik Johnston | 2015-04-10 | 19 | -27/+636 |
| | | | | | |||||
| * | | | | Remove spurious spaces | Erik Johnston | 2015-04-09 | 15 | -50/+50 |
| | | | | | |||||
| * | | | | Merge branch 'develop' of github.com:matrix-org/synapse into mysql | Erik Johnston | 2015-04-07 | 1 | -0/+31 |
| |\ \ \ \ | | | |_|/ | | |/| | | |||||
| * | | | | Add index to presence table | Erik Johnston | 2015-04-07 | 1 | -0/+2 |
| | | | | | |||||
| * | | | | Don't use multiple UNIQUE constraints; it will cause deadlocks | Erik Johnston | 2015-04-07 | 2 | -6/+8 |
| | | | | | |||||
| * | | | | Fix unicode support | Erik Johnston | 2015-04-02 | 16 | -145/+143 |
| | | | | | |||||
| * | | | | Make work in both Maria and SQLite. Fix tests | Erik Johnston | 2015-04-01 | 15 | -55/+55 |
| | | | | | |||||
| * | | | | Fix unicode database support | Erik Johnston | 2015-03-25 | 3 | -3/+2 |
| | | | | | |||||
| * | | | | Fix up schemas some more | Erik Johnston | 2015-03-20 | 3 | -3/+3 |
| | | | | | |||||
| * | | | | Remove redundant key | Erik Johnston | 2015-03-19 | 1 | -1/+0 |
| | | | | | |||||
| * | | | | Fix up schemas to work with mariadb | Erik Johnston | 2015-03-19 | 15 | -84/+82 |
| | | | | | |||||
| * | | | | Update schema to work with mariadb | Erik Johnston | 2015-03-18 | 16 | -256/+224 |
| | |_|/ | |/| | | |||||
* | | | | Add server_keys.sql to the current delta rather than creating a new delta | Mark Haines | 2015-04-28 | 1 | -0/+0 |
| | | | | |||||
* | | | | Merge branch 'develop' into key_distribution | Mark Haines | 2015-04-24 | 2 | -0/+28 |
|\ \ \ \ | | |_|/ | |/| | | |||||
| * | | | Copyright notices | Mark Haines | 2015-04-24 | 2 | -0/+28 |
| | |/ | |/| | |||||
* | | | Add methods for storing and retrieving the raw key json | Mark Haines | 2015-04-15 | 1 | -3/+3 |
| | | |