Difference between revisions of "Panorama SIG Libre 2014/Bases de datos"

From OSGeo
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
  [https://github.com/OSGeo-ES/panorama-siglibre8/issues/8 discussion] (in Spanish)
 
  [https://github.com/OSGeo-ES/panorama-siglibre8/issues/8 discussion] (in Spanish)
  
−
== Introduction ==  
+
== Main Information ==  
−
 
 
−
Some databases have spatial extensions that can be used to store geometrical data and operate them. Short history about this TODO.
 
−
 
 
−
== State of the Art ==
 
−
 
 
−
Dentro de la sección, hacia donde se está moviendo la comunidad.
 
−
 
 
−
== Software ==
 
−
 
 
−
This database extensions are usually based on a basic geometric data type you can operate with. The only background you really need to use this geometric database extensions is the same as working with any database.
 
  
 
{| class="wikitable sortable"  style="text-align: center;"
 
{| class="wikitable sortable"  style="text-align: center;"
Line 23: Line 13:
 
! Ohloh
 
! Ohloh
 
! Tech
 
! Tech
−
! OGC Compliant
+
|-
 +
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 +
| 2000
 +
| {{no|☹}}
 +
| {{no|☹}}
 +
| [http://www.mysql.com/about/legal/licensing/oem/ Oracle]
 +
| [http://www.ohloh.net/p/mysql ohloh]
 +
| C/C++
 
|-
 
|-
 
| [http://postgis.net/ PostGIS]
 
| [http://postgis.net/ PostGIS]
Line 32: Line 29:
 
| [http://www.ohloh.net/p/postgis ohloh]
 
| [http://www.ohloh.net/p/postgis ohloh]
 
| C/C++
 
| C/C++
−
| {{yes|✓}}
 
−
|-
 
−
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 
−
| ???
 
−
| {{no|☹}}
 
−
| {{no|☹}}
 
−
| [http://www.mysql.com/about/legal/licensing/oem/ Oracle]
 
−
| [http://www.ohloh.net/p/mysql ohloh]
 
−
| C/C++
 
−
| {{yes|☹}}<ref name="partially">Partially supported</ref>
 
 
|-
 
|-
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
Line 50: Line 37:
 
| [http://www.ohloh.net/p/spatialite ohloh]
 
| [http://www.ohloh.net/p/spatialite ohloh]
 
| C/C++
 
| C/C++
−
| {{yes|☹}}<ref name="partially"/>
 
 
|-
 
|-
 
| [http://www.h2gis.org/ H2GIS]
 
| [http://www.h2gis.org/ H2GIS]
Line 59: Line 45:
 
| {{no|☹}}
 
| {{no|☹}}
 
| Java
 
| Java
−
| {{yes|✓}}
 
 
|-
 
|-
 
|}
 
|}
Line 73: Line 58:
 
|-
 
|-
 
| [http://postgis.net/ PostGIS]
 
| [http://postgis.net/ PostGIS]
−
|  
+
| {{yes|✓}}
−
|
+
| {{yes|✓}}
 
| {{yes|✓}}
 
| {{yes|✓}}
 
|-
 
|-
 
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
−
|  
+
| {{no|☹}}
−
|  
+
| {{no|☹}}
−
|  
+
| {{yes|☹}}<ref name="partially">Partially supported</ref>
 
|-
 
|-
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
−
|  
+
| {{yes|✓}}
−
|  
+
| {{yes|✓}}
 +
| {{yes|✓}}
 
|-
 
|-
 
| [http://www.h2gis.org/ H2GIS]
 
| [http://www.h2gis.org/ H2GIS]
−
|  
+
| {{yes|✓}}
−
|  
+
| {{yes|✓}}
−
|  
+
| {{yes|✓}}
 
|-
 
|-
 
|}
 
|}

Latest revision as of 23:57, 16 March 2014

Work in progress

discussion (in Spanish)

Main Information

Name Year OSGeo Live License Ohloh Tech
MySQL Spatial 2000 ☹ ☹ Oracle ohloh C/C++
PostGIS 2005 G ✓ GPL v2 ohloh C/C++
Spatialite 2008 ☹ ☹ MPL tri-license ohloh C/C++
H2GIS 2008 ☹ ☹ GPL3 ☹ Java

Compliance with Simple Feature Access OGC Standard

Name Binary Geometry Normalized Geometry Types and Functions
PostGIS ✓ ✓ ✓
MySQL Spatial ☹ ☹ ☹[1]
Spatialite ✓ ✓ ✓
H2GIS ✓ ✓ ✓
  1. ↑ Partially supported

Documentation

Name Full Documentation Where to start
PostGIS Official 2.0 doc Introduction
MySQL Spatial Official 5.0 doc No Official one
Spatialite Official 2.3.1 doc 5 minutes
H2GIS Official doc Quick-start guide

More info here.

Examples

References

Retrieved from "http://wiki.osgeo.org/w/index.php?title=Panorama_SIG_Libre_2014/Bases_de_datos&oldid=77313"