Re: [gdal-dev] Ogr sqlite spatialite shared caching 2.0.1

[kelly elton]

Ah shit. I was trying the sqlite3_ version but I used the wrong case :\

Thanks for the verification and information, it appears to be working.

On Thu, Dec 10, 2015 at 1:45 PM  wrote:

> On Thu, 10 Dec 2015 18:22:09 +, kelly elton wrote:
> > I'm just trying to figure out how to turn on SQlite/Spatialite shared
> > cache in the latest stable version 2.0.1
> >
> > Before I would just call SPLite3_enable_shared_cache but apparently
> > that's been deprecated and doesn't exist anymore.(as well as
> > SPLite4_enable_shared_cache)
> >
> > It also appears that SQLite3_enable_shared_cache doesn't work either.
> >
> > From the docs on Sqlite it says you can enable shared cache per
> > connection via the connection string, but it doesn't look like
> > there's
> > any way to do that in Ogr right now.
> >
> > I'm just looking for suggestions on how to enable it.
> >
>
> Hi Kelly,
>
> all link symbols starting with "SPLite3_" simply were a tricky
> workaround adopted by the infamous (and now officially deprecated)
> spatialite-amalgamation.
>
> the real names for all those symbols are the ones defined by
> libsqlite3 and usually starting with "sqlite3_".
> here you can check the full list of all API supported by SQLite:
>
> https://www.sqlite.org/c3ref/funclist.html
>
> bye Sandro
> ___
> gdal-dev mailing list
> gdal-dev@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Ogr sqlite spatialite shared caching 2.0.1

[a . furieri]

On Thu, 10 Dec 2015 18:22:09 +, kelly elton wrote:

I'm just trying to figure out how to turn on SQlite/Spatialite shared
cache in the latest stable version 2.0.1

Before I would just call SPLite3_enable_shared_cache but apparently
that's been deprecated and doesn't exist anymore.(as well as
SPLite4_enable_shared_cache)

It also appears that SQLite3_enable_shared_cache doesn't work either.

From the docs on Sqlite it says you can enable shared cache per
connection via the connection string, but it doesn't look like 
there's

any way to do that in Ogr right now.

I'm just looking for suggestions on how to enable it. 



Hi Kelly,

all link symbols starting with "SPLite3_" simply were a tricky
workaround adopted by the infamous (and now officially deprecated)
spatialite-amalgamation.

the real names for all those symbols are the ones defined by
libsqlite3 and usually starting with "sqlite3_".
here you can check the full list of all API supported by SQLite:

https://www.sqlite.org/c3ref/funclist.html

bye Sandro
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] Ogr sqlite spatialite shared caching 2.0.1

[kelly elton]

I'm just trying to figure out how to turn on SQlite/Spatialite shared cache
in the latest stable version 2.0.1

Before I would just call SPLite3_enable_shared_cache but apparently that's
been deprecated and doesn't exist anymore.(as well as
SPLite4_enable_shared_cache)

It also appears that SQLite3_enable_shared_cache doesn't work either.

>From the docs on Sqlite it says you can enable shared cache per connection
via the connection string, but it doesn't look like there's any way to do
that in Ogr right now.

I'm just looking for suggestions on how to enable it.
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] OGR and spatialite View

[iomeneandrei]

Dear all,
I have created a spatialite View and ogrinfo does not see any spatialite
View.

Is there some error in my data? Is it OGR able to read spatialite View?

Thank you,

a

-
Andrea Borruso


email: aborr...@tin.it
website: http://blog.spaziogis.it
my 2.0 life: http://aborruso.spaziogis.it
feed: http://feeds2.feedburner.com/Tanto
38° 7' 48 N, 13° 21' 9 E

--
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/OGR-and-spatialite-View-tp6265313p6265313.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR and spatialite View

[Chaitanya kumar CH]

Andrea,

Try to explicitly ask for the view as a layer with ogrinfo. You can also try
to set the SQLITE_LIST_ALL_TABLES environment variable to TRUE.

On Tue, Apr 12, 2011 at 7:46 PM, iomeneandrei aborr...@tin.it wrote:

 Dear all,
 I have created a spatialite View and ogrinfo does not see any spatialite
 View.

 Is there some error in my data? Is it OGR able to read spatialite View?

 Thank you,

 a

 -
 Andrea Borruso

 
 email: aborr...@tin.it
 website: http://blog.spaziogis.it
 my 2.0 life: http://aborruso.spaziogis.it
 feed: http://feeds2.feedburner.com/Tanto
 38° 7' 48 N, 13° 21' 9 E
 
 --
 View this message in context:
 http://osgeo-org.1803224.n2.nabble.com/OGR-and-spatialite-View-tp6265313p6265313.html
 Sent from the GDAL - Dev mailing list archive at Nabble.com.
 ___
 gdal-dev mailing list
 gdal-dev@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/gdal-dev




