I am building a website that will present spatial data (Leaflet) and I plan to include functionalities like: add, move, delete features (i.e. by clicking on the map or on the feature) I would like to use PostGIS as DB.
Should I use a GeoServer and if so why?
I was planning to store vector data and request them as GeoJSON from DB. The approximate amount of records (10 000 - 100 000).
GeoServer is a very full-featured geospatial web service solution. But if all you want is to serve GeoJSON from PostGIS, there are other options which might be simpler to deploy, manage, configure and secure.
For instance, the Crunchy Data pg-featureserv server implements the new OGC API for Features protocol (aka WFS3), which is based on modern web standards (such as is REST, OpenAPI, and GeoJSON). It has some nice features such as ability to serve layers defined by Postgres/PostGIS functions. It provides "DB-only" configuration, and is 100% focussed on serving PostGIS spatial data.
