Re: [Qgis-developer] a SQL console as new feature
There is a new plugin - a console, Fast SQL Layer for QGIS. Have you seen this? http://underdark.wordpress.com/2011/05/25/fast-sql-layer-for-qgis/ Noli On 6/14/11, Simon Georget simon.geor...@gmail.com wrote: Hi, Sorry to reply lately and thanks for your interest on this topic. Nathan has done a good description of my request and reading from you make me think it is not impossible. Do you think this can be developed as plugin? If yes, I would be happy to work with some of you interested but unfortunetly I don't think I could handle that alone, since I don't know the QGIS API yet, I don't speak fluently python (but I can play with it) and I don't have that much time. Just let me know Regards, simon On Wed, May 25, 2011 at 3:08 PM, Nathan Woodrow madman...@gmail.com wrote: Thanks Martin, I'll check them out. I have seen them before but never really looked into them. - Nathan On Wed, May 25, 2011 at 11:06 PM, Martin Dobias wonder...@gmail.comwrote: QgsSearchString ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] a SQL console as new feature
Not really what Simon is getting at. I guess not many people on here are MapInfo users as well. MapInfo's SQL allows you to query any datasource using SQL, so you could do Select * From table1,Table2 where table1.comecolumn 10. Where table2 is a shape file and table1 is a tab file. @Simon Yes I think you could do it via a plugin although I'm not sure how it would go on speed. And stuff like this should really be built into the program. I'll investigate the plugin route if only as a prototype. - Nathan On Tue, Jun 14, 2011 at 9:18 AM, Noli Sicad nsi...@gmail.com wrote: There is a new plugin - a console, Fast SQL Layer for QGIS. Have you seen this? http://underdark.wordpress.com/2011/05/25/fast-sql-layer-for-qgis/ Noli On 6/14/11, Simon Georget simon.geor...@gmail.com wrote: Hi, Sorry to reply lately and thanks for your interest on this topic. Nathan has done a good description of my request and reading from you make me think it is not impossible. Do you think this can be developed as plugin? If yes, I would be happy to work with some of you interested but unfortunetly I don't think I could handle that alone, since I don't know the QGIS API yet, I don't speak fluently python (but I can play with it) and I don't have that much time. Just let me know Regards, simon On Wed, May 25, 2011 at 3:08 PM, Nathan Woodrow madman...@gmail.com wrote: Thanks Martin, I'll check them out. I have seen them before but never really looked into them. - Nathan On Wed, May 25, 2011 at 11:06 PM, Martin Dobias wonder...@gmail.comwrote: QgsSearchString ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] a SQL console as new feature
On 5/25/11, Nathan Woodrow madman...@gmail.com wrote: 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 Hi Nathan in QGIS we have something similar, maybe not that advanced: look for QgsSearchString and QgsSearchTreeNode classes. They were originally created for advanced search in the attribute table supporting a subset of SQL, more recently it is possible to use those classes also for evaluation of expressions. Martin ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] a SQL console as new feature
Thanks Martin, I'll check them out. I have seen them before but never really looked into them. - Nathan On Wed, May 25, 2011 at 11:06 PM, Martin Dobias wonder...@gmail.com wrote: QgsSearchString ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] a SQL console as new feature
Hi On Sun, May 22, 2011 at 3:22 PM, Simon Georget simon.geor...@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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] a SQL console as new feature
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 li...@linfiniti.com wrote: Hi On Sun, May 22, 2011 at 3:22 PM, Simon Georget simon.geor...@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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
[Qgis-developer] a SQL console as new feature
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? Many thanks, simo ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer