sqlite2 SQL database engine in a C library
2.8.17_4 databases =31

There is no maintainer for this port.
Any concerns regarding this port should be directed to the FreeBSD Ports mailing list via ports@FreeBSD.org
Port Added: 18 Dec 2004 22:05:40
License: not specified in port

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 (sqlite)
that can be used to administer an SQLite database and which serves as an
example of how to use the SQLite library.

WWW: http://www.sqlite.org/

SVNWeb : Homepage : PortsMon

Pseudo-pkg-plist information, but much better, from make generate-plist
Expand this list (15 items)

1. bin/sqlite
2. include/sqlite.h
3. lib/libsqlite.a
4. lib/libsqlite.so
5. lib/libsqlite.so.0
6. lib/libsqlite.so.0.8.6
7. @comment lib/sqlite/libtclsqlite.a
8. @comment lib/sqlite/libtclsqlite.so
9. @comment lib/sqlite/libtclsqlite.so.0
10. @comment lib/sqlite/libtclsqlite.so.0.8.6
11. @comment lib/sqlite/pkgIndex.tcl
12. libdata/pkgconfig/sqlite.pc
13. share/examples/sqlite2/example.tcl
14. @postexec /sbin/ldconfig -m /usr/local/lib
15. @postunexec /sbin/ldconfig -R
Collapse this list.

---

To install the port: cd /usr/ports/databases/sqlite2/ && make install clean
To add the package: pkg install sqlite

PKGNAME: sqlite

distinfo:

SHA256 (sqlite-2.8.17.tar.gz) = 3f35ebfb67867fb5b583a03e480f900206af637efe7179b32294a6a0cf806f37
SIZE (sqlite-2.8.17.tar.gz) = 969805

---

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:

1. gmake : devel/gmake
2. pkgconf>=1.3.0_1 : devel/pkgconf
3. tclsh8.6 : lang/tcl86

Library dependencies:

1. libreadline.so.7 : devel/readline

This port is required by:

for Libraries

1. databases/qt-sqlite-plugin^*
2. databases/qt4-sqlite-plugin
3. databases/qt5-sqldrivers-sqlite2
4. databases/ruby-dbd_sqlite^*
5. databases/sqlcached
6. databases/sqliteodbc-sqlite2
7. deskutils/gtkjournal^*
Expand this list (16 items)
8. devel/libleaftag
9. net/asterisk^*
10. net/asterisk10^*
11. net/asterisk11^*
12. net/asterisk13
13. net/asterisk14^*
14. net/asterisk15
15. net/asterisk16^*
16. sysutils/bacula2-server^*
Collapse this list.

* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

---

Configuration Options

===> The following configuration options are available for sqlite-2.8.17_4:
     DOCS=on: Build and/or install documentation
     EXAMPLES=on: Build and/or install examples
     TCL=off: Tcl scripting language support
     THREADS=off: Threading support
===> Use 'make config' to modify these settings

---

USES:

gmake libtool pathfix pkgconfig readline tcl:build

---

Master Sites:

1. http://www.sqlite.org/

- Switch to options helpers

Update devel/readline to 7.0 patch 3

- Bump PORTREVISION for shlib change

Changes:	https://cnswww.cns.cwru.edu/php/chet/readline/CHANGES
		https://lists.gnu.org/archive/html/bug-bash/2016-09/msg00107.html
		https://lists.gnu.org/archive/html/bug-readline/2017-01/msg00002.html
Differential Revision:	https://reviews.freebsd.org/D11172
PR:		219947
Exp-run by:	antoine

Make sure "all" is part of ALL_TARGET.

