Breaking News

geodatabases

MySQL and Geospatial Programming

MySQL and Geospatial Programming

Join Percona Sr. Consultant Michael Benshoof as he discusses: -The various tasks that deal with geocoding -How MySQL can solve problems such as points within a radius (e.g., “Find the 10 closest coffee shops) among others -Highlights from some of the new features bundled in the upcoming 5.7 release, and what benefits they can bring to your applications

Read More »

Getting Started With QGIS and PostGIS

Getting Started With QGIS and PostGIS

How to get the most of these two popular Open-Source GIS software Why you should care to learn QGIS and PostGIS How can a DBMS protect your data What is the potential of PostGIS How to combine PostGIS and QGIS into a powerful platform

Read More »

Spatial Database Tips for PostGIS, Oracle, & SQL Server

Spatial Database Tips for PostGIS, Oracle, & SQL Server

Become a database dynamo with these productivity-boosting tips. Discover how to connect your spatial database with 325+ data sources – including tabular, raster and GIS – without any coding. You’ll see how to spatialize ordinary data, view it on a map, and learn about automated techniques for updates/deletes, edit/change detection, as well as data validation.

Read More »

PostGIS Feature Frenzy

PostGIS Feature Frenzy

What can you do with this PostGIS thing? This talk covers some basic and not­so­basic ways to use PostGIS/PostgreSQL to process spatial data, to build infrastructures, and to do crazy things with data. PostGIS has over 300 functions, which in turn can be used with the many features of the underlying PostgreSQL database. This talk covers some basic and not­so­basic ...

Read More »

Modern SQL in PostgreSQL

Modern SQL in PostgreSQL

SQL has gone out of fashion lately — partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, the SQL standard continued to evolve during the past decades resulting in the current release of 2011. In this session, we will go through the most important additions since ...

Read More »

Tracing PostgreSQL performance

Tracing PostgreSQL performance

“How could I trace a session in PostgreSQL” – this is quite a common question from an Oracle/DB2 DBA, who is new to Postgres. Usually we start to mumble something about systemtap/perf and pgstatbgwriter. Although these tools are great and useful, but they do not exactly meet this need, and besides, some of them are really difficult to use. In ...

Read More »