I’d love to help create support for byte arrays from postgres. Has this been tried before? Any pointers to where to start in the codebase?
Mats
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
jesse
2
I’m curious about the use case for bytearrays in a data visualization tool. Could you clarify how this would be used?
Sure.
We run and operate databases with Ethereum data in it. A lot of that data is encoded naturally as hex encoded bytearrays. Our usecase is simply that a lot of our data is stored as byte arrays, and we’d like redash to support visualising it in e.g. tables.
I think the fix would be simple (0x prefixing and hex encoding).
arikfr
4
I don’t remember if it’s in v6 already or only in master (you can check the changelog), but there is already support for bytearrays.
Sounds great, would you mind pointing me to the relevant documentation or code?
I was looking at this section: https://github.com/getredash/redash/blob/23908edc284600b9c1ac0b835289b78d337f5a44/redash/query_runner/init.py#L37-L44, and from it it looks like byte arrays are not supported?
arikfr
6
The relevant code is in our JSON serialization code:
https://github.com/getredash/redash/blob/23908edc284600b9c1ac0b835289b78d337f5a44/redash/utils/init.py#L99-L100
1 Like
jesse
7
Showing my n00b status but I would not have thought to look there. But this is a nice implementation because it de facto supports bytes-like return values from any database, not just Postgres.
1 Like
Awesome. I’ll try it out. Do you know the correct path to version 6 on google storage?
For reference version 5.0.2 is according to this page at gs://redash-images/redash.5.0.2-b5486-build2.tar.gz
