Hi team,
Is the PG hstore type supported? Knex doesn’t natively but as it provides the knex.raw function you can use it and there are always custom queries available I am guessing.
However I don’t know if I will find any issues in the future with SC when using it.
I am considering using the hstore type for i18n database content.
id | title (hstore) | content (hstore)
---|-----------------------|------------------------------
1 | "en" => "Hello World",| "en" => "Content in english",
| "es" => "Hola Mundo" | "es" => "Contenido en español"
---|-----------------------|------------------------------
2 | ... | ...
I still need to do a bit more research for search and full text search with hstore fields but I just wanted to know if you can anticipate any problems with this type.
Community Page
Last updated:
Last updated: