Introduction
PostgreSQL Extension Store in Nile
PostgreSQL extensions are powerful add-ons that enhance PostgreSQL’s functionality beyond its core features. They introduce new data types, functions, and operators to the database - usually to support a specific use case.
This rich ecosystem of extensions is available to you out of the box in Nile. No need to install or even run CREATE EXTENSION
commands. Just use the extension in your queries.
You can experiment with the extensions and try them out in the Nile console, by navigating to
the Extensions
tab on the left.
Don’t see an extension you need? Let us know by creating a GitHub issue.
Featured Extensions
Pgvector
Perform vector similarity search and build AI-powered features
PostGIS
Add support for geographic objects, allowing you to run location queries in SQL
Pgcrypto
Encryption functions and hashing algorithms
Uuid-ossp
UUID generation functions
Search and Indexing
Bloom
Probabilistic index that can be useful for columns with many distinct values
Btree_Gin
GIN index support for B-tree indexable data types.
Btree_Gist
GiST index support for B-tree indexable data types.
Citext
Case-insensitive text type
Fuzzystrmatch
Functions for fuzzy string matching
Pg_bigm
Full-text search using bigrams
Pg_similarity
Text similarity measures in PostgreSQL
Pg_trgm
Similarity search in PostgreSQL using trigrams
Prefix
Prefix search functionality
Statistical and Analytical
Cube
Data type for multi-dimensional cubes
Financial
Specialized function for computing the Irregular Internal Rate of Return (XIRR)
Hll
HyperLogLog++ algorithm for estimating the number of unique elements in a set
Intagg
Integer aggregator and enumerator functions
Intarray
Functions and operators for integer arrays
Quantile
Efficient quantile and percentile calculations
Random
Random data generator extension with wide range of data types
Tablefunc
Cross tabulation and pivot operations
Xicor
Incremental correlation calculations in PostgreSQL
Geospatial
Earthdistance
Functions for calculating great-circle distances between points on Earth.
H3
Spatial indexing system developed by Uber
H3_PostGIS
Extends H3 functionality with PostGIS integration
Pgrouting
Geospatial routing extension for PostgreSQL
Postgis_raster
Raster Data Support for PostGIS
Data Types and Storage
Emailaddr
specialized data type for storing and validating email addresses
Hstore
Store key-value pairs within a single PostgreSQL value
Ip4r
IPv4 and IPv6 types and range operations
Isn
International Standard Number data types
Ltree
Hierarchical tree-like structures in PostgreSQL databases
Rdkit
Chemical structure types and functions
Seg
Line segment and floating-point interval data type
Unit
SI unit conversion and dimensional analysis
Was this page helpful?