Hi <@U0EC2UPDF>, you can tell me the difference be...
# exposed
s
Hi @tapac, you can tell me the difference between Blob and Binary columns? And in the future you add like a column for ByteReadPacket using Blob?
t
The main difference is the representation in a database for the most databases (except Postgresql and Orable) binary column used
varbinary
limited by column length and blob uses
blob
- without limitations. What is
ByteReadPacket
?
s
Is from the Kotlinx.io https://github.com/Kotlin/kotlinx-io/blob/master/core/commonMain/src/kotlinx/io/core/ByteReadPacket.kt -- I don't know you but blob is kinda annoying to use(annoying because I always parse to bytearray)
Maybe a ByteArray column using Blob can help a lot, but I think is not the goal of the project because the Table is exactly like the Table from SQL, blob is Blob, text is Text, dateTime is DateTime, etc...
t
The current problem is that Exposed works over JDBC which has not very comfortable API to work with blobs, but I plan to separate JDBC implementation from Exposed main API and then (maybe) it will be possible to improve blobs.
❤️ 1