LiveCode Forums.

... Didn't think I'd need to further clarify, but since you explicitly ask:
SQLite is file storage and while accessed with similar commands to RDBMS's ... records in a >127,000 record, very complex medical imaging database with BLOB image data took an average 93 milliseconds on 10 reads. I suspect that ...

... script will read the table and image file in "c:temp"

The save blob in sqlite is some different with mysql or odbc, so there is 2 method to insert blob data in sqlite db

I think in mysql will need base64encode to storage blob field, but in my case I don't need base64encode to storage blob ...

... cool would it be to have the app (or just card) definition stored in an SQLite db on a phone !?

The LC stack file format is very compact. If you need to store it in a DB you can use a blob field, but unless you need to manage the blog with relational metadata you'll find reading LC stack files from ...

Here's an updated stack that uses BLOB.
I updated the file to include the "binary" opening of the database.

... correctly (I think, at least).

The first is to ensure you open the sqlite db in "binary" mode - pass "binary" as the third parameter when opening ... data rather than text. This inserts the value of the var as an SQLite blob literal, rather than a string literal.

The final thing to do is to only ...

... then your generalization is correct. Using base64encode/decode is a safe way to get binary data in/out of a VARCHAR field in the database. It isn't the only way to store the data though. You could use the BLOB type to avoid needing to convert, but I've not experimented with it to provide specifics.

... is a bug somewhere. I just don't know whether it is in LiveCode or SQLite or my understanding of the concepts involved. It may well be in my ... its original state. In the SQLite database I have tried the datatype of blob as well as nvarchar. Here are the steps:

1. Unzip the stack "Encryption ...

... Your solution has solved the problem. The data type is now showing as BLOB and the full chunk of data is now in the tImage variable.

my final ... db as "binary" and this has corrected the issue
put revOpenDatabase("sqlite","countries-raster.mbtiles", "binary") into tID -- open the database ...

@n.allan: The sqlite driver originated with SQLite2 which did not support binary data... This meant that binary data had to be explicitly encoded as ... tID -- open the database

The 'binary' option turns off the encoding LC would do otherwise, and should mean BLOBs are stored and retrieved as BLOBs.

... to aid in debugging

set the defaultFolder to specialFolderPath("resources") -- place the database file beside the stack
put revOpenDatabase("sqlite","countries-raster.mbtiles") into tID -- open the database
if tID is not a number then -- In my test tID is a valid integer meaning the connection ...

I am having trouble reading BLOB data from an SQLite database file.

In my sqlite database there is a table called tiles. The columns in it are zoom_level (INTEGER), tile_row (INTEGER), tile_column (INTEGER) and tile_data (BLOB).

For anyone "in the know" these are industry standard raster ".mbtiles ...

... AUTOINCREMENT NOT NULL,
cipher char(64),
rootKey char(64),
simplePW blob
);

CREATE TABLE account (
aKey integer PRIMARY KEY AUTOINCREMENT NOT ... the cDatabaseStructure of this stack into tSQL
put revOpenDatabase("sqlite", tPath,"binary") into tDatabaseID
revExecuteSQL tDatabaseID, tSQL ...

... sure I understand the question fully, so pardon my ignorance.

While a blob in sqlite is generally there for storage of binary data, sqlite itself is a single user accessed db, normally used for local storage. Right off the top, that would prevent multiple users from doing anything with (a single ...

... if it was possible to save the current state of a main stack into a "Blob" container using SQLite. What I am trying to accomplish is keeping the data up to date in my main stack when multiple users across multiple user profiles on Windows are accessing the program. I assume that as long as I create ...

If I have 300 to 500 electronic parts in an sqlite LiveCode desktop application, would putting 1 to 5 small images (perhaps no more than 60 Kb each in ... that storing the images would be as binary files.

Well, as a blob, but not necessarily as binary. I believe the recommended way would be to ...