{"id":72055,"name":"timeseriesdb","description":"{timeseriesdb} Manage Time Series with R and PostgreSQL ","url":"https://github.com/mbannert/timeseriesdb","last_synced_at":"2025-09-08T15:29:24.578Z","repository":{"id":20436784,"uuid":"23713551","full_name":"mbannert/timeseriesdb","owner":"mbannert","description":"{timeseriesdb} Manage Time Series with R and PostgreSQL ","archived":false,"fork":false,"pushed_at":"2024-09-17T21:54:11.000Z","size":2625,"stargazers_count":24,"open_issues_count":30,"forks_count":3,"subscribers_count":4,"default_branch":"main","last_synced_at":"2025-09-05T20:27:55.757Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"","language":"R","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"gpl-3.0","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/mbannert.png","metadata":{"files":{"readme":"README.md","changelog":"NEWS.md","contributing":null,"funding":null,"license":"LICENSE.md","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":"2014-09-05T18:19:43.000Z","updated_at":"2025-01-14T14:48:09.000Z","dependencies_parsed_at":"2024-09-18T01:59:09.035Z","dependency_job_id":"0fa2f332-ef1d-4501-b0c0-dabb04d4fef1","html_url":"https://github.com/mbannert/timeseriesdb","commit_stats":{"total_commits":935,"total_committers":10,"mean_commits":93.5,"dds":0.6438502673796791,"last_synced_commit":"73c9c30e6bb682c28d8f2c507e180c1f7c7abec6"},"previous_names":[],"tags_count":0,"template":false,"template_full_name":null,"purl":"pkg:github/mbannert/timeseriesdb","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mbannert","download_url":"https://codeload.github.com/mbannert/timeseriesdb/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":274205577,"owners_count":25241011,"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":"mbannert","name":"Matt Bannert","uuid":"1382079","kind":"user","description":"Analytics \u0026 Data Engineering \r\n@cynkra, lecturer @ ETH. 2021 Global coordinator for @_useRconf. Creator of devOps Carpentry.","email":"","website":"https://whatsgood.io","location":"Zurich, Switzerland","twitter":"whatsgoodio","company":"@KOF-ch @cynkra @banboo-data","icon_url":"https://avatars.githubusercontent.com/u/1382079?u=d72bf0a55ffb8cc26244c84ec1b73e57f16b63b8\u0026v=4","repositories_count":13,"last_synced_at":"2023-04-07T07:06:11.445Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/mbannert","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-04T18:49:56.354Z","updated_at":"2023-04-07T07:06:11.529Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mbannert","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mbannert/repositories"},"packages":[{"id":413673,"name":"timeseriesdb","ecosystem":"cran","description":"A Time Series Database for Official Statistics with R and\nPostgreSQL","homepage":"https://github.com/mbannert/timeseriesdb","licenses":"GPL-3","normalized_licenses":["GPL-3.0"],"repository_url":"https://github.com/mbannert/timeseriesdb","keywords_array":[],"namespace":null,"versions_count":6,"first_release_published_at":"2014-11-26T15:40:00.000Z","latest_release_published_at":"2018-08-06T13:20:00.000Z","latest_release_number":"0.4.1","last_synced_at":"2025-09-05T03:31:42.128Z","created_at":"2022-04-06T17:48:30.160Z","updated_at":"2025-09-05T20:08:38.287Z","registry_url":"https://cran.r-project.org/package=timeseriesdb","install_command":null,"documentation_url":"http://cran.r-project.org/web/packages/timeseriesdb/timeseriesdb.pdf","metadata":{},"repo_metadata":{"id":20436784,"uuid":"23713551","full_name":"mbannert/timeseriesdb","owner":"mbannert","description":"{timeseriesdb} Manage Time Series with R and PostgreSQL ","archived":false,"fork":false,"pushed_at":"2024-09-17T21:54:11.000Z","size":2625,"stargazers_count":24,"open_issues_count":30,"forks_count":3,"subscribers_count":4,"default_branch":"main","last_synced_at":"2025-07-31T01:58:17.464Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"","language":"R","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"gpl-3.0","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/mbannert.png","metadata":{"files":{"readme":"README.md","changelog":"NEWS.md","contributing":null,"funding":null,"license":"LICENSE.md","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":"2014-09-05T18:19:43.000Z","updated_at":"2025-01-14T14:48:09.000Z","dependencies_parsed_at":"2024-09-18T01:59:09.035Z","dependency_job_id":"0fa2f332-ef1d-4501-b0c0-dabb04d4fef1","html_url":"https://github.com/mbannert/timeseriesdb","commit_stats":{"total_commits":935,"total_committers":10,"mean_commits":93.5,"dds":0.6438502673796791,"last_synced_commit":"73c9c30e6bb682c28d8f2c507e180c1f7c7abec6"},"previous_names":[],"tags_count":0,"template":false,"template_full_name":null,"purl":"pkg:github/mbannert/timeseriesdb","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mbannert","download_url":"https://codeload.github.com/mbannert/timeseriesdb/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":273813831,"owners_count":25172892,"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-05T02:00:09.113Z","response_time":402,"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":"mbannert","name":"Matt Bannert","uuid":"1382079","kind":"user","description":"Analytics \u0026 Data Engineering \r\n@cynkra, lecturer @ ETH. 2021 Global coordinator for @_useRconf. Creator of devOps Carpentry.","email":"","website":"https://whatsgood.io","location":"Zurich, Switzerland","twitter":"whatsgoodio","company":"@KOF-ch @cynkra @banboo-data","icon_url":"https://avatars.githubusercontent.com/u/1382079?u=d72bf0a55ffb8cc26244c84ec1b73e57f16b63b8\u0026v=4","repositories_count":13,"last_synced_at":"2023-04-07T07:06:11.445Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/mbannert","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-04T18:49:56.354Z","updated_at":"2023-04-07T07:06:11.529Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mbannert","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/mbannert/repositories"},"tags":[]},"repo_metadata_updated_at":"2025-09-05T20:08:38.287Z","dependent_packages_count":0,"downloads":284,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":35.27460550632611,"dependent_repos_count":35.45467469080226,"dependent_packages_count":29.796711368051938,"stargazers_count":11.922475477420273,"forks_count":17.76998531014548,"average":26.043690470549212},"purl":"pkg:cran/timeseriesdb","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/cran/timeseriesdb","docker_dependents_count":4,"docker_downloads_count":42005,"usage_url":"https://repos.ecosyste.ms/usage/cran/timeseriesdb","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/cran/timeseriesdb/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2025-07-31T01:12:27.229Z","issues_count":58,"pull_requests_count":44,"avg_time_to_close_issue":11900625.82857143,"avg_time_to_close_pull_request":3183773.1052631577,"issues_closed_count":35,"pull_requests_closed_count":38,"pull_request_authors_count":5,"issue_authors_count":7,"avg_comments_per_issue":0.8793103448275862,"avg_comments_per_pull_request":0.4090909090909091,"merged_pull_requests_count":37,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"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":1,"past_year_avg_comments_per_issue":2.0,"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/mbannert%2Ftimeseriesdb/issues","maintainers":[{"login":"HomoCodens","count":63,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/HomoCodens"},{"login":"mbannert","count":18,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mbannert"},{"login":"angelicambg","count":4,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/angelicambg"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/timeseriesdb/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/timeseriesdb/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/timeseriesdb/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/packages/timeseriesdb/related_packages","maintainers":[{"uuid":"bannert@kof.ethz.ch","login":null,"name":"Matthias Bannert","email":"bannert@kof.ethz.ch","url":null,"packages_count":3,"html_url":null,"role":null,"created_at":"2022-11-14T17:15:02.171Z","updated_at":"2022-11-14T17:15:02.171Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/cran.r-project.org/maintainers/bannert@kof.ethz.ch/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":720161,"full_name":"mbannert/timeseriesdb","default_branch":"main","committers":[{"name":"Matthias Bannert","email":"matthias.bannert@gmail.com","login":"mbannert","count":359},{"name":"thoenis","email":"sthoeni@kof.ethz.ch","login":null,"count":328},{"name":"HomoCodens","email":"32675029+HomoCodens","login":"HomoCodens","count":221},{"name":"angelicambg","email":"angelicambg@gmail.com","login":"angelicambg","count":18},{"name":"maja","email":"majazaloznik","login":"majazaloznik","count":6},{"name":"igbucur","email":"ioan.gabriel.bucur@gmail.com","login":"igbucur","count":2},{"name":"Kirill Müller","email":"krlmlr","login":"krlmlr","count":1},{"name":"Severin Thoeni","email":"thoenis@rstudio2.kof","login":null,"count":1}],"total_commits":936,"total_committers":8,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":117.0,"dds":0.6164529914529915,"past_year_committers":[{"name":"Kirill Müller","email":"krlmlr","login":"krlmlr","count":1}],"past_year_total_commits":1,"past_year_total_committers":1,"past_year_total_bot_commits":0,"past_year_total_bot_committers":0,"past_year_mean_commits":1.0,"past_year_dds":0.0,"last_synced_at":"2025-03-07T06:45:24.495Z","last_synced_commit":"94bb916d3f11bb36444d5e8050e49924e05a67c8","created_at":"2023-03-09T13:01:55.931Z","updated_at":"2025-03-07T06:45:24.906Z","commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-07T00:00:09.744Z","repositories_count":5480019,"commits_count":853389126,"contributors_count":31098155,"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":"mbannert/timeseriesdb","html_url":"https://github.com/mbannert/timeseriesdb","last_synced_at":"2025-07-31T01:12:27.229Z","status":"error","issues_count":58,"pull_requests_count":44,"avg_time_to_close_issue":11900625.82857143,"avg_time_to_close_pull_request":3183773.1052631577,"issues_closed_count":35,"pull_requests_closed_count":38,"pull_request_authors_count":5,"issue_authors_count":7,"avg_comments_per_issue":0.8793103448275862,"avg_comments_per_pull_request":0.4090909090909091,"merged_pull_requests_count":37,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"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":1,"past_year_avg_comments_per_issue":2.0,"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,"created_at":"2023-05-10T22:15:07.659Z","updated_at":"2025-09-02T08:00:45.434Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/mbannert%2Ftimeseriesdb/issues","issue_labels_count":{"enhancement":8,"question":3,"later problem":3,"bug":2},"pull_request_labels_count":{},"issue_author_associations_count":{"COLLABORATOR":33,"OWNER":15,"NONE":9,"CONTRIBUTOR":1},"pull_request_author_associations_count":{"COLLABORATOR":34,"CONTRIBUTOR":7,"OWNER":3,"NONE":1},"issue_authors":{"HomoCodens":33,"mbannert":15,"omuelle":6,"GigiHadid97":1,"Kjir":1,"majazaloznik":1,"sboriss":1},"pull_request_authors":{"HomoCodens":30,"majazaloznik":6,"angelicambg":4,"mbannert":3,"krlmlr":2},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-04T00:00:25.939Z","repositories_count":10074708,"issues_count":31280107,"pull_requests_count":95730442,"authors_count":10690872,"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":{},"past_year_pull_request_author_associations_count":{},"past_year_issue_authors":{},"past_year_pull_request_authors":{},"maintainers":[{"login":"HomoCodens","count":63,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/HomoCodens"},{"login":"mbannert","count":18,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mbannert"},{"login":"angelicambg","count":4,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/angelicambg"}],"active_maintainers":[]},"events":{"total":{"WatchEvent":2},"last_year":{"WatchEvent":2}},"keywords":[],"dependencies":[{"ecosystem":"cran","filepath":"DESCRIPTION","sha":null,"kind":"manifest","created_at":"2022-07-31T19:48:08.798Z","updated_at":"2022-07-31T19:48:08.798Z","repository_link":"https://github.com/mbannert/timeseriesdb/blob/main/DESCRIPTION","dependencies":[{"id":530838287,"package_name":"R","ecosystem":"cran","requirements":"\u003e= 3.0.0","direct":true,"kind":"depends","optional":false},{"id":530838288,"package_name":"RPostgres","ecosystem":"cran","requirements":"\u003e= 1.2.0","direct":true,"kind":"imports","optional":false},{"id":530838289,"package_name":"jsonlite","ecosystem":"cran","requirements":"\u003e= 1.1","direct":true,"kind":"imports","optional":false},{"id":530838290,"package_name":"data.table","ecosystem":"cran","requirements":"\u003e= 1.9.4","direct":true,"kind":"imports","optional":false},{"id":530838291,"package_name":"utils","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":530838292,"package_name":"xts","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":530838293,"package_name":"DBI","ecosystem":"cran","requirements":"*","direct":true,"kind":"imports","optional":false},{"id":530838294,"package_name":"openxlsx","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":530838295,"package_name":"rstudioapi","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":530838296,"package_name":"dygraphs","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":530838297,"package_name":"rmarkdown","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false},{"id":530838298,"package_name":"knitr","ecosystem":"cran","requirements":"*","direct":true,"kind":"suggests","optional":false}]}],"score":16.72082609924604,"created_at":"2025-09-08T11:22:35.663Z","updated_at":"2025-10-07T08:26:19.643Z","avatar_url":"https://github.com/mbannert.png","language":"R","category":null,"sub_category":null,"monthly_downloads":284,"funding_links":[],"readme_doi_urls":[],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":[],"project_url":"https://science.ecosyste.ms/api/v1/projects/72055","html_url":"https://science.ecosyste.ms/projects/72055"}