Follow-up to r429384: we were setting ALL_TARGET to just "doc". While the build
did not break, the code was actually being built during `make stage', which is
not what we expect.

Use ALL_TARGET instead of defining post-build to build documentation.

Use USES=pathfix where applicable.

PR:		213195
Submitted by:	mat
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D8093

- Strip binaries

Fix compiler warnings, i.e., "-lpthread: 'linker' input unused".

databases category: Remove $PTHREAD_LIBS

Note: virtuoso did not pass check-plist from before, so it was fixed.

approved by:	PTHREAD blanket

Cleanup plist

databases/sqlite2:
- Convert to USES=libtool and bump dependent ports

In some straightforward situations, protect examples behind PORTEXAMPLES,
adding EXAMPLES to OPTIONS_DEFINE where necessary. In a couple instances,
correct examples being controlled by the DOCS option.

Fix build without shared readline in base

Properly call MAKE_CMD

Finish stage support

- Stage support

Reduce over inclusion of bsd.port.mk

- Convert to USES+=tcl
- Fix package provide

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

Rely on bsdtar to autodetermine the format of the distfiles when possible

For a while now bsdtar is able to autotermine compression and archive format.
Let's then use tar directly instead of piping to tar.

Now USE_BZIP2 and USE_XZ only set EXTRACT_SUFX to the right format

Finish converting the whole ports tree to USES=pkgconfig

- Remove lang/tcl83 and x11-toolkits/tk83 (expired)
- Remove references to Tcl/Tk 8.3 from bsd.tcl.mk
- Update ports that required 8.3+ to require 8.4+ (since 8.5 is the
  default, I don't expect this change to cause much trouble)

Fix conversion to new options framework

new devel/pkgconf added to replace devel/pkg-config. new version of pkg-config
are no more self hosting so we are stuck with 0.25 version while pkgconf provide
the same set of features as 0.27 and a compatible frontend. A symlink to
pkg-config has been added for convenience and compatibility

This also introduces a new macro to use pkgconf in your ports:
USE_PKGCONFIG

it can take the following arguments:
 - yes (meaning build only dep)
 - build (meaning build only dep)
 - run (meaning run only dep)
 - both (meaning run and build dep)

From now USE_GNOME= pkgconfig is deprecated in favour of USE_PKGCONFIG
The old gnome macro has been modified to use pkgconf but still the sameway: run
and build dep to avoid large breakage.

While here fix some ports relying on pkg-config but not specifying it, fix some
ports broken because testing wrong .pc files, and fix ports using pkg-config
--version to determine pkg-config version instead of
pkg-config --modversion pkg-config like recommanded by pkg-config

With Hat:	portmgr
Exp-runs by:	bapt (pointhat-west), beat (pointyhat)

For the ports that are maintained by ports@ that have pkgconfig as their
only USE_GNOME feature, convert to a BUILD_DEPENDS. This avoids both the
bug of the bogus run depend introduced by bsd.gnome.mk, and also avoids
needlessly pulling that file in.

Convert to new options framework

- Reassign to the heap

- Get Rid MD5 support

Sync to new bsd.autotools.mk

-Repocopy devel/libtool15 -> libtool22 and libltdl15 -> libltdl22.
-Update libtool and libltdl to 2.2.6a.
-Remove devel/libtool15 and devel/libltdl15.
-Fix ports build with libtool22/libltdl22.
-Bump ports that depend on libltdl22 due to shared library version change.
-Explain what to do update in the UPDATING.

It has been tested with GNOME2, XFCE4, KDE3, KDE4 and other many wm/desktop
and applications in the runtime.

With help:      marcus and kwm
Pointyhat-exp:  a few times by pav
Tested by:      pgollucci, "Romain Tartière" <romain@blogreen.org>, and
                a few MarcusCom CVS users. Also, I might have missed a few.
Repocopy by:    marcus
Approved by:    portmgr

- Fix NOPORT* build

Reported by:    QAT

- Change hard coded TCL dependancy to USE_TCL

PR:             132381
Submitted by:   Scot W. Hetzel <swhetzel___gmail.com>

Update CONFIGURE_ARGS for how we pass CONFIGURE_TARGET to configure script.
Specifically, newer autoconf (> 2.13) has different semantic of the
configure target. In short, one should use --build=CONFIGURE_TARGET
instead of CONFIGURE_TARGET directly. Otherwise, you will get a warning
and the old semantic may be removed in later autoconf releases.

To workaround this issue, many ports hack the CONFIGURE_TARGET variable
so that it contains the ``--build='' prefix.

To solve this issue, under the fact that some ports still have
configure script generated by the old autoconf, we use runtime detection
in the do-configure target so that the proper argument can be used.

Changes to Mk/*:
 - Add runtime detection magic in bsd.port.mk

- Remove unneeded dependency from gtk12/gtk20 [1]
- Remove USE_XLIB/USE_X_PREFIX/USE_XPM in favor of USE_XORG
- Remove X11BASE support in favor of LOCALBASE or PREFIX
- Use USE_LDCONFIG instead of INSTALLS_SHLIB
- Remove unneeded USE_GCC 3.4+

Thanks to all Helpers:
        Dmitry Marakasov, Chess Griffin, beech@, dinoex, rafan, gahr,
        ehaupt, nox, itetcu, flz, pav

PR:             116263
Tested on:      pointyhat
Approved by:    portmgr (pav)

- Move from versioned tcl/tk CATEGORIES to simple tcl and tk categories

With hat:       portmgr

Fix up PORTREVISION breakage

Approved by:    portmgr (implicit)

Conversion to a single libtool environment.

Approved by:    portmgr (kris)

- Migrate all knobs to OPTIONS
- Add threads support [1] (mostly part)
- Reorganize Makefile
- Bump PORTREVISION

PR:             93101 [1]
Submitted by:   Henry Miller <hank@millerfarm.com> [1]

Update to 2.8.17
Use PORTDOCS
Reorganize Makefile

Notified by:    edwin Version Check

Mass-conversion to the USE_AUTOTOOLS New World Order.  The code present
in bsd.autotools.mk essentially makes this a no-op given that all the
old variables set a USE_AUTOTOOLS_COMPAT variable, which is parsed in
exactly the same way as USE_AUTOTOOLS itself.

Moreover, USE_AUTOTOOLS has already been extensively tested by the GNOME
team -- all GNOME 2.12.x ports use it.

Preliminary documentation can be found at:
        http://people.FreeBSD.org/~ade/autotools.txt

which is in the process of being SGMLized before introduction into the
Porters Handbook.

Light blue touch-paper.  Run.

Add SHA256

Fix build when use portinstall

PR:             87557
Submitted by:   Denis Shaposhnikov <dsh@vlink.ru>

Update my email

Approved by: pav (mentor)

- Pass maintainership to submitter

PR:             ports/86040
Submitted by:   Marcus Alves Grando <marcus@corp.grupos.com.br>

change the libtool version to use from 1.3 to 1.5

At Kris's request, back out the MACHINE_ARCH spelling correction until
after 5.4-RELEASE.

Assist getting more ports working on AMD64 by obeying the
Ports Collection documentation and use 'ARCH' rather than 'MACHINE_ARCH'.

Update to 2.8.16

PR:             ports/78510
Submitted by:   Marcus Grando

Reset maintainer on request. Thanks to Gerhard for maintaining the
ports so far!

PR:             ports/78088

Add dependency on devel/pkgconfig.

Pointy hat to:  pointyhat via kris

Clean up SQLite and related ports.
o Move databases/sqlite to databases/sqlite2.
o Fix dependency on databases/sqlite.
o Update sqlite2 to 2.8.15.
o Bump PORTREVISION, accordingly.

Approved by:    portmgr, maintainers of sqlite and related ports

Remove partial repo-copies that were requested and performed but never
completed by the original committer.  They can be re-added later if
anyone takes a renewed interest.

15 vulnerabilities affecting 134 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last updated:
2018-08-17 23:13:03