Replicate App-Embedded DuckDBs into PostgreSQL with SyncLite OSS

In plain words

SyncLite is an open-source tool that synchronizes embedded DuckDB databases from applications into PostgreSQL. It enables developers to move data from lightweight, app-embedded DuckDB instances to centralized PostgreSQL databases. The tool is designed for teams that need to consolidate data from multiple distributed applications into a single data warehouse while maintaining data consistency across systems.

written from the facts on this page · September 2026

From the sources

SyncLite : Build Anything Sync Anywhere. Contribute to syncliteio/SyncLite development by creating an account on GitHub.

In the maker’s words, at launch

Hi HN, We have been building SyncLite, an open-source platform to simplify offline-first application development. If your application uses SQLite or DuckDB, SyncLite lets it continue using the local database as usual while synchronization happens in the background. For SQL-based applications, SyncLite records…

• 
  Bi-directional sync between Postgres and SQLite2023 · powersync.com · ▲356

  Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is…

• 
  ElectricSQL, Postgres to SQLite active-active sync for local-first apps2023 · electric-sql.com · ▲617

  Hi HN, James, Valter, Sam and the team from ElectricSQL here. We're really excited to be sharing ElectricSQL with you today. It's an open source, local-first sync layer that can be used to build reactive, realtime, offline-capable apps directly on Postgres with two way active-active sync to SQLite (including with WASM in the browser). Electric comprises a sync layer (built with Elixir) placed in front of your Postgres database and a type safe client that allows you to bidirectionally sync data from your Postgres to local SQLite databases. This sync is CRDT-based, resilient to conflicting…

• 
  Embed an SQLite database in your PostgreSQL table2024 · github.com · ▲180

  pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…

• SO
  SQLite Online – 11 years of solo development, 11K daily users2025 · sqliteonline.com · ▲465

  SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics

• 
  PGlite – in-browser WASM Postgres with pgvector and live sync2024 · pglite.dev · ▲509

  Hey, Sam and the team from ElectricSQL here. PGlite is a WASM Postgres build packaged into a TypeScript&#x2F;JavaScript client library, that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It's 3mb Gzipped, now has support for many Postgres extensions, including pgvector, and it has a reactive "live query" API. It's also fast, with CRUD style queries executing in under 0.3 ms, and larger, multi-row select queries occurring within a fraction of a single frame. PGlite started as an experimental project we shared on X, and the…

• 
  Distributed SQLite on FoundationDB2022 · github.com · ▲150

  Hello HN! I'm building mvsqlite, a distributed variant of SQLite with MVCC transactions, that runs on FoundationDB. It is a drop-in replacement that just needs an `LD_PRELOAD` for existing applications using SQLite. I made this because Blueboat (https:&#x2F;&#x2F;github.com&#x2F;losfair&#x2F;blueboat) needs a native SQL interface to persistent data. Apparently, just providing a transactional key-value store isn’t enough - it is more easy and efficient to build complex business logic on an SQL database, and it seems necessary to bring a self-hostable distributed SQL DB onto the platform.…

• 
  /dev/null▲472

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲340

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 27d ago · corespeed.io

• 
  Wispr Flow▲2,732

  Speak naturally, write perfectly & 3x faster in every app

  AI · 2024 · wisprflow.ai

• 
  Pathway▲1,335

  Get user insights 10x faster

  Work · 2024 · wynde.io

• 
  BeforeSunset AI 2.0▲1,267

  Personalized AI daily planning that suits your life

  AI · 2024 · beforesunset.ai

• 
  Osmos▲1,194

  Match with like-minded professionals for 1:1 conversations

  Growth · 2024

• 
  Carrot Care▲1,168

  Understand & optimise your bloodwork

  Life & fun · 2024 · carrotcare.health

• 
  Polar▲1,167

  An open source monetization platform for developers

  Dev tools · 2024 · polar.sh