DEV Community

Cover image for Cache, Store, and Serve All in One: Manage Your Website with SQLite Power
Víctor García
Víctor García

Posted on

2 1 1 1 1

Cache, Store, and Serve All in One: Manage Your Website with SQLite Power

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

Query Mental Model

This is a mental model to guide you when working with Query.

  1. 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.
  2. I do not need a JavaScript runtime (NodeJS, Deno, or Bun), as Query offers its own.
  3. I do not need a JavaScript backend framework (NextJS, Remix or Astro), as Query provides functions to serve Pages and APIs.
  4. I do not need a caching system (Redis) for my function, as Query caches them in SQLite and serves them.
  5. I do not need a storage system (S3) for my assets, as Query stores them in SQLite and serves them.
  6. I do not need a scaffolding tool to generate code, as Query offers its own.
  7. 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.
  8. I can deploy in a couple of seconds to Query.
  9. I can distribute it in multiple regions, thanks to Fly.io and LiteFS.

The following links are related to each mental model concept.

[1] Query API
[1] Shell
[1] Functions

[2] Query JavaScript Runtime
[2] Runtime Compatibility

[3] Functions
[3] File-System Based Router

[4] Query Cache Control

[5] Query Generator

[6] Assets

[7] Query Generator
[7] Query Generator Templates

[8] Query Function CLI
[8] Query Assets CLI

[9] Fly.io
[9] LiteFS

Sentry blog image

How to reduce TTFB

In the past few years in the web dev world, we’ve seen a significant push towards rendering our websites on the server. Doing so is better for SEO and performs better on low-powered devices, but one thing we had to sacrifice is TTFB.

In this article, we’ll see how we can identify what makes our TTFB high so we can fix it.

Read more

Top comments (1)

Collapse
 
harshthedev profile image
Harsh Singh

Great article! I am working on an open-source DSL which will give superpowers to SQLite. Here is the article I wrote: dev.to/harshthedev/meet-rayql-a-sc...

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up