{"library":"pg-micro","type":"library","category":null,"description":"pg-micro is an experimental, in-process reimplementation of PostgreSQL, currently at version 0.0.5. It is built as an experimental fork of Turso, which is a full, from-scratch rewrite of SQLite in Rust. Unlike other approaches that try to compile PostgreSQL to WebAssembly or translate PostgreSQL syntax to SQLite, pg-micro directly parses the PostgreSQL language using `libpg_query` (the same parser PostgreSQL itself uses) and compiles it to SQLite bytecode for execution on Turso's engine. This approach aims to provide a fast, embeddable, single-file database that natively understands PostgreSQL syntax, targeting ephemeral, low-touch, short-lived, and small database use cases. Its key differentiators include 100% PostgreSQL syntax fidelity, direct compilation to SQLite bytecode, and a standard SQLite-compatible storage format, allowing for dual access via PostgreSQL and SQLite syntax. Release cadence is currently irregular due to its experimental nature and close ties to Turso's development cycle.","language":"javascript","status":"active","version":"0.0.5","tags":["javascript","typescript"],"install":[{"cmd":"npm install pg-micro","imports":["import { connect } from 'pg-micro';","import { Database } from 'pg-micro';","import { type Row } from 'pg-micro';"]},{"cmd":"yarn add pg-micro","imports":[]},{"cmd":"pnpm add pg-micro","imports":[]}],"homepage":null,"github":"https://github.com/glommer/pgmicro","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/pg-micro","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"18–22","success_rate":0,"avg_install_s":null,"avg_import_s":null,"wheel_type":null},"url":"https://checklist.day/v1/registry/pg-micro/compatibility"},"provenance":{"verified_status":null,"verified_at":null,"last_verified":"Wed Jun 17","next_check":"Wed Jul 22","install_tag":null}}