search

pawlaszczyk / fqlite

Mozilla Public License 2.0
61 stars 11 forks source link

How to extract BLOBs #10

Open Circuit8 opened 2 weeks ago

Circuit8 commented 2 weeks ago

I have a corrupt database which has a load of data in the __FREELIST I want to access that are stored in BLOB columns. I can see its all there, when I copy and paste a single column I get the data correctly. However, when copying a whole row or the whole freelist it always truncates the BLOB data like so:

[516, __FREELIST, 1060953, 13, F , 407293790, null, 262159, -0.17233276, 0.09866333, 0.01519260, [BLOB-0] 000010ba0000e039d3556739000030ba0000b039bab3ac39000038ba0000d039.., [BLOB-1] 0000e0ba0000883ac0188339007830be0010ca3d46c0f83c0000dfbb00007a3b.., [BLOB-2] 000000000000000000000000000080b8000000b90000c0b8000000b8000080b8..]

Is there anyway to extract the data preserving the BLOBS? My database has hundreds of rows so its not feasible to go through one by one

Circuit8 commented 2 weeks ago

@Rasmus-Riis This is FQLite isn't it? Sanderson seems to be a paid product.

Circuit8 commented 2 weeks ago

I have tried FQLite, there is an issue with extracting blob data using it. Just thought I'd open an issue here to see if there's a solution?

Circuit8 commented 2 weeks ago

Already done mate, you're in it.

pawlaszczyk commented 2 weeks ago

Hi Guys, The issue will be answered in the next release. It will be possible to copy several lines - including complete BLOBs (by the end of next week - I'm on vacation right now.).