sqlite3 3.7.12.1 databases =129

An SQL database engine in a C library
Maintained by: pavelivolkov@googlemail.com
Port Added: 31 Aug 2004 19:11:46
License: public

---

---

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/

CVSWeb : Sources : Main Web Site : Distfiles Availability : PortsMon

---

NOTE: FreshPorts displays only required dependencies information. Optional dependencies are not covered.
Required To Build: devel/pkg-config
Required To Run: devel/pkg-config

Required by:
for Build

databases/php-sqlite3 devel/gearmand dns/opendnssec net/desktop-data-model

for Libraries

archivers/rpm5 astro/foxtrotgps astro/tangogps audio/gmpc audio/gmpc-magnatune audio/gogglesmm audio/osd-lyrics audio/xmms2 chinese/sunpinyin databases/evolution-data-server databases/fpc-sqlite databases/gosqlite3 databases/mysql-workbench52 databases/ocaml-sqlite3 databases/php5-pdo_sqlite databases/php5-sqlite3 databases/php53-pdo_sqlite databases/php53-sqlite3 databases/pure-sql3 databases/rubygem-do_sqlite3 databases/rubygem-sqlite3 databases/spatialite databases/sqliteman databases/tcl-sqlite3 deskutils/pinot devel/gearmand devel/monotone devel/nemiver devel/p5-subversion devel/py-subversion devel/ruby-subversion devel/subversion devel/subversion16 dns/opendnssec finance/skrooge games/crossfire-server games/gcompris games/kajongg games/latrine games/minetest games/mudmagic games/stonesoup games/stonesoup-sdl games/xmoto graphics/darktable graphics/f-spot graphics/libchamplain graphics/mapnik graphics/qgis graphics/shotwell irc/ircd-ratbox irc/ircd-ratbox-devel irc/ratbox-services java/subversion-java lang/munger mail/exim-sqlite misc/krecipes-kde4 multimedia/banshee multimedia/vdr-plugin-upnp multimedia/xbmc multimedia/xbmc-pvr net/asterisk net/asterisk10 net/asterisk16 net/boinc-client net/desktop-data-model net/kdenetwork4 net/liferea net/mediatomb net/minidlna net-im/pidgin net-p2p/ncdc net-p2p/tribler ports-mgmt/packagekit-qt4 security/nss security/softhsm www/fusionpbx www/luakit www/midori www/mnogosearch www/mod_auth_openid www/mongrel2 www/trafficserver www/webkit-gtk2

---

To install the port: cd /usr/ports/databases/sqlite3/ && make install clean
To add the package: pkg_add -r sqlite3

---

Configuration Options

===> The following configuration options are available for sqlite3-3.7.12.1:
     FTS3=on (default) "Enable FTS3/4 (Full Text Search) module"
     ICU=off (default) "Enable built with ICU"
     RTREE=off (default) "Enable R*Tree module ()"
     RAMTABLE=off (default) "Store temporary tables in RAM = "
     UPD_DEL_LIMIT=off (default) "ORDER BY and LIMIT on UPDATE and DELETE"
     URI=off (default) "Enable use the URI filename"
     SOUNDEX=off (default) "Enables the soundex() SQL function"
     METADATA=on (default) "Enable column metadata"
     STAT3=off (default) "Help SQLite to chose a better query plan"
     DIRECT_READ=off (default) "File is read directly from disk"
     MEMMAN=off (default) "Allows it to release unused memory"
     SECURE_DELETE=on (default) "Overwrite deleted information with zeros"
     UNLOCK_NOTIFY=on (default) "Enable notification on unlocking"
     THREADSAFE=on (default) "Build thread-safe library"
     EXTENSION=on (default) "Allow loadable extensions"
===> Use 'make config' to modify these settings

---

Master Sites:

http://www.sqlite.org/

http://www2.sqlite.org/

http://www3.sqlite.org/

ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/

• 2008-04-05

  Affects: users and maintainers of ports that depend on databases/sqlite3

  Author: mnag@FreeBSD.org

  Reason: 
    Port databases/sqlite3 was updated to 3.5.6 and now has threads enabled
    by default.  If you encounter any problem with it, you can rebuild SQLite3
    without threads and test or change Makefile of affected port with this:
  
  	sed -i.bak -E -e "s|USE_SQLITE=.*|USE_SQLITE=34|g" \
  	    -e "s|databases/sqlite3|databases/sqlite34|g" Makefile
  
    Please report success or failure to port maintainer and to me.
  
  

- Update to 3.7.12.1

PR:           ports/168329
Submitted by: Pavel I Volkov <pavelivolkov _at_ googlemail.com> (maintainer)
Approved by:  decke (mentor)

Mark sqlite as MAKE_JOBS_UNSAFE

