Extensible Postgres
Nurturing all, thriving in synergy, forging infinite possibilities!
Analytics: Big Data's New Challenger
T0 analytical performance, DuckDB Extension Battleground, HTAP's future
Parallelism, MPP, columnar compression, GPU acceleration, Parquet analysis
- •pg_duckdb: Bringing extreme OLAP performance into PostgreSQL
- •pg_mooncake: Columnar Table with top 10 ClickBench rankings
- •pg_strom: GPU accelerating for PostgreSQL/PostGIS
- •citus: Distributed HTAP/OLAP with columnar storage and acceleration
AI Ready: Baseline for RAG/Vector App
Vector database, one extension conquering the entire specialized niche
Complete in-db AI workflow: inference, training, storage, embedding, and RAG
- •pgvector: Vector extension, IVFLAT & HNSW indexing, AVX512 acceleration
- •pgml: Run CUDA with SQL in-database ML/Training/Embedding/Inference
- •DiskANN, quantization, NN computation, text summarization, in-database RAG
Geospatial: De Facto GIS Standard
De facto standard for GIS, accelerating storage to computation, index & query
Route planning, sky indexing, IP geocoding, H3 indexing, GeoHash, point cloud
- •PostGIS: Geographic/geometric/topological/raster extension
- •pgrouting: GIS spatial path planning, and graph computation
- •pointcloud: Storage and processing of LiDAR point cloud data
Time Series: Temporal Data Mastery
Enhanced time-series processing & analytics capabilities, for IoT, FinTech, APM,...
Simplify app dev with temporal tables, time travel, version control, cron tasks,...
- •timescaledb: Process & Analysis Timeseries, continuous agg of streaming event
- •temporal_tables, e-maj: time travel, table_version: version control table
- •pg_cron / pg_task, pg_later, pg_background
Text Search: Built-in Search Engine
Built-in full-text search, with multi-language dict, word segmentation,...
FTS + SQL precise retrieval + vector fuzzy retrieval for hybrid search
- •pg_search: Wrap tantivy into PG native storage, as an ES alternative
- •pg_bestmatch and vchord_bm25: full-text search ranking with BM25
- •Gronnga, zhparser, hunspell, pg_bigm/pg_trgm for full text search
Languages: Language of Your Choice
PostgreSQL is not just a database, but a full-featured data development platform
Support for 20+ stored procedure languages, putting even Oracle to shame
- •Multiple languages: Python, Js, Java, Shell, Perl, Lua, TCL, PRQL, R, …
- •pg_tle: framework for developing extension using trusted languages
- •Stored Procedure Toolkit: debugging, profiling, validating, unit testing
FDW Federation: Connecting Data Silos
Create data federations with FDW, becoming the data exchange hub
Uniformly access & ETL all heterogeneous data sources with SQL
- •Major relational databases: pgsql, mysql, mssql, oracle, db2, duckdb, sqlite
- •Various data sources: redis, kafka, mongo, hdfs, s3, log, jdbc, odbc, …
- •wrappers: Comes with 20+ FDWs, write any FDW yourself using WASM
- •multicorn: Developing FDWs using Python, and many derivative FDWs
Featured: Database as a Platform
Send/Receive HTTP requests, SMTP email, Compression, QR codes, Scan PDFs
Developing web app inside Postgres - Just use PostgreSQL for everything!
- •Using Dialects: GraphQL, OpenCypher, Jq, PRQL, BSON, SQLite, MQ, HLL
- •HINT, or index advisor; anonymization, or tde, countless amazing extensions
- •Database as architecture, Web Development inside Postgres: Omnigres
PIGSTY