I want to use image storage on DB and not URL.
On my server side I use PostgreSQL and I read here that "bytea" is the suggested format to use in order to store files.
On my mobile app side, the DB is SQLite. It seems the data storage suggested format there is "BLOB" as described here.
I wonder, and I could not clearly find so far, if there is any conversion to do from PostgreSQL's "bytea" to SQLite's "BLOB"?
Both bytea and BLOB are data types within the database for storing raw binary data. They aren't encodings, like base64 or the like, so there is no conversion to do per se.
However, in reality your application will handle this data in at least 5 forms:
bytea columnBLOB columnThe data will flow through each of these forms in turn, so the conversions you need to worry about are not PostgreSQL to SQLite, but PostgreSQL to/from server-side language, server-side language to/from API encoding, and so on. You shouldn't need to make any changes to your mobile app if you change your server to use MySQL, or store the data in separate files, or find a way of creating it on the fly; the two ends of the process are completely separated.
This will be as much about using the right functions as explicitly understanding the encoding, just as storing the file to disk might involve the program environment manipulating the data, but you'd just write file.put(data) or whatever.
