# sqlite を Homebrew, apk, dnf, Nix, pacman, chocolatey, scoop, winget, zypper, apt, MacPorts でインストール sqlite のインストール経路、実行ファイル、メタデータ、AI エージェント向けセキュリティノートを確認します。 ## インストール ```sh sudo av install brew:sqlite ``` 追加のインストールコマンド: ### macOS - Homebrew (100%): ```sh brew install sqlite ``` 証拠: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install sqlite3 ``` 証拠: MacPorts ports tree: databases/sqlite3/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - apk (92%): ```sh sudo apk add sqlite ``` 証拠: Alpine Linux edge package indexes: sqlite from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz - dnf (92%): ```sh sudo dnf install sqlite ``` 証拠: Fedora Rawhide package metadata: sqlite from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst - Nix (92%): ```sh nix profile install nixpkgs#sqlite ``` 証拠: nixpkgs package indexes: sqlite from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix - pacman (92%): ```sh sudo pacman -S sqlite ``` 証拠: Arch Linux sync databases: sqlite from https://geo.mirror.pkgbuild.com/core/os/x86_64/core.db.tar.gz - zypper (92%): ```sh sudo zypper install sqlite3 ``` 証拠: openSUSE Tumbleweed package metadata: sqlite3 from https://download.opensuse.org/tumbleweed/repo/oss/repodata/50b07339cb64c8ed4091bdbabddadc1ff5737b090e478818a195b40d8a3292861a879139b4a3987c31109699fde9fbf4a716367ddf4eef77da75f96e3193d6ed-primary.xml.zst - Debian apt (92%): ```sh sudo apt install sqlite3 ``` 証拠: Debian stable package indexes: sqlite3 from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz ### Windows - Chocolatey (92%): ```sh choco install SQLite ``` 証拠: Chocolatey community package catalog: SQLite from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','sphinx' - Scoop (92%): ```sh scoop install main/sqlite ``` 証拠: Scoop official bucket manifest trees: bucket/sqlite.json from https://api.github.com/repos/ScoopInstaller/Main/git/trees/master?recursive=1 - winget (92%): ```sh winget install --id SQLite.SQLite -e ``` 証拠: Windows Package Manager source index: SQLite.SQLite from https://cdn.winget.microsoft.com/cache/source.msix ## パッケージ情報 - **パッケージキー:** brew:sqlite - **パッケージマネージャ:** Homebrew - **バージョン:** 3.53.4 - **ソース概要:** Command-line interface for SQLite - **ホームページ:** - **最終更新:** 2026-07-25T14:38:49Z - **生成日時:** 2026-08-03T19:37:03+00:00 ## 実行可能ファイル - sqlite3 (エイリアス) ## インストール挙動 - Bottle: 利用不可 ## バージョンと鮮度 - ページ生成日: 2026-08-03 - マネージャ版: 3.53.4 ## プロジェクトの歴史と使われ方 SQLite is an embedded, serverless SQL database engine and one of the most widely deployed software components in everyday computing. In package-manager culture, the `sqlite` package is both a runtime dependency and a tiny command-line database workbench. ### プロジェクトの歴史 The SQLite project states that it began on 2000-05-09. Its design centers on a self-contained, zero-configuration, transactional SQL database engine stored in ordinary disk files, with public-domain source code and long-term support goals. The SQLite command-line program, `sqlite3`, is the officially supported interactive interface to SQLite database files. The CLI is distinct from the SQLite library: it accepts user input and passes SQL to the library, while also providing dot-commands for import, export, schema inspection, archives, recovery, parameters, extensions, and scripting. ### 採用の歴史 SQLite's official site calls it the most used database engine in the world and says it is built into all mobile phones and most computers. The most-deployed page lists Android, iOS devices, Macs, Windows 10/11 installations, major browsers, Python, PHP, and many applications as places SQLite appears. The input shows SQLite packaged across Homebrew, Chocolatey, MacPorts, Nix, Scoop, winget, apk, pacman, and other distribution ecosystems. That breadth matches SQLite's role as a default local database layer and a basic CLI tool developers expect to be available. ### 使われ方 Developers use the `sqlite3` CLI to open database files, run SQL interactively, script SQL from shell pipelines, import and export CSV or TSV, inspect schemas, dump databases, recover data, load extensions, and experiment with SQL locally. SQLite is commonly used as an application file format, local cache, data-transfer container, embedded-device database, website database for modest traffic, and quick analysis database for CSV or JSON data. ### パッケージ好きにとっての重要性 Package nerds care about SQLite because it is the rare package that is simultaneously a library, a database engine, a file format, and a CLI. Installing `sqlite` gives immediate access to `sqlite3`, a portable database file format, and a common dependency shared by many higher-level tools. SQLite's public-domain status, single-file databases, cross-platform file format, and zero-admin deployment make it especially attractive in package ecosystems: it works as a dependency, debugging tool, fixture format, and data interchange tool without needing a service manager or credentials. ### タイムライン - 2000: SQLite project started on 2000-05-09. - 2021: SQLite 3.37.0 added CLI support for multiple open database connections. - 2025: SQLite documentation states an intent to support the project through 2050. - 2026: SQLite homepage lists 3.53.3 as the latest release on 2026-06-26. ### Related projects - sqlite3_analyzer and sqlite3_rsync are official SQLite companion utilities. - sqlite-utils and sqlite3-to-mysql are third-party tools that build workflows around SQLite files. - SQLite's own docs compare its problem space to local file I/O rather than to client/server database engines. ### ソース - - - - - ## セキュリティノート doc example: bounded database tool. - **Geiger リスク:** blue / 高 - doc example: bounded database tool ## 他のパッケージマネージャ記録 - Nix - sqlite: normalized package name match | nixpkgs package indexes: sqlite from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix - apk - sqlite - 3.53.4-r0: normalized package name match | Alpine Linux edge package indexes: sqlite from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine | https://www.sqlite.org/ - apk - sqlite-dev - 3.53.4-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (development files) | https://www.sqlite.org/ - apk - sqlite-doc - 3.53.4-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-doc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (documentation) | https://www.sqlite.org/ - apk - sqlite-libs - 3.53.4-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-libs from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (libraries) | https://www.sqlite.org/ - apk - sqlite-static - 3.53.4-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-static from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (static library) | https://www.sqlite.org/ - dnf - lemon - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: lemon from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | A parser generator | http://www.sqlite.org/ - dnf - sqlite - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Library that implements an embeddable SQL database engine | http://www.sqlite.org/ - dnf - sqlite-analyzer - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-analyzer from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | An analysis program for sqlite3 database files | http://www.sqlite.org/ - dnf - sqlite-debug - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-debug from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | SQLite shell configured for development and debugging purposes | http://www.sqlite.org/ - dnf - sqlite-devel - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-devel from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Development tools for the sqlite3 embeddable SQL database engine | http://www.sqlite.org/ - dnf - sqlite-doc - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-doc from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Documentation for sqlite | http://www.sqlite.org/ - dnf - sqlite-libs - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-libs from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Shared library for the sqlite3 embeddable SQL database engine. | http://www.sqlite.org/ - dnf - sqlite-tcl - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-tcl from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | Tcl module for the sqlite3 embeddable SQL database engine | http://www.sqlite.org/ - dnf - sqlite-tools - 3.53.4-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-tools from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | sqlite tools | http://www.sqlite.org/ - pacman - sqlite - 3.53.4-1: normalized package name match | Arch Linux sync databases: sqlite from https://geo.mirror.pkgbuild.com/core/os/x86_64/core.db.tar.gz | A C library that implements an SQL database engine | https://www.sqlite.org/ ## Combined YAML source View the package source record on GitHub. [combined/sqlite.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqlite.yml) ## ソース - pkg.so package database - Geiger risk classifier - curated package history - pkgdb category and tag curation - external package-manager database matches - cross-ecosystem install command graph