pgsalesforce_fdw

What it does

pgsalesforce_fdw is a Salesforce Foreign Data Wrapper (FDW) for PostgreSQL. It allows you to query live Salesforce data from PostgreSQL. Using it's core functionality, a bi-directional data sync between SF and PG is implemented with upserts and triggers.

• 
  Circular Sync2023 · ▲95

  Sync Salesforce and Postgres: alternative to Heroku Connect

• 
  Supabase AI Assistant [LW24]2024 · supabase.com · ▲761

  Idea to Postgres database

• CR
  Cloud-Ready Postgres MCP Server2025 · github.com · ▲167

  Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension…

• PC
  PG-Capture – a better way to sync Postgres with Algolia (or Elastic)2025 · pg-capture.onrender.com · ▲56

  Hello HN! Keeping Elasticsearch or Algolia in sync with Postgres is a pain when your data spans multiple tables. Traditional CDC tools like Debezium capture table-level events but don’t help when you need to index a full entity composed of related records. That's why I built PG-Capture. PG-Capture lets you define a schema as complex as you need, aggregate table-level events, and reconstruct structured objects spanning multiple tables. It then publishes them as meaningful domain-level events to any queue (RabbitMQ, SQS, etc.). PG-Capture does NOT replace Debezium, it works on top of it (or…

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

• BA
  Bracket, a Heroku Connect alternative2023 · app.usebracket.com · ▲6

  Hi HN, Bracket CEO here. Bracket lets you set up two-way and one-way syncs between Salesforce and Postgres. We’re essentially a hosting-agnostic alternative to Heroku Connect. Salesforce is the most popular CRM on the planet, but it’s way, way easier to build apps and do analysis on Postgres tables. You can use Bracket to create Postgres tables from scratch based on existing Salesforce objects, choose which fields you’d like to sync and which direction, and schedule&#x2F;manage those syncs. Working with some early beta users, we’ve mostly seen these benefits: 1. Build apps and workflows on…

• 
  Dograh▲592

  The open source VAPI alternative

  Dev tools · 27d ago · dograh.com

• 
  Meridian▲530

  Don't let your work go unnoticed. Get promoted!

  Dev tools · 22d ago · meridiona.com

• 
  x1▲516

  Lovable for iPhone apps go from idea to App Store

  Dev tools · 13d ago · x1.new

• 
  Open-Source eInk Bike Computer▲418

  OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.

  Dev tools · 4d ago · opentrailpaper.com

• 
  Nuphos▲380

  The AI-Native DevOps Workspace.

  Dev tools · 26d ago · nuphos.ai

• 
  Lettertrace▲375

  Track your AI visibility for free (using your own API keys!)

  Dev tools · 27d ago · lettertrace.com

• 
  Wordware▲9,866

  Your tool for building AI agents with natural language

  AI · 2024 · wordware.ai

• IY
  If YouTube had actual channels▲2,741

  Life & fun · 2024 · ytch.xyz

• 
  Me.bot▲1,628

  The inspiring companion for your life

  AI · 2024 · me.bot

• 
  Upmetrics AI▲1,197

  Business plan & financial forecast using AI

  Work · 2024 · upmetrics.co

• 
  Jupitrr AI▲1,196

  Auto-generate B-roll visuals for content marketing videos

  AI · 2024 · jupitrr.com

• IA
  InstantDB – A Modern Firebase▲1,145

  Hey there HN! We’re Joe and Stopa, and today we’re open sourcing InstantDB, a client-side database that makes it easy to build real-time and collaborative apps like Notion and Figma. Building modern apps these days involves a lot of schleps. For a basic CRUD app you need to spin up servers, wire up endpoints, integrate auth, add permissions, and then marshal data from the backend to the frontend and back again. If you want to deliver a buttery smooth user experience, you’ll need to add optimistic updates and rollbacks. We do these steps over and over for every feature we build, which can…

  Dev tools · 2024 · github.com