Our great sponsors
-
drizzle-orm
Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
It's just SQL so you can take it out at any moment and move to any other DB provider. The package for working with Astro DB, @astrojs/db, includes Drizzle ORM so migration to a different provider should be relatively painless
import { defineDb, defineTable, column } from 'astro:db'; const Visits = defineTable({ columns: { id: column.number({ primaryKey: true }), page: column.text({ default: 'home' }), content: column.text({ default: "none" }), pagination: column.number({ default: 1 }), visitor_ip_hash: column.text(), visitor_user_agent_hash: column.text(), visitor_count: column.number({ default: 1 }) } }); // https://astro.build/db/config export default defineDb({ tables: { Visits } });