Show HN: DbDeclare – A Python declarative layer for your database 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! https://ift.tt/iHVhG5t February 27, 2023 at 10:04PM
Show HN: StreetComplete, an OpenStreetMap Editor for Humans StreetComplete is an OpenStreetMap[0] editor directed at people who want to contribute and want to do this using their smartphone, without learning how to edit things[1]. It is available as an Android application. It is intended to be used as one walks, with quests appearing as markers on the map. Selecting a marker allows one to answer a simple question. The answer will be added to the OpenStreetMap database, with app handling selecting objects for editing, transforming answer into OSM tags and making edits. OpenStreetMap account is needed to apply edits, but it is possible to start without it, make some edits and login/register later. Note: I am not the main author, but I am one of the active contributors. Github page is at https://ift.tt/2g8lasH and https://ift.tt/3nR9PzS shows what was recently released. [0]OpenStreetMap is a Wikipedia of maps, available on the open licence. This dataset is already used for many interestin...
Comments