Storing *.patt File In Sqlite Database

I have a .patt (pattern) file which I want to store in Sqlite Database and retrieve it later in order to match it with another pattern. contents of pattern file(*.patt) 178 176 17

Solution 1:

There is a blob data-type for such operations. However, It would be bad habit to store & retrieve a file in Sqlite. It may effect in performance of application for operation reading/writing file data into sqlite. You should store it directly as file and store its path inside the sqlite database. This way it will be easy to retrieve.