SQLite? Postgres? Use both with omni_SQLite

In plain words

omni_sqlite is a Postgres extension that allows SQLite databases to be used as a native data type within Postgres. It leverages an expandable datum technique to minimize serialization overhead when moving data between systems. The extension is designed for developers who want to combine the capabilities of both database systems without performance penalties.

written from the facts on this page · September 2026

From the sources

omni_sqlite is an extension that adds the capability to use SQLite databases as a first-class data type within Postgres. It uses expandable datum technique to ensure no additional serialization overhead for data in-flight. omni_sqlite is a templated extension. This means that by installing it, its default-instantiated into omni_sqlite but can be instantiated into any other schema: select omni_sqlite . instantiate ([ schema => 'omni_sqlite' ]) Credits ¶ This work is inspired by postgres-sqlite by Michel Pelletier, licensed under BSD 3-Clause License, but is now a significant rewrite in a different language (C++ instead of C) with added functionality. This extension simplifies…from docs.omnigres.org

• 
  Postgres-SQLite: SQLite as first-class types in Postgres2025 · github.com · ▲15

  In Memory SQLlite as a Postgres data type. Contribute to michelp/postgres-sqlite development by creating an account on GitHub.

• 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

• 
  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…

• 
  Base, an SQLite database editor for macOS2025 · menial.co.uk · ▲693

  I recently released v3 of Base, my SQLite editor for macOS. The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app. The coolest features are - That it can handle full altering of tables, which is quite finicky to do manually with SQLite. - It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon. This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing. I'd love to hear any…

• 
  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…

• 
  NoSQL, but it's SQLite2024 · gist.github.com · ▲98

  Manipulate your SQLite database like a giant Javascript object. Built with o1.

• 
  SimCity, but with Permits▲908

  A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.

  Life & fun · 1d ago · permit.petercai.com

• IV
  I've been paying for a rural Tanzanian's education for 10 years▲778

  Life & fun · 14d ago · tanzaniaeducationproject.org

• 
  Bigwords.page – Turn any screen into a sign. The URL is the app▲728

  Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.

  Life & fun · 14d ago · bigwords.page

• 
  Guitoro, a virtual guitar you strum with your keyboard▲573

  Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.

  Life & fun · 8d ago · guitoro.com

• 
  See *almost* any carriers phone settings▲432

  Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.

  Life & fun · 12d ago · carrierexplode.com

• 
  The whole Solar System and every tracked satellite, live in the browser▲407

  Life & fun · 22d ago · space.bl2.net

• 
  Sider 5.0: Deep Research with Wisebase▲1,358

  Mimic Human Research & Save Findings in AI Knowledge Base

  AI · 2025 · sider.ai

• 
  MGX (Now Atoms)▲1,296

  Turn your ideas into products that sell

  AI · 2025 · atoms.dev

• 
  Aha▲1,152

  The world's first AI influencer marketing team

  AI · 2025 · ahacreator.com

• 
  Fluently▲976

  Start speaking English as well as your native language

  AI · 2025 · getfluently.app

• 
  TheySaid 2.0▲917

  Conversational AI surveys, interviews, user tests, polls

  AI · 2025 · theysaid.io

• 
  ツSupercut▲880

  Record your screen, share instantly, look like a PRO

  Growth · 2025 · supercut.ai