datasette-stripe
rqlite
datasette-stripe | rqlite | |
---|---|---|
6 | 112 | |
20 | 14,898 | |
- | 0.9% | |
0.0 | 9.9 | |
almost 2 years ago | 1 day ago | |
JavaScript | Go | |
MIT License | MIT 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.
datasette-stripe
-
Zed Shaw Explains How Stripe Is PayPal Circa 2010
If you want to analyse your payment failures with SQL you could use https://table.dog to download them into a SQLite database.
-
SQLite is not a toy database
https://table.dog is a CLI that downloads your Stripe account to a SQLite db.
Would appreciate it if you could test it out if you are interested.
-
Rust 1.63.0
https://table.dog (a CLI to download Stripe to SQLite).
I considered Node.js, C#.
I went with Rust for a few reasons:
- Easy to build small portable binaries (as a primary language feature).
- The type checker ensures type consistency when writing out to SQL tables (SQLite is loosely typed). Code that reads from the SQLite database implicitly benefits from Rusts strong type checks.
- Macros to convert structs to SQL insert/updates.
- Reduce the chance of errors at runtime.
- Leverage as much as SQLite's write throughput as possible.
- When converting Stripes Open API JSON spec into Rust code (using another Node.js program), the Rust type checker ensures I have a well formed HTTP client - the strict compiler makes it a good target for generated programs. Read more about this idea at (https://willcrichton.net/notes/rust-the-new-llvm/).
-
Show HN: Tdog – Download Stripe to SQLite
This is a CLI written in Rust to download your Stripe account to a local SQLite database.
It is intended to enable using SQL queries over your data.
There is also a template for fly.io and Datasette to give you a Sigma like web UI:
https://github.com/tabledog/datasette-stripe
- Show HN: Stripe Sigma alternative: tdog – SQLite – Datasette
rqlite
- The lightweight, easy-to-use, distributed relational database built on SQLite
-
CursusDB – A new scalable distributed document oriented database
Seems like you could do the same with rqlite [1], since SQLite supports JSON.
[1]: https://rqlite.io
-
Rqlite 8.0
rqlite[1] creator here, happy to answer any questions about rqlite, this latest release, and how it works.
[1] https://rqlite.io
-
Adding new database engine support
I found simple distributed RQlite https://github.com/rqlite/rqlite based on raft and sqlite. How hard is to add it?
- I'm All-In on Server-Side SQLite
-
So, you want to deploy on the edge?
rqlite[1] creator here, happy to answer any questions. rqlite also supports read-only nodes, which can also help with reads at the "edge". It probably wouldn't scale to 100s of nodes, it is an option.
"rqlite supports adding read-only nodes. You can use this feature to add read scalability to the cluster if you need a high volume of reads, or want to distribute copies of the data nearer to clients – but don’t want those nodes counted towards the quorum. These types of nodes are also known as non-voting nodes."
[1] https://rqlite.io/
[2] https://rqlite.io/docs/clustering/read-only-nodes/
- LiteFS Cloud: Distributed SQLite with Managed Backups
- Show HN: Rqlite, distributed DB built on SQLite, now runs on MIPS, RISC, PowerPC
- rqlite v7.19.0: the lightweight distributed relational database built on Go, Raft, and SQLite -- now runs on MIPS, PowerPC, and RISC
- rqlite v7.18: the lightweight distributed database built on Go, Raft, and SQLite -- now with new Unified HTTP endpoint for easy reads and writes
What are some alternatives?
mvsqlite - Distributed, MVCC SQLite that runs on FoundationDB.
dqlite - Embeddable, replicated and fault-tolerant SQL engine.
enarx - Enarx: Confidential Computing with WebAssembly
litestream - Streaming replication for SQLite.
sqlitedao - Simple dao for sqlite for personal/desktop projects
cockroach - CockroachDB - the open source, cloud-native distributed SQL database.
tokio-scoped - Scoped Runtime for tokio
bolt
subscription-use-cases - Create subscriptions with fixed prices or usage based billing.
etcd - Distributed reliable key-value store for the most critical data of a distributed system [Moved to: https://github.com/etcd-io/etcd]
parquet-wasm - Rust-based WebAssembly bindings to read and write Apache Parquet data
TinyGo - Go compiler for small places. Microcontrollers, WebAssembly (WASM/WASI), and command-line tools. Based on LLVM.