# Extensible Postgres

> Blossom of Possibilities
---

> Nurturing all, thriving in synergy, forging infinite possibilities!


**Analytics**


        Big Data's New Challenger



**AI Ready**


        Baseline for RAG/Vector App



**Geospatial**


        De Facto GIS Standard



**Time Series**


        Temporal Data Mastery



**Text Search**


        Built-in Search Engine



**Languages**


        Language of Your Choice



**FDW Federation**


        Connecting Data Silos



**Featured**


        Database as a Platform





--------

## Analytics: Big Data's New Challenger {#analytics}

> 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 {#ai-ready}

> 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
- Additional extensions: DiskANN, quantization, NN computation, text summarization
- In-database RAG workflow with vector similarity search

--------

## Geospatial: De Facto GIS Standard {#geospatial}

> De facto standard for GIS, accelerating storage to computation, index & query\
> Route planning, sky indexing, IP geocoding, H3 indexing

- 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 {#time-series}

> 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 capabilities
- table_version: Version control for table data
- pg_cron/pg_task: Background task management and scheduling

--------

## Text Search: Built-in Search Engine {#text-search}

> Built-in full-text search engine with multilingual support\
> Advanced text processing and search capabilities

- Built-in full-text search with tsvector and tsquery
- Multilingual support with various dictionaries
- Fuzzy matching and similarity search
- Advanced text analytics and processing

--------

## Languages: Language of Your Choice {#languages}

> 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, and more
- pg_tle: Framework for developing extensions using trusted languages
- Stored Procedure Toolkit: Debugging, Profiling, Validating, Unit testing

--------

## FDW Federation: Connecting Data Silos {#foreign-data}

> 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
- 20+ FDWs available, write FDWs using WASM
- Multicorn: Developing FDWs using Python

--------

## Featured: Database as a Platform {#featured}

> HTTP requests, SMTP email, compression, QR codes, PDF scanning\
> Developing web app inside Postgres - Just use PostgreSQL for everything!

- Dialects: GraphQL, OpenCyper, Jq, PRQL, BSON, SQLite, MQ, HLL
- Performance Tools: HINT, index advisor
- Security: Anonymization, TDE
- Web Development: Omnigres for full-stack web development