BSD Portsdatabases/sqlite3 3.50.4_3,1 MidnightBSD
SQL database engine in a C library
- System
- MidnightBSD
- Repository
- mports
- Maintainer
- [email protected]
- Last update
- Commit
2f48ba41c2- License
- publicdom
- Categories
- databases
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.
In the other systems
| System | Port | Version |
|---|---|---|
| MidnightBSD | databases/sqlite3 | 3.50.4_3,1 |
| FreeBSD | databases/sqlite3 | 3.53.4,1 |
| OpenBSD | databases/sqlite3 | 3.53.2 |
| NetBSD | databases/sqlite3 | 3.53.4 |
| DragonFly | databases/sqlite3 | 3.46.1_1,1 |
Install
Binary package:
mport install sqlite3From mports:
cd /usr/mports/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/sqlite3Dependencies
Configuration
Options name: databases_sqlite3
| Option | Default | Description |
|---|---|---|
| EXAMPLES | off | |
| GEOPOLY | off | Uses the GeoJSON notation (RFC-7946) |
| ICU | off | |
| LIBEDIT | on | |
| OFFSET | off | Enable sqlite_offset() returning records file offset |
| READLINE | off | |
| 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 |
| STRIP | on | |
| TCL | off | Enable tcl extension and sqlite_analyzer |
| THREADS | on | |
| 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
- libtool ncurses zip cpe
- Service scripts
- none
- Conflicts with
- sqlite3 sqlite3-icu sqlite3-tcl tcl-sqlite3
Files
Manual pages 2
- sqlite3(1)
- sqlite3.(n)
pkg-plist 17
- 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
- share/man/mann/sqlite3..n.gz
- lib/%%TCLVER%%/sqlite3/libtclsqlite3.so
- lib/%%TCLVER%%/sqlite3/pkgIndex.tcl
- share/examples/sqlite3/example.tcl
- share/examples/sqlite3/sqlitecon.tcl
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| sqlite-src-3500400.zip | 1.4393367e+07 | b7b4dc060f36053902fb65b344bbbed592e64b2291a26ac06fe77eec097850e9 |
Master sites 3
- https://www.sqlite.org/${_YEAR}/
- https://www2.sqlite.org/${_YEAR}/
- https://www3.sqlite.org/${_YEAR}/