pgcraft

Warning

pgcraft is in pre-alpha. APIs may change between releases.

Getting started

• Setting up a new project
  • Installation
  • Dependencies
  • alembic.ini
  • env.py
  • models.py
• Playground
  • Prerequisites
  • Configuration
  • Setup
  • Commands
  • Typical workflow
  • Adding models
  • PostgREST

Guides

• Built-in dimensions
  • Simple dimension
  • Append-only dimension (SCD Type 2)
  • EAV dimension (Entity-Attribute-Value)
• Constraints and indices
  • Column markers
  • Check constraints
  • Indices
  • Foreign keys
  • Simple dimension example
  • Append-only dimension example
  • EAV dimension example
• Ledger tables
  • Basic ledger
  • Double-entry ledger
  • Customising the value type
  • Using a UUID primary key
  • Ledger events
  • Plugin reference
• Ledger events
  • Reconciliation (diff mode)
  • Simple event (input only)
  • Factory integration
  • Validation
• Naming conventions
  • Setting up naming conventions
  • Overriding a specific convention
  • Convention reference
• Cookbook
  • Migrations only
  • Using pgcraft models in your application
  • Indices and foreign keys

Reference

• Plugin architecture
  • Core concepts
  • Plugin execution order
  • Plugin resolution
  • Singleton groups
  • Context keys
  • Writing a custom plugin
  • Global configuration
  • Factory and view reference
  • Built-in plugins reference
• Built-in plugins
  • SerialPKPlugin
  • UUIDV4PKPlugin
  • UUIDV7PKPlugin
  • CreatedAtPlugin
  • SimpleTablePlugin
  • PostgRESTView
  • StatisticsViewPlugin
  • SimpleTriggerPlugin
  • RawTableProtectionPlugin
  • TableCheckPlugin
  • TableIndexPlugin
  • TableFKPlugin
  • AppendOnlyTablePlugin
  • EAVTablePlugin
  • Plugin execution order
• Extension system
  • Quick start
  • Extension hooks
  • Inter-extension dependencies
  • Entry point discovery
  • Writing an extension
  • PostgREST extension
• API reference
  • Plugin system
  • Dimension resource factories
  • Ledger resource factory
  • View factories
  • Ledger events
  • Built-in plugins
  • Alembic integration
  • PostgREST / API
• Benchmarks
  • What is benchmarked
  • Representative results

Contributing

• Development
• Changelog