{"id":11798736,"name":"@photostructure/sqlite","ecosystem":"npm","description":"Drop-in replacement for node:sqlite","homepage":"https://photostructure.github.io/node-sqlite/","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/photostructure/node-sqlite","keywords_array":["sqlite","node:sqlite","drop-in-replacement","database","sql","native","node-addon","DatabaseSync","StatementSync","sync","performance"],"namespace":"photostructure","versions_count":17,"first_release_published_at":"2025-06-14T03:01:49.070Z","latest_release_published_at":"2026-09-18T05:55:27.237Z","latest_release_number":"2.6.0","last_synced_at":"2026-10-03T03:22:43.416Z","created_at":"2025-06-14T03:02:28.264Z","updated_at":"2026-10-03T03:22:45.256Z","registry_url":"https://www.npmjs.com/package/@photostructure/sqlite","install_command":"npm install @photostructure/sqlite","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"2.6.0"},"contentPolicy":null},"repo_metadata":{"id":296281922,"uuid":"992828789","full_name":"photostructure/node-sqlite","owner":"photostructure","description":"Drop-in replacement for `node:sqlite` _but with async too_ ","archived":false,"fork":false,"pushed_at":"2026-09-18T19:19:25.000Z","size":17074,"stargazers_count":7,"open_issues_count":0,"forks_count":0,"subscribers_count":0,"default_branch":"main","last_synced_at":"2026-10-01T01:43:08.813Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"https://photostructure.github.io/node-sqlite/","language":"C","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":"SECURITY.md","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":"2025-05-29T19:24:21.000Z","updated_at":"2026-09-18T19:19:28.000Z","dependencies_parsed_at":"2025-05-29T21:39:20.239Z","dependency_job_id":"f35eab5b-9aba-40c2-8c45-519a831b36f5","html_url":"https://github.com/photostructure/node-sqlite","commit_stats":null,"previous_names":["photostructure/node-sqlite"],"tags_count":10,"template":false,"template_full_name":null,"purl":"pkg:github/photostructure/node-sqlite","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/photostructure","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":342542704,"owners_count":37957421,"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-10-03T02:00:07.567Z","response_time":59,"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":35,"last_synced_at":"2026-09-25T09:25:07.486Z","metadata":{"has_sponsors_listing":true,"funding":null},"html_url":"https://github.com/photostructure","funding_links":["https://github.com/sponsors/photostructure"],"total_stars":1141,"followers":93,"following":0,"created_at":"2022-11-14T00:59:15.694Z","updated_at":"2026-09-25T09:25:07.749Z","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":"v1.2.1","sha":"4113d2b0dc5903d16b052288f944c5f539d098fc","kind":"tag","published_at":"2026-04-28T06:55:58.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v1.2.1","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v1.2.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v1.2.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.2.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.2.1/manifests"},{"name":"v1.2.0","sha":"a157b26bc6faaaf50b48cf5c0027b74dc01e0024","kind":"tag","published_at":"2026-04-16T01:49:05.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v1.2.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v1.2.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v1.2.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.2.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.2.0/manifests"},{"name":"v1.1.0","sha":"5aadba69d17274b3abfc4f1f5556ba94321fc533","kind":"tag","published_at":"2026-03-13T23:47:46.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v1.1.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v1.1.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v1.1.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.1.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.1.0/manifests"},{"name":"v1.0.0","sha":"ca5c88484116d5835d07093efe7c9888db9d8eb3","kind":"tag","published_at":"2026-03-08T05:44:29.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v1.0.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v1.0.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v1.0.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.0.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v1.0.0/manifests"},{"name":"v0.5.0","sha":"d83b7006daf853a68ec9c6a22d0db261916b8f0d","kind":"tag","published_at":"2026-02-07T06:12:47.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v0.5.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v0.5.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v0.5.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.5.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.5.0/manifests"},{"name":"v0.4.0","sha":"84b73743974ca2df89796e44cb30be9a4776ff2e","kind":"tag","published_at":"2026-02-04T18:41:23.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v0.4.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v0.4.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v0.4.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.4.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.4.0/manifests"},{"name":"v0.3.0","sha":"793dfcf195d3f57d43c8d0d13e27abfad67185da","kind":"tag","published_at":"2025-12-17T20:03:02.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v0.3.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v0.3.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v0.3.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.3.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.3.0/manifests"},{"name":"v0.2.1","sha":"4763c4b963e134392f3839690508602ef49f426e","kind":"tag","published_at":"2025-12-02T07:08:36.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v0.2.1","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v0.2.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v0.2.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.2.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.2.1/manifests"},{"name":"v0.2.0","sha":"8b916d42a905095eab37b7c99c8bfe080b3836eb","kind":"tag","published_at":"2025-12-01T23:46:01.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v0.2.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v0.2.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v0.2.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.2.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.2.0/manifests"},{"name":"v0.0.1","sha":"693400ac6e4e97d16ec2d8a098082f4e47e8531a","kind":"tag","published_at":"2025-06-14T03:01:45.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v0.0.1","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v0.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v0.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.0.1/manifests"}]},"repo_metadata_updated_at":"2026-10-03T03:22:45.256Z","dependent_packages_count":0,"downloads":1554,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":null,"dependent_repos_count":24.435935445474673,"dependent_packages_count":35.26631383452246,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":29.851124639998567},"purl":"pkg:npm/%40photostructure/sqlite","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/@photostructure/sqlite","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/@photostructure/sqlite","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/@photostructure/sqlite/dependencies","status":null,"funding_links":["https://github.com/sponsors/photostructure"],"critical":null,"issue_metadata":{"last_synced_at":"2026-09-24T13:53:06.463Z","issues_count":0,"pull_requests_count":72,"avg_time_to_close_issue":null,"avg_time_to_close_pull_request":737688.6458333334,"issues_closed_count":0,"pull_requests_closed_count":48,"pull_request_authors_count":2,"issue_authors_count":0,"avg_comments_per_issue":null,"avg_comments_per_pull_request":0.625,"merged_pull_requests_count":2,"bot_issues_count":0,"bot_pull_requests_count":70,"past_year_issues_count":0,"past_year_pull_requests_count":6,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":986682.0,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":2,"past_year_pull_request_authors_count":2,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":0.16666666666666666,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":4,"past_year_merged_pull_requests_count":0,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/issues","maintainers":[{"login":"mceachen","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mceachen"}],"active_maintainers":[{"login":"mceachen","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mceachen"}]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/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":"2025-06-14T03:03:53.891Z","updated_at":"2025-06-14T03:03:53.891Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/mceachen/packages"}]}