Asopitech With · Journal app
Day One with Alopex DB
Day One is a journal app with photos, video and audio attached to entries. What if we rebuilt it with Alopex DB?
Updated: Oct 12, 2026
What the service does
Day One is a journaling app. Entries can carry photos, video and audio, and past entries from the same date come back on the day. The journal is protected by a passcode and can be exported at any time. The data is entry text, dates, attachment details and places.
Where the data lives
- SQL tables: entries, journals and tags live in tables. Past entries from the same date come from a date condition.
- JSON: details that vary by entry, such as place, weather and attachments, go in a JSON column.
- Vectors: entry embeddings in a vector column answer questions such as “the day we took the kids to the beach”.
Attachments stay as files on the device, and the tables hold their details.
Deployment
Alopex DB is embedded in the app on the device. The whole journal is one .alopex file on the device, and exporting it is a file copy.
Why Alopex DB fits
A journal is the most private data there is. Alopex DB keeps entries and semantic search together on the device, and handles years of journaling without a server.
We recommend Alopex DB as the base for a journal app, keeping entries, places and semantic search in one file on the device. It runs right away with the quickstart.