Hi devs,<br>
<br>I'd like to attend the GSoC 2011 as student to develop the following idea:<br><a href="http://www.qgis.org/wiki/Google_Summer_of_Code_2011#Database_Manager">http://www.qgis.org/wiki/Google_Summer_of_Code_2011#Database_Manager</a><br>
<br>Brief.<br>I think PG_manager is a very useful plugin because permits users to get informations <br>and run queries on a PG database from within QGis. Furthermore PG_manager GUI is <br>very intuitive!<br>So, at the HF in Pisa (2010.04) I starting to develop SL_manager, based on <br>
PG_manager but working on SpatiaLite databases. Unfortunately I didn't adapted the <br>existent code to manage SL databases, instead I forked it. <br><br>Now there're 2 different plugins based on the same code and it's very difficult <br>
maintaining both as porting fixes between them and adding new features could <br>require a lot of time.<br><br>There's another plugin based on PG_manager, it's the RT_Sql_Layer plugin which <br>allow users to load a PG or SL layer using whatever select statement. <br>
<br>Proposal.<br>My aim is to merge both 3 plugins together and create the DB_manager plugin.<br><br>First and the most important requirement, the DB_manager plugin *must* be easily <br>expandable to manage different kind of databases (e.g. mysql, ...).<br>
I didn't look ahead when I forked PG_manager, but I want to correct my mistakes.<br><br>Second, it should permit an easy management of databases, running common tasks <br>as create/alter/delete tables, retrieve infos about tables, run queries, ... . <br>
Those are implemented in PG/SL_manager yet, but I have to do some changes to <br>make them more general than they are.<br><br>Third, DB_manager should allow to load tables as layer on the QGis canvas and, <br>on the contrary, import layers from the canvas into the db.<br>
<br>What is your
opinion? Did I miss something? <br>What other features would you like to see? And what other plugins (if any) would it be <br>good to integrate in?<br><br>
Thanks for your comments.<br><br>-- <br>Giuseppe Sucameli<br><br>