← Graph

PostgreSQL

tool 24 connections

Open-source relational database. In this talk framed as the incumbent being migrated away from. Postgres uses MVCC row-level locking allowing many concurrent writers on disjoint rows, exposes clear foreign-key error messages, has types (inet, uuid, interval, arrays) and functions (casts, array operators, ILIKE) that SQLite lacks or implements differently. Wrona kept Postgres during the schema refactor and only switched to SQLite after types/constraints/queries were made compatible.

category
service
talk Fantastic Databases and Where to Find Them
about
PostgreSQL tool
Bulk of the talk explores Postgres features.
talk LATERAL Joins Rails Performance Lightning Talk
about
PostgreSQL tool
All three optimized queries target PostgreSQL features (≥ 8.4 for CTE, ≥ 9.3 for LATERAL).
talk Nightmare neighbours caveats of Rails based mutlitenancy
about
PostgreSQL tool
Row-level security and session parameters discussed in the Postgres context.
question Per-tenant read models via database views
about
PostgreSQL tool
Discusses PL/pgSQL views as a separation mechanism.
talk How (and why) to run SQLite in production
about
PostgreSQL tool
Extensive comparison between running SQLite and running Postgres in various cloud topologies.
question Is starting with SQLite a lock-in if I later need Postgres?
about
PostgreSQL tool
Question asks about migrating away from SQLite to Postgres.
talk Performance Panel wroclove.rb 2024
about
PostgreSQL tool
Recommended as the default for big filterable endpoints.
talk From PostgreSQL to SQLite in Rails
about
PostgreSQL tool
Migration source database; many trade-offs are discussed relative to Postgres.
question Why not just run a local Postgres instance?
about
PostgreSQL tool
Compares running Postgres locally versus embedded SQLite.
person Krzysztof Hasiński
recommends
PostgreSQL tool
Calls Postgres 'probably the best open-source project ever'.
concept Aggregate-Scoped Sequence Number
related_to
PostgreSQL tool
Pašalić recommends a store with constraint support such as PostgreSQL to enforce per-aggregate sequence numbers.
tool Citus
related_to
PostgreSQL tool
Citus is a Postgres extension.
tool PgHero
related_to
PostgreSQL tool
PgHero is a Postgres performance dashboard.
concept EXPLAIN / EXPLAIN ANALYZE
related_to
PostgreSQL tool
EXPLAIN is a Postgres feature.
concept Window Functions
related_to
PostgreSQL tool
Demonstrated against Postgres.
concept Unlogged Tables
related_to
PostgreSQL tool
Unlogged tables are a Postgres feature.
concept Row-Level Security
related_to
PostgreSQL tool
Row-level security policies and session parameters demonstrated in Postgres.
concept Schema-Level Partitioning
related_to
PostgreSQL tool
Uses Postgres search_path session parameter to switch schemas.
project estimate_count gem
uses
PostgreSQL tool
Gem leverages Postgres EXPLAIN statistics for fast count estimation.
project Trezy
uses
PostgreSQL tool
Single Postgres database backs both the read model and rails_event_store.
project Eventide
uses
PostgreSQL tool
MessageDB is implemented on top of Postgres.
project Geneva Drive
uses
PostgreSQL tool
Supported as one of Geneva Drive's backing databases.
company Statesert
uses
PostgreSQL tool
Migrated data from MongoDB to PostgreSQL ~4 years before the talk.
tool neighbor
uses
PostgreSQL tool
Backs vector search via Postgres / pgvector.

Provenance

Created in
Applying CQRS & Event Sourcing on Rails applications — An... 2026-04-17 16:18
Last updated in
From PostgreSQL to SQLite in Rails — Wojtek Wrona at wroc... 2026-04-18 06:46
Total updates
2 extractions
Read by
28 extractions