SrSouza

    SrSouza

    3 years ago
    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?
    tapac

    tapac

    3 years ago
    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
    ?
    SrSouza

    SrSouza

    3 years ago
    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...
    tapac

    tapac

    3 years ago
    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.