Your whole backend,
built on PostgreSQL.

import PocketBase from "pocketbase";

// the PocketBase JS SDK works with slonbase's API
const pb = new PocketBase("http://localhost:8090");

await pb.collection("users")
  .authWithPassword("ann@example.com", "secret");

const posts = await pb.collection("posts").getList(1, 20, {
  filter: 'published = true && views > 100',
  expand: "author",
});

// realtime
pb.collection("posts").subscribe("*", (e) => {
  console.log(e.action, e.record.title);
});

// hooks: your logic, next to your data
onRecordCreateRequest((e) => {
  if (!e.auth) throw new ForbiddenError("Sign in first.");
  e.record.set("author", e.auth.id);
  e.next();
}, "posts");

routerAdd("GET", "/api/top", (e) => {
  const rows = arrayOf(new DynamicModel({ title: "", views: 0 }));
  $app.db().select("title", "views").from("posts")
    .where($dbx.hashExp({ published: true }))
    .orderBy("views DESC").limit(10).all(rows);
  return e.json(200, rows);
});

cronAdd("cleanup", "0 3 * * *", () => {
  $app.db().delete("posts", $dbx.hashExp({ status: "spam" })).execute();
});

-- every collection is a real table: query it, join it, index it
SELECT a.name, count(*) AS posts, sum(p.views) AS views
FROM slonbase.posts p
JOIN slonbase.users a ON a.id = p.author
WHERE p.published
GROUP BY a.name
ORDER BY views DESC;

-- and changes made here reach realtime subscribers too
UPDATE slonbase.posts SET featured = true WHERE views > 10000;