Database support

[Hokkaydo]

Add database support and migrate all current files to db

[ananas-dev]

Hi, I would like to implement this, what files should be migrated ?

[ananas-dev]

Is there a preference for a certain type of database? I was thinking of something like sqlite because it is simple and portable but nosql options such as mongodb can do the job too.

[Hokkaydo]

Hi, I would like to implement this, what files should be migrated?

It's a little bit messy.
The files are generated at runtime if not already present.
Those three files should be migrated to different tables :

• "warned_confessions" => currently in the format "moderatorId;;;authorId;;;timestamp", should become a table "id, warned_confession_message_id, author_id, content, moderator_id, timestamp"
• "message_ids": currently in the format "threadId;path", should become a table "id, thread_id, path"
• "mirrors": currently in the format "channelA;channelB", should become a table "id, channel_a, channel_b."

We should also have a few tables to store course static data :

• "courses" => "id, course_code, course_name, quarter, groupId" (eg: (0, "LINMA1315", "Complément d'analyse", 4, 3))
• "course_groups" => "id, group_code, french_name" (e.g.: (3, "MAP", "Filière en Mathématiques Appliquées" => (integer, string, string))

Additionally, I want to implement a new feature requiring a table "notices" with columns "id, author_id, subject_id, timestamp, type, content" (e.g.: (0, 45646565, 4, 255555566) => (integer, integer, integer, Date, string, string))

Is there a preference for a certain type of database? I was thinking of something like SQLite because it is simple and portable but nosql options such as MongoDB can do the job too.

To me, the easier to implement is SQLite, I don't think we need the storage size of MongoDB but if you think the latter is a better choice, you're free to go.

Btw, if you could write an interface to handle different storage types, it could help us if we want to move on to another database later.

[Hokkaydo]

#32 Is waiting for you

[Hokkaydo]

Solved in #41