[Qgis-developer] a SQL console as new feature

[Nathan Woodrow]

Tim,

One step but not exactly what Simon is referring to IMO.   In MapInfo you
have a layer of SQL that you can run on any data type, eg Select * From A,B
WHERE a.obj intersects Bobj

A can be a native MapInfo table and B can be a shape file that you have
opened, or a csv or anything.  This gives the user a lot of power to join
anything to anything and not just on data but spatially.  This is more what
Simon is talking about IMO.  I think it can be done in QGIS just the hardest
thing is supporting all the different providers, but this SQL would another
layer above what is already there and would really only have to talk to
QgsFeature and QgsGeometry as they have everything it needs.

- Nathan

On Wed, May 25, 2011 at 6:20 AM, Tim Sutton <lists at linfiniti.com> wrote:

> Hi
>
> On Sun, May 22, 2011 at 3:22 PM, Simon Georget <simon.georget at gmail.com>
> wrote:
> > Hi list,
> >
> > Firs,t many thanks to all developers and qgis contributors. Qgis is now
> > getting very impressive!
> >
> > I'd like to share an idea that I already shared on SE. See
> > http://gis.stackexchange.com/questions/7295/a-sql-console-in-qgis  (A
> > lecture of the thread could be interesting to understand better).
> >
> > From what i've seen, Qgis is designed to perform easily basic operations
> but
> > makes it harder for full control operations. Actually, I'm also a mapinfo
> > and orbisgis user. These two applications presents the big interest (to
> me)
> > of having an SQL console, which makes gis user life really better.
> > Doing it with mapinfo appears to be easier because is only have one
> > proprietary format to handle. But orbisgis, which is also a foss able to
> > handle several formats, provides the feature whatever the given source is
> > (shapefile, mapinfo, postgis, ...).
> >
> > On SE, Nathan Woodrow supported the idea and already had few thoughts
> about
> > developing such a feature. See his blog :
> >
> http://woostuff.wordpress.com/2011/05/17/the-things-i-would-like-to-see-in-qgis-what-are-yours/
> >
> > Could someone tell me about qgis developer team interest regarding that?
> >
>
> Looks like it may be in scope of this:
>
> http://www.qgis.org/wiki/DB_Manager_plugin_GSoC_2011
>
> Regards
>
> Tim
>
>
> > Many thanks,
> >
> > simo
> >
> >
> >
> > _______________________________________________
> > Qgis-developer mailing list
> > Qgis-developer at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-developer
> >
> >
>
>
>
> --
> Tim Sutton - QGIS Project Steering Committee Member (Release  Manager)
> ==============================================
> Please do not email me off-list with technical
> support questions. Using the lists will gain
> more exposure for your issues and the knowledge
> surrounding your issue will be shared with all.
>
> Visit http://linfiniti.com to find out about:
>  * QGIS programming and support services
>  * Mapserver and PostGIS based hosting plans
>  * FOSS Consulting Services
> Skype: timlinux
> Irc: timlinux on #qgis at freenode.net
> ==============================================
> _______________________________________________
> 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/20110525/dac8e10a/attachment.html