分类: FUNC

multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)

ulid type and methods

Create UUIDv7 values in postgres

UUID v8 generator with embedded timestamps for PostgreSQL

Pseudo-randomly permute sequences with a format-preserving encryption on elements

Short unique id generator for PostgreSQL, using hashids

Generate cryptographically secure timestamp-based slugs

generator of sequential UUIDs

Allows to use TypeIDs in Postgres natively

Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL

type for top-n JSONB

Quantile aggregation function

Lower quantile aggregate function

An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate

data structure for on-line agg of data into approximate sketch

Provides ddsketch aggregate function

discover hidden correlations in your data with MIC

XI Correlation Coefficient in Postgres

High-performance weighted statistics functions for sparse data

Descriptive statistics and clinical effect-size functions over arrays

Approximate analytics sketches and aggregates for PostgreSQL

Closure-preserving formula-based statistical modeling in SQL

Provides tdigest aggregate function.

HDR histogram type, percentile queries and mergeable aggregation.

first() and last() aggregate functions

Extra Window Functions for PostgreSQL

Math for vectors (arrays) of numbers

Aggregate functions for array inputs

Various functions for computing statistics on arrays of numbers

argmax, argmin, and anyold aggregate functions

Flexible CSV processing for Postgres

Array math and operators that work element by element on the contents of arrays

GSL statistical functions for postgresql

random data generator

Integer Base36 types

Base62 extension for PostgreSQL

Base58 Encoder/Decoder Extension for PostgreSQL

Financial aggregate functions

Accumulation registers for balance and turnover tracking in PostgreSQL

conversion functions for spatial, routing and other specialized uses

Text conversion with NULL or a typed fallback on conversion errors.

GIN index operator class and partial-match operators for text arrays

functions for implementing referential integrity (obsolete)

functions for autoincrementing fields

functions for tracking who changed a table

functions for tracking last modification time

TABLESAMPLE method which accepts time in milliseconds as a limit

text search dictionary template for extended synonym processing

TABLESAMPLE method which accepts number of rows as a limit

Triggered change notifications

generate universally unique identifiers (UUIDs)

support for indexing common datatypes in GiST

support for indexing common datatypes in GIN

functions, operators, and index support for 1-D arrays of integers

integer aggregator and enumerator (obsolete)

text search dictionary template for integers

text search dictionary that removes accents