Meta tags:
description=Lightweight WASM Postgres;

Headings (most frequently used words):

pglite, extensions, about, docs, reference, live, pgvector, amcheck, apache, age, auto_explain, bloom, btree_gin, btree_gist, citext, cube, dict_int, dict_xsyn, earthdistance, file_fdw, fuzzystrmatch, hstore, intarray, isn, lo, ltree, pageinspect, pg_buffercache, pg_freespacemap, pg_hashids, pg_ivm, pg_stat_statements, pg_surgery, pg_textsearch, pg_trgm, pg_uuidv7, pg_visibility, pg_walinspect, pgcrypto, pgmq, pgtap, postgis, seg, tablefunc, tcn, tsm_system_rows, tsm_system_time, unaccent, uuid, ossp, framework, hooks, tools,

Text of the page (most frequently used words):
#pglite (141), the (108), extension (103), postgres (83), contrib (67), sql (58), electric (56), package (51), extensions (50), from (48), create (45), for (45), size (44), bundle (43), not (43), exists (43), exec (43), await (43), new (43), const (43), import (43), documentation (40), main (33), included (32), provides (30), and (29), module (26), functions (21), this (21), that (20), data (19), external (19), postgresql (12), npm (11), search (10), which (10), can (10), https (10), com (10), separate (10), text (9), used (9), distributed (9), www (9), npmjs (9), bloom (9), are (8), dictionary (8), seg (8), postgis (8), database (8), file_fdw (8), cube (8), citext (8), age (8), live (8), also (7), unaccent (7), tsm_system_rows (7), tcn (7), tablefunc (7), useful (7), type (7), pgtap (7), pgcrypto (7), pg_walinspect (7), pg_visibility (7), pg_trgm (7), with (7), pg_surgery (7), pg_stat_statements (7), pg_ivm (7), pg_freespacemap (7), pg_buffercache (7), pageinspect (7), ltree (7), isn (7), intarray (7), hstore (7), fuzzystrmatch (7), earthdistance (7), dict_xsyn (7), dict_int (7), btree_gist (7), btree_gin (7), auto_explain (7), amcheck (7), using (6), only (6), means (6), tsm_system_time (6), you (6), support (6), pgmq (6), pg_uuidv7 (6), pg_textsearch (6), pg_hashids (6), distance (6), page (5), full (5), table (5), method (5), index (5), access (5), graph (5), uuid_ossp (4), unique (4), output (4), these (4), representing (4), github (4), make (4), like (4), level (4), map (4), strings (4), example (4), when (4), read (4), server (4), all (4), view (4), model (4), query (4), vector (4), uuid (3), one (3), there (3), what (3), its (3), any (3), behavior (3), trigger (3), various (3), return (3), multiple (3), rows (3), both (3), their (3), write (3), implements (3), relational (3), tap (3), such (3), allow (3), contents (3), low (3), debugging (3), purposes (3), than (3), examining (3), visibility (3), operators (3), operator (3), classes (3), searching (3), bm25 (3), your (3), incremental (3), ivm (3), materialized (3), views (3), numbers (3), free (3), space (3), value (3), tree (3), structure (3), types (3), single (3), many (3), implement (3), multi (3), supports (3), pgvector (3), plugin (3), api (3), apache (2), development (2), next (2), upgrade (2), path (2), ossp (2), uuids (2), several (2), standard (2), special (2), available (2), allows (2), insensitive (2), sampling (2), tablesample (2), clause (2), select (2), command (2), function (2), changes (2), must (2), includes (2), tables (2), own (2), examples (2), need (2), use (2), storing (2), indexing (2), easy (2), test (2), reporting (2), those (2), but (2), inspect (2), similar (2), through (2), rather (2), similarity (2), based (2), matching (2), fast (2), efficient (2), languages (2), parameters (2), relation (2), them (2), may (2), corrupt (2), cause (2), foreign (2), key (2), tuples (2), great (2), repo (2), execution (2), statements (2), maintenance (2), way (2), small (2), open (2), source (2), short (2), non (2), ids (2), into (2), simply (2), called (2), pages (2), product (2), number (2), integers (2), indexed (2), values (2), files (2), file (2), tools (2), add (2), template (2), words (2), synonyms (2), while (2), case (2), equivalent (2), built (2), enables (2), users (2), top (2), databases (2), precision (2), vectors (2), sync (2), repl (2), docs (2), about (2), navigation (2), dual, licensed, under, license, previous, pager, generate, universally, identifiers, algorithms, produce, certain, constants, necessary, requirements, beyond, core, removes, accents, diacritic, signs, lexemes, filtering, always, passed, unlike, normal, dictionaries, accent, processing, system_time, system_rows, notifies, listeners, attached, after, each, row, right, how, line, segments, floating, point, intervals, represent, uncertainty, interval, endpoints, making, especially, laboratory, measurements, follow, issue, status, issues, 916, install, extends, capabilities, adding, querying, geospatial, 233, suite, emitting, unit, tests, psql, scripts, xunit, style, suitable, harvesting, analysis, harness, perl, applications, lightweight, message, queue, aws, sqs, rsmq, cryptographic, ahead, log, running, cluster, analytical, educational, pg_waldump, accessible, utility, information, check, integrity, force, rebuilt, tiny, valid, version, determining, alphanumeric, trigram, well, 542, relevance, ranked, ranking, supporting, custom, perform, surgery, damaged, unsafe, design, further, easily, inconsistent, indexes, constraint, violations, even, visible, will, crash, they, should, caution, last, resort, tracking, planning, statistics, executed, feature, date, computed, applied, recomputing, scratch, refresh, does, update, more, efficiently, recomputation, parts, changed, hashids, library, generates, sequential, converts, 347, yr8, decode, back, bundling, uids, fsm, pg_freespace, two, overloaded, precise, show, recorded, given, happening, shared, buffer, cache, real, time, offers, evict, testing, superusers, labels, stored, hierarchical, extensive, facilities, label, trees, provided, managing, large, objects, los, blobs, lo_manage, following, international, numbering, standards, ean13, upc, isbn, books, ismn, music, issn, serials, manipulating, null, arrays, searches, some, sets, pairs, within, scenarios, attributes, rarely, examined, semi, structured, keys, determine, similarities, between, wrapper, system, execute, programs, program, format, copy, currently, calculating, circle, distances, surface, earth, extended, synonym, replaces, groups, makes, possible, word, motivation, control, signed, unsigned, allowing, preventing, excessive, growth, greatly, affects, performance, multidimensional, cubes, character, string, essentially, internally, calls, lower, comparing, otherwise, behaves, almost, same, gist, gin, filters, filter, whether, element, member, set, exclusion, via, signatures, whose, determined, creation, logging, plans, slow, automatically, without, having, run, explain, hand, 138, leverage, existing, acronym, inspired, bitnine, agensgraph, fork, basic, principle, project, storage, handles, ansi, along, opencypher, most, popular, today, strong, cohesive, functionalities, features, offering, boot, verify, logical, consistency, relations, inner, cosine, hamming, jaccard, half, binary, sparse, exact, approximate, nearest, neighbor, store, rest, reactive, subscribe, receive, updated, results, underlying, change, below, list, has, enable, extend, public, interface, benchmarks, reference, catalog, locale, prepopulated, pgdump, socket, orms, builders, component, tab, worker, bundler, vue, react, framework, hooks, filesystems, queries, getting, started, videos, sidebar, menu, home, skip, content,

