1

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?

6
  • 3
    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, 2018 at 21:18
  • 1
    GeoPackages (like shapefiles) are read at each render, for max performance put your data in a PostGIS DB,
    – Ian Turton
    May 9, 2018 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? May 9, 2018 at 12:26
  • 1
    No, I just always recommend a DB over files on disk.
    – Ian Turton
    May 9, 2018 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, 2018 at 15:23

1 Answer 1

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).

2
  • 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. May 9, 2018 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. May 9, 2018 at 16:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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