depot - monorepo for the virus lounge

Age	Commit message (Collapse)	Author	Files	Lines
2018-05-27	feat(db): Update views with thread-closed field	Vincent Ambo	2	-0/+65

2018-05-27	feat(db): Add migration & fields to indicate a thread is closed	Vincent Ambo	2	-0/+2

2018-05-02	feat(migrations): Add a view for simplified post querying	Vincent Ambo	2	-0/+12
	Adds a view to avoid having to query and join the users & posts table inside of the application (which isn't particularly convenient in Diesel).
2018-05-02	refactor(migrations): Rename 'author' column to 'user_id'	Vincent Ambo	2	-16/+16
	This makes it easier to integrate with Diesel, for which this is the expected column name.
2018-05-02	fix(migrations): Explicitly insert anonymous user	Vincent Ambo	1	-5/+11
	This guarantees that the anonymous user will always exist and have ID=1.
2018-05-02	fix(migrations): Fix search index creation in user migration	Vincent Ambo	2	-0/+4

2018-05-02	feat(migrations): Adds a migration to create a users table	Vincent Ambo	2	-0/+136
	As a first step of getting the concept of users into the database, this creates a (somewhat involved) migration that moves all existing "users" into a new users table and updates the post table to reference it. This migration is not yet finalised and still needs to be updated with something to handle the concept of anonymous users (which I want to keep around).
2018-04-14	fix(migrations): Change weighting of title vs. body	Vincent Ambo	1	-2/+2
	After thinking for a little while I actually think the body of a post may be more relevant when searching for posts than the thread title. Right now this is just a hunch and we'll have to find out how it actually ends up working in real life.
2018-04-14	feat(migrations): Add materialized view & index for full text search	Vincent Ambo	2	-0/+23
	Adds a materialized view to be used for full-text searches that indexes the tsvector documents for each post.
2018-04-14	feat(db): Add support for stickies in database	Vincent Ambo	4	-16/+23
	Adds a 'sticky' column to threads and rewrites the thread index to take sticky markings into account when ordering threads. Stickies are not yet highlighted in any way in the forum overview.
2018-04-14	feat(db): Add view for ordering thread index by most recent post	Vincent Ambo	2	-0/+16
	This implements the classic thread ordering expected by most forum users (i.e. the thread with the most recent post is at the top).
2018-04-14	feat(migrations): Drop 'body' column from threads	Vincent Ambo	2	-0/+7
	As a data model simplification, the text of a thread's top post should simply also go into the posts table.
2018-04-08	feat(migrations): Add author columns to tables	Vincent Ambo	2	-0/+15
	Adds columns for author names and emails to both threads and posts. "Users" don't (yet? who knows!) exist as independent entity in Converse, they are simply "inferred" via OIDC providers.
2018-04-08	feat(migrations): Default 'posted' columns to NOW()	Vincent Ambo	2	-0/+4

2018-04-08	refactor(db): Establish Post->Thread association	Vincent Ambo	2	-0/+2
	This makes it possible to query posts by thread via Diesel.
2018-04-08	feat(migrations): Add posts & threads tables	Vincent Ambo	5	-0/+57