Feature request: `bytea` ids and field

[prevostc]

Postgres bytea column type is more space efficient than string and makes hex value comparison "case insensitive", which is perfect for any Bytes and/or ID fields.

[prevostc]

That could help with #634

[DZakh]

Thanks for the suggestion. This is actually not easy to implement, so I removed the "Good first issue" label.

[DZakh]

The problem is that in handlers, we treat addresses as strings, but to write them to Bytea field we'd need to convert them to Uint8Array or Buffer in runtime, which I'd like to avoid.

[DZakh]

I'll think how we should approach it differently.

[prevostc]

The problem is that in handlers, we treat addresses as strings, but to write them to Bytea field we'd need to convert them to Uint8Array or Buffer in runtime, which I'd like to avoid.

@DZakh I believe this serialization / deserialization is already handled by postgres.js here, correct? https://github.com/porsager/postgres/blob/v3.4.7/src/types.js#L37

there is also custom types https://github.com/porsager/postgres?tab=readme-ov-file#custom-types
not sure wich is easier to use.