glommer

glommer / pgmicro

Public

An in-process reimplementation of PostgreSQL, backed by a SQLite-compatible storage engine

83
0
100% credibility
Found Mar 27, 2026 at 85 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Rust
AI Summary

pgmicro provides an embeddable, single-file database that supports PostgreSQL syntax and tools while storing data in a standard SQLite-compatible format.

How It Works

1
🔍 Discover pgmicro

You hear about pgmicro, a simple way to use powerful database features like PostgreSQL without managing servers or complex setups.

2
📦 Get the tool

Run a quick command to start using it right away, no complicated installation needed.

3
🗄️ Create your database

Launch your personal database as a single file or in memory with one easy step, ready for your data.

4
➕ Build your tables

Write familiar commands to create tables, add auto-numbering IDs, and store your information securely.

5
🔍 Find your data

Ask questions in plain language to pull out exactly what you need, seeing results instantly.

6
🔌 Connect familiar tools

Link it to tools you already know, like command-line explorers, for seamless viewing and editing.

✅ Your database shines

Enjoy a fast, lightweight database that handles real work without the hassle, keeping everything simple and close at hand.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 85 to 83 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is pgmicro?

pgmicro delivers an in-process PostgreSQL reimplementation in Rust, backed by a SQLite-compatible storage engine. Developers get full PostgreSQL syntax – SERIAL types, JSON operators, dollar quoting – running on standard .db files or in-memory, with no server process. Use the CLI via `npx pg-micro myapp.db`, JS SDK for async queries, or server mode for psql compatibility.

Why is it gaining traction?

It bridges PostgreSQL's richer type system and query power to SQLite's embeddable simplicity, ideal for single-file deploys. Dialect switching mixes PG and SQLite syntax in one DB, easing migrations. The single-executable engine handles ephemeral workloads without PostgreSQL's process-per-connection overhead.

Who should use this?

AI agent devs building short-lived scratch DBs or session stores needing PG JSON features. Full-stack Rust/JS teams prototyping per-user sandboxes. Researchers exploring pgmicro ufba or pgmicro ufrgs in edge deployments.

Verdict

Grab pgmicro for quick PostgreSQL-in-a-file prototypes – the in-process storage shines for low-touch apps. But 1.0% credibility score, 83 stars, and experimental status mean incomplete features and rough GitHub release/PR process; test thoroughly before production.

(187 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.