Ic

Iceaxe – A modern, fast ORM for Python and Postgres

Hacker News

Iceaxe – A modern, fast ORM for Python and Postgres

Hey HN, I've been writing webapps in Python for 6 years and have been using SQLAlchemy as my ORM for about that same time. As I've recently scaled more products with this stack a few things occurred to me: - It takes really careful session management to avoid idle-in-transaction hanging in the database because objects are still floating around (see: PEP 249 and its prioritization “implicit begin” and “explicit commit”) - Not once have we switched backend databases, we've always stuck with Postgres While it was baking hot in San Francisco a few weekends ago I took a step back to write a ground-up Postgres ORM with modern syntax. It main focuses are typehinted schemas, async support, integrated database migrations, and explicit transaction management. You can certainly do all this with existing solutions but my hope is by making them first class primitives it's easier to write correct and performant database code. Give it a try - would love to hear what you think! (More documentation is also at https://mountaineer.sh/iceaxe/guides/quickstart )

Share card

Actual performance

2points
2comments
Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →
Hacker NewsStrong engagement from HN community · Strong signals: exist, existing, ide · Missing: https docs, excited, just released
79%79% predicted probability of success on Hacker News, based on ML models trained on real launch data.
nativeThis product was originally launched on this platform.
Product HuntOn track for Day 1 leaderboard · Strong signals: apps, using, code · Missing: mac, agents, macos
72%72% predicted probability of success on Product Hunt, based on ML models trained on real launch data.
Indie HackersFits the IH revenue-focused audience · Missing: supports, reddit linkedin, podcasting
68%68% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.
TrustMRRLess likely to generate early MRR · Strong signals: apps, way · Missing: mobile apps, ios, personal
36%36% predicted probability of success on TrustMRR, based on ML models trained on real launch data.
AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive
28%28% predicted probability of success on AppSumo, based on ML models trained on real launch data.
Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue
17%17% predicted probability of success on Acquire.com, based on ML models trained on real launch data.
BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto
0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Incorrect prediction on native model

Similar products

Si
Sink 5000 rows/SEC from Kafka –> Postgres using Python and 250MiB Mem70%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Sink 5000 rows/SEC from Kafka –> Postgres using Python and 250MiB Mem

Hacker News2
1M
1M rows/s from Postgres to Python70%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

1M rows/s from Postgres to Python

Hacker News296
Fa
Fast suffix arrays in Python61%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Fast suffix arrays in Python

Hacker News72
jp
jpegtran-cffi: Fast JPEG transformations with Python68%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

jpegtran-cffi: Fast JPEG transformations with Python

Hacker News1
Pg
Pgmigrate, modern Postgres migrations CLI38%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Pgmigrate, modern Postgres migrations CLI

Hacker News2
Pg
PgModeler – EER Diagramming for postgres73%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

PgModeler – EER Diagramming for postgres

Hacker News9
Me
Merging RethinkDB and Postgres with GraphQL79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Merging RethinkDB and Postgres with GraphQL

Hacker News6
Fi
First experiment wih Vertx,Vue,Postgres48%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

First experiment wih Vertx,Vue,Postgres

Hacker News1
No
Now supporting MySQL, Postgres, Redis, Mongo60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Now supporting MySQL, Postgres, Redis, Mongo

Hacker News3
Gr
GraphQL for Postgres83%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

GraphQL for Postgres

Hacker News195