Forums intermittently going down?

[Vladimir Panteleev]

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...