{"id":52765,"library":"ql","title":"QL Database Engine","description":"Package ql implements a pure Go embedded SQL database engine with ACID transactions.","status":"active","version":"1.5.1","language":"go","source_language":null,"source_url":null,"tags":["sql","database","embedded","pure-go"],"install":[{"cmd":"go get modernc.org/ql","lang":"bash","label":"Install modernc.org/ql"}],"dependencies":[],"imports":[{"symbol":"ql","correct":"modernc.org/ql"}],"quickstart":{"code":"package main\n\nimport (\n\t\"log\"\n\t\"modernc.org/ql\"\n)\n\nfunc main() {\n\tdb, err := ql.OpenFile(\"test.db\", nil)\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tdefer db.Close()\n\t_, _, err = db.Run(\"CREATE TABLE IF NOT EXISTS foo (id int, name string)\")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n}","lang":"go","description":"Open a QL database and create a table."},"warnings":[{"fix":"Set FileFormat to 2 in options for larger records.","message":"File format V2 is available but not default; V1 has a ~64KB record size limit.","severity":"gotcha","affected_versions":"<1.5.0"}],"env_vars":null,"search_vec":"'acid':15 'databas':2,12,18 'embed':10,19 'engin':3,13 'go':9,22 'implement':6 'packag':4 'pure':8,21 'pure-go':20 'ql':1,5 'sql':11,17 'transact':16","created_at":"2026-06-15T07:10:51.945776+00:00","updated_at":"2026-06-15T07:10:51.945776+00:00","problems":[],"ecosystem":"go","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://gitlab.com/cznic/ql","github":null,"docs":"https://pkg.go.dev/modernc.org/ql#section-documentation","changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["database","utility"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-15","next_check":"2026-12-12","install_tag":null}}