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.
