From ed02ba872c02eafed45f406c68d389d0a1112a4e Mon Sep 17 00:00:00 2001
From: cashmere <cashmere@autistici.org>
Date: Thu, 30 Jul 2026 18:17:45 +0200
Subject: feat: Electron desktop app, native ffmpeg export, fully static web

- apps/desktop: Electron shell serving the static web build over a
  privileged opencut:// protocol; exports stream frames over IPC to a
  bundled ffmpeg (libx264/libvpx-vp9, BT.709 tagged) with backpressure.
  electron-builder packaging: AppImage, deb, rpm.
- apps/web: dead backend deleted (better-auth, drizzle/pg, upstash,
  botid, freesound proxy, blog, rss, env validation); next build emits
  a zero-env static export; /editor/[project_id] -> /editor?project=.
- Native exporter mirrors SceneExporter; activates when the preload
  bridge is present; web keeps the mediabunny path.
- Docker self-hosting now builds and serves the static export via nginx.
- Release workflow: v* tags publish static web tarball + Linux packages.
- Changelog 0.4.0; README/AGENTS/CONTRIBUTING/roadmap updated.
- GPUI/Rust rewrite parked on branch rust-rewrite.
---
 apps/web/src/db/index.ts  | 19 -------------
 apps/web/src/db/schema.ts | 70 -----------------------------------------------
 2 files changed, 89 deletions(-)
 delete mode 100644 apps/web/src/db/index.ts
 delete mode 100644 apps/web/src/db/schema.ts

(limited to 'apps/web/src/db')

diff --git a/apps/web/src/db/index.ts b/apps/web/src/db/index.ts
deleted file mode 100644
index 29e3ffda..00000000
--- a/apps/web/src/db/index.ts
+++ /dev/null
@@ -1,19 +0,0 @@
-import { drizzle } from "drizzle-orm/postgres-js";
-import postgres from "postgres";
-import * as schema from "./schema";
-import { webEnv } from "@/env/web";
-
-let _db: ReturnType<typeof drizzle> | null = null;
-
-function getDb() {
-	if (!_db) {
-		const client = postgres(webEnv.DATABASE_URL);
-		_db = drizzle(client, { schema });
-	}
-
-	return _db;
-}
-
-export const db = getDb();
-
-export * from "./schema";
diff --git a/apps/web/src/db/schema.ts b/apps/web/src/db/schema.ts
deleted file mode 100644
index 8f8be248..00000000
--- a/apps/web/src/db/schema.ts
+++ /dev/null
@@ -1,70 +0,0 @@
-import { pgTable, text, timestamp, boolean } from "drizzle-orm/pg-core";
-
-export const users = pgTable("users", {
-	id: text("id").primaryKey(),
-
-	// todo: implement fully anonymous sign-in for privacy
-	// we don't have any auth flows currently so this is fine for now
-	name: text("name").notNull(),
-	email: text("email").notNull().unique(),
-	emailVerified: boolean("email_verified").default(false).notNull(),
-	image: text("image"),
-	createdAt: timestamp("created_at")
-		.$defaultFn(() => /* @__PURE__ */ new Date())
-		.notNull(),
-	updatedAt: timestamp("updated_at")
-		.$defaultFn(() => /* @__PURE__ */ new Date())
-		.notNull(),
-}).enableRLS();
-
-export const sessions = pgTable("sessions", {
-	id: text("id").primaryKey(),
-	expiresAt: timestamp("expires_at").notNull(),
-	token: text("token").notNull().unique(),
-	createdAt: timestamp("created_at").notNull(),
-	updatedAt: timestamp("updated_at").notNull(),
-	ipAddress: text("ip_address"),
-	userAgent: text("user_agent"),
-	userId: text("user_id")
-		.notNull()
-		.references(() => users.id, { onDelete: "cascade" }),
-}).enableRLS();
-
-export const accounts = pgTable("accounts", {
-	id: text("id").primaryKey(),
-	accountId: text("account_id").notNull(),
-	providerId: text("provider_id").notNull(),
-	userId: text("user_id")
-		.notNull()
-		.references(() => users.id, { onDelete: "cascade" }),
-	accessToken: text("access_token"),
-	refreshToken: text("refresh_token"),
-	idToken: text("id_token"),
-	accessTokenExpiresAt: timestamp("access_token_expires_at"),
-	refreshTokenExpiresAt: timestamp("refresh_token_expires_at"),
-	scope: text("scope"),
-	password: text("password"),
-	createdAt: timestamp("created_at").notNull(),
-	updatedAt: timestamp("updated_at").notNull(),
-}).enableRLS();
-
-export const feedback = pgTable("feedback", {
-	id: text("id").primaryKey(),
-	message: text("message").notNull(),
-	createdAt: timestamp("created_at")
-		.$defaultFn(() => new Date())
-		.notNull(),
-});
-
-export const verifications = pgTable("verifications", {
-	id: text("id").primaryKey(),
-	identifier: text("identifier").notNull(),
-	value: text("value").notNull(),
-	expiresAt: timestamp("expires_at").notNull(),
-	createdAt: timestamp("created_at").$defaultFn(
-		() => /* @__PURE__ */ new Date(),
-	),
-	updatedAt: timestamp("updated_at").$defaultFn(
-		() => /* @__PURE__ */ new Date(),
-	),
-}).enableRLS();
-- 
cgit v1.3.1