home / garden / post

post: bfac4e6f69f095b2b3d2f7002e00e46c0e8ecf34

Data source: Myles' Garden Posts

This data as json

_id _path text html type name summary emoji publishedAt updatedAt author tags location syndication inReplyTo bookmarkOf rsvp likeOf repostOf visibility cover media book film tvShowSeason vinylRecord listenOnUrls playlist leftHand rightHand readStatus currentPage event watchStatus
bfac4e6f69f095b2b3d2f7002e00e46c0e8ecf34 src/content/posts/2024/03/09/arc-to-sqlite/index.md I started working on a Dogsheep utility for processing [Arc App](https://www.bigpaua.com/arcapp/)'s Daily (or Monthly) JSON exports into a SQLite database. This provides the ability to analysis the places I visit and activities I am doing in [Datasette](https://datasette.io/). ![Screenshot of Datasette showing the timeline_items table in a SQLite database. There is a map at the bottom that is showing the locations I traveled in the last few days.](./arc-to-sqlite-running-in-datasette.png "Datasette screenshot") I've published a working alpha version of the Dogsheep utility, [arc-to-sqlite on my Github](https://github.com/myles/arc-to-sqlite). Check it out if you are interested. <p>I started working on a Dogsheep utility for processing <a href="https://www.bigpaua.com/arcapp/">Arc App</a>'s Daily (or Monthly) JSON exports into a SQLite database. This provides the ability to analysis the places I visit and activities I am doing in <a href="https://datasette.io/">Datasette</a>.</p> <p><img alt="Screenshot of Datasette showing the timeline_items table in a SQLite database. There is a map at the bottom that is showing the locations I traveled in the last few days." src="./arc-to-sqlite-running-in-datasette.png" title="Datasette screenshot" /></p> <p>I've published a working alpha version of the Dogsheep utility, <a href="https://github.com/myles/arc-to-sqlite">arc-to-sqlite on my Github</a>. Check it out if you are interested.</p> article Arc App's JSON Export to SQLite     2024-03-09T00:00:00-05:00     ["arc-to-sqlite", "arc-timeline", "software-engineering", "projects"]                 {"image": "./arc-to-sqlite-running-in-datasette.png", "alt": "Screenshot of datasette running the output of arc-to-sqlite."}                          
Powered by Datasette · Queries took 0.807ms · Data source: Myles' Garden Posts