Show HN: Postgres WASM

1. postgres-wasm

   1 11 2,316 2.8 Shell

   Discontinued A PostgresQL server running in your browser

   

   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

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. wasmer-postgres

   2 4 415 0.0 Rust

   💽🕸 Postgres library to run WebAssembly binaries.

   

   I believe the team at Wasmer have worked on something like this:

   https://github.com/wasmerio/wasmer-postgres

   It only works for PG10, but I can't imagine it will take much effort to bring it up to the latest version

4. postgres-wasm

   3 5 103 0.0 Shell

   A PostgresQL server in your browser (by supabase-community)

   

5. copycat

   4 15 961 6.4 TypeScript

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

   

6. Puts Debuggerer

   5 3,463 202 4.2 Ruby

   Ruby library for improved puts debugging, automatically displaying bonus useful information such as source line number and source code.

   

7. webusb

   6 15 1,348 4.3 Bikeshed

   Connecting hardware to the web.

   

8. litefs

   7 40 4,289 3.5 Go

   FUSE-based file system for replicating SQLite databases across a cluster of machines

   

   We actually kinda see parts of this in https://github.com/superfly/litefs, albeit for SQLite.

   And here we see some ideas forming around "pluggable storage for PostgresQL": https://wiki.postgresql.org/wiki/Future_of_storage#Pluggable...

   Seriously! If any of this sounds interesting to build, reach out, and we'll make it happen!

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. Greenplum

    8 9 6,221 9.9 C

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

    

    I was wondering if anyone had thought about using this to experiment with the planner.

    The engineering and support teams at Greenplum, a fork of Postgres, have a tool (minirepro[0]) which, given a sql query, can grab a minimal set of DDLs and the associated statistics for the tables involved in the query that can then be loaded into a "local" GPDB instance. Having the DDL and the statistics meant the team was able to debug issues in the optimizer (example [1]), without having access to a full set of data. This approach, if my understanding is correct, could be enabled in the browser with this Postgres WASM capability.

    [0] https://github.com/greenplum-db/gpdb/blob/6X_STABLE/gpMgmt/b...

11. go

    9 2,237 126,590 10.0 Go

    The Go programming language

    

    Have you looked at compressing that ~16MB wasm file with something like Brotli?

    When I was actively doing stuff with wasm (~2019), Brotli was the best compression approach. eg 16MB uncompressed -> 2.4MB compressed

    https://github.com/golang/go/wiki/WebAssembly#reducing-the-s...

12. v86

    10 163 20,463 9.5 JavaScript

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

    

    > How much work was done supporting the VM

    All of the heavy lifting here is done by v86: https://github.com/copy/v86

    v86 can be used for a number of things besides Postgres - things like Repls or other entire applications are definitely achievable.

    Networking between Postgres and the internet was a lot of work, and Mark came up with a neat solution detailed in the blog post.

    This solution can be used for any other application. If you're looking to run a native application in the browser using v86, the repo & blog post is a good launching pad.

13. direnv

    11 180 13,244 7.4 Go

    unclutter your .profile

    

    I think `direnv` [1] may be closer to `asdf` than this. They also mention it, and the integration, `asdf-direnv` on their website [2].

    [1] https://direnv.net/

14. byoda

    12 1 0 10.0 Ruby

    Data breach resistant application: Bring Your Own Database

    I was trying to find a way to make apps "data-leak resistant" and one step into this direction was to let the user store the data by bringing his/her own database. I even made a poc https://github.com/andersonDadario/byoda (explanation in the blog post link found on the readme) - but no user would manage his own database. Having a database in the browser opens more possibilities though. I will give it some thought. Looking forward to what else will be built on WASM.

15. actually-serverless

    13 6 62 2.2 JavaScript

    Dynamic HTTP Endpoints in your Browser

    

    I wrote an in-browser serverless platfrom [1] a few months ago with which this would pair well; but seeing the techniques described here, it might make sense to compile workerd [2] to wasm instead.

    [1] https://github.com/johnhenry/actually-serverless

16. workerd

    14 41 6,576 9.9 C++

    The JavaScript / Wasm runtime that powers Cloudflare Workers

    

17. SaaSHub

    www.saashub.com featured

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    

Suggest a related project