{"id":8655563,"name":"pgapi","ecosystem":"pypi","description":"CLI tool and Python library for manipulating Postgres databases","homepage":"https://github.com/Florents-Tselai/pgAPI","licenses":"Apache License, Version 2.0","normalized_licenses":["Apache-2.0"],"repository_url":"https://github.com/Florents-Tselai/pgAPI","keywords_array":[],"namespace":null,"versions_count":1,"first_release_published_at":"2023-12-19T09:01:02.000Z","latest_release_published_at":"2023-12-19T09:01:02.000Z","latest_release_number":"0.0.1a1","last_synced_at":"2026-09-19T07:17:36.190Z","created_at":"2023-12-19T09:02:25.373Z","updated_at":"2026-09-21T21:13:24.419Z","registry_url":"https://pypi.org/project/pgapi/","install_command":"pip install pgapi --index-url https://pypi.org/simple","documentation_url":"https://pgAPI.tselai.com/en/stable/","metadata":{"funding":null,"documentation":"https://pgAPI.tselai.com/en/stable/","classifiers":["Development Status :: 5 - Production/Stable","Intended Audience :: Developers","Intended Audience :: End Users/Desktop","Intended Audience :: Science/Research","License :: OSI Approved :: Apache Software License","Programming Language :: Python :: 3.10","Programming Language :: Python :: 3.11","Programming Language :: Python :: 3.12","Programming Language :: Python :: 3.7","Programming Language :: Python :: 3.8","Programming Language :: Python :: 3.9","Topic :: Database"],"normalized_name":"pgapi","project_status":null},"repo_metadata":{"id":213228915,"uuid":"733007097","full_name":"Florents-Tselai/pgAPI","owner":"Florents-Tselai","description":"Python CLI utility and library for manipulating Postgres databases","archived":false,"fork":true,"pushed_at":"2025-06-06T08:05:13.000Z","size":1949,"stargazers_count":0,"open_issues_count":4,"forks_count":0,"subscribers_count":1,"default_branch":"main","last_synced_at":"2025-09-23T08:45:05.393Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"https://pgapi.tselai.com","language":"Python","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":"simonw/sqlite-utils","license":"apache-2.0","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/Florents-Tselai.png","metadata":{},"created_at":"2023-12-18T10:59:45.000Z","updated_at":"2023-12-19T09:06:22.000Z","dependencies_parsed_at":null,"dependency_job_id":null,"html_url":"https://github.com/Florents-Tselai/pgAPI","commit_stats":null,"previous_names":["florents-tselai/sqlite-utils"],"tags_count":0,"template":false,"template_full_name":null,"purl":"pkg:github/Florents-Tselai/pgAPI","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Florents-Tselai%2FpgAPI","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Florents-Tselai%2FpgAPI/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Florents-Tselai%2FpgAPI/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Florents-Tselai%2FpgAPI/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/Florents-Tselai","download_url":"https://codeload.github.com/Florents-Tselai/pgAPI/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/Florents-Tselai%2FpgAPI/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":341189360,"owners_count":37448985,"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-18T02:00:15.364Z","response_time":89,"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":"Florents-Tselai","name":"Florents Tselai","uuid":"2118708","kind":"user","description":"Building Data Tools 🛠️ | Writing Python 🐍 | Hacking Postgres 🐘","email":"florents@tselai.com","website":"https://tselai.com","location":"Athens, Greece","twitter":"FlorenTselai","company":null,"icon_url":"https://avatars.githubusercontent.com/u/2118708?u=386c36654959c704611d28c5133db48acf21af71\u0026v=4","repositories_count":64,"last_synced_at":"2026-09-21T07:51:09.015Z","metadata":{"has_sponsors_listing":true,"funding":null},"html_url":"https://github.com/Florents-Tselai","funding_links":["https://github.com/sponsors/Florents-Tselai"],"total_stars":786,"followers":163,"following":0,"created_at":"2022-11-14T19:36:30.262Z","updated_at":"2026-09-21T07:51:09.033Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/Florents-Tselai","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/Florents-Tselai/repositories"},"tags":[]},"repo_metadata_updated_at":"2026-09-21T21:13:24.419Z","dependent_packages_count":1,"downloads":17,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":null,"dependent_repos_count":66.84682262087145,"dependent_packages_count":10.131271674220486,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":38.48904714754597},"purl":"pkg:pypi/pgapi","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/pypi/pgapi","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/pypi/pgapi","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/pypi/pgapi/dependencies","status":null,"funding_links":["https://github.com/sponsors/Florents-Tselai"],"critical":null,"issue_metadata":{"last_synced_at":"2026-09-18T21:57:24.509Z","issues_count":4,"pull_requests_count":1,"avg_time_to_close_issue":49402.0,"avg_time_to_close_pull_request":498.0,"issues_closed_count":1,"pull_requests_closed_count":1,"pull_request_authors_count":1,"issue_authors_count":1,"avg_comments_per_issue":0.5,"avg_comments_per_pull_request":1.0,"merged_pull_requests_count":1,"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/Florents-Tselai%2FpgAPI/issues","maintainers":[{"login":"Florents-Tselai","count":5,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/Florents-Tselai"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/pgapi/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/pgapi/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/pgapi/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/pgapi/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/pgapi/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/pgapi/codemeta","maintainers":[{"uuid":"florents.tselai","login":"florents.tselai","name":null,"email":null,"url":null,"packages_count":21,"html_url":"https://pypi.org/user/florents.tselai/","role":null,"created_at":"2023-12-19T09:23:08.349Z","updated_at":"2023-12-19T09:23:08.349Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/maintainers/florents.tselai/packages"}]}