{"id":8226987,"name":"github.com/go-llsqlite/crawshaw","ecosystem":"go","description":"Package sqlite provides a Go interface to SQLite 3.\n\nThe semantics of this package are deliberately close to the\nSQLite3 C API, so it is helpful to be familiar with\nhttp://www.sqlite.org/c3ref/intro.html.\n\nAn SQLite connection is represented by a *sqlite.Conn.\nConnections cannot be used concurrently.\nA typical Go program will create a pool of connections\n(using Open to create a *sqlitex.Pool) so goroutines can\nborrow a connection while they need to talk to the database.\n\nThis package assumes SQLite will be used concurrently by the\nprocess through several connections, so the build options for\nSQLite enable multi-threading and the shared cache:\nhttps://www.sqlite.org/sharedcache.html\n\nThe implementation automatically handles shared cache locking,\nsee the documentation on Stmt.Step for details.\n\nThe optional SQLite3 compiled in are: FTS5, RTree, JSON1, Session, GeoPoly\n\nThis is not a database/sql driver.\n\nStatements are prepared with the Prepare and PrepareTransient methods.\nWhen using Prepare, statements are keyed inside a connection by the\noriginal query string used to create them. This means long-running\nhigh-performance code paths can write:\n\nAfter all the connections in a pool have been warmed up by passing\nthrough one of these Prepare calls, subsequent calls are simply a\nmap lookup that returns an existing statement.\n\nThe sqlite package supports the SQLite incremental I/O interface for\nstreaming blob data into and out of the the database without loading\nthe entire blob into a single []byte.\n(This is important when working either with very large blobs, or\nmore commonly, a large number of moderate-sized blobs concurrently.)\n\nTo write a blob, first use an INSERT statement to set the size of the\nblob and assign a rowid:\n\nUse BindZeroBlob or SetZeroBlob to set the size of myblob.\nThen you can open the blob with:\n\nEvery connection can have a done channel associated with it using\nthe SetInterrupt method. This is typically the channel returned by\na context.Context Done method.\n\nFor example, a timeout can be associated with a connection session:\n\nAs database connections are long-lived, the SetInterrupt method can\nbe called multiple times to reset the associated lifetime.\n\nWhen using pools, the shorthand for associating a context with a\nconnection is:\n\nSQLite transactions have to be managed manually with this package\nby directly calling BEGIN / COMMIT / ROLLBACK or\nSAVEPOINT / RELEASE/ ROLLBACK. The sqlitex has a Savepoint\nfunction that helps automate this.\n\nUsing a Pool to execute SQL in a concurrent HTTP handler.\n\nFor helper functions that make some kinds of statements easier to\nwrite see the sqlitex package.","homepage":"https://github.com/go-llsqlite/crawshaw","licenses":"ISC","normalized_licenses":["ISC"],"repository_url":"https://github.com/go-llsqlite/crawshaw","keywords_array":[],"namespace":"github.com/go-llsqlite","versions_count":12,"first_release_published_at":"2023-09-04T10:35:56.000Z","latest_release_published_at":"2025-06-20T01:37:44.000Z","latest_release_number":"v0.6.0","last_synced_at":"2026-06-30T22:03:37.814Z","created_at":"2023-09-05T04:00:56.729Z","updated_at":"2026-06-30T22:03:37.814Z","registry_url":"https://pkg.go.dev/github.com/go-llsqlite/crawshaw","install_command":"go get github.com/go-llsqlite/crawshaw","documentation_url":"https://pkg.go.dev/github.com/go-llsqlite/crawshaw#section-documentation","metadata":{},"repo_metadata":{"id":174559379,"uuid":"652408343","full_name":"go-llsqlite/crawshaw","owner":"go-llsqlite","description":"Low-level Go interface to SQLite 3 using cgo","archived":false,"fork":false,"pushed_at":"2025-06-20T01:38:53.000Z","size":6017,"stargazers_count":24,"open_issues_count":3,"forks_count":7,"subscribers_count":2,"default_branch":"master","last_synced_at":"2025-08-01T00:25:41.492Z","etag":null,"topics":["cgo","crawshaw","go","sqlite"],"latest_commit_sha":null,"homepage":"","language":"C","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"isc","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/go-llsqlite.png","metadata":{"files":{"readme":"README.md","changelog":null,"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}},"created_at":"2023-06-12T02:34:35.000Z","updated_at":"2025-06-20T01:37:55.000Z","dependencies_parsed_at":"2023-11-12T00:25:06.579Z","dependency_job_id":"9cdbbc86-fc36-4b03-ad9c-2bdd7e6a162b","html_url":"https://github.com/go-llsqlite/crawshaw","commit_stats":null,"previous_names":["go-llsqlite/llsqlite"],"tags_count":8,"template":false,"template_full_name":null,"purl":"pkg:github/go-llsqlite/crawshaw","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/go-llsqlite","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/sbom","host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":268157486,"owners_count":24204749,"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-07-31T02:00:08.723Z","response_time":66,"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":"go-llsqlite","name":"go-llsqlite","uuid":"136288730","kind":"organization","description":null,"email":null,"website":null,"location":null,"twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/136288730?v=4","repositories_count":1,"last_synced_at":"2023-06-12T03:27:22.174Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/go-llsqlite","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2023-06-12T03:27:22.175Z","updated_at":"2023-06-12T03:27:22.175Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/go-llsqlite","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/go-llsqlite/repositories"},"tags":[{"name":"v0.6.0","sha":"e049d2988338109a605cdf88aa06eae58c882928","kind":"commit","published_at":"2025-06-20T01:37:44.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.6.0","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.6.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.6.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.6.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.6.0/manifests"},{"name":"v0.5.5","sha":"7acb15b8edc3dc6512970ce2bceae440ec38ef72","kind":"commit","published_at":"2024-08-20T06:01:35.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.5.5","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.5.5","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.5.5","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.5","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.5/manifests"},{"name":"v0.5.4","sha":"f281871835953b59f3f0c520b9b1936b07d1835f","kind":"commit","published_at":"2024-08-19T07:00:37.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.5.4","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.5.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.5.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.4/manifests"},{"name":"v0.5.3","sha":"e1b4b55a1f4a4e456e349b82e8e4062626349cae","kind":"commit","published_at":"2024-06-15T23:25:29.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.5.3","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.5.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.5.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.3/manifests"},{"name":"v0.5.2","sha":"f30eb7704568415d8de4e86068306ac776cecb53","kind":"commit","published_at":"2024-04-25T03:41:40.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.5.2","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.5.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.5.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.2/manifests"},{"name":"v0.5.1","sha":"ca6dc893ac250e64744ed09174796045198d5121","kind":"commit","published_at":"2024-02-08T04:33:45.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.5.1","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.5.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.5.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.1/manifests"},{"name":"v0.5.0","sha":"9da9e50c4de1f0639b95c59c5d2971c0ad4e246c","kind":"commit","published_at":"2023-11-11T23:37:08.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.5.0","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.5.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.5.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.5.0/manifests"},{"name":"v0.4.0","sha":"aeb8ae1e7fddcbee442352627c0b12447533ee95","kind":"commit","published_at":"2023-09-17T03:14:38.000Z","download_url":"https://codeload.github.com/go-llsqlite/crawshaw/tar.gz/v0.4.0","html_url":"https://github.com/go-llsqlite/crawshaw/releases/tag/v0.4.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/go-llsqlite/crawshaw@v0.4.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.4.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/go-llsqlite%2Fcrawshaw/tags/v0.4.0/manifests"}]},"repo_metadata_updated_at":"2025-08-01T01:59:00.651Z","dependent_packages_count":61,"downloads":null,"downloads_period":null,"dependent_repos_count":6,"rankings":{"downloads":null,"dependent_repos_count":2.066368453980421,"dependent_packages_count":0.8528297443705953,"stargazers_count":14.66044963395274,"forks_count":13.460980070704945,"docker_downloads_count":0.5344279993973217,"average":6.315011180481205},"purl":"pkg:golang/github.com/go-llsqlite/crawshaw","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/go/github.com/go-llsqlite/crawshaw","docker_dependents_count":4,"docker_downloads_count":1083249,"usage_url":"https://repos.ecosyste.ms/usage/go/github.com/go-llsqlite/crawshaw","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/go/github.com/go-llsqlite/crawshaw/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":null,"versions_url":"https://packages.ecosyste.ms/api/v1/registries/proxy.golang.org/packages/github.com%2Fgo-llsqlite%2Fcrawshaw/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/proxy.golang.org/packages/github.com%2Fgo-llsqlite%2Fcrawshaw/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/proxy.golang.org/packages/github.com%2Fgo-llsqlite%2Fcrawshaw/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/proxy.golang.org/packages/github.com%2Fgo-llsqlite%2Fcrawshaw/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/proxy.golang.org/packages/github.com%2Fgo-llsqlite%2Fcrawshaw/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/proxy.golang.org/packages/github.com%2Fgo-llsqlite%2Fcrawshaw/codemeta","maintainers":[]}