Support byte arrays (from postgres)

#1

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

0 Likes

#2

I’m curious about the use case for bytearrays in a data visualization tool. Could you clarify how this would be used?

0 Likes

#3

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).

0 Likes

#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.

0 Likes

#5

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?

0 Likes

#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

#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

#8

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

0 Likes

#9

We haven’t built a v6 image yet… But you can run an upgrade.

1 Like

AMI for Redash v6
#10

Hi, any update about the v6 image? I want to go straight to redash v6

0 Likes