Oliver Seifert
@imgajeed Membre depuis mai 2026
30 docos 0 discussions 0 réponses 6 vérifications
Outils
- Remotes, push, pull, and clone Use a PostgreSQL connection URL as a pgit remote to push, pull, and clone repositories, and how to run your own remote. Pgit / Remotes pgit avant-hier
- Quickstart Import a real git repository into pgit and run your first analyses and SQL queries, start to finish, in about ten minutes. Pgit / Quickstart pgit avant-hier
- Querying with SQL and search Run custom SQL against your repository, search every version of every file, and write queries that stay fast on delta-compressed tables. Pgit / Querying With Sql pgit avant-hier
- What pgit is A Git-like CLI that imports a repo into PostgreSQL so you can run SQL, pre-built analyses, and cross-history search on its commit history. Pgit / Overview pgit avant-hier
- Managing the local container Start, stop, update, and reset the shared pgit database container, and manage the per-repository databases inside it. Pgit / Local Container pgit avant-hier
- Installing pgit Install the pgit CLI with Go, a prebuilt binary, or a system package, then verify the one runtime requirement. Pgit / Installation pgit avant-hier
- Importing a git repository Import a git history into pgit in depth, covering branches, parallel workers, resuming an interrupted run, and importing straight into a remote. Pgit / Importing A Repo pgit avant-hier
- How pgit stores a repository The tables behind pgit, how delta groups collapse renames and copies, and why the analyses are shaped the way they are. Pgit / How It Works pgit avant-hier
- Database schema reference Every table and column in a pgit database, what each holds, and which tables are delta-compressed. Pgit / Database Schema pgit avant-hier
- Configuration and tuning Configure pgit at the repository and global level, set environment variables, and tune the database container for your hardware. Pgit / Configuration And Tuning pgit avant-hier
- Compression vs git How pgit's delta compression compares to git packfiles, with the honest two-number story and how to measure your own repository. Pgit / Compression pgit avant-hier
- Command reference Every pgit command and its flags, grouped by what you use it for. Pgit / Commands pgit avant-hier
- Analyzing history The six pre-built pgit analyses (churn, coupling, hotspots, authors, activity, bus-factor) with their filters, sorting, and output formats. Pgit / Analyzing History pgit avant-hier
- Links & navigation Internal and external links, soft links by kind, hard and pinned URLs, prev/next, and the sidebar sitemap. Docolin / Authoring / Links Docolin avant-hier
- Frontmatter The YAML block at the top of every doco that says what it is, who wrote it, and where it belongs in docolin. Docolin / Authoring / Frontmatter Docolin avant-hier
Données
- Data types & limitations Which column types work where, and the things pg-xpatch does not do, by design and by current implementation. Types And Limitations pg-xpatch avant-hier
- Tuning read performance Size the content cache to your working set, warm it deliberately, lean on indexes, and read cache_stats to know what to change. Tuning Read Performance pg-xpatch avant-hier
- Tuning compression & storage How keyframe_every, compress_depth, and enable_zstd trade storage against write speed, and why batching inserts is the cheapest win. Tuning Compression pg-xpatch avant-hier
- How storage works Keyframes, deltas, per-group chains, and how pg-xpatch rebuilds a row on read, the model behind the compression. Storage Model pg-xpatch avant-hier
- SQL functions Complete reference for the xpatch.* schema, signatures, arguments, and returned columns for every public function. Sql Functions pg-xpatch avant-hier
- Server parameters Every pg_xpatch.* GUC, with default, range, change context, and what it controls. Server Parameters pg-xpatch avant-hier
- Quickstart: your first versioned table Build a tiny document store with pg-xpatch, from an empty table to seeing the deltas on disk, in six short steps. Quickstart pg-xpatch avant-hier
- What pg-xpatch is A PostgreSQL table access method that stores versioned rows as deltas, so a hundred near-identical versions cost about as much as one. Overview pg-xpatch avant-hier
- Monitoring & introspection The functions that answer is compression working, is the cache healthy, and how is this group actually stored. Monitoring pg-xpatch avant-hier
- Installing pg-xpatch Install pg-xpatch on PostgreSQL 16 with Docker, a prebuilt binary, or a source build, then enable the shared cache and create the extension. Installation pg-xpatch avant-hier
- Example: a versioned notes app A real Svelte app where every keystroke is a version, walked through the pg-xpatch parts, schema, aggressive compression config, and the append-only write pattern. Example Notes App pg-xpatch avant-hier
- Configuring a table When auto-detection is enough, when to call xpatch.configure(), and what every option does, plus the validation rules that bite. Configuration pg-xpatch avant-hier
- Caching & performance Why pg-xpatch keeps a shared-memory cache, what lives in it, cold versus warm reads, and the storage/read/write trade-off. Caching And Performance pg-xpatch avant-hier
- Benchmarks What pg-xpatch's compression and speed look like in practice, drawn from the xpatch delta library and the pgit project built on it. Benchmarks pg-xpatch avant-hier
- Backup & restore pg_dump and pg_restore work with xpatch tables, with two things to remember, install the extension first and run fix_restored_configs() after. Backup And Restore pg-xpatch avant-hier