[Qgis-developer] SPIT still functional?

[Olivier Dalang]

Hi,

As I said on the user list ( thread : "Import (not so) large data into a
remote postgis database" ), SPIT has the advantage of showing a progress
bar.
This is a good feature when uploading data through a slow connection (my
case these days).

But I think it would make sense to move this feature (the progress bar) to
the DB manager.
I tried to do it [1], and it kind of works sometimes, but there's some UI
refreshing issues, and I won't time to investigate much more these days...

Maybe we should also think about making the import more efficient and
robust. I'm currently working with a slow connection, and uploading a table
of around 4000 lines takes ages (around 2 hours).
I don't really understand what the bottleneck is, but the transfer rate is
way under the transfer rate I'd have if I uploaded a dump file and ran it
online.
All more efficient ways (pg_dump, ogr2ogr, pgdump,...) are not suited for
non power users...

Bests,

Olivier



2015-01-20 14:40 GMT+00:00 Paolo Cavallini <cavallini at faunalia.it>:

> Hi all,
> is SPIT plugin still functional? Still useful?
> AFAIK its main advantage is the possibility of importing multiple files
> (but a Processing module is now available for this), and speed.
> IMHO this is a good time to evaluate whether we want to drop some parts.
> All the best.
> --
> Paolo Cavallini - www.faunalia.eu
> QGIS & PostGIS courses: http://www.faunalia.eu/training.html
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150120/77bca545/attachment-0001.html>