Hacker GitHub

← All repos

pgspider/sqlite_fdw

View on GitHub ↗ ★ 264 PLpgSQL

SQLite Foreign Data Wrapper for PostgreSQL

4 mentions on Hacker News by 4 people: 0 stories, 4 comments · first 2020-08-17 · latest 2023-09-18

Mentions per year 4 mentions · busiest year 2023 (2)
20082026
AllStoriesComments NewestTopOldest
  1. https://github.com/pgspider/sqlite_fdw
    comment by bane · 2023-09-18 · in What if OpenDocument used SQLite? (2014)
  2. Postgres has foreign data wrappers which can kinda achieve this(see also: https://github.com/pgspider/sqlite_fdw ), but ive been surprised by how well sqlite is already supported by many tools : sometimes it comes for free as its used in…
    comment by voganmother42 · 2023-07-04 · in Things that surprised me while running SQLite in production
  3. …Or you could do a more realtime sync by using a Postgres foreign data wrapper like this one: https://github.com/pgspider/sqlite_fdw which would let you write directly to SQLite. Combine that with database triggers on the Postgres side of…
    comment by JohnBooty · 2022-05-10 · in I'm all-in on server-side SQLite
  4. …for inserts (it is quite fast if you turn off all logging) and then query with Postgres via a FDW https://github.com/pgspider/sqlite_fdw
    comment by vii · 2020-08-17 · in Understanding Recursive Queries in PostgreSQL