Query Mental Model

Query is a one-file system that uses SQLite to cover most of the full-stack development and infrastructure needs for small websites.

Let's list the key facts for this mental model:

I do not need a database server (PostgreSQL or MySQL), as I can connect to my SQLite databases remotely using the Query APIs, the CLI, and the functions.

Query API
Shell
Functions

I do not need a JavaScript runtime (NodeJS, Deno, or Bun), as Query offers its own.

Query JavaScript Runtime
Runtime Compatibility

I do not need a JavaScript backend framework (NextJS, Remix or Astro), as Query provides functions to serve Pages and APIs.

Functions
File-System Based Router

I do not need a caching system (Redis) for my function, as Query caches them in SQLite and serves them.

Query Cache Control

I do not need a storage system (S3) for my assets, as Query stores them in SQLite and serves them.

Assets

I do not need a scaffolding tool to generate code, as Query offers its own.

Query Generator

I do not need to develop a back office admin area, thanks to the Query generator, as I can build one just by executing a command.

Query Generator
Query Generator Templates

I can deploy in a couple of seconds to Query.

Query Function CLI
Query Assets CLI

I can distribute it in multiple regions, thanks to Fly.io and LiteFS.

Fly.io
LiteFS