NodeDB server

Version
NodeDB 0.3.0
Transport
pgwire PostgreSQL wire via libpq/pg
Host : Port
localhost:6432
Database
nodedb
User
nodedb
application_name
(unset)

Adapter + runtime

Adapter
NodeDB
database_version stub
150000
Prepared statements
disabled (BUG-005)
ActiveRecord
8.1.3
Rails
8.1.3
Ruby
4.0.1

Gems

nodedb-ruby
0.1.0.alpha.5
activerecord-nodedb-adapter
0.1.0.alpha.8
pg
1.6.3

Migrations

Applied
8
Versions
001 002 003 004 005 006 007 008
Environment
development
schema_sha1
(unset)

Collections 8

Name Engine Owner Created Rows Cols Schema
articles document_strict nodedb 2026-07-02T23:46:00+08:00 3 3 id:TEXT id:TEXT PRIMARY KEY title:text body:text
audit_logs schemaless nodedb 2026-07-02T23:46:01+08:00 4 6 id:TEXT id:TEXT PRIMARY KEY actor:text action:text target:text context:text recorded_at:text
embeddings schemaless nodedb 2026-07-02T23:46:01+08:00 4 1 id:TEXT document:JSON
kv_sessions kv nodedb 2026-07-02T23:46:01+08:00 2 2 id:TEXT key:TEXT PRIMARY KEY value:text
locations document_strict nodedb 2026-07-02T23:46:01+08:00 8 4 id:TEXT id:TEXT PRIMARY KEY name:text lat:float lon:float
metrics timeseries nodedb 2026-07-02T23:46:00+08:00 16 3 id:TEXT ts:TIMESTAMP TIME_KEY host:text value:float
posts document_strict nodedb 2026-07-02T23:46:01+08:00 5 3 id:TEXT id:TEXT PRIMARY KEY title:text body:text
social_nodes schemaless nodedb 2026-07-02T23:46:00+08:00 6 1 id:TEXT document:JSON

Internal collections

Managed by activerecord-nodedb-adapter for Rails migration tracking.
NameOwnerCreated
ar_internal_metadata nodedb 2026-07-02T23:46:00+08:00
schema_migrations nodedb 2026-07-02T23:46:00+08:00

Operations NodeDB v0.3.0

Surfaced by connection.show_stats, show_metrics, show_memory, show_roles, and show_tenant(0) — adapter helpers shipped in activerecord-nodedb-adapter 0.1.0.alpha.8.

SHOW STATS

22 rows
NameValue
version 0.3.0
queries_total 0
query_errors 0
slow_queries_total 0
active_connections 0
pgwire_connections 0
http_connections 0
native_connections 0
auth_failures 0
auth_successes 0
wal_fsync_count 0
wal_segment_count 0
wal_segment_bytes 0
raft_apply_lag 0
compaction_debt 0
compaction_cycles 0
queries_vector 10
queries_graph 0
queries_document 0
queries_columnar 0
queries_kv 0
queries_fts 0

SHOW METRICS

26 rows
NameValue
version 0.3.0
queries_total 0
query_errors 0
slow_queries_total 0
active_connections 0
pgwire_connections 0
http_connections 0
native_connections 0
auth_failures 0
auth_successes 0
wal_fsync_count 0
wal_segment_count 0
wal_segment_bytes 0
raft_apply_lag 0
compaction_debt 0
compaction_cycles 0
queries_vector 10
queries_graph 0
queries_document 0
queries_columnar 0
queries_kv 0
queries_fts 0
wal_fsync_p50_us 0
wal_fsync_p99_us 0
query_latency_p50_us 0
query_latency_p99_us 0

SHOW MEMORY

Per-engine memory budget snapshot
Engine Allocated Limit Peak Rejections Util %
Crdt 0 96636764 0 0 0
DocumentSchemaless 0 21474836 0 0 0
Kv 0 21474836 0 0 0
Graph 0 21474836 0 0 0
Sparse 0 150323855 0 0 0
Vector 0 268435456 0 0 0
Wal 0 21474836 0 0 0
Array 0 21474836 0 0 0
Spatial 0 21474836 0 0 0
Fts 0 32212254 0 0 0
Query 0 171798691 0 0 0
Columnar 0 32212254 0 0 0
Bridge 0 10737418 0 0 0
DocumentStrict 0 21474836 0 0 0
Timeseries 0 96636764 164352 0 0

SHOW ROLES

0 rows · defined roles
Name Tenant Parent Created
No roles defined yet — use CREATE ROLE <name> over psql or a superuser session. NodeDB v0.3.0 also accepts WITH ADMIN on auth DDL.

SHOW TENANT 0 default tenant

conn.show_tenant(0)
tenant_id
0
name
active_requests
0
total_requests
1093
rejected_requests
0
Tracked NodeDB upstream limitations: docs/bugs · issues