Hi, Indeed the usage of mysql for spatial data handling was rather limited some years ago mainly to the fact that until v5.5 spatial support was rather limited to working with minimum bounding rectangles rather than the actual geometries and spatial functions provided quite limited. However since the advent of v5.6 this has changed and mysql now provides precise spatial operations, a quite a rich interface of spatial analysis functions, spatial indexes etc. Maybe it does not yet provide the richness of postgis but it is constantly improving and its performance is quite decent. IMHO when it comes to open source solutions where you want efficiency and robustness for handling both spatial and nonspatial data it might be now the 2nd best option after postgres and I am sure it will gain popularity (regarding spatial usage) in the coming years. Personally, I have built an application for supporting greek cadastral activities using mysql 5.7 and geotools (via udig, I had to extend the geotools mysql-jdbc module a couple of years ago to support mysql v5.6+ ) and I am pretty content with its robustness. The problem of course is that this evolution of mysql spatial comes at the cost of breaking backward compatibility as it is the case for v8.0 (that is why I am still using v5.7).
Στις Τετ, 28 Οκτ 2020 στις 5:51 μ.μ., ο/η Andrea Aime < andrea.a...@geo-solutions.it> έγραψε: > On Wed, Oct 28, 2020 at 3:46 PM Martin Baxter via GeoTools-Devel < > geotools-devel@lists.sourceforge.net> wrote: > >> I'm glad you sometimes get an itch to make progress on this. I read that >> MySQL is the second-most popular database, > > > As a generic relational database that might be still true, but when it > comes to spatial data, it's nowhere to be found. > The store was created many years ago in the spare time of a core > developer, and never gained traction (as in, > it does not generate any sort of business for people involved in the > project). > > Cheers > Andrea > > == GeoServer Professional Services from the experts! Visit > http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf > Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa > (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 > 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.* > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel >
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
