showcase
TPC-C
| showcase | TPC-C | |
|---|---|---|
| 10 | 1 | |
| 150 | 7 | |
| 2.0% | - | |
| 4.7 | 10.0 | |
| 11 months ago | almost 6 years ago | |
| TypeScript | TypeScript | |
| GNU General Public License v3.0 or later | - |
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)
TPC-C
-
Postgres wire compatible SQLite proxy
I think the following could be an interesting project:
A pair of programs. One to emulate Postgres server, another to emulate a Postgres client. These two programs would assume they are just talking to each other, and know exactly what to expect from the other side.
Then we can inject a protocol implementer (the system under test, or SUT) between these two programs and see if the SUT can make both these programs believe that they are still talking just with each other. This way we can validate the level of protocol support by the SUT. And if we can run this whole setup, multiple clients, a server, and the SUT, under controlled conditions, we can also evaluate the performance of each such protocol implementation.
The Postgres client emulator would send a predefined set of commands, and would know exactly what the response should be. The Postgres server emulator would know exactly what commands to expect, and the hard-coded responses to send for each incoming command.
The client emulator's knowledge of the responses would make it easy to catch any errors/bugs introduced by the SUT.
The Postgres server emulator would _not_ implement any server-side logic (command parsing, planning, etc.), to ensure the peak performance for each command it processes.
I was thinking of implementing such a Postgres server emulator back in around 2014, but for a different reason. IIRC, I was thinking of calling it Black Hole Postgres, to test the performance of my TPC-C implementation, DBYardstick [1].
[1]: https://github.com/DBYardstick/TPC-C
What are some alternatives?
kysely - A type-safe typescript SQL query builder
mysql-proxy - MySQL Proxy is a simple program that sits between your client and MySQL server(s) and that can monitor, analyze or transform their communication. Its flexibility allows for a wide variety of uses, including load balancing, failover, query analysis, query filtering and modification, and many more.
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.
postlite - Postgres wire compatible SQLite proxy.
annuaire-entreprises-sirene-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
marmot - A distributed SQLite replicator built on top of NATS
durafetch-server - Download all Cloudflare durable object state to a local SQLite database.
postgrest-starter-kit - Starter Kit and tooling for authoring REST API backends with PostgREST
sqlc - Generate type-safe code from SQL
sshfs - A network filesystem client to connect to SSH servers