PostgreSQL support

[kaylendog]

As of #2, support was added for archiving text channels instead of needing to move them to the Archive category on the Discord. The system currently dumps messages into a text file and uploads it, which has some downsides

• The requests to fetch all messages in the channel take a very long time e.g. (archiving #developer-chat, which has ~110,000 messages, would take maybe 20 minutes).
• There's no way to make snapshots of channels, or take a data range slice without having to redo all the queries.

I propose we mirror Discord's database by simply storing messages received through the gateway in their raw form in PostgreSQL. This would allow us to compute the above things on the fly, making response times a lot snappier.

We can use either TypeORM or Objection.JS - the former is designed to work with TS, so is probably better given our environment.

[kaylendog]

The only downside of this I can think of is that this is going to use quite a lot of storage space.

[vladfrangu]

2 things :D

1. Saving data in a DB is very... disliked by Discord unless we have encryption (on the DB, etc)
2. We can also use Prisma, which is super popular and, from personal and friend's experience, works more reliably than TypeORM

[kaylendog]

.1 Saving data in a DB is very... disliked by Discord unless we have encryption (on the DB, etc)

If you're referring to the legality, we can just tell everyone we do that. I'm no lawyer, but:

Any data, text, graphics, photographs and their selection and arrangement, and any other materials uploaded to the Service by you is “Your Content.” You represent and warrant that Your Content is original to you and that you exclusively own the rights to such content, including the right to grant all of the rights and licenses in these Terms without the Company incurring any third party obligations or liability arising out of its exercise of such rights and licenses.

Legally, the message content still belongs to the author - if we state in the Developer intro that the archiver thing will be saving our messages, and ask for permission for us to do this when developers join the server, I suspect we're not in legal murky water.

[kaylendog]

Prisma looks hot - we can use that.