PostgreSQL — the database behind your website and online store

What PostgreSQL is and what it stores for your website

PostgreSQL is an open-source relational database system, in continuous development since 1996 — with roots in the POSTGRES project at the University of California, Berkeley (1986). On 4buildsite, PostgreSQL is where your website data lives: products and stock, orders and payments, leads from forms and page content. You work in the visual editor; PostgreSQL keeps every change safe.

Why does this matter to you if you are not a programmer? Because the difference between a serious database and a fragile one shows up exactly in the hard moments: a traffic spike during a promotion, a payment retried twice, a server restart. PostgreSQL is designed to get through those moments without losing or corrupting data — which is why companies like Instagram and Reddit run it at scale, and historically it powered Skype’s infrastructure.

• Products, variants and stock — your store’s complete catalog
• Orders, Stripe payments and invoices — your sales history, with no gaps
• Leads from forms — every quote request, guaranteed saved
• Page and template content — everything you edit in the visual editor
• Your site’s domains, settings and published versions

Orders and payments without corrupted data — ACID integrity

When a customer places an order, several things happen at once: stock decreases, the order is created, the Stripe payment is recorded. PostgreSQL executes them as a single transaction: either all of them happen, or none. If the payment fails halfway, stock automatically returns to its initial value. This behaviour is called ACID (Atomicity, Consistency, Isolation, Durability) and PostgreSQL guarantees it on every table, with no special configuration.

Beyond transactions, PostgreSQL enforces integrity rules directly in the database: an order line cannot reference a product that does not exist, stock cannot go negative, an account e-mail cannot be duplicated. These constraints (foreign keys, check, unique) stop bad data before it gets in — not after it has broken your sales report.

For marketplaces, integrity matters twice over: commissions and split payments through Stripe Connect are calculated from order data. A duplicated order or an inconsistent amount would mean money split incorrectly between vendors. PostgreSQL transactions keep those calculations correct, order by order.

Fast catalog search and flexible content

PostgreSQL ships a full-text search engine: customers type “running shoes” and find the right products, with stemming dictionaries including Romanian. The pg_trgm extension adds typo tolerance. For a store, these capabilities mean a catalog can be searched well without a separate Elasticsearch-style service — so fewer components that can fail and lower infrastructure costs.

The content of pages built in the visual editor has no fixed structure — a hero block, a form and a gallery all have different fields. PostgreSQL solves this with JSONB: native JSON storage, indexable with GIN indexes, queryable like any column. You get the flexibility of a document database while keeping relational integrity for orders and payments — in one system, not two.

• tsvector + stemming dictionaries (Romanian included) — relevant catalog search
• pg_trgm — customers find the product even with a typo
• JSONB with GIN indexes — flexible page blocks stay fast to query

Reliability: backup, recovery and no surprises

PostgreSQL writes every change to a journal first (WAL — Write-Ahead Log) and only then to the actual data. If the server stops abruptly, the database rebuilds itself from the journal on restart, with no corrupted data. The same mechanism is what PostgreSQL builds point-in-time recovery (PITR) on — a standard engine capability for installations that archive the WAL journal. On 4buildsite, data lives on persistent volumes, separate from the application, so a platform restart or update never touches it.

PostgreSQL also supports streaming replication — a synchronised copy of the database, ready to take over traffic when needed. For your website, database reliability translates directly into SEO and GEO: a site that responds consistently is crawled and indexed consistently, while repeated 5xx errors lower your Google rankings and your chances of being cited as a source by AI engines.

Scaling and costs — grow without licence bills

When your store grows, PostgreSQL grows with it: indexes keep queries fast on catalogs with hundreds of thousands of products, partitioning splits order history by period, and read replicas absorb reporting traffic. Instagram and Reddit scaled on PostgreSQL to hundreds of millions of users — an online store hits this technology’s limits far later than it thinks.

PostgreSQL has a free licence (the PostgreSQL License, BSD-style) — no licence fees and no commercial owner who can change the rules overnight. Commercial databases are typically licensed per CPU core, and that cost inevitably ends up in the client’s price. On 4buildsite, the database is included in your plan, alongside hosting and SSL — with no separate fee.