# Implementing "seen by" functionality with Postgres

DevFeed: [Implementing "seen by" functionality with Postgres](<https://devfeed.tech/articles/implementing-seen-by-functionality-with-postgres-547.md>)

Original publisher: [Read original article](<https://supabase.com/blog/seen-by-in-postgresql>)

Author: Victor

Published: 2022-07-18T07:00:00Z

Content type: article

Language: en

Sources: [Supabase Blog](<https://devfeed.tech/sources/supabase-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [testing](<https://devfeed.tech/tags/testing.md>)

## AI overview

The article examines approaches for implementing "seen by" functionality in PostgreSQL to track content views across posts. It begins with a simple per-post counter and discusses the complexity of counting unique or repeated views, with HyperLogLog presented as a reasonable approach with useful trade-offs.

## Source excerpt

Different approaches for tracking visitor counts with PostgreSQL.