446442 - Move projects and languages to database

Status: RESOLVED FIXED

(Webtools Graveyard :: Verbatim, defect)

Description

[Dan Schafer [:dschafer]]

Currently, projects and languages are stored in pootle.prefs; these should be moved to a database.

Comment 1

[Dan Schafer [:dschafer]]

Attachment: Patch moving projects and languages to database

First version of a patch moving language and project information to a database.  Thorough testing still needs to be done, but the major issue in this patch right now is the number of SQL queries.  Due to the removal of the "potree.languages" and "potree.projects" data structures, any and all accessing of project/language information requires a SQL query, so there are an absurd number of queries on most pages.

Comment 2

[Dan Schafer [:dschafer]]

Attachment: Improved patch moving Languages / Projects

This improves upon the previous patch by storing a dictionary of languages and projects, to avoid unneeded SQL queries.  All of the major features have been tested with this code, and so it is committed in revision 7830.

Comment 3

[Dan Schafer [:dschafer]]

Changed the storage of user's projects, languages, uilang and altsrc lang to use relational database techniques.

This is in revision 7831.

This should cover everything related to languages and projects, so marking this FIXED.

Comment 4

[Dan Schafer [:dschafer]]

Attachment: Patch to add relational information between tables.

Patch for above comment.