Working with geospatial data in Postgres.
PostgreSQL has several extensions so spatial and geometry data can be treated as first-class objects within your PostgreSQL database.
By
Nick Arner
Articles
By
Nick Arner
Using indexing to optimize database search performance.
Your intuition about indexing might be broken. Here's how to use indexing to optimize database search performance.
a year ago
A primer on database replication.
Replicating a database can make our applications faster and increase our tolerance to failures.
a year ago
You can probably do it in SQL.
All that code you're writing? You may as well do it in SQL.
a year ago
PostgreSQL is an ORDBMS. What does that mean?
PostgreSQL is an ORDBMS, or an Object-Relational Database Management System. This means that, similar to Object-Oriented programming languages, objects, classes, and inheritance are supported by PostgreSQL.
By
Nick Arner
A very short guide to choosing between MySQL and PostgreSQL.
While MySQL and PostgreSQL have many things in common, you should make sure you understand the differences between them in order to make sure you select the right one for your specific application.
a year ago
By
Kevin Zhang
By
Saba Yasrebi