From 6052641ea9461f8d6e6b442d104540165bb2db89 Mon Sep 17 00:00:00 2001
From: Teddy Wing
Date: Sun, 6 Mar 2022 23:33:19 +0100
Subject: Idea for a program to convert between YAML and SQLite

---
 Idea.txt | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 Idea.txt

diff --git a/Idea.txt b/Idea.txt
new file mode 100644
index 0000000..54ad59f
--- /dev/null
+++ b/Idea.txt
@@ -0,0 +1,26 @@
+Program to translate from YAML to SQLite and back.
+
+$ yaqlite insert --db database.db 'table_name' records.yml
+
+# records.yml
+- column: value
+  column2: 2
+- column: value2
+  column2: 4
+
+translates to:
+
+INSERT INTO "table_name"
+	(column, column2)
+	VALUES
+	('value', 2),
+	('value2', 4);
+
+
+$ yaqlite select --db database.db 'table_name' <ID> > records.yml
+
+# records.yml
+- column: value
+  column2: value
+  column3: >
+    Multiline value.
-- 
cgit v1.2.3