basic notes support

Signed-off-by: Xe Iaso <me@christine.website>

1 files changed, 38 insertions, 0 deletions

diff --git a/docs/notes.markdown b/docs/notes.markdown
new file mode 100644
index 0000000..8ab83f5
--- /dev/null
+++ b/docs/notes.markdown
@@ -0,0 +1,38 @@
+# Notes
+
+## Goals
+
+- Have somewhere other than Twitter or Mastodon to host short-form content or
+  list articles I "like".
+- Authenticate over Tailscale
+- Simple API to automate posting with iOS Shortcuts
+- Have a JSONFeed for people to subscribe
+- Send WebMentions when I reply to things
+- Store things in SQLite
+
+## Schema
+
+```sql
+CREATE TABLE IF NOT EXISTS notes
+  ( id           INTEGER PRIMARY KEY
+  , content      TEXT    NOT NULL
+  , content_html TEXT    NOT NULL
+  , created_at   INTEGER NOT NULL -- Unix epoch timestamp
+  , updated_at   INTEGER          -- Unix epoch timestamp
+  , deleted_at   INTEGER          -- Unix epoch timestamp
+  , reply_to     TEXT
+  );
+```
+
+```rust
+#[derive(Clone, Debug, Serialize, Deserialize)]
+pub struct Note {
+  pub id: u64,
+  pub content: String,
+  pub content_html: String,
+  pub created_at: DateTime<Utc>,
+  pub updated_at: Option<DateTime<Utc>>,
+  pub deleted_at: Option<DateTime<Utc>>,
+  pub reply_to: Option<String>,
+}
+```