Service / 05

Database architecture

We model data deliberately, then plan the indexes, migrations, replication and recovery needed to keep it dependable.

Start a project

ordersprimary

iduuid · pk

customer_iduuid · fk

statusenum

total_centsint

created_attimestamptz

customersreference

iduuid · pk

nametext

emailcitext

segmenttext

order_itemsdetail

iduuid · pk

order_iduuid · fk

skutext

quantityint

price_centsint

orders.customer_id → customers.idorder_items.order_id → orders.id

The work

Designed for
the conditions.

01Data modelling
02Schema and index design
03Query optimisation
04Migrations
05Replication and recovery

Process

Clear steps,
visible progress.

Model the domain
Name the entities and relationships the business runs on.
Design for the queries
Shape schemas and indexes around real access patterns.
Plan for growth
Migrations, partitioning and capacity before they hurt.
Protect the data
Replication, backups and tested recovery paths.

The work

What you get

01Data model and ER diagrams
02Index and query tuning report
03Migration and rollback plan
04Backup and recovery drills

Operating targets

Tested RPO/RTO

Recovery

Query budgets

Performance

Encrypted at rest

Security

Live example

Edit the code. Run it. Break it.

A real, runnable slice of this work — your edits run in a sandboxed preview.

playground/database-architecture.html

<h2>deploy · main → production</h2>
<p class="hint">The pipeline streams its own logs as it runs — this whole window is one deploy, from commit to edge.</p>
<div class="grid">
  <div class="stages">
    <div class="stage" id="st0"><i></i><span>BUILD</span><small></small></div>
    <div class="stage" id="st1"><i></i><span>TEST</span><small></small></div>
    <div class="stage" id="st2"><i></i><span>SHIP</span><small></small></div>
  </div>
  <div class="term"><pre id="log"><span class="cursor"></span></pre></div>
</div>
<div class="tiles">
  <div><b>12</b><small>edge regions</small></div>
  <div><b>1.2k</b><small>req / s</small></div>
  <div><b>84 ms</b><small>p95 latency</small></div>
  <div><b id="runs">1</b><small>deploys today</small></div>
</div>
<p id="status" class="idle">waiting for push…</p>
<button id="again" class="ghost">Deploy again</button>

⎇ main0 errors · 0 warningsLn 1, Col 1 · Spaces: 2 · UTF-8 · HTML · ○ idle

sandbox.nordiso.local/database-architecture

sandbox idle — boots when this section scrolls into view

Technology examples

PostgreSQLMySQL

MongoDB

RedisObject storage

Examples, not a fixed stack — chosen per project, with the team that will own it.

PostgreSQL
MongoDB
Redis

Have something important to build?

Let’s make a good start.

Start a project

<h2>deploy · main → production</h2> <p class="hint">The pipeline streams its own logs as it runs — this whole window is one deploy, from commit to edge.</p> <div class="grid"> <div class="stages"> <div class="stage" id="st0"><i></i><span>BUILD</span><small></small></div> <div class="stage" id="st1"><i></i><span>TEST</span><small></small></div> <div class="stage" id="st2"><i></i><span>SHIP</span><small></small></div> </div> <div class="term"><pre id="log"><span class="cursor"></span></pre></div> </div> <div class="tiles"> <div><b>12</b><small>edge regions</small></div> <div><b>1.2k</b><small>req / s</small></div> <div><b>84 ms</b><small>p95 latency</small></div> <div><b id="runs">1</b><small>deploys today</small></div> </div> <p id="status" class="idle">waiting for push…</p> <button id="again" class="ghost">Deploy again</button>

Database architecture

Designed forthe conditions.

Clear steps,visible progress.

Model the domain

Design for the queries

Plan for growth

Protect the data

What you get

Edit the code. Run it. Break it.

Let’s make a good start.

Database architecture

Designed forthe conditions.

Clear steps,visible progress.

Model the domain

Design for the queries

Plan for growth

Protect the data

What you get

Edit the code. Run it. Break it.

Let’s make a good start.

Designed for
the conditions.

Clear steps,
visible progress.

Designed for
the conditions.

Clear steps,
visible progress.