[Qgis-developer] a SQL console as new feature

[Nathan Woodrow]

Simon,

I was having a look around today and it seems uDig do some like MapInfo in
regards to SQL.  uDig uses CQL (Comman Query Language) that is part of the OGC
Catalog specification <http://www.opengeospatial.org/standards/cat>.  I'm
going to check out the code for uDig to see how they have done it and see if
something can be done like that in QGIS.

http://udig.refractions.net/confluence/display/EN/Common+Query+Language

<http://udig.refractions.net/confluence/display/EN/Common+Query+Language>I'll
keep you posted on progress.

- Nathan

On Wed, May 25, 2011 at 7:05 AM, Nathan Woodrow <madmanwoo at gmail.com> wrote:

> 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/6b91a569/attachment.html