post: bfac4e6f69f095b2b3d2f7002e00e46c0e8ecf34

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."}