[Qgis-user] columns in spatialite

[kimaidou]

Hi,

You could probably try the last "master" QGIS and processing, as René-Luc
(rldhont) added a couple of days ago the ability to save scripts and algs
result layers into a spatialite database. Combined with the tool "Refactor"
( visible in the Processing toolbox), and using your initial spatialite
table, this could do the trick without the need to create a new plugin for
this.

Regards
Michaël

2015-11-10 15:42 GMT+01:00 Bernd Vogelgesang <bernd.vogelgesang at gmx.de>:

> Hi Micha,
>
> yeah, working with spatialite dbs "seriously" is still quite uncomfortable.
> When I try, I mostly have to use all available means to get the work done:
> DBManager, QSpatialite, SpatialiteGUI. Unfortunately I easily forget how
> sql works, so doing "easy" stuff becomes very time consuming and
> frustrating.
>
> Do you think it would be technically possible to create a plugin like
> Table Manager plugin, that records the changes you want to do to the table
> and then creates the necessary sql commands and performs all that stuff in
> one go?
>
> Cause this would be sth I really would be interested donating money on!
>
> Cheers
> Bernd
>
> Am 10.11.2015, 15:26 Uhr, schrieb Micha Silver <micha at arava.co.il>:
>
> I have found that QGIS cannot "see" any spatialite column that comes after
> the "geometry" column. When I alter a table, adding a column in a
> Spatialite, the new column which is after the geometry column in the
> database table just does not appear in QGIS. If I recreate the table,
> reordering the columns so that the geometry is last, all is good again.
>
> Is this a bug? or am I missing something?
>
> It's quite annoying considering that sqlite does not have any simple way
> to shuffle the columns around, other than dropping and recreating the
> table. And if I have foreign constraints defined, it becomes a whole row of
> dominoes that come down...
>
> Thanks,
> Micha
>
>
>
>
> --
> Bernd Vogelgesang
> Siedlerstraße 2
> 91083 Baiersdorf/Igelsdorf
> Tel: 09133-825374
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151110/3a002aab/attachment.html>