[Kexi] Re: [calligra/kexi-maps-wicik] /: FEATURE: Initial version of Map widget in kexi forms

[Noli Sicad]

On 4/7/11, Jaroslaw Staniek <staniek at kde.org> wrote:
> On 6 April 2011 23:10, Radosław Wicik <radoslaw at wicik.pl> wrote:
>
>> Coming next maps in reports, then connect it to DB for setting and
>> displaying data with/on maps.
>>
>> If that will be ready then I'll try flake shapes.
>>
>> After that I'll go deeper, define new data types:
>>        - points
>>        - lines
>>        - polygons
>> thanks to it it will be possible to add some "zones" on maps,
>> What do you think about this plan?
>>
>> What do you think about me blogging my "way of the Calligra developer"?
>> This would be technical, high level view about the source, and thinks
>> that I found hard to understand or interesting, maybe this would be
>> helpful for somebody?
>
> Hi Radek,
> No doubt it will be helpful! Just make sure your blog is syndicated at
> http://planetkde.org/ before you blog.
> Regarding the data types, it's hard to add it in current kexi, since
> kexidb is feature-frozen. Predicate is not but it's in heavy
> development (refactoring) and I wouldn't like to destabilize it.
>
> I am not 100% sure about the use case. If you mean adding lines,
> points and polygons to the map (by the user), I would recommend using
> some predefined XML (first define it on a wiki page).
> In any kexi database there's kexi__objectdata table where you can save
> extra data string related to any object (here: form and report). Query
> objects use that to store SQL statements and forms use it to store
> QtDesigner-like XML for UIs.

Spatialite, Sqlite GIS extension can do this.

 http://www.gaia-gis.it/spatialite/spatialite-tutorial-2.3.1.html

Noli