<div dir="ltr">Oops I forgot the link to the branch with the small update on the db manager : <a href="https://github.com/olivierdalang/QGIS/tree/db_manager_dialog_on_import">https://github.com/olivierdalang/QGIS/tree/db_manager_dialog_on_import</a></div><div class="gmail_extra"><br><div class="gmail_quote">2015-01-20 17:59 GMT+00:00 Olivier Dalang <span dir="ltr"><<a href="mailto:olivier.dalang@gmail.com" target="_blank">olivier.dalang@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>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.</div><div>This is a good feature when uploading data through a slow connection (my case these days).</div><div><br></div><div>But I think it would make sense to move this feature (the progress bar) to the DB manager.</div><div>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...</div><div><br></div><div>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).</div><div>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.</div><div>All more efficient ways (pg_dump, ogr2ogr, pgdump,...) are not suited for non power users...</div><div><br></div><div>Bests,</div><div><br></div><div>Olivier<br><br></div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">2015-01-20 14:40 GMT+00:00 Paolo Cavallini <span dir="ltr"><<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all,<br>
is SPIT plugin still functional? Still useful?<br>
AFAIK its main advantage is the possibility of importing multiple files<br>
(but a Processing module is now available for this), and speed.<br>
IMHO this is a good time to evaluate whether we want to drop some parts.<br>
All the best.<br>
<span><font color="#888888">--<br>
Paolo Cavallini - <a href="http://www.faunalia.eu" target="_blank">www.faunalia.eu</a><br>
QGIS & PostGIS courses: <a href="http://www.faunalia.eu/training.html" target="_blank">http://www.faunalia.eu/training.html</a><br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</font></span></blockquote></div><br></div>
</div></div></blockquote></div><br></div>