Spatialite libraries for Windows 8 Modern UI application

[MCh]

Hello,

I am going to develop application that is using Spatialite database under Windows 8 Modern UI (desktop and tablets).
I can't find any examples and drivers how to do it. I found only SQLite drivers that can be installed into Visual Studio.

Best Regards,
Maciej

[noel.frankinet]

Le 20/05/2013 09:29, MCh a �crit :
Hello,

What language do you plan to use ?

No�l

> --
> You received this message because you are subscribed to the Google
> Groups "SpatiaLite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to spatialite-use...@googlegroups.com.
> To post to this group, send email to spatiali...@googlegroups.com.
> Visit this group at http://groups.google.com/group/spatialite-users?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[MCh]

Hello,

I want to create application in C#.
I have tested System.Data.SQLite under desktop application. In desktop this is simple. Just load file libspatialite-4.dll by load_extension SQLite function (using standard libraries downloaded from "http://www.gaia-gis.it/gaia-sins/" website.
Native SQLite driver for Wndows Modern UI (sqlite-net) does not work.

Best Regards,
Maciej

W dniu poniedziałek, 20 maja 2013 11:53:54 UTC+2 użytkownik nfr napisał:

Le 20/05/2013 09:29, MCh a �crit :

Hello,

What language do you plan to use ?

No�l

[Brad Hards]

On 20/05/13 20:02, MCh wrote:
> I want to create application in C#.
> I have tested System.Data.SQLite under desktop application. In desktop
> this is simple. Just load file libspatialite-4.dll by load_extension
> SQLite function (using standard libraries downloaded from
> "http://www.gaia-gis.it/gaia-sins/" website.
> Native SQLite driver for Wndows Modern UI (sqlite-net) does not work.

[It would be better if you could post answers below questions - makes it
flow better.]

Are you saying that sqlite works OK in both environments, but spatialite
doesn't work in the non-desktop environment? That seems really strange.
Or are you saying that sqlite doesn't work in the non-desktop environment?

If its the later, then spatialite probably isn't your problem, and
perhaps you need to ask the sqlite driver developers / users?

I haven't really worked with Win8 development yet, hence my vague answers.

Brad

[Noel Frankinet]

Load extension is often disabled in precompiled libraries. If its the case, spatalite cannot be loaded.

--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-users+unsubscribe@googlegroups.com.
To post to this group, send email to spatialite-users@googlegroups.com.

Visit this group at http://groups.google.com/group/spatialite-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

--
Noël Frankinet
Strategis sprl
0478/90.92.54

[a.fu...@lqt.it]

> Load extension is often disabled in precompiled libraries. If its the
> case, spatalite cannot be loaded.
>

Surely YES
please read this old document for more details:
http://www.gaia-gis.it/gaia-sins/spatialite-arch-2.3.1.html#trap

anyway it should be noted that in more recent times this issue
seems to become less frequent than before.

when SQLite initially introduced the "load_extension" mechanism
this innovative feature was always disabled by default (an explicit
--enable option was then required at configure/build time).
but since many years all recent versions of SQLite will behave
exactly in the opposite way: now always enabling dynamic extensions
loading is the silent default choice; a system packager has to
take an explicit configure action in order to keep disabled this
option.
this change in default settings helped a lot, and many SQLite
language bindings (even on Windows) now support dynamic extension
loading; evidently few exceptions to this general rule still
resist here and there.

in this is your case, you as an user/developer simply have to face
two possible ways:
a) switching to some alternative language/toolkit being less paranoid
and more sane-minded (not always a viable alternative)
b) insistently asking the system packagers to quickly change their
build settings (sometimes such an action could be successful)

bye Sandro

--
Il messaggio e' stato analizzato alla ricerca di virus o
contenuti pericolosi da MailScanner, ed e'
risultato non infetto.