Currently, projects and languages are stored in pootle.prefs; these should be moved to a database.
Created attachment 330831 [details] [diff] [review] 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.
Created attachment 330853 [details] [diff] [review] 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.
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.
Created attachment 330865 [details] [diff] [review] Patch to add relational information between tables. Patch for above comment.