PR:             ports/167934
Submitted by:   "Bryan Drewery" <bryan@shatow.net>
Approved by:    Pavel Volkov <pavelivolkov@googlemail.com> (maintainer)

- Update to 3.7.12
- switch to autoconf version (no more need of tcl)

PR:             ports/167913 [1], ports/155908 [2]
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer),
bapt[2]

- Update to 3.7.11

Changes:        http://www.sqlite.org/releaselog/3_7_11.html
PR:             ports/166782
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)
Feature safe:   yes

- update to 3.7.10

PR:             ports/164371
Approved by:    gabor (mentor, implicit)

Add patch that fixes blobs handling in interactive mode.

Looks like this issue is known by upstream since 2009,
but never was fixed in any release.

PR:             162650
Submitted by:   Valentin Davydov <cs at soi.spb.ru>
Approved by:    maintainer, novel (mentor, implicit)

- Remove WITH_FBSD10_FIX, is no longer needed

- Get rid FreeBSD 6.x support

- Update to 3.7.9

PR:             ports/162308
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)

- Fix build on FreeBSD 10

Approved by:    pavelivolkov AT googlemail.com (maintainer)

- Add LDFLAGS to CONFIGURE_ENV and MAKE_ENV (as it was done with LDFLAGS)
- Fix all ports that add {CPP,LD}FLAGS to *_ENV to modify flags instead

PR:             157936
Submitted by:   myself
Exp-runs by:    pav
Approved by:    pav

Update to 3.7.8

PR:             ports/160853
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)

- Update to 3.7.7.1

PR:             158550
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)

Update to 3.7.7

PR:             ports/158400
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)
Approved by:    bapt (mentor, implicit)

Relax the requirement for icudata's shared library number.

Submitted:      self
Approved by:    maintainer
PR: 157330

- Update to 3.7.6.3

PR:             ports/157272
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)

- Update to 3.7.6.2

Changes:        http://www.sqlite.org/changes.html
PR:             ports/156842
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)

- Update to 3.7.6.1

Changes:        http://www.sqlite.org/changes.html
PR:             ports/156420
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)

- Update to 3.7.5

PR:             154844
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com>
Approved by:    maintainer

Chase devel/icu upgrade
Add an updating note

- WITH_GCOV breaks nss

Submitted by:   nork, gabor
Approved by:    pavelivolkov@googlemail.com (maintainer)

- Update to 3.7.4

PR:             ports/152961
Submitted by:   Pavel I Volkov <pavelivolkov@googlemail.com> (maintainer)

Correct dependencies (from tcl modules)
Bump portrevision

PR: 152054
Submitted by: Pavel I Volkov (pavelivolkov@googlemail.com)

Update to 3.7.3
Update maintainer address

PR:             ports/151501
Submitted by:   Pavel I. Volkov (maintainer)

Fix build issue which is inclusion of already installed header.

Approved by:    Pavel I Volkov  pol at opk ru (maintainer)

- Remove options that do nothing
- Don't bump PORTREVISION as nothing really changed

PR:             150226
Submitted by:   Pavel I Volkov <pol@opk.ru> (maintainer)
Suggested by:   ale@

- Update to 3.7.2

PR:             149472, 150119
Submitted by:   Pavel I Volkov <pol@opk.ru> (maintainer)

- Turn "Allow loadable extensions" option default on, the port like
  databases/py-sqlite3 needs this to execute successfully.

PR:             ports/149842
Submitted by:   lwhsu
Approved by:    Pavel I Volkov <pol AT opk.ru> (maintainer)

- Recover missing dependency (devel/pkg-config)
- Bump PORTREVISION

PR:             ports/146876
Submitted by:   Sunpoet Po-Chuan Hsieh <sunpoet AT sunpoet.net>
Approved by:    Pavel I Volkov <pol AT opk.ru> (maintainer)

- Fix 'make package' when NO_INSTALL_MANPAGES is defined

PR:             ports/146083
Submitted by:   Sunpoet Po-Chuan Hsieh <sunpoet AT sunpoet.net>
Approved by:    Pavel I Volkov <pol AT opk.ru> (maintainer)

Over to new volunteer.

Approved by:    old maintainer

- Revert to TCL patch-Makefile

- Unbroken FTS3 and RTree usign TCL to build.
- Install manpages [1]
- Bump PORTREVISION

PR:             137296 [1]
Submitted by:   Pavel I Volkov <pol___opk.ru> [1]

Update to 3.6.32.1.
Remove TCL build dependency using a patch from OpenBSD.

PR:             ports/145213
Submitted by:   Bapt <baptiste.daroussin@gmail.com>
Approved by:    mnag@ (maintainer timeout)

- Added OPTION to enable extension library loading

PR:             ports/143329
Submitted by:   glarkin
Approved by:    maintainer timeout (mnag; 37 days)
Feature safe:   yes

