PostgreSQL
49 items tagged with "postgresql"
Tutorials8
Migrating from MySQL to PostgreSQL
Complete guide to migrating databases from MySQL to PostgreSQL
Database Management with Prisma
Set up Prisma ORM for type-safe database access
How to provision a managed PostgreSQL database on Cloud SQL
Provision, secure, and connect to a managed PostgreSQL instance on Google Cloud SQL with private IP.
How to design and tune PostgreSQL indexes for query performance
Find slow queries with EXPLAIN, choose the right index types, and verify gains so reads stay fast without bloating writes.
How to partition a large PostgreSQL table by range
Use declarative range partitioning to split a large table by time, improving query pruning, maintenance, and data retention.
How to set up vector similarity search with pgvector
Install pgvector in PostgreSQL, store embeddings, build an ANN index, and run nearest-neighbor queries for semantic search.
How to store and query time-series data with TimescaleDB
Turn a PostgreSQL table into a TimescaleDB hypertable, add continuous aggregates, and apply retention for time-series workloads.
How to migrate a PostgreSQL database using logical replication
Move a PostgreSQL database to a new server with near-zero downtime using publications, subscriptions, and a final cutover.
Blueprints3
MySQL to PostgreSQL Blueprint
Complete migration guide from MySQL to PostgreSQL
Oracle to PostgreSQL Migration Blueprint
Migrate an Oracle Database workload to PostgreSQL, converting PL/SQL, data types, and schema while preserving data integrity.
SQL Server to PostgreSQL Migration Blueprint
Migrate Microsoft SQL Server to PostgreSQL, converting T-SQL, data types, and schema to remove licensing cost.
Migrations10
DynamoDB to PostgreSQL Migration
Migrate DynamoDB single-table designs to relational PostgreSQL with new schema and access patterns
MongoDB to PostgreSQL Migration
Convert NoSQL MongoDB to relational PostgreSQL with JSONB
MySQL to Aurora PostgreSQL Migration
Migrate MySQL to Aurora PostgreSQL including schema translation and cutover
MySQL to PostgreSQL Migration
Migrate MySQL schema and data to PostgreSQL, translating queries and tuning indexes
Oracle to PostgreSQL Migration
Migrate Oracle Database to PostgreSQL with PL/SQL conversion
PostgreSQL 12 to PostgreSQL 16 Migration
Major-version upgrade PostgreSQL 12 → 16 with extension checks, replication/cutover, and performance validation
PostgreSQL to Aurora PostgreSQL Migration
Move PostgreSQL to managed Aurora PostgreSQL with minimal downtime using replication
SQL Server to Aurora PostgreSQL Migration
Migrate SQL Server to Aurora PostgreSQL with T-SQL rewrites and managed Postgres operations
SQL Server to PostgreSQL Migration
Migrate from SQL Server to PostgreSQL including stored procedures
SQLite to PostgreSQL Migration
Migrate an app from embedded SQLite to PostgreSQL for concurrency, HA, and operational tooling
Products4
Stacks16
PERN Stack
PostgreSQL, Express.js, React, Node.js - Relational DB full-stack
Go Microservices Stack
Go, gRPC, Kubernetes, PostgreSQL - High-performance services
Supabase Stack
Supabase, Next.js, Tailwind - Open source Firebase alternative
Next.js + Supabase
A fullstack pairing Next.js with Supabase for Postgres, auth, storage, and realtime, shipping production apps with minimal backend code.
Next.js + Prisma + Postgres
A typed fullstack of Next.js, the Prisma ORM, and PostgreSQL for SaaS apps with a hand-owned backend and end-to-end type safety.
Remix + Postgres
A web stack built on Remix's loader/action model over PostgreSQL, embracing web standards and progressive enhancement for fast, resilient apps.
SvelteKit + Postgres
A full-stack SvelteKit application with server routes and a PostgreSQL database, delivering fast, lightweight web apps with minimal JavaScript.
Express + React + Postgres
A classic JavaScript full stack: an Express REST API on Node.js, a React frontend, and a PostgreSQL database, flexible and widely understood.
Fastify + Prisma
A high-performance Node.js backend using Fastify with schema-based validation and Prisma ORM over PostgreSQL, built for low-overhead, type-safe APIs.
Vapor Swift Server
A server-side Swift web framework using async/await and a typed ORM, letting iOS-focused teams build backends in the same language as their apps.
Ktor + Exposed
A lightweight, coroutine-based Kotlin web framework paired with the Exposed SQL library, for idiomatic, asynchronous Kotlin backends and APIs.
Rocket (Rust) Stack
An ergonomic, type-safe Rust web framework with compile-time route checking and request guards, paired with a database for fast, safe backends.
Axum + SQLx (Rust)
A modern async Rust backend built on the Tokio runtime with the Tower middleware ecosystem and compile-time-checked SQL via SQLx.
Gin + GORM
A fast, lightweight Go web stack pairing the Gin HTTP framework with the GORM ORM, popular for high-performance REST APIs and backend services.
Echo + Ent
A performant Go web stack combining the Echo framework with Ent, an entity framework that generates type-safe, graph-aware data access code from schemas.
Supabase Realtime Stack
A realtime application stack built on Supabase, streaming Postgres changes, broadcast messages, and presence to clients over WebSockets atop row-level security.
Comparisons6
PostgreSQL vs MySQL
Comparison of the two most popular open-source relational databases
MongoDB vs PostgreSQL
Comparing document database MongoDB with relational PostgreSQL
Postgres vs CockroachDB
The versatile single-node-first relational database versus a distributed, Postgres-compatible SQL database built for global scale.
SQLite vs Postgres
An embedded, serverless, single-file database versus a full-featured client-server relational database system.
PostgreSQL vs Cassandra
A relational ACID database for complex queries versus a distributed wide-column store built for write-heavy linear scale.
pgvector vs Dedicated Vector Database
pgvector adds vector search to PostgreSQL; a dedicated vector database is purpose-built. The choice trades operational simplicity against scale and specialized features.
Benchmarks2
sysbench
A scriptable, multi-threaded benchmark tool widely used for MySQL/PostgreSQL OLTP tests as well as CPU, memory, and file I/O microbenchmarks.
pgbench
PostgreSQL's built-in benchmarking tool that runs a TPC-B-like transaction load and custom scripts to measure transactions per second and latency.