datasette-stripe
awesome-sqlite
Our great sponsors
| datasette-stripe | awesome-sqlite | |
|---|---|---|
| 6 | 12 | |
| 20 | 464 | |
| - | - | |
| 0.0 | 5.1 | |
| almost 2 years ago | over 1 year ago | |
| JavaScript | ||
| 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
awesome-sqlite
What are some alternatives?
mvsqlite - Distributed, MVCC SQLite that runs on FoundationDB.
enarx - Enarx: Confidential Computing with WebAssembly
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines
sqlitedao - Simple dao for sqlite for personal/desktop projects
tokio-scoped - Scoped Runtime for tokio
awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources
subscription-use-cases - Create subscriptions with fixed prices or usage based billing.
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
parquet-wasm - Rust-based WebAssembly bindings to read and write Apache Parquet data
rqlite - The lightweight, distributed relational database built on SQLite.