# PostgreSQL: Data is Important

DevFeed: [PostgreSQL: Data is Important](<https://devfeed.tech/articles/postgresql-data-is-important-15806.md>)

Original publisher: [Read original article](<https://developer.squareup.com/blog/postgresql-data-is-important>)

Author: Square Engineering

Published: 2011-06-06T16:00:00Z

Content type: article

Language: en

Sources: [Square Corner Blog RSS Feed](<https://devfeed.tech/sources/square-corner-blog-rss-feed.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Web](<https://devfeed.tech/topics/web.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Geographic Information System](<https://devfeed.tech/topics/gis.md>)

Tags: [algorithms](<https://devfeed.tech/tags/algorithms.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [data](<https://devfeed.tech/tags/data.md>), [durability](<https://devfeed.tech/tags/durability.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [full-text-search](<https://devfeed.tech/tags/full-text-search.md>), [gis](<https://devfeed.tech/tags/gis.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [search](<https://devfeed.tech/tags/search.md>), [sql](<https://devfeed.tech/tags/sql.md>), [statement](<https://devfeed.tech/tags/statement.md>), [types](<https://devfeed.tech/tags/types.md>), [web](<https://devfeed.tech/tags/web.md>)

## AI overview

This article presents a case for using PostgreSQL in a modern web architecture. It describes PostgreSQL features including migration support, indexes, transactional DDL, constraints, streaming replication, query planning, PostGIS, and full-text search.

## Source excerpt

A case for PostgreSQL in a modern web architecture.