postgres-browser vs postgres-wasm

postgres-browser

A PostgresQL server running in your browser [Moved to: https://github.com/snaplet/postgres-wasm] (by snaplet)

DISCONTINUED

Suggest alternative

Edit details

postgres-wasm

A PostgresQL server running in your browser (by snaplet)

WASM Playground Postgres

Source Code

Suggest alternative

Edit details

InfluxDB - Power Real-Time Data Analytics at Scale

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

www.influxdata.com

featured

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

featured

postgres-browser		postgres-wasm
	Project
1	Mentions	11
1,545	Stars	2,248
-	Growth	1.3%
10.0	Activity	2.8
over 1 year ago	Latest Commit	about 1 month ago
Shell	Language	Shell
MIT License	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

postgres-browser

Posts with mentions or reviews of postgres-browser. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-10-10.

Postgres WASM by Snaplet and Supabase
7 projects | dev.to | 10 Oct 2022

See source code.

postgres-wasm

Posts with mentions or reviews of postgres-wasm. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-01-03.

Container2wasm: Convert Containers to WASM Blobs
16 projects | news.ycombinator.com | 3 Jan 2024

Also: https://github.com/copy/v86 - more productized browser x86 runtime, used by eg https://github.com/snaplet/postgres-wasm
Show HN: I made a SQL game to help people learn / challenge their skills
2 projects | news.ycombinator.com | 22 Apr 2023

> forcing SQLite
It might be the case that it's running SQLite via wasm. If so, then other database engines would need to be runnable in a browser too.
PostgreSQL has been shown to work in the browser (eg https://www.crunchydata.com/blog/learn-postgres-at-the-playg..., and also https://github.com/snaplet/postgres-wasm), so that might be an option.
Not sure about others.
WebAssembly: Docker Without Containers
9 projects | news.ycombinator.com | 21 Dec 2022
Show HN: SadServers. Test your Linux troubleshooting skills
5 projects | news.ycombinator.com | 26 Oct 2022

Thanks, I've been looking at WASM, for ex https://github.com/snaplet/postgres-wasm/tree/main/packages/... , it would certainly simplify everything to "download a fat file".
The Docker+WASM Technical Preview
9 projects | news.ycombinator.com | 24 Oct 2022
Hey! Peter from Snaplet here. This is really exciting stuff. We created the OSS postgres-wasm (https://github.com/snaplet/postgres-wasm) example a few weeks ago. An idea I'm playing around with is something like:
```
  1. Visit https://postgresql.com/try?version=14.x
```
How to test nestjs modules?
10 projects | /r/Nestjs_framework | 13 Oct 2022

Other in-memory alternatives for PostgreSQL embedded-postgres (I haven't tried it yet) postgres-wasm (currently it only runs in the browser).
PostgreSQL 15 Released!
2 projects | /r/programming | 13 Oct 2022

"/s" is obsolete as of now: https://github.com/snaplet/postgres-wasm I'm so sorry
Postgres WASM by Snaplet and Supabase
7 projects | dev.to | 10 Oct 2022

Today we're open sourcing postgres-wasm with our friends at Snaplet.
GitHub - snaplet/postgres-wasm: A PostgresQL server running in your browser
1 project | /r/devopsish | 8 Oct 2022
Show HN: Postgres WASM
16 projects | news.ycombinator.com | 3 Oct 2022

Peter from Snaplet here. A month ago I saw the CrunchyData post and wanted to play around with the code that made it happen, it wasn't OSS so I asked for help:
> If anyone out there wants to work on an open source version of this full-time please reach out to me. [0]
Paul reached out and we started working on it almost immediately. Check out the repo here: https://github.com/snaplet/postgres-wasm
We have a blog post about some of the interesting technical challenges that we faced whilst building this: https://www.snaplet.dev/post/postgresql-in-the-browser
Like most things, this is built on-top of the amazing open-source projects that made this possible, but special mention goes to v86.js and buildroot. We just glued it together.
---
[0] Request for collaboration: https://news.ycombinator.com/item?id=32500526

What are some alternatives?

When comparing postgres-browser and postgres-wasm you can also consider the following projects:

postgres-wasm - A PostgresQL server in your browser

microservice-rust-mysql - A template project for building a database-driven microservice in Rust and run it in the WasmEdge sandbox.

websockproxy

sadservers - SadServers: Linux & DevOps Troubleshooting Scenarios SaaS

v86 - x86 PC emulator and x86-to-wasm JIT, running in the browser

Greenplum - Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.

absurd-sql - sqlite3 in ur indexeddb (hopefully a better backend soon)

wasmtime - A fast and secure runtime for WebAssembly

copycat - Generate deterministic fake values: The same input will always generate the same fake-output.

jest-mock-extended - Type safe mocking extensions for Jest https://www.npmjs.com/package/jest-mock-extended

pg_ivm - IVM (Incremental View Maintenance) implementation as a PostgreSQL extension