[Qgis-developer] a SQL console as new feature

[Nathan Woodrow]

Simon,

I started working on a very rough (read: try to much and it will explode)
prototype in Python today, if I get something usable at some stage I will
throw it up on github .  It's not going to handle geometry stuff right away,
just basic Select {columns} from {tables} where {foo} = {bar}.  But for a
prototype it will do for now.

The abstraction layer is QgsVectorLayer and QgsFeature which means you can
just use those to classes to handle joining and comparing features for any
dataset.

Nathan

On Tue, Jun 14, 2011 at 5:34 PM, Simon Georget <simon.georget at gmail.com>wrote:

> @noli > Thanks but it is is not the feature I'm looking for. See Nathan's
> answer and give a try to Orbisgis or Mapinfo -mapbasic console! ;-))
>
> @Nathan > I totally share your point of view. It should be a core feature,
> and even more I think it could be a backbone of the application
> architecture, since it changes the way you handle all inputs and queries.
> But for now, it just has to be a proof of concept .....
> How inputs are taken in charge for now? I guess there is already an
> abstraction layer or something, no?
>
>
>
> On Tue, Jun 14, 2011 at 1:45 AM, Nathan Woodrow <madmanwoo at gmail.com>wrote:
>
>> 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 <nsicad at 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.georget at 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 <madmanwoo at 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.sk at gmail.com>wrote:
>>> >>
>>> >>> QgsSearchString
>>> >>
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> Qgis-developer mailing list
>>> >> Qgis-developer at lists.osgeo.org
>>> >> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>> >>
>>> >>
>>> >
>>> _______________________________________________
>>> 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/20110614/145e83fb/attachment-0001.html