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, ... 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 ...

... livecode 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 ...

... 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 ...

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

... work 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 ...

... 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 handler ... 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 text and then decoded (when using the *b). If your database is coming from another ...

... 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 ...

... KEY AUTOINCREMENT NOT NULL, cipher char(64), rootKey char(64), simplePW blob ); CREATE TABLE account ( aKey integer PRIMARY KEY AUTOINCREMENT NOT ... put 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 ...

... 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 ...

If I have 300 to 500 electronic parts in an sqlite LiveCode desktop application, would putting 1 to 5 small images (perhaps ... I understand 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 textencode/decode ...