Tech gems 👁️ #15: All-in PostgreSQL with PGLite
Adrien Zaganelli -
- ▶️ PGLite is SQLite for PostgreSQL
- ▶️ Postgres.new will write SQL for you
- ▶️ Exploring pg-boss: Background Jobs in TypeScript and PostgreSQL
- ▶️ Backup Strategies Simplified: Using pg_back with PostgreSQL
PGLite is SQLite for PostgreSQL
pglite on Github
GitHub - electric-sql/pglite: Lightweight WASM Postgres with real-time, reactive bindings.
Lightweight WASM Postgres with real-time, reactive bindings. - electric-sql/pglite
You can now work with Postgre databases without a server. With PGLite, your database can be in memory, in your filesystem or directly in indexedDB. This is huge for testing as you run can this locally. It's also good to know that Drizzle ORM already supports it.
Postgres.new will write SQL for you
Speaking of PGLite, here comes Postgres.new !
It’s like if ChatGPT and Postgres had a love-child: launch as many databases as you want, build them with AI, create charts, create embeddings. 100% open source.
from Paul Copplestone, Supabase CEO
Here is a demo from the Vercel CEO.
Exploring pg-boss: Background Jobs in TypeScript and PostgreSQL
pg-boss in TypeScript: A Deep Dive
Scheduled and Background Jobs with pg-boss in TypeScript: A Deep Dive | LogSnag
Explore the power of pg-boss for managing background jobs in TypeScript, leveraging PostgreSQL's capabilities for efficient task scheduling and queue management in web applications.
This article explores pg-boss, a Node.js job queue library using PostgreSQL, discussing its benefits, basic usage, scheduling jobs, and a proposal for a TypeScript wrapper for easier job handling.
