drizzle-team / drizzle-team/drizzle-orm
[FEATURE]: Add support for Postgresql `hstore` data type
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
The `hstore` [(Official Reference)](https://www.postgresql.org/docs/current/hstore.html) data type is used for storing key-value pairs in a single value. We can add value like the following:
`'"paperback" => "243",
"publisher" => "postgresqltutorial.com",
"language" => "English"'`
Json can be used, but nested data can be passed in this case. hstore enforces key-value pairs without nested data and better query support.
Contributor guide
Research direction
Read the PostgreSQL hstore official reference linked in the issue first, then inspect how PostgreSQL data types are represented in drizzle-orm. The issue names no files or tests; done means hstore can be declared, stored, and queried with key-value pairs without nested data.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, typescript
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100