GeoServer VS PostGIS

GeoServer Reviews

PostGIS Reviews

GeoServer mentions (9)

• GIS Developer career path

  If you want to get into web GeoDjango is a popular option for the backend, but you could also learn to roll your own with flask/FastAPI. You also have some choice of JavaScript libraries for the frontend, [Leaflet]() and [OpenLayers]() are likely the most popular frameworks, but there are others (personally I'd recommend OpenLayers as it's the only one backed by OSGeo as far as I know). It also wouldn't hurt to... Source: over 1 year ago

• Volunteering for FOSS4G

  Java: https://geoserver.org - the ogcapi work is a "community" module because it is not ready yet. Source: over 1 year ago

• Self Hosting a Google Maps Alternative with OpenStreetMap

  Thank you! It's on my todo-list to set up such a server and your work will really help with it. Here is another excellent write-up from Stefan Erhardt who is the founder of OpenTopoMap [0][1] which gives step-by-step instructions [2] on how to set up a tile server with custom tile rendering, also based on OSM's data. Also worth mentioning is GeoServer [3] [0] https://opentopomap.org/ [1]... - Source: Hacker News / over 1 year ago

• Making a web based map working with millions of records

  ArcGIS Online could be the right move as long as you set up the service correctly. You could also load the shapefile into a database like PostgreSQL and connect to the database via an API like Geoserver FastVector, or pg_tileserv. This would cause a lot more time, cost, and knowledge on your end though to host a database and api vs loading the data into the ESRI ecosystem. Source: over 1 year ago

• Which tile server should I use? Terracotta or Geoserver or is there a better one?

  I am currently working on setting up a web app using leaflet that can display .tif images along with some polygons and add some filters in the web app to better interact with the data. In the process of implementing this, I came to know that I need to use a tile server because I have large amounts of data and the tile server can help to serve the tiles on the web app. Based on my research, I guess these two are... Source: almost 2 years ago

PostGIS mentions (1)

• Efficient Distance Querying in MySQL

  This is an interesting article about strategies to use when traditional indexes just won't do, but for the love of the index please use MySQL's (or postgres' or sqlite's) built in spatial index for this particular class of problems. It will does this sort of thing much, much more efficiently than 99% of in house solutions. https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html... - Source: Hacker News / over 2 years ago