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.
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.