{"id":13621523,"name":"@photostructure/knex-sqlite","ecosystem":"npm","description":"Knex.js dialect for @photostructure/sqlite","homepage":"https://github.com/photostructure/knex-sqlite#readme","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/photostructure/knex-sqlite","keywords_array":["knex","sqlite","sqlite3","photostructure","database","query-builder","dialect","node-sqlite"],"namespace":"photostructure","versions_count":3,"first_release_published_at":"2026-02-09T22:42:00.530Z","latest_release_published_at":"2026-08-08T21:24:27.465Z","latest_release_number":"1.0.0","last_synced_at":"2026-08-15T03:38:13.502Z","created_at":"2026-02-12T00:44:00.767Z","updated_at":"2026-08-15T03:38:33.452Z","registry_url":"https://www.npmjs.com/package/@photostructure/knex-sqlite","install_command":"npm install @photostructure/knex-sqlite","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"1.0.0"},"contentPolicy":null},"repo_metadata":{"id":337521797,"uuid":"1153982779","full_name":"photostructure/knex-sqlite","owner":"photostructure","description":"Knex.js dialect for @photostructure/sqlite","archived":false,"fork":false,"pushed_at":"2026-08-08T21:22:34.000Z","size":47,"stargazers_count":1,"open_issues_count":0,"forks_count":0,"subscribers_count":0,"default_branch":"main","last_synced_at":"2026-08-15T03:30:26.523Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":null,"language":"JavaScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"mit","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/photostructure.png","metadata":{"files":{"readme":"README.md","changelog":"CHANGELOG.md","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,"zenodo":null,"notice":null,"maintainers":null,"copyright":null,"agents":null,"dco":null,"cla":null}},"created_at":"2026-02-09T22:16:57.000Z","updated_at":"2026-08-08T21:22:38.000Z","dependencies_parsed_at":null,"dependency_job_id":null,"html_url":"https://github.com/photostructure/knex-sqlite","commit_stats":null,"previous_names":["photostructure/knex-sqlite"],"tags_count":1,"template":false,"template_full_name":null,"purl":"pkg:github/photostructure/knex-sqlite","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fknex-sqlite","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fknex-sqlite/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fknex-sqlite/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fknex-sqlite/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/photostructure","download_url":"https://codeload.github.com/photostructure/knex-sqlite/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fknex-sqlite/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":36672374,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-08-06T04:43:03.162Z","status":"online","status_checked_at":"2026-08-15T02:00:05.847Z","response_time":94,"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":"photostructure","name":"PhotoStructure","uuid":"48070612","kind":"organization","description":"PhotoStructure is your new home for all your photos and videos.","email":"hello@photostructure.com","website":"https://photostructure.com","location":"Earth","twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/48070612?v=4","repositories_count":33,"last_synced_at":"2026-08-07T17:28:34.315Z","metadata":{"has_sponsors_listing":true,"funding":null},"html_url":"https://github.com/photostructure","funding_links":["https://github.com/sponsors/photostructure"],"total_stars":1125,"followers":92,"following":0,"created_at":"2022-11-14T00:59:15.694Z","updated_at":"2026-08-07T17:28:34.341Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/photostructure","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/photostructure/repositories"},"tags":[{"name":"v0.1.1","sha":"49a28da23a605b6adfe2f0bee8de80c600d066a4","kind":"tag","published_at":"2026-02-09T23:29:04.000Z","download_url":"https://codeload.github.com/photostructure/knex-sqlite/tar.gz/v0.1.1","html_url":"https://github.com/photostructure/knex-sqlite/releases/tag/v0.1.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/knex-sqlite@v0.1.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fknex-sqlite/tags/v0.1.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fknex-sqlite/tags/v0.1.1/manifests"}]},"repo_metadata_updated_at":"2026-08-15T03:38:33.452Z","dependent_packages_count":0,"downloads":30,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":null,"dependent_repos_count":22.945251037738736,"dependent_packages_count":33.08080111572745,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":28.013026076733095},"purl":"pkg:npm/%40photostructure/knex-sqlite","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/@photostructure/knex-sqlite","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/@photostructure/knex-sqlite","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/@photostructure/knex-sqlite/dependencies","status":null,"funding_links":["https://github.com/sponsors/photostructure"],"critical":null,"issue_metadata":null,"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fknex-sqlite/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fknex-sqlite/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fknex-sqlite/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fknex-sqlite/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fknex-sqlite/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fknex-sqlite/codemeta","maintainers":[{"uuid":"mceachen","login":"mceachen","name":null,"email":"matthew-npm@mceachen.org","url":null,"packages_count":22,"html_url":"https://www.npmjs.com/~mceachen","role":null,"created_at":"2026-02-12T00:44:07.759Z","updated_at":"2026-02-12T00:44:07.759Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/mceachen/packages"}]}