Home

PostgreSQL Framework for Backend Development

PostgreSQL Framework for backend development is a platform for building modern, reliable server solutions based on PostgreSQL.

The System turns PostgreSQL into a full-fledged backend: from the data core and business logic to REST API and external service integration.

---

What the Platform Provides

• Production-ready backend The end result of developing on the platform is a fully operational server-side automated information system.

• Quick start for web and mobile applications The platform is ideal for:

  • Web applications (Single Page Application, SPA)
  • Mobile applications
  • Integration with external systems and services

• Transparent and documented REST API The server-side REST API is described using the OpenAPI specification and accessible via Swagger UI, simplifying integration, client SDK generation, and frontend team workflows.

• Optional administration module The server part can be supplemented with a web-based administration module for managing configuration, data, and users.

---

Getting Started

Concepts

• System — General concepts and operating principles
• Server Application — Transport layer and entry points
• Architecture — How components interact
• Workflow — Working with documents and processes
• Reports — Building reports and analytics

API Guide

• API Introduction — Basic principles
• API Access — Tokens, authorization, permissions
• Dynamic Methods — Universal method invocation
• Query Parameters — Filtering, sorting, pagination

---

API Reference

The System provides a rich set of ready-made APIs for typical enterprise application tasks:

Authentication & Session

• Connection — Connectivity test (ping, time)
• Registration — User sign-up
• Authorization (OAuth 2.0) — Token management
• Sign In — User login
• Sign Out — User logout
• Password Recovery — Multi-step password reset
• Verification Codes — Email/phone verification
• Authentication — Session authentication
• Authorization — Session authorization check
• Who Am I? — Current user profile

Core Services

• Current Parameters — Query session settings
• Session — Session parameter management
• Locale — Language selection
• Resource — Multilingual resource tree
• Registry — Hierarchical key-value storage
• Event Log — System event logging
• Notice — User notifications
• Comment — Hierarchical comments
• Notification — Real-time change notifications
• KLADR — Russian address classifier

Object & Workflow Endpoints

• Workflow Endpoints — Entity, class, action, state, method
• Object Endpoints — Generic object CRUD
  • Object Groups — Grouping objects
  • Object Links — Object relationships
  • Object Files — File attachments
  • Object Data — Arbitrary data storage
  • Object Address — Postal addresses
  • Object Geolocation — GPS coordinates
• Class Endpoints — Per-class REST patterns

---

Internals & Developer Guide

Schema & Internals

• Schema Overview — Database schemas, users, two-layer architecture
• Database Tables — Complete table reference by module
• Function Reference — Naming conventions and patterns
• Entity System Internals — Object hierarchy and lifecycle
• Access Control — Three-layer permission system (ACU/AMU/AOU)
• Observer (Pub/Sub) — Publisher/listener event system

Configuration Developer Guide

• Configuration Guide — Creating a new Configuration
• Creating an Entity — Step-by-step entity tutorial
• Creating a Document — Document class tutorial
• Creating a Reference — Reference class tutorial
• Workflow Customization — Custom states, methods, transitions
• REST Endpoint Guide — Writing REST dispatchers
• Event Handler Guide — Writing event handlers

Operations

• Installation — Database setup and management

---

Projects Built on the Platform

Solutions based on the Platform are already in production:

• Ship Safety ERP — Automated ERP system for maritime safety management
• CopyFrog — AI-powered platform for generating images, ad copy, and marketing content
• Talking to AI — Telegram chatbot for AI conversations
• OCPP CSS — Cloud SaaS platform for EV charging station management
• PlugMe — Charging Station Management System (CSMS)
• DEBT-Master — Utility debt collection automation system
• BitDeals — BTC cryptocurrency arbitration system

These projects demonstrate that the platform is suitable for both industry-specific B2B solutions and mass-market online services and AI-based products.