-- 
Best regards,
Chaitanya kumar CH.
/tʃaɪθənjə/ /kʊmɑr/
+91-9494447584
17.2416N 80.1426E
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR and SpatiaLite

[Yewondwossen Assefa]

Brent,

MS4W 3 Beta 10's OGR was not build with that -DHAVE_SPATIALITE. Next version 
would have it (bug refernece: http://bugzilla.maptools.org/show_bug.cgi?id=2167)

regards,

Brent Fraser wrote:

Tamas,

  I was afraid of that.  I'm having trouble getting MS4W 3 Beta 10's OGR
to read my SpatiaLite database.  I suspect it's because SpatiaLite was
not compiled in (I'm a SQLite newbie so I'm not sure); but there's no
way to tell.

Thanks!
Brent

  

Brent,

It should be SQLite in both cases.

Best regards,

Tamas


2010/3/11 Brent Fraser bfra...@geoanalytic.com



What would ogrinfo --formats show if GDAL was compiled with
HAVE_SPATIALITE set?
What would it show if only SQLite (and not SpatiaLite) was compiled in?

Thanks!
Brent Fraser


___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

  




___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

  



--

Assefa Yewondwossen   
Software Analyst   

Email: ass...@dmsolutions.ca
http://www.dmsolutions.ca/


Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925



___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR and SpatiaLite

[Brent Fraser]

Execellent!  Thanks!

Brent

Yewondwossen Assefa wrote:

Brent,

MS4W 3 Beta 10's OGR was not build with that -DHAVE_SPATIALITE. Next 
version would have it (bug refernece: 
http://bugzilla.maptools.org/show_bug.cgi?id=2167)


regards,

Brent Fraser wrote:

Tamas,

  I was afraid of that.  I'm having trouble getting MS4W 3 Beta 10's OGR
to read my SpatiaLite database.  I suspect it's because SpatiaLite was
not compiled in (I'm a SQLite newbie so I'm not sure); but there's no
way to tell.

Thanks!
Brent

 

Brent,

It should be SQLite in both cases.

Best regards,

Tamas


2010/3/11 Brent Fraser bfra...@geoanalytic.com

   

What would ogrinfo --formats show if GDAL was compiled with
HAVE_SPATIALITE set?
What would it show if only SQLite (and not SpatiaLite) was compiled in?

Thanks!
Brent Fraser


___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

  




___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

  





___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] OGR and SpatiaLite

[Brent Fraser]

What would ogrinfo --formats show if GDAL was compiled with HAVE_SPATIALITE 
set?
What would it show if only SQLite (and not SpatiaLite) was compiled in?

Thanks!
Brent Fraser


___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR and SpatiaLite

[Tamas Szekeres]

Brent,

It should be SQLite in both cases.

Best regards,

Tamas


2010/3/11 Brent Fraser bfra...@geoanalytic.com

 What would ogrinfo --formats show if GDAL was compiled with
 HAVE_SPATIALITE set?
 What would it show if only SQLite (and not SpatiaLite) was compiled in?

 Thanks!
 Brent Fraser


 ___
 gdal-dev mailing list
 gdal-dev@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/gdal-dev

___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR and SpatiaLite

[Brent Fraser]

Tamas,

  I was afraid of that.  I'm having trouble getting MS4W 3 Beta 10's OGR
to read my SpatiaLite database.  I suspect it's because SpatiaLite was
not compiled in (I'm a SQLite newbie so I'm not sure); but there's no
way to tell.

Thanks!
Brent

 Brent,

 It should be SQLite in both cases.

 Best regards,

 Tamas


 2010/3/11 Brent Fraser bfra...@geoanalytic.com

 What would ogrinfo --formats show if GDAL was compiled with
 HAVE_SPATIALITE set?
 What would it show if only SQLite (and not SpatiaLite) was compiled in?

 Thanks!
 Brent Fraser


 ___
 gdal-dev mailing list
 gdal-dev@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/gdal-dev





___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR and SpatiaLite

[Tamas Szekeres]

Check out the recent builds from here:
http://vbkto.dyndns.org/sdk/

Those have been compiled with spatialite support.

Best regards,

Tamas



2010/3/11 Brent Fraser bfra...@geoanalytic.com

 Tamas,

  I was afraid of that.  I'm having trouble getting MS4W 3 Beta 10's OGR
 to read my SpatiaLite database.  I suspect it's because SpatiaLite was
 not compiled in (I'm a SQLite newbie so I'm not sure); but there's no
 way to tell.

 Thanks!
 Brent

  Brent,
 
  It should be SQLite in both cases.
 
  Best regards,
 
  Tamas
 
 
  2010/3/11 Brent Fraser bfra...@geoanalytic.com
 
  What would ogrinfo --formats show if GDAL was compiled with
  HAVE_SPATIALITE set?
  What would it show if only SQLite (and not SpatiaLite) was compiled in?
 
  Thanks!
  Brent Fraser
 
 
  ___
  gdal-dev mailing list
  gdal-dev@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/gdal-dev
 
 




___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev