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

Chars	Title
33,010	will they say your name
20,648	"Orange/Blue" 1 [] Chapter 17: Orange/Blue
18,673	[] Chapter 18: Faithful Host
15,531	NaNoWriMo Template
14,872	[] Chapter 20: beggars and braggers
13,587	[] Chapter 21: Rebel without applause
12,537	[] Chapter 13: moon above, sun below
12,262	[] Chapter 14: Gilt

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/