Favorite DB tools
Posted by Original-Produce7797@reddit | Python | View on Reddit | 18 comments
Python backend developers, what are your favorite database or sql-related tools or extensions that made your work easier?
slotix@reddit
DuckDB + raw SQL is hard to beat right now, especially for anything involving files.
One thing I’ve started appreciating more is tools that let you query across sources (DB + parquet/JSON/S3) without setting up a pipeline first. Being able to quickly join a Postgres table with a local dataset or a file dump is surprisingly useful during debugging and prototyping.
Still using SQLAlchemy/asyncpg in apps, but for exploration and quick analysis I lean more toward that kind of workflow now.
Original-Produce7797@reddit (OP)
if it's not a secret, what are you building? i wonder because I saw s3, but nobody i know uses s3 for local prototyping. Thanks for sharing your experience
slotix@reddit
been building a tool around that, DBConvert Streams
mostly focused on querying across sources first, then moving or syncing data if needed
S3 part isn’t really about local prototyping, more about data that already ends up there (exports, logs, backups, dumps)
sometimes it’s just easier to query it in place instead of loading it somewhere first
PriorTrick@reddit
I like datagrip but you can also use Dbeaver for free, pretty similar functionality. The database extension in vscode is just okay. Otherwise I tend yo just use asyncpg, write raw sql and return pydantic models.
aifrantz@reddit
Been using DBeaver and DataGrip. I am having fun with both.
MyWorksandDespair@reddit
DuckDB, hands down.
Scrapheaper@reddit
For backend? I know it as a data engineering tool, does it support transactions?
MyWorksandDespair@reddit
Yes, it’s full ACID compliant. It’s one of the only open source tools that doesn’t neuter its functionality behind a paywall and actually does what it claims.
CorpusculantCortex@reddit
Duckdb direct read from s3 parquet store is my jam right now
NameThatIsntTaken13@reddit
Underrated, def +1 to duckdb
fcomdword@reddit
Prisma
fenghuangshan@reddit
for sqlite , i recommend sqlite studio
gerardwx@reddit
Datagrip
Miserable_Ear3789@reddit
mongoKV
MajesticParsley9002@reddit
Alembic for migrations and pgcli for CLI queries. Alembic versions your schema changes perfectly, no more manual SQL hell in production. pgcli's autocomplete and fuzzy search make ad-hoc queries stupid fast.
sudonem@reddit
The obvious answer is DB Browser for SQLite.
Original-Produce7797@reddit (OP)
interesting tool, because i tried to visualize sqlite in vscode, but most extensions don't do their job all that well, and CLI is far from ready OOTB, I'll give it a try, thanks mate
One-Novel1842@reddit
Sqlalchemy in async python: https://github.com/krylosov-aa/context-async-sqlalchemy