GeoServer connects to PostGIS directly, either through JDBC props or JNDI. The latter gives you more control over connection pooling using standard Java Servlet technology.
The original question is a classic. Yes, you can write a bunch of code to query PostGIS directly and provide a GeoJSON web service for your apps. For really simple use cases, and when you have really no other need for a Map Server like GeoServer, then that might make sense. But as your solution grows, you will eventually be re-inventing the wheel one piece at a time, when it comes to things like: a proper Query API, resource management, support for 3rd party clients, etc. The GeoServer WFS is stable, robust, and standards compliant. Oh yeah, and free! Jason Newmoyer Newmoyer Geospatial Solutions 843.606.0424 [email protected] On Wed, Jan 29, 2020 at 11:14 AM Rahkonen Jukka (MML) < [email protected]> wrote: > Hi, > > > > Fundamental question: Is it possible to make Geoserver to connect the > PostGIS database directly, or is that database in some external location so > that you must use either files or some service for transporting the data? > Or do you have a master database that keeps the native data and another > database that you are using with Geoserver? > > > > -Jukka Rahkonen- > > > > *Lähettäjä:* Vera Green <[email protected]> > *Lähetetty:* keskiviikko 29. tammikuuta 2020 17.55 > *Vastaanottaja:* Ian Turton <[email protected]> > *Kopio:* geoserver-users <[email protected]> > *Aihe:* Re: [Geoserver-users] Import geojson from Postgis to GeoServer > > > > This makes me wonder if it's more efficient to export geojason from wfs or > directly from PG. Currently I'm going to the database for this in my web > applications. > > Vera > > > > On Wed., Jan. 29, 2020, 3:58 a.m. Ian Turton, <[email protected]> wrote: > > The obvious way to do this is to skip the geojson and just add the PostGIS > tables as new layers, you can export them from GeoServer as GeoJSON using > WFS if you want. > > > > Ian > > > > On Wed, 29 Jan 2020 at 09:48, Vitor Fonseca <[email protected]> wrote: > > > > Hi, > > > > Confusing questions. Please elaborate more on what you want to do... > > > > > > Samann Long <[email protected]> escreveu no dia terça, 28/01/2020 > à(s) 06:12: > > Hello, I am having some troubles with the rest API of importing geojson > from Postgres PostGIS database to Geoserver to create layer and register to > WFS services. > Are there any ways we can do it? > > Thank you > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > > -- > > [image: Lähettäjä poisti kuvan.] > > www.vfonsecaz.pt > > > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > > -- > > Ian Turton > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
