https://kotlinlang.org logo
s

SrSouza

07/08/2019, 10:54 PM
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

tapac

07/09/2019, 9:40 AM
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

SrSouza

07/09/2019, 3:19 PM
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

tapac

07/09/2019, 3:26 PM
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