[sqlite] Need help to confirm my understanding on Foreign Key indexes

Looking at the documentation for the latest version I think I understand that I must define indexes for all foreign keys, manually, with UNIQUE as described in the documentation.  If I don't then the database will give me an immediate or deferred error.  These Foreign Key indexes are NOT generat

[sqlite] Confused by import of NULL values from CSV file

Hello hopefully someone can help me out on this item   I import a CSV flat file into a table (using sqliteman as GUI).  The flat file has NULL values as simply no data between two delimiters (I use 'tab' as Delimiter).   The resulting table does not treat 'no data' between 2 delimiters as NULL.