# mastodon-to-sqlite
Save data from Mastodon to a SQLite database.
## Install
```console
foo@bar:~$ pip install mastodon-to-sqlite
```
## Authentication
First you will need to create an application on your Mastodon server. You
can find that on your Mastodon serer.
```console
foo@bar:~$ mastodon-to-sqlite auth
Mastodon domain: mastodon.social
Create a new application here: https://mastodon.social/settings/applications/new
Then navigate to newly created application and paste in the following:
Your access token: xxx
```
This will write an `auth.json` file to your current directory containing your
access token and Mastodon domain. Use `-a other-file.json` to save those
credentials to a different location.
That `-a` option is supported by all other commands.
You can verify your authentication by running `mastodon-to-sqlite
verify-auth`.
## Retrieving Mastodon followers
The `followers` command will retrieve all the details about your Mastodon
followers.
```console
foo@bar:~$ mastodon-to-sqlite followers mastodon.db
```
## Retrieving Mastodon followings
The `followings` command will retrieve all the details about your Mastodon
followings.
```console
foo@bar:~$ mastodon-to-sqlite followings mastodon.db
```
## Retrieving Mastodon statuses
The `statuses` command will retrieve all the details about your Mastodon
statuses.
```console
foo@bar:~$ mastodon-to-sqlite statuses mastodon.db
```
## Retrieving Mastodon bookmarks
The `bookmarks` command will retrieve all the details about your Mastodon
bookmarks.
```console
foo@bar:~$ mastodon-to-sqlite bookmarks mastodon.db
```
## Retrieving Mastodon favourites
The `favourites` command will retrieve all the details about your Mastodon
favourites.
```console
foo@bar:~$ mastodon-to-sqlite favourites mastodon.db
```
Raw data
{
"_id": null,
"home_page": "https://github.com/myles/mastodon-to-sqlite",
"name": "mastodon-to-sqlite",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.9,<4.0",
"maintainer_email": "",
"keywords": "mastodon,sqlite,dogsheep",
"author": "Myles Braithwaite",
"author_email": "me@mylesbraithwaite.com",
"download_url": "https://files.pythonhosted.org/packages/10/f6/2797317aac4df20d2dfde6046e34dd3b1ac88eb861b3a6006f635e5f7364/mastodon_to_sqlite-0.2.1.tar.gz",
"platform": null,
"description": "# mastodon-to-sqlite\n\nSave data from Mastodon to a SQLite database.\n\n## Install\n\n```console\nfoo@bar:~$ pip install mastodon-to-sqlite\n```\n\n## Authentication\n\nFirst you will need to create an application on your Mastodon server. You\ncan find that on your Mastodon serer.\n\n```console\nfoo@bar:~$ mastodon-to-sqlite auth\nMastodon domain: mastodon.social\n\nCreate a new application here: https://mastodon.social/settings/applications/new\nThen navigate to newly created application and paste in the following:\n\nYour access token: xxx\n```\nThis will write an `auth.json` file to your current directory containing your\naccess token and Mastodon domain. Use `-a other-file.json` to save those\ncredentials to a different location.\n\nThat `-a` option is supported by all other commands.\n\nYou can verify your authentication by running `mastodon-to-sqlite\nverify-auth`.\n\n## Retrieving Mastodon followers\n\nThe `followers` command will retrieve all the details about your Mastodon \nfollowers.\n\n```console\nfoo@bar:~$ mastodon-to-sqlite followers mastodon.db\n```\n\n## Retrieving Mastodon followings\n\nThe `followings` command will retrieve all the details about your Mastodon \nfollowings.\n\n```console\nfoo@bar:~$ mastodon-to-sqlite followings mastodon.db\n```\n\n## Retrieving Mastodon statuses\n\nThe `statuses` command will retrieve all the details about your Mastodon \nstatuses.\n\n```console\nfoo@bar:~$ mastodon-to-sqlite statuses mastodon.db\n```\n\n## Retrieving Mastodon bookmarks\n\nThe `bookmarks` command will retrieve all the details about your Mastodon\nbookmarks.\n\n```console\nfoo@bar:~$ mastodon-to-sqlite bookmarks mastodon.db\n```\n\n\n## Retrieving Mastodon favourites\n\nThe `favourites` command will retrieve all the details about your Mastodon\nfavourites.\n\n```console\nfoo@bar:~$ mastodon-to-sqlite favourites mastodon.db\n```\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Save data from Mastodon to a SQLite database",
"version": "0.2.1",
"project_urls": {
"Homepage": "https://github.com/myles/mastodon-to-sqlite",
"Repository": "https://github.com/myles/mastodon-to-sqlite"
},
"split_keywords": [
"mastodon",
"sqlite",
"dogsheep"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "0155373f0f7e628ded08e4fb741c97297bd3b639583d64b401fd7f47a2278137",
"md5": "3d3096e05db92730845dc892fd923008",
"sha256": "ff939cb22a7753af5894e6ec7e82d97f1f282f7ede2a14f8080de5a48b83935d"
},
"downloads": -1,
"filename": "mastodon_to_sqlite-0.2.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "3d3096e05db92730845dc892fd923008",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9,<4.0",
"size": 10839,
"upload_time": "2024-02-06T03:02:26",
"upload_time_iso_8601": "2024-02-06T03:02:26.196265Z",
"url": "https://files.pythonhosted.org/packages/01/55/373f0f7e628ded08e4fb741c97297bd3b639583d64b401fd7f47a2278137/mastodon_to_sqlite-0.2.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "10f62797317aac4df20d2dfde6046e34dd3b1ac88eb861b3a6006f635e5f7364",
"md5": "31a942611d6023c0e213621b2820142b",
"sha256": "3bdd07f33087f48eef8a2fa951728cfd8361619763a7a26316574cd4a0304922"
},
"downloads": -1,
"filename": "mastodon_to_sqlite-0.2.1.tar.gz",
"has_sig": false,
"md5_digest": "31a942611d6023c0e213621b2820142b",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9,<4.0",
"size": 9589,
"upload_time": "2024-02-06T03:02:27",
"upload_time_iso_8601": "2024-02-06T03:02:27.270113Z",
"url": "https://files.pythonhosted.org/packages/10/f6/2797317aac4df20d2dfde6046e34dd3b1ac88eb861b3a6006f635e5f7364/mastodon_to_sqlite-0.2.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-02-06 03:02:27",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "myles",
"github_project": "mastodon-to-sqlite",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "mastodon-to-sqlite"
}
JSON
