datasette-stripe
sqlitedao
Our great sponsors
datasette-stripe | sqlitedao | |
---|---|---|
6 | 3 | |
20 | 2 | |
- | - | |
0.0 | 0.0 | |
almost 2 years ago | over 1 year ago | |
JavaScript | Python | |
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
sqlitedao
-
Show HN: Minimal, no-JS web forum software
May I recommend an ORM for any such project? hand rolling SQL statement aren't going to scale.
Here's my shameless plug: `pip install sqlitedao`: https://github.com/Aperocky/sqlitedao
-
Flyweight: An ORM for SQLite
Here's a python (pip) version of the same concept:
https://github.com/Aperocky/sqlitedao
https://pypi.org/project/sqlitedao
Same concept, huge speed boost to personal projects.
- SQLite is not a toy database
What are some alternatives?
mvsqlite - Distributed, MVCC SQLite that runs on FoundationDB.
enarx - Enarx: Confidential Computing with WebAssembly
awesome-sqlite - A curated list of awesome things related to SQLite
tokio-scoped - Scoped Runtime for tokio
agreper - Minimal, no-JS web forum software
subscription-use-cases - Create subscriptions with fixed prices or usage based billing.
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines
parquet-wasm - Rust-based WebAssembly bindings to read and write Apache Parquet data
mayim - The *NOT* ORM hydrator
transmitic - Encrypted, peer to peer, file transfer program :: https://discord.gg/tRT3J6T :: https://www.reddit.com/r/transmitic/ :: https://twitter.com/transmitic
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at: