DbDeclare – A Python declarative layer for your database

Hacker News

Hi HN! I made and just published v0.0.1 of DbDeclare. I use Python a lot, and interact with Postgres a lot. I like using SQLAlchemy, and I love Alembic. Those wonderful tools primarily operate on tables, though, and I often find myself writing custom code to declare what databases, roles, schemas, privileges, etc. I want, and I have a hard time updating them reliably and in a repeatable fashion. That's where DbDeclare aims to help: declare what you want in your cluster (in addition to SQLAlchemy-defined tables and columns) in-code, alongside your tables. There is a lot this can't do yet (thus the v0.0.1), but I think there's a decent foundation here to build on and eventually have really nice features like autogenerating change statements between your in-code definition and what is actually in your database cluster (like Alembic). This is also my first attempt at building an open-source project, so I'm sure there are plenty of mistakes. Please feel free to provide feedback, I'd love to make it better. For what it's worth, I'm aware that you can do some of this at the infrastructure-as-code layer using a tool like Terraform/Pulumi. My personal preference is to have all this sit closer to my tables rather than my infrastructure, so here we are. Anyway, let me know what y'all think. Thanks!

Visit product View on Hacker NewsFeb 27, 2023

Share card

Actual performance

3points

Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →

Product HuntOn track for Day 1 leaderboard · Strong signals: using, code, open · Missing: mac, agents, macos

89%89% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Indie HackersFits the IH revenue-focused audience · Strong signals: mistakes · Missing: supports, reddit linkedin, podcasting

73%73% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

Hacker NewsStrong engagement from HN community · Strong signals: ide, io · Missing: https docs, excited, just released

57%57% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

TrustMRRLess likely to generate early MRR · Strong signals: personal, way · Missing: mobile apps, ios, entrepreneurs

37%37% 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

36%36% 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

13%13% 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

Baldur – Reliability layer for Python (one decorator)37%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Baldur – Reliability layer for Python (one decorator)

Hacker News1

Phoenix database adapter for Python70%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Phoenix database adapter for Python

Hacker News1

An in-memory, NoSQL database implemented in Python66%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

An in-memory, NoSQL database implemented in Python

Hacker News7

C++,MATLAB,Python and Database Designing39%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Its All About Coding Of MATLAB,C++,Python

Indie Hackerscommitment-full-time

Graph Database for Python69%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Graph Database for Python

Hacker News4

A Python-based, in-memory NoSQL database60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

A Python-based, in-memory NoSQL database

Hacker News1

CustomStringParser ( Python)54%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

CustomStringParser ( Python)

Hacker News1

Lusernews is an implementation of lamernews in python48%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Lusernews is an implementation of lamernews in python

Hacker News1

Do/While in Python55%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Do/While in Python

Hacker News4

Gatos, conCATenative functions for python54%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Gatos, conCATenative functions for python

Hacker News1

Browse all products Analyze your launch