Knowledge and creative tools
Relate documents, projects, revision history, metadata, and search in one model.
relations · JSONB · full-text searchShip a complete PostgreSQL database inside desktop and mobile software or a WASIX host. Keep data in an app-owned root and use it through a language SDK or, where supported, a local PostgreSQL endpoint.
Language SDKs
Relations, JSONB, geospatial queries, full-text search, and vectors can live in the same app-owned root.
Relate documents, projects, revision history, metadata, and search in one model.
relations · JSONB · full-text searchKeep records with the app and run spatial queries where the target ships PostGIS.
transactions · geography · recoveryStore vectors beside source data and combine similarity with relational filters.
pgvector · indexes · structured filtersImport, inspect, transform, and query complex datasets with PostgreSQL behavior.
SQL · types · extensionsOliphaunt packages PostgreSQL, its runtime, and verified extension builds for the target.
Ship PostgreSQL storage, SQL, types, transactions, indexes, WAL, and recovery inside an application-owned database root.
Use native direct, broker, or server modes on supported platforms. For WASIX hosts, ship portable runtime assets with target-specific carriers.
Add spatial data, vector search, full-text search, trigram indexes, crypto, UUIDv7, and more across native and WASIX targets.
PostGISspatialpgvectorvectorsFTSsearchpg_trgmmatchingpgcryptocryptoUUIDv7identityTarget-verified extension builds
Open the root, create a schema, bind values, and read typed rows from Rust, Swift, Kotlin, React Native, or TypeScript.
oliphauntuse oliphaunt::Oliphaunt;async fn open_database() -> oliphaunt::Result<()> { let db = Oliphaunt::builder() .path(".oliphaunt") .native_direct() .open() .await?; db.execute(r#" CREATE TABLE IF NOT EXISTS todos ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, title text NOT NULL UNIQUE, done boolean NOT NULL DEFAULT false ) "#).await?; db.query_params( "INSERT INTO todos (title) VALUES ($1) ON CONFLICT (title) DO UPDATE SET done = false", ["Run the first product query"], ).await?; let todos = db .query("SELECT title FROM todos WHERE NOT done ORDER BY id DESC LIMIT 20") .await?; let first_title = todos.get_text(0, "title")?; db.close().await?; Ok(())}Four committed apps exercise native and WASIX paths through Tauri and Electron.
Rust SDK · app-owned rootRust owns the Oliphaunt handle in application state.
SourceWASIX sidecar · SQLxOliphauntServer exposes a local PostgreSQL URL to SQLx.
SourceTypeScript SDK · native serverThe TypeScript SDK runs native server mode in the main process.
SourceWASIX sidecar · local endpointA Rust sidecar supplies a local PostgreSQL URL to the main process.
Source