Forums intermittently going down?

[CharlesM]

On Tuesday, 25 September 2018 at 21:20:29 UTC, Vladimir Panteleev 
wrote:
> Sometimes the database (SQLite)

https://github.com/CyberShadow/DFeed/blob/master/schema.sql

CREATE TABLE [Groups] (
[Group] VARCHAR(50)  NULL,
[ArtNum] INTEGER  NULL,
[ID] VARCHAR(50)  NULL
, Time INTEGER);

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.

You may declare GROUP VARCHAR(50), but if you insert something 
bigger, it will insert anyway, because the column adjust 
according the value.

And if I'm not mistaken it usually preferable to use TEXT for 
strings.

And should avoid NULL columns every time you can, because it 
impacts (Negatively) in the index.