Text of the page (random words):
the main pglite package js import btree_gist from electric sql pglite contrib btree_gist const pg new pglite extensions btree_gist await pg exec create extension if not exists btree_gist documentation bundle size 23 6 kb postgres extension postgres contrib citext citext provides a case insensitive character string type citext essentially it internally calls lower when comparing values otherwise it behaves almost the same as text citext is included in the main pglite package js import citext from electric sql pglite contrib citext const pg new pglite extensions citext await pg exec create extension if not exists citext documentation bundle size 4 9 kb postgres extension postgres contrib cube cube provides a data type cube for representing multidimensional cubes cube is included in the main pglite package js import cube from electric sql pglite contrib cube const pg new pglite extensions cube await pg exec create extension if not exists cube documentation bundle size 14 8 kb postgres extension postgres contrib dict_int dict_int is an example of an add on dictionary template for full text search the motivation for this example dictionary is to control the indexing of integers signed and unsigned allowing such numbers to be indexed while preventing excessive growth in the number of unique words which greatly affects the performance of searching dict_int is included in the main pglite package js import dict_int from electric sql pglite contrib dict_int const pg new pglite extensions dict_int await pg exec create extension if not exists dict_int documentation bundle size 1 3 kb postgres extension postgres contrib dict_xsyn dict_xsyn extended synonym dictionary is an example of an add on dictionary template for full text search this dictionary type replaces words with groups of their synonyms and so makes it possible to search for a word using any of its synonyms dict_xsyn is included in the main pglite package js import dict_xsyn from electric sql pglite contrib dict_xsyn const pg new pglite extensions dict_xsyn await pg exec create extension if not exists dict_xsyn documentation bundle size 1 9 kb postgres extension postgres contrib earthdistance the earthdistance module provides tools for calculating great circle distances on the surface of the earth earthdistance is included in the main pglite package js import earthdistance from electric sql pglite contrib earthdistance const pg new pglite extensions earthdistance await pg exec create extension if not exists earthdistance documentation bundle size 2 2 kb postgres extension postgres contrib file_fdw the file_fdw module provides the foreign data wrapper file_fdw which can be used to access data files in the server s file system or to execute programs on the server and read their output the data file or program output must be in a format that can be read by copy from access to data files is currently read only file_fdw is included in the main pglite package js import file_fdw from electric sql pglite contrib file_fdw const pg new pglite extensions file_fdw await pg exec create extension if not exists file_fdw documentation bundle size 4 4 kb postgres extension postgres contrib fuzzystrmatch fuzzystrmatch provides functions to determine similarities and distance between strings fuzzystrmatch is included in the main pglite package js import fuzzystrmatch from electric sql pglite contrib fuzzystrmatch const pg new pglite extensions fuzzystrmatch await pg exec create extension if not exists fuzzystrmatch documentation bundle size 11 7 kb postgres extension postgres contrib hstore this module implements the hstore data type for storing sets of key value pairs within a single postgresql value this can be useful in various scenarios such as rows with many attributes that are rarely examined or semi structured data keys and values are simply text strings hstore is included in the main pglite package js import hstore from electric sql pglite contrib hstore const pg new pglite extensions hstore await pg exec create extension if not exists hstore documentation bundle size 20 9 kb postgres extension postgres contrib intarray the intarray module provides a number of useful functions and operators for manipulating null free arrays of integers there is also support for indexed searches using some of the operators intarray is included in the main pglite package js import intarray from electric sql pglite contrib intarray const pg new pglite extensions intarray await pg exec create extension if not exists intarray documentation bundle size 14 4 kb postgres extension postgres contrib isn the isn module provides data types for the following international product numbering standards ean13 upc isbn books ismn music and issn serials isn is included in the main pglite package js import isn from electric sql pglite contrib isn const pg new pglite extensions isn await pg exec create extension if not exists isn documentation bundle size 30 7 kb postgres extension postgres contrib lo the lo module provides support for managing large objects also called los or blobs this includes a data type lo and a trigger lo_manage lo is included in the main pglite package js import lo from electric sql pglite contrib lo const pg new pglite extensions lo await pg exec create extension if not exists lo documentation bundle size 1 8 kb postgres extension postgres contrib ltree this module implements a data type ltree for representing labels of data stored in a hierarchical tree like structure extensive facilities for searching through label trees are provided ltree is included in the main pglite package js import ltree from electric sql pglite contrib ltree const pg new pglite extensions ltree await pg exec create extension if not exists ltree documentation bundle size 19 1 kb postgres extension postgres contrib pageinspect the pageinspect module provides functions that allow you to inspect the contents of database pages at a low level which is useful for debugging purposes all of these functions may be used only by superusers pageinspect is included in the main pglite package js import pageinspect from electric sql pglite contrib pageinspect const pg new pglite extensions pageinspect await pg exec create extension if not exists pageinspect documentation bundle size 15 5 kb postgres extension postgres contrib pg_buffercache the pg_buffercache module provides a means for examining what s happening in the shared buffer cache in real time it also offers a low level way to evict data from it for testing purposes pg_buffercache is included in the main pglite package js import pg_buffercache from electric sql pglite contrib pg_buffercache const pg new pglite extensions pg_buffercache await pg exec create extension if not exists pg_buffercache documentation bundle size 3 1 kb postgres extension postgres contrib pg_freespacemap the pg_freespacemap module provides a means for examining the free space map fsm it provides a function called pg_freespace or two overloaded functions to be precise the functions show the value recorded in the free space map for a given page or for all pages in the relation pg_freespacemap is included in the main pglite package js import pg_freespacemap from electric sql pglite contrib pg_freespacemap const pg new pglite extensions pg_freespacemap await pg exec create extension if not exists pg_freespacemap documentation bundle size 1 5 kb postgres extension postgres contrib pg_hashids hashids is a small open source library that generates short unique non sequential ids from numbers it converts numbers like 347 into strings like yr8 you can also decode those ids back this is useful in bundling several parameters into one or simply using them as short uids this is an external extension distributed as a separate package at https www npmjs com package electric sql pglite pg_hashids js import pg_hashids from electric sql pglite pg_hashids const pg new pglite extensions pg_hashids await pg exec create extension if not exists pg_hashids documentation npm bundle size 4 1 kb postgres extension external pg_ivm the pg_ivm module provides incremental view maintenance ivm feature for postgresql incremental view maintenance ivm is a way to make materialized views up to date in which only incremental changes are computed and applied on views rather than recomputing the contents from scratch as refresh materialized view does ivm can update materialized views more efficiently than recomputation when only small parts of the view are changed this is an external extension distributed as a separate package at https www npmjs com package electric sql pglite pg_ivm js import pg_ivm from electric sql pglite pg_ivm const pg new pglite extensions pg_ivm await pg exec create extension if not exists pg_ivm documentation npm bundle size 24 3 kb postgres extension external pg_stat_statements the pg_stat_statements module provides a means for tracking planning and execution statistics of all sql statements executed by a server pg_stat_statements is included in the main pglite package js import pg_stat_statements from electric sql pglite contrib pg_stat_statements const pg new pglite extensions pg_stat_statements await pg exec create extension if not exists pg_stat_statements repo bundle size 11 3 kb postgres extension postgres contrib pg_surgery the pg_surgery module provides various functions to perform surgery on a damaged relation these functions are unsafe by design and using them may corrupt or further corrupt your database for example these functions can easily be used to make a table inconsistent with its own indexes to cause unique or foreign key constraint violations or even to make tuples visible which when read will cause a database server crash they should be used with great caution and only as a last resort pg_surgery is included in the main pglite package js import pg_surgery from electric sql pglite contrib pg_surgery const pg new pglite extensions pg_surgery await pg exec create extension if not exists pg_surgery documentation bundle size 2 6 kb postgres extension postgres contrib pg_textsearch postgresql extension for bm25 relevance ranked full text search provides a bm25 index access method for efficient full text search with bm25 ranking supporting multiple languages and custom parameters this is an external extension distributed as a separate package at https www npmjs com package electric sql pglite pg_textsearch js import pg_textsearch from electric sql pglite pg_textsearch const pg new pglite extensions pg_textsearch await pg exec create extension if not exists pg_textsearch documentation npm bundle size 542 5 kb postgres extension external pg_trgm the pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching as well as index operator classes that support fast searching for similar strings pg_trgm is included in the main pglite package js import pg_trgm from electric sql pglite contrib pg_trgm const pg new pglite extensions pg_trgm await pg exec create extension if not exists pg_trgm documentation bundle size 15 8 kb postgres extension postgres contrib pg_uuidv7 a tiny postgres extension to create valid version 7 uuids in postgres this is an external extension distributed as a separate package at https www npmjs com package electric sql pglite pg_uuidv7 js import pg_uuidv7 from electric sql pglite pg_uuidv7 const pg new pglite extensions pg_uuidv7 await pg exec create extension if not exists pg_uuidv7 documentation npm bundle size 1 5 kb postgres extension external pg_visibility the pg_visibility module provides a means for examining the visibility map vm and page level visibility information of a table it also provides functions to check the integrity of a visibility map and to force it to be rebuilt pg_visibility is included in the main pglite package js import pg_visibility from electric sql pglite contrib pg_visibility const pg new pglite extensions pg_visibility await pg exec create extension if not exists pg_visibility documentation bundle size 4 1 kb postgres extension postgres contrib pg_walinspect the pg_walinspect module provides sql functions that allow you to inspect the contents of write ahead log of a running postgresql database cluster at a low level which is useful for debugging analytical reporting or educational purposes it is similar to pg_waldump but accessible through sql rather than a separate utility pg_walinspect is included in the main pglite package js import pg_walinspect from electric sql pglite contrib pg_walinspect const pg new pglite extensions pg_walinspect await pg exec create extension if not exists pg_walinspect documentation bundle size 4 6 kb postgres extension postgres contrib pgcrypto the pgcrypto module provides cryptographic functions for postgresql pgcrypto is included in the main pglite package js import pgcrypto from electric sql pglite contrib pgcrypto const pg new pglite extensions pgcrypto await pg exec create extension if not exists pgcrypto documentation bundle size 1 1 mb postgres extension postgres contrib pgmq a lightweight message queue like aws sqs and rsmq but on postgres this is an external extension distributed as a separate package at https www npmjs com package electric sql pglite pgmq js import pgmq from electric sql pglite pgmq const pg new pglite extensions pgmq await pg exec create extension if not exists pgmq documentation npm bundle size 40 9 kb postgres extension external pgtap pgtap is a suite of database functions that make it easy to write tap emitting unit tests in psql scripts or xunit style test functions the tap output is suitable for harvesting analysis and reporting by a tap harness such as those used in perl applications this is an external extension distributed as a separate package at https www npmjs com package electric sql pglite pgtap js import pgtap from electric sql pglite pgtap const pg new pglite extensions pgtap await pg exec create extension if not exists pgtap documentation npm bundle size 233 8 kb postgres extension external postgis postgis extends the capabilities of the postgresql relational database by adding support for storing indexing and querying geospatial data this is an external extension distributed as a separate package at https www npmjs com package electric sql pglite postgis you need to install it to use it npm i electric sql pglite postgis follow this issue for the status https github com electric sql pglite issues 916 js import postgis from electric sql pglite postgis const pg new pglite extensions postgis await pg exec create extension if not exists postgis documentation npm bundle size 18 8 mb postgres extension external seg this module implements a data type seg for representing line segments or floating point intervals seg can represent uncertainty in the interval endpoints making it especially useful for representing laboratory measurements seg is included in the main pglite package js import seg from electric sql pglite co...