# A year's look at Postgres

DevFeed: [A year's look at Postgres](<https://devfeed.tech/articles/a-year-s-look-at-postgres-41165.md>)

Original publisher: [Read original article](<https://www.craigkerstiens.com/2014/03/26/A-years-look-at-Postgres/>)

Author: Map

Published: 2014-03-26T20:55:56Z

Content type: article

Language: en

Sources: [Craig Kerstiens](<https://devfeed.tech/sources/craig-kerstiens.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Security](<https://devfeed.tech/topics/security.md>), [Vulnerabilities](<https://devfeed.tech/topics/vulnerabilities.md>)

Tags: [data-type](<https://devfeed.tech/tags/data-type.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [psql](<https://devfeed.tech/tags/psql.md>), [security](<https://devfeed.tech/tags/security.md>)

## AI overview

The article looks back at highlights from the first year of Postgres Weekly, including PostgreSQL features, the postgresql-hll extension, the psql command-line editor, and coverage of a PostgreSQL security vulnerability.

## Source excerpt

A couple years back I started more regularly blogging, though I've done this off and on before, this time I kept some regularity. A common theme started to emerge with some content on Postgres about once a month because most of what was out there was much more reference oriented. A bit after that I connected with petercooper, who runs quite a few weekly email newsletters. As someone thats been interested helping give others a good reason to create content the obvious idea of Postgres Weekly emerged. Since then we've now had the newsletter running for over a year, helped surface quite a bit of content, and grown to over 5,000 subscribers. First if you're not subscribed, then go subscribe now. And if you need some inspiration or just want to reminisce with me... here's a look back at a few highlights over the past year: The inagural issue Postgres: The Bits You Haven't Found A slide-deck from a presentation at Heroku's Waza conference that highlights many of the more unknown and rare features within Postgres, including 'WITH', arrays, pub/sub, and hstore. Open Source Release:postgresql-hll Aggregate Knowledge released Postgres HyperLogLog, which is a new Postgres datatype hll that strikes a balance between HyperLogLog and a simple set. This data type solves the problem of calculating uniques for a given data set efficiently both in performance and storage. The above is still one of my favorite extensions that most of the world doesn't know about How I Work with Postgres - Psql, My PostgreSQL Admin A common question for anyone new or even experienced with Postgres is whats the best editor out there? Most when they are asking this are asking for a GUI editor, this post highlights much of the power in the CLI 'psql' editor. A mix of notable entries Issue 6 Dissecting PostgreSQL CVE-2013-1899 After the heavily publicized and very serious security vulnerability was patched last week Blackwing intelligence took the chance to dig in. Read more on the details of the vulnerabili