OpenViSTAI · Agents · Blockchain · Crypto
Submit a project
Menu
Developer Tools

Postgres WEB3

Postgres WEB3 is a C-based PostgreSQL extension that adds fixed-width signed and unsigned 128-bit and 256-bit integers, plus 160-bit and 256-bit hexadecimal types, with database operators and conversions for web3-related data.

Explore the practical guide ↓

Independent OpenViST project profile, based on linked sources.

Postgres WEB3 — OpenViST project profile in Developer Tools.
OpenViST project illustration. See the linked sources for product details.
Understand the project

Practical overview

When it fits

Consider it when a PostgreSQL schema or query workload needs fixed-width large integers or hexadecimal values with operators, rather than representing those values only with generic text or numeric fields.

Who it is for

  • Developers building web3 or blockchain applications on PostgreSQL.
  • Database operators who need fixed-width large integers or hexadecimal values to support database-level operations.

Documented uses

  • Represent large signed and unsigned integers as typed PostgreSQL values.
  • Store hexadecimal values such as Ethereum addresses and block hashes in fixed-width types.
  • Compare, perform arithmetic on, or apply bitwise operations to supported values in PostgreSQL.
Before you choose

Requirements & limits

The repository is public and lists the MIT license. The project documents Linux/amd64 container images and a compile-and-install path.

  • The supported types are int128, uint128, int256, uint256, hex160 and hex256.
  • Hexadecimal inputs are case-insensitive, unprefixed base-16 strings; output is lowercase and does not preserve input case.
  • Unsigned types accept the negative string -0 for compatibility, but not other negative integer strings.
  • Signed-to-unsigned integer casts are not implicit.
  • The documented container image availability is limited to a modified Alpine PostgreSQL variant, with linux/amd64 images listed.

Check current requirements in the official documentation. Source-based guidance does not mean OpenViST has run or independently tested this project.

Source-based practical guide

Enable Postgres WEB3 in an installed PostgreSQL instance

Make the extension available in a database after installing it.

Before you start

  • A PostgreSQL instance.
  • Postgres WEB3 compiled and installed in the PostgreSQL environment.

Steps

  1. Compile and install the extension using the project’s documented installation process.

  2. In the target database, execute CREATE EXTENSION postgres_web3.

Expected outcome

The extension is enabled in the target database, allowing its documented data types to be used there.

Guide limitations

  • The available container images are for linux/amd64; the project says images may build on other platforms.
  • The README identifies a modified Alpine PostgreSQL image as the currently available image variant.
Documentation 1 ↗
Evidence and transparency

Sources & review

Official repository ↗
Source record details
Source availability
Active
Sources checked
16 October 2026
Original website title
Yen/postgres_web3 · Official homepage title · retained in its source language
How we review sourcesSuggest a correction