PGlite is an embeddable PostgreSQL database that runs through WebAssembly, allowing applications to execute PostgreSQL queries without connecting to a separate database server.
Developed by Electric, PGlite makes it possible to use PostgreSQL directly in web browsers and JavaScript runtime environments. The database can operate entirely in memory or persist its contents between application sessions.
Unlike conventional PostgreSQL deployments, PGlite does not require a separate server process. It adapts PostgreSQL’s single-user operating mode to work within a WebAssembly environment, providing applications with embedded database functionality and access to PostgreSQL extensions.
PGlite is particularly useful for local-first applications, browser-based development environments and applications that need relational data storage without running a dedicated database service.
This is free and open source software.
Key Features
- Embedded PostgreSQL database running through WebAssembly.
- Execute PostgreSQL queries directly within browser applications.
- Works with Node.js, Bun and Deno runtime environments.
- In-memory database operation supports temporary and disposable data stores.
- Persistent browser storage uses IndexedDB to retain data between sessions.
- Filesystem persistence supports applications running outside the browser.
- PostgreSQL extension support includes pgvector and PostGIS.
- Asynchronous JavaScript interface supports database queries and SQL execution.
- Reactive bindings and related integration packages support applications that respond to database changes.
- Integration with node-postgres allows compatible clients and modules to work with embedded databases.
- Single-user connection model allows PostgreSQL to operate without its conventional multiprocessing server architecture.
Website: github.com/electric-sql/pglite
Support:
Developer: Electric
License: Apache License 2.0 and PostgreSQL License
PGlite is written in TypeScript. Learn TypeScript with our recommended free books and free tutorials.
Related Software
| Relational Databases | |
|---|---|
| MariaDB | High compatibility with MySQL, ensuring drop-in replacement capability |
| PostgreSQL | Award winning Object-relational database management system |
| MySQL | Multithreaded, multi-user SQL database management system |
| SQLite | Embeddable SQL Database Engine |
| TiDB | Cloud-native, distributed SQL database |
| DuckDB | In-process SQL OLAP database management system |
| Turso | In-process relational database engine |
| YugabyteDB | PostgreSQL-compatible distributed SQL database |
| rqlite | Distributed database built on SQLite |
| MonetDB | High performance relational database system for analytics |
| Dolt | Version-controlled SQL database |
| Firebird | Relational database offering many ANSI SQL features |
| H2 | Relational database management system written in Java |
| HSQLDB | JDBC interface, client-server version, query tool, grid and more |
| CUBRID | Database engine with built-in enterprise grade features |
| Apache Cloudberry | Massively parallel processing database |
| Virtuoso | Data Management with Web Application Server and Web Services |
| Apache Derby | Full-featured relational database implemented entirely in Java |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.