{"id":7977905,"name":"sqlite-utils-shell","ecosystem":"pypi","description":"An interactive shell for sqlite-utils","homepage":"https://github.com/simonw/sqlite-utils-shell","licenses":"Apache-2.0","normalized_licenses":["Apache-2.0"],"repository_url":"https://github.com/simonw/sqlite-utils-shell","keywords_array":[],"namespace":null,"versions_count":3,"first_release_published_at":"2023-07-24T03:48:27.000Z","latest_release_published_at":"2023-12-21T06:25:12.000Z","latest_release_number":"0.3","last_synced_at":"2026-09-21T07:51:43.560Z","created_at":"2023-07-24T03:51:38.309Z","updated_at":"2026-09-21T17:22:58.594Z","registry_url":"https://pypi.org/project/sqlite-utils-shell/","install_command":"pip install sqlite-utils-shell --index-url https://pypi.org/simple","documentation_url":"https://sqlite-utils-shell.readthedocs.io/","metadata":{"funding":null,"documentation":null,"classifiers":["License :: OSI Approved :: Apache Software License"],"normalized_name":"sqlite-utils-shell","project_status":null},"repo_metadata":{"id":183342954,"uuid":"669984081","full_name":"simonw/sqlite-utils-shell","owner":"simonw","description":"Interactive shell for sqlite-utils","archived":false,"fork":false,"pushed_at":"2023-12-21T06:24:17.000Z","size":20,"stargazers_count":9,"open_issues_count":1,"forks_count":0,"subscribers_count":2,"default_branch":"main","last_synced_at":"2025-08-29T08:26:16.312Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"","language":"Python","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"apache-2.0","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/simonw.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null}},"created_at":"2023-07-24T03:21:15.000Z","updated_at":"2025-02-03T09:20:51.000Z","dependencies_parsed_at":"2024-10-20T20:19:11.680Z","dependency_job_id":null,"html_url":"https://github.com/simonw/sqlite-utils-shell","commit_stats":{"total_commits":11,"total_committers":1,"mean_commits":11.0,"dds":0.0,"last_synced_commit":"fdb5da4807f84c8a578e1f99e9b6e84d0f35109c"},"previous_names":["simonw/sqlite-utils-shell"],"tags_count":3,"template":false,"template_full_name":null,"purl":"pkg:github/simonw/sqlite-utils-shell","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/simonw","download_url":"https://codeload.github.com/simonw/sqlite-utils-shell/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":341189360,"owners_count":37561130,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-08-22T15:14:58.755Z","status":"online","status_checked_at":"2026-09-21T02:00:06.232Z","response_time":53,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"},"owner_record":{"login":"simonw","name":"Simon Willison","uuid":"9599","kind":"user","description":"","email":"","website":"https://simonwillison.net/","location":"Half Moon Bay, CA","twitter":"simonw","company":"Datasette","icon_url":"https://avatars.githubusercontent.com/u/9599?u=b14820695cc6ae03f8a831990697bc040596c0f4\u0026v=4","repositories_count":744,"last_synced_at":"2024-05-01T10:38:17.142Z","metadata":{"has_sponsors_listing":true},"html_url":"https://github.com/simonw","funding_links":["https://github.com/sponsors/simonw"],"total_stars":29909,"followers":6017,"following":138,"created_at":"2022-11-02T17:20:02.362Z","updated_at":"2024-05-01T10:40:57.107Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/simonw","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/simonw/repositories"},"tags":[{"name":"0.3","sha":"fdb5da4807f84c8a578e1f99e9b6e84d0f35109c","kind":"commit","published_at":"2023-12-21T06:22:13.000Z","download_url":"https://codeload.github.com/simonw/sqlite-utils-shell/tar.gz/0.3","html_url":"https://github.com/simonw/sqlite-utils-shell/releases/tag/0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/simonw/sqlite-utils-shell@0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/tags/0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/tags/0.3/manifests"},{"name":"0.2","sha":"bfdbc4b993eeea5e99db4cf47ca74bfa6cd1143c","kind":"commit","published_at":"2023-07-24T14:42:56.000Z","download_url":"https://codeload.github.com/simonw/sqlite-utils-shell/tar.gz/0.2","html_url":"https://github.com/simonw/sqlite-utils-shell/releases/tag/0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/simonw/sqlite-utils-shell@0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/tags/0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/tags/0.2/manifests"},{"name":"0.1","sha":"1f962969da0ab1eaed0873f15de551f51fd36dfe","kind":"commit","published_at":"2023-07-24T03:45:00.000Z","download_url":"https://codeload.github.com/simonw/sqlite-utils-shell/tar.gz/0.1","html_url":"https://github.com/simonw/sqlite-utils-shell/releases/tag/0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/simonw/sqlite-utils-shell@0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/tags/0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/tags/0.1/manifests"}]},"repo_metadata_updated_at":"2026-09-21T17:22:58.593Z","dependent_packages_count":0,"downloads":21,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":17.187177457336684,"dependent_repos_count":69.80777363346114,"dependent_packages_count":7.490033931731681,"stargazers_count":23.301860132319725,"forks_count":30.20926238067274,"docker_downloads_count":null,"average":29.599221507104392},"purl":"pkg:pypi/sqlite-utils-shell","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/pypi/sqlite-utils-shell","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/pypi/sqlite-utils-shell","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/pypi/sqlite-utils-shell/dependencies","status":null,"funding_links":["https://github.com/sponsors/simonw"],"critical":null,"issue_metadata":{"last_synced_at":"2026-09-21T07:36:48.605Z","issues_count":7,"pull_requests_count":0,"avg_time_to_close_issue":31197.333333333332,"avg_time_to_close_pull_request":null,"issues_closed_count":6,"pull_requests_closed_count":0,"pull_request_authors_count":0,"issue_authors_count":1,"avg_comments_per_issue":1.5714285714285714,"avg_comments_per_pull_request":null,"merged_pull_requests_count":0,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":0,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":null,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":0,"past_year_pull_request_authors_count":0,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":null,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/simonw%2Fsqlite-utils-shell/issues","maintainers":[{"login":"simonw","count":7,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/simonw"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/sqlite-utils-shell/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/sqlite-utils-shell/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/sqlite-utils-shell/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/sqlite-utils-shell/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/sqlite-utils-shell/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/sqlite-utils-shell/codemeta","maintainers":[{"uuid":"simonw","login":"simonw","name":null,"email":null,"url":null,"packages_count":387,"html_url":"https://pypi.org/user/simonw/","role":null,"created_at":"2023-07-24T03:51:39.323Z","updated_at":"2023-07-24T03:51:39.323Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/maintainers/simonw/packages"}]}