virtualpg ☆
« Back to VersTracker
Description:
Loadable dynamic extension for SQLite and SpatiaLite
Type: Formula  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: sqlite postgresql spatialite database extension
Install: brew install virtualpg
About:
VirtualPG is a loadable dynamic extension for SQLite and SpatiaLite that enables direct read-only access to PostgreSQL databases. It implements the PostgreSQL wire protocol, allowing these databases to be queried as if they were native virtual tables. This facilitates seamless data integration and interoperability between SQLite-based applications and existing PostgreSQL server environments.
Key Features:
  • Direct read-only access to PostgreSQL databases from SQLite
  • Implements the PostgreSQL wire protocol for native connectivity
  • Seamless integration with SpatiaLite for spatial data queries
  • No need for external drivers or middleware
Use Cases:
  • Querying live PostgreSQL data directly from SQLite clients
  • Integrating PostgreSQL data into local SpatiaLite analysis workflows
  • Building lightweight data bridges for heterogeneous database environments
Alternatives:
  • ogr – GDAL's OGR driver provides broader multi-format database access, whereas VirtualPG is specialized for PostgreSQL connectivity within SQLite.
  • fdw – PostgreSQL Foreign Data Wrappers work in the opposite direction, allowing a Postgres server to query other databases.
Version History
Detected Version Rev Change Commit
Sep 28, 2024 6:18pm 0 VERSION_BUMP 40b158cc
Sep 28, 2024 1:04pm 0 VERSION_BUMP 370069d0
Sep 12, 2024 6:10pm 0 VERSION_BUMP 78a78a10
« Back to VersTracker  |  Browse Packages  |  About