1

Fast way to determine if a file is a SQLite database

view story
linux-howto

http://unix.stackexchange.com – I am looking for a way to determine file types in a folder with thousands of files. File names do not reveal much and have no extension but are different types. Specifically I am trying to determine if a file is a sqlite database. When using 'file' command, it determines type of 2-3 files in a second. This seems like a good way to adress the problem, except it is too slow. Then I tried opening each file with sqlite3 and check if I get an error. That way I can check 4-5 files per second. Much better, but I think that there might be a better way to do this. (HowTos)

Danial's picture
Submitted by Danial on 09/21/2012

Stories similar to Fast way to determine if a file is a SQLite database

When I click a link in Firefox that leads to a file, the MIME type of the file seems to be read to determine which application is more suitable to open the file.

Occasionally servers send out wrong mime type and Firefox defaults to the text editor, without making any further attempts to identify the file type.

Im doing an app which uses sqlite database There is an feature in my app having a button 'Update Database'.

When user clicks on the 'Update Database' button i need to upgrade the old db file with new db file from URL.

How to do this. the research tells me that we cant change a db as it gets place in an .apk file. Is there any solution to this. Please help me out. Thank you.

I am trying to share files between two Android phones using Socket programming. The problem is right now I have to hard code the file extension on the receiving end.

I am using find to find names of databases that return some rows for a query.

$ find . -name 'sqlite.db' -exec sqlite3 "{}" 'SELECT * FROM table WHERE column1="value"' \;

value|a|b|c|d

But I want the name of the file, so I tried -print

$ find .

I have a folder (the iPhone Backup) with various files without a suffix.

I want to run a batch process over these files, which detects each file's file-type (with the help of the magic-file database (/usr/share/misc/magic or man file), and automatically changes / renames its file-suffix (from a database file/mime-type<->suffix) accordingly.

Hours of Googling and StackExchange-Searching brough

I assign the variable

Code: name=`find .

I've two excel file with inside some link to .doc and .pdf file. Both excel files and linked files are on a network shared folder. The first excel file is an .xls, the second an .xlsm.

While opening link to .pdf file is very fast (the file is open in few seconds) it take a long time to open .doc files (about 40 secs.).

file control with mime-type 17 weeks 4 days ago

I have a security question regarding the mime types.

I have a website on which users can upload videos. Prior to encoding with ffmpeg, I make a mime-type check to be sure the video file is really a video file and not a weird file or even an exec with a video file extension.

Nevertheless sometimes, mime-type aren't recognized, especially with mkv containers.

Team,

I have an Android application with large SQLite database this data costs me lots of money and I don't want to let anybody have it easily. This database come to me as databse.sqlite file and I shipped into into the APK assets.