Thanks to the hard work of Giuseppe Sucameli, the supervision of Martin Dobias, and
the support of Google for its Summer of Code initiative, DB Manager is now available.
DB Manager's aim is to merge some of QGIS DB plugins, e.g. PGManager, SLManager,
RT_Sql_Layer. At the moment it works with both PostgreSQL and SQLite databases. It displays list of tables, info about the selected table. In addition,
allows the user to rename/delete tables through its GUI and run query on the selected
database, hence replaces SLManager.
Thanks to Mauricio De Paulo, now DB Manager also supports PostGIS Rasters!
The last DB Manager version can import Vector Layer feature by drag'n'drop
a layer from the QGIS browser (or even DB Manager) to a database in the DB Manager
GUI. The Import Vector Layer feature allows user to import/copy any vector layer in QGIS from different datasources (i.e. PostGIS/SpatiaLite databases and OGR files).
It's available through the QgsVectorLayerImport class and it has just been merged in
master branch.
Faunalia is committed to support the development of this tool, and other DB plugins. Developers are welcome to join and merge their works, to reduce
confusion for users.
Watch a screencast about DB Manager on our YouTube Channel.