{"id":74101,"name":"readwritesqlite","description":"An R package that enhances writing and reading data to and from SQLite databases","url":"https://github.com/poissonconsulting/readwritesqlite","last_synced_at":"2025-09-08T16:14:42.284Z","repository":{"id":34863301,"uuid":"158617726","full_name":"poissonconsulting/readwritesqlite","owner":"poissonconsulting","description":"An R package that enhances writing and reading data to and from SQLite databases","archived":false,"fork":false,"pushed_at":"2025-09-05T00:49:20.000Z","size":3047,"stargazers_count":37,"open_issues_count":8,"forks_count":1,"subscribers_count":4,"default_branch":"main","last_synced_at":"2025-09-05T02:33:25.800Z","etag":null,"topics":["cran","dbi","log","metadata","posixct","r","read","rstats","sfc","sqlite","units","write"],"latest_commit_sha":null,"homepage":"https://poissonconsulting.github.io/readwritesqlite/","language":"R","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"other","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/poissonconsulting.png","metadata":{"files":{"readme":"README.Rmd","changelog":"NEWS.md","contributing":".github/CONTRIBUTING.md","funding":null,"license":"LICENSE","code_of_conduct":".github/CODE_OF_CONDUCT.md","threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":".github/SUPPORT.md","governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null,"notice":null,"maintainers":null,"copyright":null,"agents":null,"dco":null,"cla":null}},"created_at":"2018-11-21T23:26:36.000Z","updated_at":"2025-09-05T00:49:23.000Z","dependencies_parsed_at":"2024-09-17T21:26:56.692Z","dependency_job_id":"cfdae669-e61a-4ad0-b225-44567d0eefdd","html_url":"https://github.com/poissonconsulting/readwritesqlite","commit_stats":{"total_commits":312,"total_committers":6,"mean_commits":52.0,"dds":"0.10256410256410253","last_synced_commit":"db961138ad98b957b70b3e4f257ab8c9c317b8e2"},"previous_names":[],"tags_count":25,"template":false,"template_full_name":null,"purl":"pkg:github/poissonconsulting/readwritesqlite","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/poissonconsulting","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":274210603,"owners_count":25241791,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2022-07-04T15:15:14.044Z","status":"online","status_checked_at":"2025-09-08T02:00:09.813Z","response_time":121,"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":{"login":"poissonconsulting","name":"Poisson Consulting Ltd.","uuid":"1679318","kind":"organization","description":"Computational Biology and Statistical Ecology","email":"software@poissonconsulting.ca","website":"http://www.poissonconsulting.ca","location":"Nelson, BC, Canada","twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/1679318?v=4","repositories_count":68,"last_synced_at":"2023-04-08T05:01:05.886Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/poissonconsulting","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-04T19:41:10.197Z","updated_at":"2023-04-08T05:01:06.702Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/poissonconsulting","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/poissonconsulting/repositories"},"packages":[{"id":434875,"name":"readwritesqlite","ecosystem":"cran","description":"Enhanced Reading and Writing for 'SQLite' Databases","homepage":"https://github.com/poissonconsulting/readwritesqlite","licenses":"MIT + file LICENSE","normalized_licenses":["MIT"],"repository_url":"https://github.com/poissonconsulting/readwritesqlite","keywords_array":[],"namespace":null,"versions_count":6,"first_release_published_at":"2019-07-11T12:47:00.000Z","latest_release_published_at":"2022-10-16T00:00:00.000Z","latest_release_number":"0.2.0","last_synced_at":"2025-08-01T02:54:44.286Z","created_at":"2022-04-06T22:52:31.913Z","updated_at":"2025-08-01T02:54:44.287Z","registry_url":"https://cran.r-project.org/package=readwritesqlite","install_command":null,"documentation_url":"http://cran.r-project.org/web/packages/readwritesqlite/readwritesqlite.pdf","metadata":{},"repo_metadata":{"id":34863301,"uuid":"158617726","full_name":"poissonconsulting/readwritesqlite","owner":"poissonconsulting","description":"An R package that enhances writing and reading data to and from SQLite databases","archived":false,"fork":false,"pushed_at":"2022-10-16T23:14:24.000Z","size":1224,"stargazers_count":37,"open_issues_count":8,"forks_count":1,"subscribers_count":6,"default_branch":"main","last_synced_at":"2024-08-06T03:04:16.598Z","etag":null,"topics":["cran","dbi","log","metadata","posixct","r","read","rstats","sfc","sqlite","units","write"],"latest_commit_sha":null,"homepage":"https://poissonconsulting.github.io/readwritesqlite","language":"R","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"other","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/poissonconsulting.png","metadata":{"files":{"readme":"README.Rmd","changelog":null,"contributing":".github/CONTRIBUTING.md","funding":null,"license":"LICENSE","code_of_conduct":".github/CODE_OF_CONDUCT.md","threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null}},"created_at":"2018-11-21T23:26:36.000Z","updated_at":"2024-02-06T13:56:20.000Z","dependencies_parsed_at":"2022-08-21T01:10:26.064Z","dependency_job_id":null,"html_url":"https://github.com/poissonconsulting/readwritesqlite","commit_stats":null,"previous_names":[],"tags_count":10,"template":false,"template_full_name":null,"repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/poissonconsulting","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/refs/heads/main","host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":215640378,"owners_count":15909213,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2022-07-04T15:15:14.044Z","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":"poissonconsulting","name":"Poisson Consulting Ltd.","uuid":"1679318","kind":"organization","description":"Computational Biology and Statistical Ecology","email":"software@poissonconsulting.ca","website":"http://www.poissonconsulting.ca","location":"Nelson, BC, Canada","twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/1679318?v=4","repositories_count":68,"last_synced_at":"2023-04-08T05:01:05.886Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/poissonconsulting","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-04T19:41:10.197Z","updated_at":"2023-04-08T05:01:06.702Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/poissonconsulting","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/poissonconsulting/repositories"},"tags":[{"name":"v0.2.0.9000","sha":"db961138ad98b957b70b3e4f257ab8c9c317b8e2","kind":"tag","published_at":"2022-10-16T23:09:17.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.2.0.9000","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.2.0.9000","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.2.0.9000","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.2.0.9000/manifests"},{"name":"v0.2.0","sha":"c32bba5a898e641f7d3821aa45b7789dbe0e4b0a","kind":"tag","published_at":"2022-10-16T23:08:28.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.2.0","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.2.0","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.2.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.2.0/manifests"},{"name":"v0.1.2.9001","sha":"64cf73bbbff2eb7960212f74d4d35ae691b84157","kind":"tag","published_at":"2022-10-15T13:31:40.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.1.2.9001","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.1.2.9001","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.2.9001","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.2.9001/manifests"},{"name":"v0.1.2.9000","sha":"9f0c91676cfdab9a0cd1d5f22d05e066992aaa3e","kind":"tag","published_at":"2020-07-13T17:04:29.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.1.2.9000","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.1.2.9000","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.2.9000","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.2.9000/manifests"},{"name":"v0.1.2","sha":"e0459b9c9fb8d9c71477154a367d3b71de58135b","kind":"tag","published_at":"2020-07-13T17:03:29.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.1.2","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.1.2","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.2/manifests"},{"name":"v0.1.1.9001","sha":"b1f0f47b207e463d28d6b3806de1bcbf3e71a48a","kind":"tag","published_at":"2020-07-10T20:31:52.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.1.1.9001","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.1.1.9001","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.1.9001","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.1.9001/manifests"},{"name":"v0.1.1","sha":"7a6a6f075d5d150b1d142e2a6d9bcf09fc73f2d0","kind":"commit","published_at":"2020-04-07T14:50:13.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.1.1","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.1.1","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.1/manifests"},{"name":"v0.1.0","sha":"ab0205ad5308e25ba5a77a65cdd0eeec69f3434c","kind":"commit","published_at":"2020-01-29T00:31:53.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.1.0","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.1.0","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.1.0/manifests"},{"name":"v0.0.2","sha":"9afb0a9aaa57daf179a5c85412ae7e62af3134b1","kind":"commit","published_at":"2019-07-23T16:23:53.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.0.2","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.0.2/manifests"},{"name":"v0.0.1","sha":"9c47733f60de322656ec1b1471566201008841f0","kind":"commit","published_at":"2019-07-07T16:11:23.000Z","download_url":"https://codeload.github.com/poissonconsulting/readwritesqlite/tar.gz/v0.0.1","html_url":"https://github.com/poissonconsulting/readwritesqlite/releases/tag/v0.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/tags/v0.0.1/manifests"}]},"repo_metadata_updated_at":"2024-08-16T13:56:45.262Z","dependent_packages_count":0,"downloads":263,"downloads_period":"last-month","dependent_repos_count":4,"rankings":{"downloads":38.06767586821015,"dependent_repos_count":14.577025823686554,"dependent_packages_count":28.750835003340015,"stargazers_count":8.07212822796082,"forks_count":21.046304541406947,"docker_downloads_count":null,"average":22.102793892920896},"purl":"pkg:cran/readwritesqlite","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/cran/readwritesqlite","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/cran/readwritesqlite","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/cran/readwritesqlite/dependencies","status":"removed","funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2024-07-10T16:18:16.901Z","issues_count":31,"pull_requests_count":8,"avg_time_to_close_issue":5135920.782608695,"avg_time_to_close_pull_request":6441478.25,"issues_closed_count":23,"pull_requests_closed_count":8,"pull_request_authors_count":4,"issue_authors_count":8,"avg_comments_per_issue":0.967741935483871,"avg_comments_per_pull_request":0.5,"merged_pull_requests_count":5,"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/poissonconsulting%2Freadwritesqlite/issues","maintainers":[{"login":"joethorley","count":20,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/joethorley"},{"login":"evanamiesgalonski","count":7,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/evanamiesgalonski"},{"login":"aylapear","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/aylapear"},{"login":"krlmlr","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/krlmlr"},{"login":"nadinehussein","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/nadinehussein"},{"login":"sebdalgarno","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/sebdalgarno"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/readwritesqlite/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/readwritesqlite/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/readwritesqlite/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/readwritesqlite/related_packages","maintainers":[{"uuid":"joe@poissonconsulting.ca","login":null,"name":"Joe Thorley","email":"joe@poissonconsulting.ca","url":null,"packages_count":16,"html_url":null,"role":null,"created_at":"2022-11-14T17:22:38.401Z","updated_at":"2022-11-14T17:22:38.401Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/maintainers/joe@poissonconsulting.ca/packages"}],"registry":{"name":"cran.r-project.org","url":"https://cran.r-project.org","ecosystem":"cran","default":true,"packages_count":26181,"maintainers_count":14299,"namespaces_count":0,"keywords_count":8326,"github":"r-project-org","metadata":{"funded_packages_count":539},"icon_url":"https://github.com/r-project-org.png","created_at":"2022-04-06T16:32:25.637Z","updated_at":"2025-09-08T06:54:01.855Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages","maintainers_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/maintainers","namespaces_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/namespaces"}}],"commits":{"id":723959,"full_name":"poissonconsulting/readwritesqlite","default_branch":"main","committers":[{"name":"Joe Thorley","email":"joe@poissonconsulting.ca","login":"joethorley","count":280},{"name":"Kirill Müller","email":"krlmlr","login":"krlmlr","count":25},{"name":"Duncan Kennedy","email":"duncan@poissonconsulting.ca","login":"dunkenwg","count":23},{"name":"Evan","email":"evanamiesgalonski@gmail.com","login":"evanamiesgalonski","count":22},{"name":"Seb Dalgarno","email":"seb@poissonconsulting.ca","login":"sebdalgarno","count":3},{"name":"Nadine Hussein","email":"nadinehussein3@gmail.com","login":"nadinehussein","count":3},{"name":"Ayla Pearson","email":"aylapearson23@gmail.com","login":"aylapear","count":2},{"name":"Mowahid Latif","email":"mowahidlatif@Mowahids-MacBook-Air.local","login":null,"count":2}],"total_commits":360,"total_committers":8,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":45.0,"dds":0.2222222222222222,"past_year_committers":[{"name":"Kirill Müller","email":"krlmlr","login":"krlmlr","count":25},{"name":"Duncan Kennedy","email":"duncan@poissonconsulting.ca","login":"dunkenwg","count":23}],"past_year_total_commits":48,"past_year_total_committers":2,"past_year_total_bot_commits":0,"past_year_total_bot_committers":0,"past_year_mean_commits":24.0,"past_year_dds":0.47916666666666663,"last_synced_at":"2025-05-26T22:35:10.525Z","last_synced_commit":"a6a509ea397b22b108a4f5926a3847c739710149","created_at":"2023-03-09T13:10:31.966Z","updated_at":"2025-05-26T22:35:10.637Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-08-28T00:00:20.468Z","repositories_count":5479765,"commits_count":853308191,"contributors_count":31095157,"owners_count":906558,"icon_url":"https://github.com/github.png","host_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories"}},"issues_stats":{"full_name":"poissonconsulting/readwritesqlite","html_url":"https://github.com/poissonconsulting/readwritesqlite","last_synced_at":"2025-09-06T23:58:37.551Z","status":null,"issues_count":33,"pull_requests_count":37,"avg_time_to_close_issue":5135920.782608695,"avg_time_to_close_pull_request":1610352.2702702703,"issues_closed_count":23,"pull_requests_closed_count":37,"pull_request_authors_count":6,"issue_authors_count":9,"avg_comments_per_issue":1.6060606060606062,"avg_comments_per_pull_request":0.21621621621621623,"merged_pull_requests_count":34,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":2,"past_year_pull_requests_count":27,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":93553.03703703704,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":27,"past_year_pull_request_authors_count":2,"past_year_issue_authors_count":2,"past_year_avg_comments_per_issue":0.0,"past_year_avg_comments_per_pull_request":0.14814814814814814,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":27,"created_at":"2023-05-10T22:48:10.243Z","updated_at":"2025-09-06T23:58:37.552Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/poissonconsulting%2Freadwritesqlite/issues","issue_labels_count":{"Timeline: Soon":5,"Type: Feature":5,"Difficulty: Intermediate":4,"Effort: Medium":4,"Importance: High":3,"Importance: Medium":3,"Difficulty: Advanced":2,"Type: Bug":1,"Timeline: Now":1,"Effort: Small":1,"Type: Refactor":1,"Effort: Large":1},"pull_request_labels_count":{},"issue_author_associations_count":{"MEMBER":26,"NONE":4,"COLLABORATOR":3},"pull_request_author_associations_count":{"COLLABORATOR":25,"MEMBER":5,"NONE":4,"CONTRIBUTOR":3},"issue_authors":{"joethorley":18,"evanamiesgalonski":5,"krlmlr":3,"aylapear":2,"edzer":1,"NewGraphEnvironment":1,"sebdalgarno":1,"D3SL":1,"dusadrian":1},"pull_request_authors":{"krlmlr":25,"dunkenwg":4,"MowahidLatif":3,"joethorley":2,"evanamiesgalonski":2,"nadinehussein":1},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-08T00:00:17.013Z","repositories_count":10168351,"issues_count":32015117,"pull_requests_count":100242866,"authors_count":10730290,"icon_url":"https://github.com/github.png","host_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories","owners_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/owners","authors_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors"},"past_year_issue_labels_count":{},"past_year_pull_request_labels_count":{},"past_year_issue_author_associations_count":{"COLLABORATOR":1,"NONE":1},"past_year_pull_request_author_associations_count":{"COLLABORATOR":25,"NONE":1,"CONTRIBUTOR":1},"past_year_issue_authors":{"krlmlr":1,"NewGraphEnvironment":1},"past_year_pull_request_authors":{"krlmlr":25,"dunkenwg":2},"maintainers":[{"login":"krlmlr","count":28,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/krlmlr"},{"login":"joethorley","count":20,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/joethorley"},{"login":"evanamiesgalonski","count":7,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/evanamiesgalonski"},{"login":"aylapear","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/aylapear"},{"login":"sebdalgarno","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/sebdalgarno"},{"login":"nadinehussein","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/nadinehussein"}],"active_maintainers":[{"login":"krlmlr","count":26,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/krlmlr"}]},"events":{"total":{"CreateEvent":14,"IssuesEvent":1,"ReleaseEvent":1,"WatchEvent":2,"IssueCommentEvent":29,"PushEvent":66,"PullRequestEvent":30},"last_year":{"CreateEvent":14,"IssuesEvent":1,"ReleaseEvent":1,"WatchEvent":2,"IssueCommentEvent":29,"PushEvent":66,"PullRequestEvent":30}},"keywords":["cran","dbi","log","metadata","posixct","r","read","rstats","sfc","sqlite","units","write"],"dependencies":[{"ecosystem":"cran","filepath":"DESCRIPTION","sha":null,"kind":"manifest","created_at":"2022-08-21T01:10:25.854Z","updated_at":"2022-08-21T01:10:25.854Z","repository_link":"https://github.com/poissonconsulting/readwritesqlite/blob/main/DESCRIPTION","dependencies":[{"id":2198330554,"package_name":"R","ecosystem":"cran","requirements":"\u003e= 3.6","direct":true,"kind":"depends","optional":false},{"id":2198330555,"package_name":"chk","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330556,"package_name":"DBI","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330557,"package_name":"hms","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330558,"package_name":"lifecycle","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330559,"package_name":"RSQLite","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330560,"package_name":"tibble","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330561,"package_name":"sf","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330562,"package_name":"rlang","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330563,"package_name":"glue","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330564,"package_name":"crayon","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":2198330565,"package_name":"covr","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":2198330566,"package_name":"knitr","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":2198330567,"package_name":"pool","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":2198330568,"package_name":"rmarkdown","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":2198330569,"package_name":"testthat","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":2198330570,"package_name":"units","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/R-CMD-check.yaml","sha":null,"kind":"manifest","created_at":"2024-09-17T21:26:53.771Z","updated_at":"2024-09-17T21:26:53.771Z","repository_link":"https://github.com/poissonconsulting/readwritesqlite/blob/main/.github/workflows/R-CMD-check.yaml","dependencies":[{"id":20193959601,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":20193959602,"package_name":"r-lib/actions/setup-tinytex","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":20193959603,"package_name":"r-lib/actions/setup-r","ecosystem":"actions","requirements":"master","direct":true,"kind":"composite","optional":false},{"id":20193959604,"package_name":"r-lib/actions/setup-pandoc","ecosystem":"actions","requirements":"master","direct":true,"kind":"composite","optional":false},{"id":20193959605,"package_name":"actions/cache","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":20193959606,"package_name":"actions/upload-artifact","ecosystem":"actions","requirements":"master","direct":true,"kind":"composite","optional":false},{"id":20193959607,"package_name":"8398a7/action-slack","ecosystem":"actions","requirements":"v3.0.0","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/coverage.yaml","sha":null,"kind":"manifest","created_at":"2024-09-17T21:26:55.569Z","updated_at":"2024-09-17T21:26:55.569Z","repository_link":"https://github.com/poissonconsulting/readwritesqlite/blob/main/.github/workflows/coverage.yaml","dependencies":[{"id":20193960129,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":20193960131,"package_name":"r-lib/actions/setup-r","ecosystem":"actions","requirements":"master","direct":true,"kind":"composite","optional":false},{"id":20193960132,"package_name":"r-lib/actions/setup-pandoc","ecosystem":"actions","requirements":"master","direct":true,"kind":"composite","optional":false},{"id":20193960133,"package_name":"actions/cache","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"actions","filepath":".github/workflows/pkgdown.yaml","sha":null,"kind":"manifest","created_at":"2024-09-17T21:26:56.275Z","updated_at":"2024-09-17T21:26:56.275Z","repository_link":"https://github.com/poissonconsulting/readwritesqlite/blob/main/.github/workflows/pkgdown.yaml","dependencies":[{"id":20193960134,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":20193960135,"package_name":"r-lib/actions/setup-r","ecosystem":"actions","requirements":"master","direct":true,"kind":"composite","optional":false},{"id":20193960136,"package_name":"r-lib/actions/setup-pandoc","ecosystem":"actions","requirements":"master","direct":true,"kind":"composite","optional":false},{"id":20193960137,"package_name":"actions/cache","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false},{"id":20193960138,"package_name":"8398a7/action-slack","ecosystem":"actions","requirements":"v3.0.0","direct":true,"kind":"composite","optional":false}]}],"score":11.477091011961011,"created_at":"2025-09-08T11:27:18.832Z","updated_at":"2025-10-07T08:26:48.947Z","avatar_url":"https://github.com/poissonconsulting.png","language":"R","category":null,"sub_category":null,"monthly_downloads":263,"funding_links":[],"readme_doi_urls":[],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":["chk","species-sensitivity-distribution","assertion","checkr","fish","ecotoxicology","bc","ssd","water-quality-guideline","derived-parameters"],"project_url":"https://science.ecosyste.ms/api/v1/projects/74101","html_url":"https://science.ecosyste.ms/projects/74101"}