Hi Xavier, First, I would not recommend to use a file as store for a possible concurrent read/write access data source, this could lead to several unexpected issues on your production environment. Indeed using a database is the best idea for storing/caching data-in-motion snapshots, and Postgresql/Postgis is good for this.
You can update your datasource data with GeoServer WFS-T. With this method you can insert, update, and delete features sending HTTP requests to Geoserver using GML. This is the simplest approach and it supports Postgresql. https://docs.geoserver.org/latest/en/user/services/wfs/reference.html On advanced approaches, you can use an standalone service to ingest data changes and push them directly to the database, for example: - A simple spring boot service polling the data changes and storing them directly to posgis using jdbc or Geotools datastores API. Simple and recommended if your updates are not heavy. - A small Apache Kafka client service receiving the data capture events and sending them to a distributed ingestion system (Kafta streams, Spark streaming, Flink, Storm, ... ). This is a complex approach and only valid when you need to "internet scale" your system having big and concurrent updates. Regards, Fernando Mino == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Fernando Mino Software Engineer GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail. From "XAVIER RAYO SARRIAS" [email protected] To [email protected] Cc Date Mon, 18 May 2020 12:59:16 +0200 Subject [Geoserver-users] Load realtime csv, GML or geoJson in Geoserver for Real time data Hi all, I would like to load a csv, GML or geojson layer to geoserver. The thing is that this layer stores some gps position (and other data) that is updated every minute and would like to refresh the layer also every minute or so. I've read that it could be done using postgres/postgis but don't really know how to do it and that's why I was wondering if it could be done with a simple file. Thank you very much for your help! xavi
_______________________________________________ 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
