# HTQLDB CMS | Your CMS is a second database. Ours is the database.

> HTQLDB’s CMS is part of the database: content types, entries, images and email templates authored in the console, versioned, governed by the same permissions, and rendered with live data in one HTQL statement.

URL: https://sigmar.au/cms
Organisation: Sigmar AOS (trading name of Sigmar Investment)

*HTQLDB CMS · Content Ready*

## Your CMS is a second database. Ours is the database.

Pages, menus, emails and images live beside your orders and customers: authored by your team, governed by the same rules, and rendered with live data in a single query.

- [See content meet data](#content-meets-data)
- [Back to HTQLDB](https://sigmar.au/htqldb)

### No second login

### Every edit restorable

### Content meets live data

*The problem*

## Every site runs two databases. Only one of them is yours.

A separate CMS means another login, permissions, backups and copied product data. Prices, accounts and audit logs must stay in step.

Two databases, kept in step

*HTQLDB*

Same tables. Same permissions. Same query language. Same history.

### Business database

### CMS database

### Business data and content

### Under shared rules

*Content meets data*

## The words come from your CMS. The numbers come from your books. One statement.

Your team edits the template. HTQL retrieves the data. Handlebars renders both inside HTQLDB under the caller’s permissions.

LET tpl = LOOKUP("content.entries",
    WHERE(id = "orderDigest"),
    SHOW("fields"), TAKE(1))
LET orders = LOOKUP("orders",
    SORT("created_at DESC"),
    SHOW("order_number", "total"), TAKE(5))
RETURN HANDLEBARS(
    PLUCK(PLUCK(PLUCK(tpl, "fields"), "body"), "en-US"),
    {"orders": orders})

An order digest

Change the wording in the console and the next render uses it. No deploy.

### Template

<ul>{{#each orders}}
  <li>Order {{order_number}}:
    {{total}}</li>
{{/each}}</ul>

### Your latest orders

Order 10427: $249.00
Order 10426: $79.00
Order 10425: $420.00
Order 10424: $129.00
Order 10423: $95.00

*Content models*

## A page is not a blob of HTML. It is a shape your team defines.

Define models and their fields as data. Your team adds fields in the console, and the editor offers them immediately. Linked entries make up the page.

LOOKUP("content.content_types", WHERE(id = "page"), SHOW("id", "name", "fields"), TAKE(1))

The same models shape your site, your emails and your forms.

> Page Hero banner Layout Card Icon Image Content card Callout

### Short text

### Long text

### Number

### Date

### True or false

### List

### Object

### Link

- **Only the values you allow**
- **Only the links you allow**
- **Required fields are marked**

*What you stop building*

## Everything a CMS does. Nothing it costs you to keep in step.

LOOKUP("content.entries", WHERE(slug = "index"), SHOW("fields"), TAKE(1))

HTQL terminal

### Model it

Define content shapes and fields. Add a field without a deploy.

### Author it

Edit pages, menus and footers. Upload images.

### Restore it

Every save keeps the previous version.

### Publish it

Refresh the live site and edge cache.

### Govern it

Sites read. Authorised console users write.

### Isolate it

Each site reads only its own content.

### Render it

Handlebars for pages, emails, text messages and Flow notifications.

### Query it

Read, filter and join content with business data in HTQL.

*One template language*

## The welcome email, the receipt, the alert. Edited where the website is edited.

Your team edits email and text-message templates in the same console, with the same permissions and version history.

### A welcome email, a receipt and an order confirmation

- **One language**
- **Safe by default**
- **Same history**

*Proof*

## This page is a CMS entry. So is every page on this site.

Both sites read their pages, menus, footers and images through HTQL. HTQLDB’s own emails are templates in the same store.

> If it carries us, it carries you.

### sigmar.io

The Sigmar website runs on HTQLDB CMS for its pages, menus and images.

### profitguard.app

The Profit Guard site also reads its content through HTQL.

### Explore HTQLDB

### Read the HTQL guide

## Show us the CMS you sync every night. We’ll show you the query that replaces it.

- [Book a walkthrough](https://sigmar.au/book-demo)
- [Start building](https://sigmar.au/htqldb)
