<div>Simon,</div><div><br></div><div>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 <span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; "><a href="http://www.opengeospatial.org/standards/cat" rel="nofollow" style="color: rgb(0, 51, 102); ">OGC Catalog specification</a>. 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. </span></div>
<div><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; "><br></span></div><a href="http://udig.refractions.net/confluence/display/EN/Common+Query+Language" target="_blank">http://udig.refractions.net/confluence/display/EN/Common+Query+Language</a><div>
<br></div><div><a href="http://udig.refractions.net/confluence/display/EN/Common+Query+Language" target="_blank"></a>I'll keep you posted on progress.</div><div><br></div><div>- Nathan<br><br><div class="gmail_quote">
On Wed, May 25, 2011 at 7:05 AM, Nathan Woodrow <span dir="ltr"><<a href="mailto:madmanwoo@gmail.com" target="_blank">madmanwoo@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Tim,<div><br></div><div>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</div>
<div><br></div>
<div>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.</div>
<div><br></div><font color="#888888"><div>- Nathan </div></font><div><div></div><div><div><br><div class="gmail_quote">On Wed, May 25, 2011 at 6:20 AM, Tim Sutton <span dir="ltr"><<a href="mailto:lists@linfiniti.com" target="_blank">lists@linfiniti.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi<br>
<div><div></div><div><br>
On Sun, May 22, 2011 at 3:22 PM, Simon Georget <<a href="mailto:simon.georget@gmail.com" target="_blank">simon.georget@gmail.com</a>> wrote:<br>
> Hi list,<br>
><br>
> Firs,t many thanks to all developers and qgis contributors. Qgis is now<br>
> getting very impressive!<br>
><br>
> I'd like to share an idea that I already shared on SE. See<br>
> <a href="http://gis.stackexchange.com/questions/7295/a-sql-console-in-qgis" target="_blank">http://gis.stackexchange.com/questions/7295/a-sql-console-in-qgis</a> (A<br>
> lecture of the thread could be interesting to understand better).<br>
><br>
> From what i've seen, Qgis is designed to perform easily basic operations but<br>
> makes it harder for full control operations. Actually, I'm also a mapinfo<br>
> and orbisgis user. These two applications presents the big interest (to me)<br>
> of having an SQL console, which makes gis user life really better.<br>
> Doing it with mapinfo appears to be easier because is only have one<br>
> proprietary format to handle. But orbisgis, which is also a foss able to<br>
> handle several formats, provides the feature whatever the given source is<br>
> (shapefile, mapinfo, postgis, ...).<br>
><br>
> On SE, Nathan Woodrow supported the idea and already had few thoughts about<br>
> developing such a feature. See his blog :<br>
> <a href="http://woostuff.wordpress.com/2011/05/17/the-things-i-would-like-to-see-in-qgis-what-are-yours/" target="_blank">http://woostuff.wordpress.com/2011/05/17/the-things-i-would-like-to-see-in-qgis-what-are-yours/</a><br>
><br>
> Could someone tell me about qgis developer team interest regarding that?<br>
><br>
<br>
</div></div>Looks like it may be in scope of this:<br>
<br>
<a href="http://www.qgis.org/wiki/DB_Manager_plugin_GSoC_2011" target="_blank">http://www.qgis.org/wiki/DB_Manager_plugin_GSoC_2011</a><br>
<br>
Regards<br>
<br>
Tim<br>
<br>
<br>
> Many thanks,<br>
><br>
> simo<br>
><br>
><br>
><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>
><br>
><br>
<br>
<br>
<br>
--<br>
Tim Sutton - QGIS Project Steering Committee Member (Release Manager)<br>
==============================================<br>
Please do not email me off-list with technical<br>
support questions. Using the lists will gain<br>
more exposure for your issues and the knowledge<br>
surrounding your issue will be shared with all.<br>
<br>
Visit <a href="http://linfiniti.com" target="_blank">http://linfiniti.com</a> to find out about:<br>
* QGIS programming and support services<br>
* Mapserver and PostGIS based hosting plans<br>
* FOSS Consulting Services<br>
Skype: timlinux<br>
Irc: timlinux on #qgis at <a href="http://freenode.net" target="_blank">freenode.net</a><br>
==============================================<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>
</blockquote></div><br></div>
</div></div></blockquote></div><br>
</div>