showcase
postgresql-replicant
showcase | postgresql-replicant | |
---|---|---|
10 | 5 | |
150 | 38 | |
2.0% | - | |
4.7 | 3.2 | |
11 months ago | 9 months ago | |
TypeScript | Haskell | |
GNU General Public License v3.0 or later | BSD 3-clause "New" or "Revised" License |
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.
showcase
-
Appropriate way to retrieve data from PlanetScale in client side code?
While the example is next interacting with postgresql, the lib also supports mysql (and planetscale by extension) https://github.com/subzerocloud/showcase/tree/main/node-myrest
-
PostgREST – Serve a RESTful API from Any Postgres Database
Soon (in the works now, it will be particularly interesting in the context of cloudflare workers talking to planetscale)
https://github.com/subzerocloud/showcase
-
Go and SQLite in the Cloud
Yes there is but not FOSS
https://github.com/subzerocloud/showcase/tree/main/flyio-sql...
- Blue-steel: REST API for your database (PostgreSQL/SQLite)
-
Postgres wire compatible SQLite proxy
You can query and write to SQLite over http with [1] (i wrote it) but it's not through the method you describe (range for files).
https://github.com/subzerocloud/blue-steel
- Is there anything like this in Rust?
- Show HN: The power of PostgREST in a Rust library
- The power of PostgREST in a Rust library (looking for feedback)
- Automated REST API for PostgreSQL/SQLite/ClickHouse (In Rust)
postgresql-replicant
-
PostgREST – Serve a RESTful API from Any Postgres Database
You can use a library like https://github.com/agentultra/postgresql-replicant or similar to hook in a data plane and use PostgREST as a data plane.
Your business logic works on the event stream that comes from the WAL.
-
backend.sql and frontend.js = ♥
I wrote postgresql-replicant [0] in order to do this. It’s not a novel idea. It lets you read the logical replication stream.
On top of this library you can do all sorts of things: replicate data to Kafka or SQS, write a web socket server to publish changes to clients, etc.
[0] https://github.com/agentultra/postgresql-replicant
-
Ask HN: What are some tools / libraries you built yourself?
https://github.com/agentultra/postgresql-replicant — stream delta changes from a PostgreSQL database. Not a novel concept or implementation but this library doesn’t exist in Haskell and that’s a shame because Haskell has lots of great libraries for working with streams.
https://github.com/agent ultra/DataVersion — type-directed data migration library. I needed to migrate some data in a document database that had no schema with years of data in it to a format that had a schema. I leveraged some other stuff to achieve it but this library was a key piece to being confident that the transformations were correct and complete. Migrated the database and backfill it with a Lambda function using this library.
Those are just the most recent ones.
-
Haskell good for general use?
On my stream at https://twitch.tv/agentultra I've been working on a library to stream changes out of a PostgreSQL database. We've had to figure out how to use low-level libpq bindings, concurrency primitives, serializing and deserializing binary messages, etc. You can find the library here: https://github.com/agentultra/postgresql-replicant
-
[Announce] postgresql-replicant-0.1.0.0-candidate: streaming PostgreSQL changes
You can star the repo and report issues at: https://github.com/agentultra/postgresql-replicant -- new contributors are welcome! I'm still working out a contribution guide, it's still super early on the project. I can be found here and on the FP Slack (https://fpchat-invite.herokuapp.com/) and on the FP Zulip (https://funprog.zulipchat.com)
What are some alternatives?
kysely - A type-safe typescript SQL query builder
lowdefy - The config web stack for business apps - build internal tools, client portals, web apps, admin panels, dashboards, web sites, and CRUD apps with YAML or JSON.
cf-socket-server - This nifty little project is a swiss army knife for realtime backend projects. It is scoped to rooms, and encompasses multiple useful features.
GoJS, a JavaScript Library for HTML Diagrams - JavaScript diagramming library for interactive flowcharts, org charts, design tools, planning tools, visual languages.
annuaire-entreprises-sirene-api
Pion WebRTC - Pure Go implementation of the WebRTC API
cloudflare-for-speed-and-security - Scale faster and save big with the global edge cloud platform - https://kerkour.com/cloudflare-for-speed-and-security
Tabula - Extract tables from PDF files
postlite - Postgres wire compatible SQLite proxy.
Zip Foundation - Effortless ZIP Handling in Swift
marmot - A distributed SQLite replicator built on top of NATS
null - reasonable handling of nullable values