Unironic Sun Emoji

Unironic Sun Emoji

A NaNoWriMo experimental/literary fiction project. 949 binder items, 886 documents with body text, totaling 1,304,622 characters.

Structure

All content is flat under a single NaNoWriMo Template root -- 949 text items at depth 1, no folders or sub-hierarchy. Stream-of-consciousness / fragmentary manuscript.

Longest Documents

Comments

13 inline comments across the project. Samples:

• "what..."
• "Stop relying on memory for this. What was said?"

Database Access

All data is in /Users/alice/v/scrivener.duckdb.

-- All documents
SELECT * FROM documents WHERE project = '☼';

-- Content with body text, ordered by length
SELECT d.title, c.body, c.body_length
FROM documents d JOIN content c ON d.uuid = c.uuid AND d.project = c.project
WHERE d.project = '☼' AND c.body_length > 0
ORDER BY c.body_length DESC;

-- Labels
SELECT * FROM labels WHERE project = '☼';

-- Comments
SELECT * FROM comments WHERE project = '☼';

-- Full text search
SELECT d.title, c.body_length
FROM documents d JOIN content c ON d.uuid = c.uuid AND d.project = c.project
WHERE d.project = '☼' AND c.body LIKE '%search_term%';

Source

Scrivener project bundle: /Users/alice/Desktop/☼.scriv/