0

I'm currently working on a GeoServer deployment and for simplicity, I want to to transition to using GeoPackages rather than Shapefiles (longer column names, less work integrating the data, etc.).

As GeoPackages are based on the SQLite3 standard there's a possibility that, with too many connections, users won't be able to read the polygons saved within a GeoPackage. (Here's a similar discussion on StackOverflow).

I'm not sure whether GeoServer loads shapefiles and other data into a database that can accommodate 100s of users, or if it simply reads shapefiles/other vector data directly when a user demands access to them. While other SE's may know more about DBMSes, I felt this question was appropriate for the GIS SE users who have more likely used GeoServers.

My question is what are the connection limitations for GeoPackages served through GeoServer?

  • 2
    docs.geoserver.org/latest/en/user/community/geopkg/input.html. The discussion in your link is not appropriate for your use case if your users just read data, not write with WFS-T. – user30184 May 8 '18 at 21:18
  • GeoPackages (like shapefiles) are read at each render, for max performance put your data in a PostGIS DB, – Ian Turton May 9 '18 at 8:10
  • @Ian with the work I did this winter on geopackage, there should not be significant performance differences left. Do you have tests showing otherwise? – Andrea Aime May 9 '18 at 12:26
  • No, I just always recommend a DB over files on disk. – Ian Turton May 9 '18 at 12:28
  • GeoPackage is a database as well and PostGIS data files are also stored on disk. Recommendation should perhaps be based on some other facts. – user30184 May 10 '18 at 15:23
3

There is no connection limitation if you're using version 2.13.x (warmly recommended, it's significantly faster than older versions when it comes to geopackages), but you'll eventually hit the max number of open files limit (which you can raise, in different ways according to the operating system in use).

  • That's great to hear and it clarifies many of my concerns. Thanks! I know this breaks SE conventions, but on a side note, I've been following the discussion concerning SLD loading from GeoPackage to GeoServer. Is there a site/GitHub repo where I can find news on that project? All the best. – Trevor J. Smith May 9 '18 at 14:08
  • At the moment there is nothing I'm afraid, after the initial impetus the thing seems to have died down... we'll see. Check the geotools project developer list archives and geotools pull request queue. – Andrea Aime May 9 '18 at 16:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.