databases/sqlite3 3.53.4,1
SQL database engine in a C library
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
78c83a9c4b- License
- PD
- Categories
- databases
- Package size
- 1254.0 KiB, 4542.6 KiB installed
Description
SQLite is an SQL database engine in a C library. Programs that link the SQLite library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite3) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.
Install
As a binary package — by origin, or by package name:
pkg install databases/sqlite3
pkg install sqlite3From the ports tree:
cd /usr/ports/databases/sqlite3/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= sqlite3>0:databases/sqlite3
LIB_DEPENDS= libsqlite3.so:databases/sqlite3Packages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 3.53.4,1 | 3.53.4,1 | 3.40.1,1 | 3.50.2_1,1 | 3.53.4,1 |
| FreeBSD:14:quarterly | 3.53.4,1 | 3.53.4,1 | n/a | 3.50.2_1,1 | 3.53.4,1 |
| FreeBSD:15:latest | 3.53.4,1 | 3.53.4,1 | n/a | 3.50.2_1,1 | 3.50.2_1,1 |
| FreeBSD:15:quarterly | 3.53.4,1 | 3.53.4,1 | n/a | n/a | n/a |
| FreeBSD:16:latest | 3.53.4,1 | 3.53.4,1 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
The Makefile names none itself; they come from USES and USE_*.
The full lists below include those, and their dependencies in turn.
All build dependencies 2
All run dependencies 1
Required by 4508
- accessibility/accerciser
- accessibility/caribou
- accessibility/gammastep
- accessibility/kdeaccessibility
- accessibility/kmag
- accessibility/kmousetool
- accessibility/kmouth
- accessibility/libqaccessibilityclient
- accessibility/onboard
- accessibility/orca
- accessibility/qt6-speech
- accessibility/redshift
- arabic/arabtex
- arabic/libreoffice
- archivers/ark
- archivers/arqiver
- archivers/deco
- archivers/engrampa
- archivers/file-roller
- archivers/gnome-autoar
- archivers/kf6-karchive
- archivers/libarchive-qt
- archivers/lxqt-archiver
- archivers/quazip
- archivers/rpm4
- archivers/thunar-archive-plugin
- archivers/urbackup-client
- archivers/urbackup-server
- archivers/xarchiver
- astro/foxtrotgps
- astro/geographiclib
- astro/gpsbabel
- astro/gpscorrelate
- astro/gpsd
- astro/indiwebmanagerapp
- astro/kosmindoormap
- astro/kosmorro
- astro/kstars
- astro/libosmium
- astro/marble
- astro/merkaartor
- astro/opencpn
- astro/oskar
- astro/phd2
- astro/pp3
- astro/py-alerce
- astro/py-horoscopegenerator
- astro/py-indiweb
- astro/py-kosmorrolib
- astro/py-metpy
- astro/py-pykep
- astro/py-pytest-astropy
- astro/py-skyfield
- astro/py-skyfield-data
- astro/py-sunpy
- astro/pykep
- astro/qmapshack
- astro/siril
- astro/stellarium
- astro/stellarsolver
- astro/viking
- audio/abx
- audio/amarok
- audio/amberol
- audio/ardour
- audio/ario
- audio/asterisk-espeak
- audio/asterisk-flite
- audio/audacity
- audio/audiocd-kio
- audio/baresip
- audio/beets
- audio/bespokesynth
- audio/boca
- audio/cadence
- audio/cantata
- audio/cardinal
- audio/carla
- audio/cliamp
- audio/d11amp
- audio/deadbeef-playback-status-plugin
- audio/deadbeef-waveform-seekbar-plugin
- audio/dmidiplayer
- audio/drumkv1-lv2
- audio/drumstick
- audio/dsbmixer
- audio/easytag
- audio/elisa
- audio/emms
- audio/entropypianotuner
- audio/exaile
- audio/faustlive
- audio/fooyin
- audio/freac
- audio/g4music
- audio/giada
- audio/gigedit
- audio/gmtp
- audio/gnome-metronome
- audio/gnome-music
The first 100 are listed.
Configuration
Options name: databases_sqlite
| Option | Default | Description |
|---|---|---|
| EXAMPLES | off | Build and/or install examples |
| GEOPOLY | off | Uses the GeoJSON notation (RFC-7946) |
| ICU | off | Unicode support via ICU |
| LIBEDIT | on | Command line editing via libedit |
| OFFSET | off | Enable sqlite_offset() returning records file offset |
| READLINE | off | Command line editing via libreadline |
| RTREE | on | Enable R*Tree module |
| RTREE_INT | off | Store 32-bit sig int (no float) coordinates |
| SESSION | on | Enable the session extension |
| SOUNDEX | off | Enable the soundex() SQL function |
| STAT3 | off | Collect histogram data from leftmost column |
| STAT4 | off | Collect histogram data from all columns |
| TCL | off | Enable tcl extension and sqlite_analyzer |
| THREADS | on | Threading support |
| TS0 | off | Always use temporary file |
| TS1 | on | File by default, change allowed PRAGMA |
| TS2 | off | Memory by default, change allowed PRAGMA |
| TS3 | off | Always use memory |
| UNICODE61 | on | Unicode Version 6.1 tokenizer |
- USES
- cpe libtool ncurses zip
- Service scripts
- none
- Conflicts with
- sqlite3 sqlite3-icu sqlite3-tcl tcl-sqlite3
- Flavors
sqlite-icu-3.53.4,1,sqlite-tcl-3.53.4,1
Files
Manual pages 1
- sqlite3(1)
pkg-plist 16
- bin/sqlite3
- bin/sqldiff
- bin/sqlite3_analyzer
- include/sqlite_cfg.h
- include/sqlite3.h
- include/sqlite3ext.h
- lib/libsqlite3.a
- lib/libsqlite3.so
- lib/libsqlite3.so.0
- lib/libsqlite3.so.
- libdata/pkgconfig/sqlite3.pc
- share/man/man1/sqlite3.1.gz
- lib/%%TCLVER%%/sqlite%%PORTVERSION%%/libsqlite%%PORTVERSION%%.so
- lib/%%TCLVER%%/sqlite%%PORTVERSION%%/pkgIndex.tcl
- share/examples/sqlite3/example.tcl
- share/examples/sqlite3/sqlitecon.tcl
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| sqlite-src-3530400.zip | 1.4557315e+07 | d18fa15aec74d8c17e1463f861095adc01b5ad190256acb4f91d22f0368d232b |
Master sites 3
- https://sqlite.org/2026/
- https://www2.sqlite.org/2026/
- https://www3.sqlite.org/2026/