got the core pieces in place

1 files changed, 49 insertions, 0 deletions

diff --git a/src/tmp.lil b/src/tmp.lil
index 06f5a7f..5ad150e 100644
--- a/src/tmp.lil
+++ b/src/tmp.lil
@@ -56,4 +56,53 @@ print[filter]
 print[spread_conforming]
 
 
+# spent a good bit of time playing with lil and reviewing the docs. I am now
+# totally smitten and excited to use lil. 
+
+# a basic sketch of the data table at the center of the action
+
+# catalogue.entry_type
+# catalogue.parent # not 100% certain how to reference another entry by id
+# catalogue.title
+# catalogue.body
+# catalogue.reference
+# catalogue.created_date
+# catalogue.updated_date # does this matter? (sorta leaning towards "no")
+
+# entry_type's 
+# - link
+# - note
+# - folder
+
+# every item can have 1 parent
+# a parent is usually a folder
+
+# data table wrapped in an interactive cli for adding, querying, and viewing
+# input data. Input data stored as CSV between sessions
+
+# NOTE: if input data is stored as CSV is becomes trivial to pipe in and out 
+# of SQLite in the future...if that'd be desirable
+
+# NOTE: I'm using just 1 table so that this can be easily exported as CSV...
+# if it weren't for that requirement, I'd have multiple tables
+
+# catalogue:table catalogue
+
+# alternate syntax to make a table, 
+# t: insert food:("Eggs","Pancakes","Grapefruit") quantity:(3,4,1) tasty:(1,1,0) into 0
+
+
+
+
+# validate that I can write a table to disk and read it back in
+# show[catalogue]
+# out:writecsv[catalogue]
+# show[out]
+# write["test.csv" out]
+
+# data:read["test.csv"]
+# newtable:readcsv[data "sis "] # this column spec. syntax looks hilarious
+# show[newtable]
+# HUGE SUCCESS!
+