Need to compare blobs in firebird

Posted by Michael Beck on Stack Overflow See other posts from Stack Overflow or by Michael Beck
Published on 2010-03-18T16:33:57Z Indexed on 2010/03/19 10:01 UTC
Read the original article Hit count: 533

Filed under:

firebird

|

blob

|

database

Hey guys,

I need to check on the contents of blobs in my databases (yes, plural, but one problem at a time).

In one database, I have about 900 images of potentially varying sizes. I need to check to see if the versioning system that's built into our application is actually correctly replicating the image data from the previous version to the new version of a record.

How do I compare values en masse so I don't have to pick through each record one at a time and open up the blob using FlameRobin or Firebird Maestro and visually compare these images?

Thanks for any assistance.

© Stack Overflow or respective owner

Related posts about firebird

How to migrate data from a Firebird database to PostGreSQL on Linux

as seen on Server Fault - Search for 'Server Fault'
Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly written to export/import from one firebird db to another, not as a migration tool. There's also: Firebird… >>> More
Firebird .NET: Database backup not working (small file)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to backup my Firebird 2.5 database file by code: FbBackup backupSvc = new FbBackup(); backupSvc.ConnectionString = MyConnectionManager.buildConnectionString(); backupSvc.BackupFiles.Add(new FbBackupFile(backupPathFilenameAndExtension, 2048)); backupSvc.Verbose = true; backupSvc.Options… >>> More
Need to compare blobs in firebird

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, I need to check on the contents of blobs in my databases (yes, plural, but one problem at a time). In one database, I have about 900 images of potentially varying sizes. I need to check to see if the versioning system that's built into our application is actually correctly replicating… >>> More
Does firebird support transactional schema changes?

as seen on Stack Overflow - Search for 'Stack Overflow'
Does firebird support transactional schema changes? It seems to me that MySQL does not (am I correct?). >>> More
Firebird sequence-backed ID shorthand

as seen on Stack Overflow - Search for 'Stack Overflow'
What do others do to simplify the creation of simple, serial surrogate keys populated by a SEQUENCE (a.k.a. GENERATOR) in Firebird = 2.1? I finc the process comparatively arduous: For example, in PostgreSQL, I simply type: pg> CREATE TABLE tbl ( > id SERIAL NOT NULL PRIMARY KEY, >… >>> More

Related posts about blob

Upload File to Windows Azure Blob in Chunks through ASP.NET MVC, JavaScript and HTML5

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/shaunxu/archive/2013/07/01/upload-file-to-windows-azure-blob-in-chunks-through-asp.net.aspxMany people are using Windows Azure Blob Storage to store their data in the cloud. Blob storage provides 99.9% availability with easy-to-use API through .NET SDK… >>> More
Can't create blob container on Azure Blob Storage

as seen on Stack Overflow - Search for 'Stack Overflow'
The following code throws an error on the "CreateIfNotExist" method call. I am attempting to connect to my Azure Blob storage and create a new container called "images" var storageAccount = new CloudStorageAccount( new StorageCredentialsAccountAndKey("my_account_name", "... my shared key ...")… >>> More
Display MySQL BLOB'd image on webpage without separate script (PHP)

as seen on Stack Overflow - Search for 'Stack Overflow'
So I've got some images stored in a MySQL database as BLOB's (I know it's better to just store the directory and do it that way, but this is what I need to do for now) and I need to display them on a webpage. Now, I know how to make a script and give it an image header and pull the img src from there… >>> More
JPA - insert and retrieve clob and blob types

as seen on Oracle Blogs - Search for 'Oracle Blogs'
This article describes about the JPA feature for handling clob and blob data types.You will learn the following in this article. @Lob annotation Client code to insert and retrieve the clob/blob types End to End ADFaces application to retrieve the image from database table and display it in web page… >>> More
T-SQL Tuesday #006: Tiger/Line Spatial Data

as seen on SQL Blog - Search for 'SQL Blog'
This month’s T-SQL Tuesday post is about LOB data http://sqlblog.com/blogs/michael_coles/archive/2010/05/03/t-sql-tuesday-006-what-about-blob.aspx . For this one I decided to post a sample Tiger/Line SQL database I use all the time in live demos. For those who aren't familiar with it, Tiger/Line data… >>> More