How to check SQLite BLOB Size?

Lincoln Burrows ~ Modified: September 19th, 2015 ~ ~ 1 Minute Reading

This topic has 2 replies, 3 voices, and was last updated 8 years, 7 months ago by Andrew Jackson.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
September 19, 2015 at 10:38 am #681 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

My SQlite Database seems to be bigger than I estimated. How can I check the distribution or whats causing this. It has some BLOB fields. Even after deleting the BLOB data, size doesn’t seem to change.

September 21, 2015 at 12:31 pm #701 Score: 0

Stephen West
Moderator

Karma: 4 pts

For a binary blob? That would be in violation of the SQLite documentation which says blobs are treated as text and as such length() is accurate only until it finds a \0 character

September 22, 2015 at 12:14 pm #710 Score: 0

Andrew Jackson
Moderator

Karma: 1 pt

Try to run vacuum SQlite command.
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.