Explore using SQLite to replace PostgreSQL for v1.0

[jduan00]

Readings

• How to use SQLite with Deno
• Cloudflare D1
• Cloudflare D1 performance and latency globally
• Fly.io LiteFS
• Cloudflare Queues
• Benchmark video: SQLite vs Postgres
• SQLite Write-Ahead Logging
• Neon: Server-less postgres db
• Turso - a fork of SQLite

Idea

1. Maker it lighter weight and easy-to-deploy for v1.0. Eliminate the use of PostgreSQL. This simplifies the global deployment process on the Edge. Implement a fully cloud-native architecture.
2. Identify and address any potential drawbacks. Our primary objective for v1.0 is to achieve a throughput of 1000 requests per second.

[jduan00]

https://pglite.dev/docs/