db: add sqlite and starrocks

petergithub · petergithub · commit bb9365bf01ac · 2026-01-31T20:00:15.000+08:00
diff --git a/01Technology/database/sqlite/sqliteNote.md b/01Technology/database/sqlite/sqliteNote.md
@@ -0,0 +1,23 @@
+# sqlite notes
+
+```sh
+sqlite3 /tmp/meta.db "CREATE TABLE dynamic_sources (code TEXT, type TEXT, host TEXT, port INTEGER, database TEXT, username TEXT, password_encrypted TEXT, status TEXT);"
+sqlite3 /tmp/meta.db "SELECT * FROM sources;"
+sqlite3 /tmp/meta.db "INSERT INTO sources VALUES ('dynamic1', 'sqlite', 'localhost', 0, '/tmp/dynamic1.db', 'user', 'password', 'active');"
+sqlite3 /tmp/meta.db "INSERT INTO sources VALUES ('dynamic2', 'sqlite', '', 0, '/tmp/dynamic2.db', 'user2', 'pass2', 'active');"
+sqlite3 /tmp/meta.db "UPDATE sources SET host='localhost', port=1 WHERE code='dynamic1';"
+sqlite3 /tmp/meta.db "DELETE FROM sources;"
+
+sqlite3 /tmp/dynamic1.db "VACUUM;"
+```
+
+sql
+
+```sql
+.database
+.tables
+.headers on
+.mode csv
+.output /tmp/test.csv
+SELECT * FROM test;
+```
diff --git a/01Technology/database/starrocks/starrocksNotes.md b/01Technology/database/starrocks/starrocksNotes.md
@@ -0,0 +1,15 @@
+# StarRocks
+
+[Deploy StarRocks with Docker | StarRocks](https://docs.starrocks.io/docs/3.5/quick_start/shared-nothing/)
+[hub.docker.com](https://hub.docker.com/r/starrocks/allin1-ubuntu)
+
+```sh
+docker pull starrocks/artifacts-ubuntu:3.5.10
+docker pull starrocks/allin1-ubuntu:3.5.10
+
+docker run -p 9030:9030 -p 8030:8030 -p 8040:8040 -itd \
+--name quickstart starrocks/allin1-ubuntu:3.5.10
+
+docker exec -it quickstart \
+mysql -P 9030 -h 127.0.0.1 -u root --prompt="StarRocks > "
+```
