pgo icon indicating copy to clipboard operation
pgo copied to clipboard

Support for h_store

Open ghivert opened this issue 2 months ago • 3 comments

Postgres supports the h_store type, to manage a hash map directly in PG columns. While it's probably easier to use jsonb nowadays, it could be useful to add support for older DB.

After diving in pg_types, used internally by pgo, I figured out that pushing a native gleam Dict is enough. Right now, using the ugly dynamic trick (from |> unsafe_coerce) is working, but we could think to add a function like hstore: fn (Dict(String, a)) -> Value in the future.

I'm not sure we should add such a function to the package, but I think it's useful enough to keep this info somewhere, at least to let people interested to know there's a solution to their problem, and wait before someone really needs it before implementing a solution? To make sure we have a correct API.

ghivert avatar May 04 '24 12:05 ghivert