On Wednesday, 26 September 2018 at 02:28:27 UTC, CharlesM wrote:
If you're using SQLite you don't need to specify the size of the columns, for what I gather it's useless for this DB.
Yep, this is mostly descriptive. Types in column declarations have mostly the same effect.
And if I'm not mistaken it usually preferable to use TEXT for strings.
In SQLite? How so?
And should avoid NULL columns every time you can, because it impacts (Negatively) in the index.
The only thing I could find on NULL in index performance was this:
For example, a partial index might omit entries for which the column being indexed is NULL. When used judiciously, partial indexes can result in smaller database files and improvements in both query and write performance.
However, a lot of those NULL columns should never be null. I wonder why I declared them as such...
