Currently the MyISAM storage engine has no support for foreign keys, but is there any way to put the logic for foreign key checking in a stored procedure.

I am using SQLite build-in import command for importing records from text files.

The code being follows:

$ sqlite3 dbname.db
SQLite version 3.1.3
Enter ".help" for instructions
sqlite> .separator "\t"

Once I have set the field separator, I do import:

sqlite> .import filename.txt tablename

This solves my purpose but have any one tried on any user-defined function to import data to sqlite.