zulfadzlyrazak/sqlite3 repository overview

Using Docker run

1. Create work directory
   mkdir mysqliteDb
2. Navigate to work directory
   cd mysqliteDb
3. create db folder to persist data
   mkdir db
4. First time run
   docker run -itd --name sqlite3 -v $(pwd)/db:/root/db/ zulfadzlyrazak/sqlite3
5. Access sqlite container
   docker exec -it sqlite3 ash
6. Use/Create sample db
   sqlite3 sampleDb
7. Create sample table
   BEGIN TRANSACTION; CREATE TABLE IF NOT EXISTS "sample_contact" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "email" TEXT NOT NULL ); INSERT INTO "sample_contact" VALUES (1,'Zul','[email protected]'); INSERT INTO "sample_contact" VALUES (2,'Shah','[email protected]'); INSERT INTO "sample_contact" VALUES (3,'Nina','[email protected]'); INSERT INTO "sample_contact" VALUES (4,'Khai','[email protected]'); INSERT INTO "sample_contact" VALUES (5,'Khalid','[email protected]'); COMMIT;
8. View sample db data
   SELECT * FROM sample_contact;
9. CTRL + D to exit sqlite console \
10. Exit sqlite container
    exit
11. Stop sqlite container
    docker stop sqlite3
12. Start sqlite container
    docker start sqlite3