PGXN

PostgreSQL Extension Network

PGXN Gear PostgreSQL Extension Network
  • gregburd
  • pg_mentat
  • SUMMARY
  • Users
  • Tags
  • Recent

Contents

  • Summary
  • User Guide
  • Cookbook
  • Reference
  • Deployment
  • Embedded (SQLite) mentat
  • Development

Summary

Introduction


User Guide

  • Getting Started
  • Architecture
  • Scripting (mino)
  • Datalog Query Language
  • Pull API
  • Time Travel
  • Schema Reference

Cookbook

  • JOIN Datalog Results With Postgres Tables
  • Approximate-Regex Search via pg_tre
  • Phonetic & Edit-Distance Functions via fuzzystrmatch
  • Trigram Similarity via pg_trgm
  • BM25-style Ranked Search via rum
  • Vector Search via pgvector
  • Cross-Database Datalog via postgres_fdw
  • Transactional Event Stream via PgQue
  • Model-Knowledge Search via pg_infer
  • Geospatial Search via PostGIS
  • Property Graph Queries via PG19 SQL/PGQ
  • Time-Series Storage via TimescaleDB
  • Declarative Partitioning via pg_partman
  • Scheduled Maintenance via pg_cron

Reference

  • SQL Function Reference
  • Configuration (GUCs)
  • Multi-Tenancy & RLS
  • Datomic Compatibility

Deployment

  • Operations: Throughput, Bloat & the Live Projection
  • mentatd HTTP Server

Embedded (SQLite) mentat

  • About Project Mentat
  • Tutorial

Development

  • Contributing
Blog | Mastodon | Release on PGXN About | FAQ | Mirroring | Feedback