[Qgis-user] columns in spatialite

[Bernd Vogelgesang]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151110/6462dc3f/attachment.html>