Update sqlite3 to 3.6.19 release:
- fix thread-safe support (does it make sense to have an option to disable it?)
- add R*Tree index OPTION
- rework/simplify the port

PR:             ports/139276
Submitted by:   ale
Approved by:    maintainer

-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

- Update to 3.6.14.2

- Update to 3.6.13.
- Fix upgrade with tcl 8.4.

- Update to 3.6.11
- Change hard coded TCL dependancy to USE_TCL [1]

PR:             132382 [1]
Submitted by:   Scot W. Hetzel <swhetzel___gmail.com> [1]

- Update to 3.6.10

Requested by:   many

- Update to 3.6.4 [1]
- Add option to enable/disable column metadata [2]

PR:             125004 [2]
Submitted by:   Lapo Luchini <lapo___lapo.it> [2]
Requested by:   many [1]

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

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

With hat:       portmgr

- Finally, update to 3.5.6
- Enable THREADS by default

PS: See UPDATING if you have problems.

Requested by:   many

- Fix build with FTS2

PR:             115271
Pointy hat to:  mnag
Reported by:    many

- Update to 3.4.1
- Make sqlite3 respect CC [1]
- Add support for FTS2 [2]

PR:             112286 [1], 113477 [2]
Submitted by:   Sergey Prikhodko <sergey___network-asp.biz> [1],
                Anton Berezin <tobez___FreeBSD.org> [2]

- Update to 3.3.17

- Update to 3.3.16

PR:             111925
Submitted by:   Michael Scheidell <scheidell___secnap.net>

- Update to 3.3.15
- Install example.tcl only if WITH_TCLWRAPPER are set [1]

Submitted by:   bland [1]

- Update to 3.3.14

* databases/Makefile

- Add sqlite3-threads port

* databases/sqlite3

- Upgrade to 3.3.13 [1]

* databases/sqlite3-threads

- Create a slave port for threads-override-locks. [2]

PR:             110446 [1], 110104 [2]
Submitted by:   Michael Scheidell <scheidell___secnap.net> [1], thierry [2]

- Update to 3.3.12 [1]
- Fix FTS1 build [2]

Notified by:    Max Khitrov <mkhitrov___umd.edu> [1],
                Jeroen Ruigrok/asmodai <asmodai___in-nomine.org> [2]

- Add OPTION to build FTS1 (Full text search).

PR:             106281
Submitted by:   Barry Pederson<bp___barryp.org>

- Update to 3.3.8

- Update to 3.3.7
- portlint(1)

- Update to 3.3.6

- Update to 3.3.5
- Teach sqlite{,3}.pc to use ${PTHREAD_LIBS} when select PTHREAD OPTIONS.
- Building docs via ALL_TARGET instead of post-build

Conversion to a single libtool environment.

Approved by:    portmgr (kris)

- Update to 3.3.4
- Add THREADS, DEBUG and DOCS in OPTIONS
- Fix build when select WITH_TCLWRAPPER and NOPORTDOCS
- Reorganize Makefile

- Update to 3.3.3 [1]
- Reorganize Makefile

Submitted by:   cokane [1]

Update to 3.2.8
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

Update to 3.2.7 [1]
Take MAINTAINER

PR:             86288
Submitted by:   Robin Breathe <robin@isometry.net> [1]
Approved by:    pav (mentor), green (maintainer)

Update to version 3.2.5.
Unmark "beta" (from inside COMMENT).
Fix a NOPORTDOCS build issue.

Submitted by:   Marcus Grando <marcus@corp.grupos.com.br>
PR:     85420

- Update to 3.2.2

PR:             ports/82483
Submitted by:   Marcus Grando <marcus@corp.grupos.com.br>
Approved by:    maintainer timeout (24 days)

- Update to 3.2.1
- Use OPTIONS

PR:             ports/79024
Submitted by:   Marcus Grando <marcus@corp.grupos.com.br>
Approved by:    maintainer timeout (2 months)

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'.

Add dependency on devel/pkgconfig.

Pointy hat to:  pointyhat via kris

Fix pkg-plist.  This problem is heinousness, so I bump PORTREVISION.

Pointy hat to:  myself

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

databases/sqlite3 does not link with tcl8.3

        When trying to build databases/sqlite3 port with SQLITE_WITH_TCL83
        defined, the linking stage fails.  It looks like sqlite3
        uses a funciton which is only available in tcl8.4.

Removed TCL83 support for databases/sqlite3

PR:             ports/72918
Submitted by:   Anton Berezin <tobez@freebsd.org>

Update databases/sqlite3 to 3.0.8

        Update databases/sqlite3 to 3.0.8

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

Add SQLite 3 (in beta form).

12 vulnerabilities affecting 17 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities