Ordnary

Docs Ordnary Web Services Ordnary Serverlite

What Ordnary Serverlite is

Serverless SQLite databases: query them from the console or from your app over HTTPS, with no servers to size and no connections to manage.

4 min readBeginner

Concepts

Database
One SQLite database with its own tables, indexes and views. Its name is unique within your account and your app can use it in place of the ID.
SQL console
An editor in the console that runs SQL against a database and shows the rows, with how many rows each query read and wrote.
Query API
The HTTPS endpoint your app calls: POST https://serverlite.ordnary.com/v1/databases/{database}/query. See Query API.
API token
A secret starting with osq_ that your app sends with every request. Read-only or read and write, for every database or one. See API tokens.
Placement
Where a database keeps its data: chosen automatically, steered with a region hint, or pinned to the EU. Set when you create the database.

It is SQLite

Every database is real SQLite: the same SQL, the same types and the same functions you know from the sqlite3 command line, including JSON functions, foreign keys, indexes, views and triggers. Migrations written for SQLite run unchanged.

Placement

Automatic
The database starts close to where you create it. Right for most databases.
Location hint
Prefer a region such as Western Europe or Eastern North America, typically the one your servers or users are in. A preference, not a guarantee.
EU jurisdiction
Data is stored and processed only inside the European Union. Choose this when residency is a requirement rather than a preference.

Limits

Database name

Lowercase letters, digits, - and _, starting with a letter or digit.

1 to 63 charactersper database

Request body

SQL plus parameters. Split bulk loads over several requests.

4 MBper request

Statements in a batch

A batch runs in one transaction.

100per request

Rows shown in the console

The query still runs in full; add a LIMIT to see a specific part.

1,000per result

What it costs

Rows read per million, rows written per million and storage per GB-month. Every month the first 150 million rows read, 3 million rows written and 5 GB-month of storage are free. The current rates are on the activation page and under Billing in the console; see Billable usage.

Create your first database

Make a table in the console and query it from your app in five minutes.

Open the quickstart
Was this page helpful?
Updated 2 November 2026 Suggest an edit

Choose which cookies Ordnary may use. You can change this at any time via Cookie settings at the bottom of every page.