sql

All things SQL and JDBC...
Cora (she/her) 2020-02-24T22:34:54.003100Z

anyone have advice on how to use postgres jsonb columns with next.jdbc?

valtteri 2020-02-27T10:04:14.014500Z

Iā€™m not sure if this is what you were asking but I hope it helps!

dharrigan 2020-02-27T10:38:12.014700Z

that is very handy!

Cora (she/her) 2020-02-27T11:42:38.016500Z

yep!! that's basically what we arrived at except we also encode vectors to json. thank you!

dharrigan 2020-02-27T14:03:25.016800Z

I think was is missing is a way to query the json data, using the chaining operators.

seancorfield 2020-02-24T22:35:48.003800Z

No, but if someone is willing to write up documentation on that, I'll happily add it to the PostgreSQL Tips & Tricks section of the docs!

valtteri 2020-02-28T21:08:27.029600Z

Wow! That was quick

teodorlu 2020-03-02T16:47:17.062400Z

Thanks a lot, @valtteri! I'm really happy to see this make its way into the official docs.

šŸ™‚ 1
Cora (she/her) 2020-02-24T22:36:01.004Z

alrighty, thanks!