Ben HardillNov 24, 2022
Anybody out there found a good #NodeJS client for #postgres #hstore? The best hit on npm appears to be abandoned
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
Show threadBen Hardill
@abraxas Thanks, I'll have a look. But we are already using Sequelize for our ORM so may not want to introduce another...
Nov 25, 2022 at 1:30pmWeb
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 threadBen HardillNov 25, 2022
@abraxas We already have PostgreSQL so it has that in it's favour, it also appears to have a more plugable auth than say redis. Just trying to find something that works for our use case without building it from scratch.
Show threadabraxasNov 25, 2022

@ben Sure!

It's ok to have 2 databases in your solution, though, if the value prop is there. I use redis for session-management anyway because it's blazingly fast. So might be a different story for you.