Articles in postgis

GeoFile: Everything in the Radius with PostGIS

GeoFile is a series dedicated to looking at geographical data, its features and uses. In this article, we build upon our last discussion of getting the distance between two points, and now move to getting all data points within a specified radius. On…

Continue reading »

Compose NewsBits: PostgreSQL 9.6, Neural Redis, GraphQL, Nmap, Erlang, SETI and chatbots

Compose NewsBits for the week ending September 30th: PostgreSQL 9.6 is out and so is PostGIS 2.3 and Barman 2.0, Redis gets a neural plugin to embed machine learning in the database, GraphQL gets some nice examples, Nmap gets an update, Erlang's nice…

Continue reading »

GeoFile: Getting the distance using Redis and PostgreSQL

GeoFile is a series dedicated to looking at geographical data, its features and uses. In this article, we discuss getting the distance between two points on a map and how Redis and the PostgreSQL extension PostGIS approach this problem. The most comm…

Continue reading »

Compose NewsBits: MySQL 8.0, Angular 2, Swift 3, Vim 8 and more

Compose NewsBits: MySQL 8.0 is now official and there's a MySQL vulnerability about, Angular 2 and Swift 3 are finalised, PostGIS 2.3 goes beta, Vim's back with version 8.0 and we look at a database that's a quine and a Tiny Lisp computer. NewsBits i…

Continue reading »

GeoFile: Spatial Reference Systems and Databases

GeoFile is a series dedicated to looking at geographical data, its features and its uses. In this article, we discuss spatial reference systems, what EPSG codes are, and how databases handle and transform them. Having and knowing what the right spati…

Continue reading »

GeoFile: Converting and importing shapefiles for Compose PostgreSQL and MongoDB

GeoFile is a series dedicated to looking at geographical data, its features and its uses. In this article, we discuss how to convert shapefiles into SQL and GeoJSON and import them into Compose PostgreSQL and MongoDB. When viewing geographical data o…

Continue reading »

Compose's Little Bits #19 - Sleepy SQL injections, MySQL JSON, PostGIS and more

Using SLEEP() in SQL Injections, using JSON in MySQL, sprinting for PostGIS features, the biggest SSDs yet, Rust's latest flakings, jQuery 3 previewed, OSX installer woes, an ECG in a business card and this year's Turing Award – all the links that ca…

Continue reading »

Compose's Little Bits #8

A collection of links that have caught the eye of Compose's Technical Content Curator over the past week. This week, Nimrod for MongoDB, Massive.js for PostgreSQL, PostGIS, UUIDs, PHP 7, curl, ghi, OpenSSL and some Cutting. Database-y Nimrod - As an…

Continue reading »

PostGIS for All Compose PostgreSQL Deployments

We've been getting great feedback from our customers since our roll out of PostgreSQL deployments on Compose. One of the first and repeated requests we have received during was for PostGIS support and while others may make PostGIS an option, we've d…

Continue reading »