You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2022/11/10 06:05:41 UTC
[GitHub] [age] stanislav-a-frolov opened a new issue, #350: agtype to jsonb conversion
stanislav-a-frolov opened a new issue, #350:
URL: https://github.com/apache/age/issues/350
Hello, everyone.
I'd like to have an agtype to jsonb conversion, so I would be able to write less complicated sql or use Postgresql drivers.
It was mentioned in docs that agtype is quite close to jsonb, so would such conversion be fast enough for large objects?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] dehowef commented on issue #350: agtype to jsonb conversion
Posted by "dehowef (via GitHub)" <gi...@apache.org>.
dehowef commented on issue #350:
URL: https://github.com/apache/age/issues/350#issuecomment-1577575323
@ppKrauss can you share how JSONB functions have evolved in the past few years? This might be useful in seeing what changes we can/should make. Thanks~
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] ppKrauss commented on issue #350: agtype to jsonb conversion
Posted by "ppKrauss (via GitHub)" <gi...@apache.org>.
ppKrauss commented on issue #350:
URL: https://github.com/apache/age/issues/350#issuecomment-1576581304
Hi! There are a fast, secure and orthogonal (reversible) typecasting between AGTYPE and PG datatypes? @jrgemignani can you list here, for performance discussion?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [age] jrgemignani commented on issue #350: agtype to jsonb conversion
Posted by GitBox <gi...@apache.org>.
jrgemignani commented on issue #350:
URL: https://github.com/apache/age/issues/350#issuecomment-1310688969
AGTYPE is based on JSONB and uses modified PG routines for JSONB. So, it is as fast as JSONB. However, it contains some **additions** to JSONB so it is not 1 to 1. There are functions available for typecasting **some** items back and forth between AGTYPE and PG datatypes.
If by complicated SQL you mean the wrapping SQL,... that is due to the nature of PG extensions and what we can and cannot do. It is also why we need to use a container datatype like AGTYPE.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org