blob

[1/1]

  1. Understanding BLOBs and SQLAlchemy: A Guide to Efficient Binary Data Storage
    BLOBs are data types used in databases for storing large binary data such as images, audio files, documents, or any other kind of non-textual data
  2. Unpacking the Mystery of BLOBs: How to Store and Retrieve Binary Data in SQLite
    Retrieving a BLOB:Here are some additional points to consider:Security: Always use prepared statements to prevent SQL injection attacks
  3. Introducing octet_length(): The Savior for Accurate Blob Size in SQLite
    length() function: While the length() function in SQLite usually returns the number of bytes for blobs, it can be unreliable if the blob contains null characters (\0). These characters mark the end of strings in some programming languages
  4. Beyond the Database: Efficient Image Management on Your Filesystem
    Databases excel at structured data like numbers and text. However, storing large blobs of binary data like images can:Impact performance: Retrieving large images from a database can be slower than accessing them directly from the filesystem