Sven GeggusOct 22, 2024
After I upgraded the #postgresql backend to the latest and greatest version of #osm2pgsql and replaced #hstore by #json (jsonb) at the @geofabrik #Openstreetmap hack-weekend the https://opencampingmap.org Website is now up and running again.
OpenCampingMap

OpenCampingMap is a map of campgrounds based on data from OpenStreetMap

OpenCampingMap
CalicosineMar 24, 2023

Ooooohhh, now I get why it's called the "hStore", the "h" stands for "Homebrew".

#hStore #3DS #homebrew

Show threadabraxasNov 25, 2022

@ben Understood! Probably not worth changing an ORM over half-ass support.

It's funny, #hstore is so cool, but I've never worked anywhere that used it seriously. Probably due to lack of tooling. I guess if I wanted that much key-value data, I wouldn't use a SQL database for those models.

Show threadabraxasNov 25, 2022

@ben #prisma appears to have support for #hstore in some way or another. It's not super-well documented.

It may be that it will only map hstore data, not give non-raw query functionality.

https://www.prisma.io/docs/concepts/components/prisma-schema/postgresql-extensions

How to represent PostgreSQL extensions in your Prisma schema

How to represent PostgreSQL extensions in your Prisma scheme, introspect extensions in your database, and apply changes to extensions with Prisma Migrate

Prisma
Ben HardillNov 24, 2022
Anybody out there found a good #NodeJS client for #postgres #hstore? The best hit on npm appears to be abandoned