SQLite3 CLI: The Ultimate Beginner's Guide
Dump of the final todolist.db file:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE categories (category_id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE, color TEXT);
INSERT INTO categories VALUES(1,'Personal','blue');
INSERT INTO categories VALUES(2,'Work','red');
INSERT INTO categories VALUES(3,'Health','green');
INSERT INTO categories VALUES(4,'Learning','purple');
CREATE TABLE priorities (priority_id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE, value INTEGER NOT NULL);
INSERT INTO priorities VALUES(1,'Low',1);
INSERT INTO priorities VALUES(2,'Medium',2);
INSERT INTO priorities VALUES(3,'High',3);
INSERT INTO priorities VALUES(4,'Urgent',4);
CREATE TABLE tasks (task_id INTEGER PRIMARY KEY, title TEXT NOT NULL, description TEXT, due_date TEXT, completed INTEGER DEFAULT 0, completion_date TEXT, category_id INTEGER, priority_id INTEGER, FOREIGN KEY (category_id) REFERENCES categories (category_id), FOREIGN KEY (priority_id) REFERENCES priorities (priority_id));
INSERT INTO tasks VALUES(1,'Buy groceries','Milk, eggs, bread, and vegetables','2023-09-30',0,NULL,1,2);
INSERT INTO tasks VALUES(2,'Prepare presentation','Quarterly sales review for management','2023-09-28',0,NULL,2,3);
INSERT INTO tasks VALUES(3,'Go jogging','30 minutes around the park','2023-09-25',0,NULL,3,1);
INSERT INTO tasks VALUES(4,'Learn SQLite','Complete tutorial on command-line usage','2023-09-27',0,NULL,4,2);
INSERT INTO tasks VALUES(5,'Call mom',NULL,NULL,0,NULL,1,4);
COMMIT;
On this page of the site you can watch the video online SQLite3 CLI: The Ultimate Beginner's Guide with a duration of hours minute second in good quality, which was uploaded by the user Manas Mishra 19 April 2025, share the link with friends and acquaintances, this video has already been watched 85 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
