summaryrefslogtreecommitdiff
path: root/databases/sqlite3
AgeCommit message (Collapse)AuthorFilesLines
2007-03-07update to 3.3.13drochner2-6/+6
changes: -bugfixes -enhanced PRAGMA integrity_check
2007-01-11update to 3.3.10drochner4-7/+49
changes: -fixed bugs which can lead to database corruption under obscure and difficult to reproduce circumstances -new sqlite3_prepare_v2() API -bug fixes in the command-line shell -enhancements to the query optimizer pkgsrc change: fix a selftest which couldn't work as intended due to misuse of O_APPEND
2006-11-18Update to 3.3.8:wiz3-6/+20
Version 3.3.8 adds support for full-text search using the FTS1 module. There are also minor bug fixes. Upgrade only if you want to try out the new full-text search capabilities or if you are having problems with 3.3.7. Version 3.3.7 includes support for loadable extensions and virtual tables. But both features are still considered "beta" and their APIs are subject to change in a future release. This release is mostly to make available the minor bug fixes that have accumulated since 3.3.6. Upgrading is not necessary. Do so only if you encounter one of the obscure bugs that have been fixed or if you want to try out the new features. 2006-Jun-6 - Version 3.3.6 Changes include improved tolerance for windows virus scanners and faster :memory: databases. There are also fixes for several obscure bugs. Upgrade if you are having problems. 2006-Apr-5 - Version 3.3.5 This release fixes many minor bugs and documentation typos and provides some minor new features and performance enhancements. Upgrade only if you are having problems or need one of the new features.
2006-08-29Fixed path to the install manual page.rillig1-2/+2
2006-07-08Change the format of BUILDLINK_ORDER to contain depth information as well,jlam1-2/+2
and add a new helper target and script, "show-buildlink3", that outputs a listing of the buildlink3.mk files included as well as the depth at which they are included. For example, "make show-buildlink3" in fonts/Xft2 displays: zlib fontconfig iconv zlib freetype2 expat freetype2 Xrender renderproto
2006-07-08Track information in a new variable BUILDLINK_ORDER that informs usjlam1-1/+2
of the order in which buildlink3.mk files are (recursively) included by a package Makefile.
2006-04-12Aligned the last line of the buildlink3.mk files with the first line, sorillig1-2/+2
that they look nicer.
2006-04-06Over 1200 files touched but no revisions bumped :)reed1-3/+3
RECOMMENDED is removed. It becomes ABI_DEPENDS. BUILDLINK_RECOMMENDED.foo becomes BUILDLINK_ABI_DEPENDS.foo. BUILDLINK_DEPENDS.foo becomes BUILDLINK_API_DEPENDS.foo. BUILDLINK_DEPENDS does not change. IGNORE_RECOMMENDED (which defaulted to "no") becomes USE_ABI_DEPENDS which defaults to "yes". Added to obsolete.mk checking for IGNORE_RECOMMENDED. I did not manually go through and fix any aesthetic tab/spacing issues. I have tested the above patch on DragonFly building and packaging subversion and pkglint and their many dependencies. I have also tested USE_ABI_DEPENDS=no on my NetBSD workstation (where I have used IGNORE_RECOMMENDED for a long time). I have been an active user of IGNORE_RECOMMENDED since it was available. As suggested, I removed the documentation sentences suggesting bumping for "security" issues. As discussed on tech-pkg. I will commit to revbump, pkglint, pkg_install, createbuildlink separately. Note that if you use wip, it will fail! I will commit to pkgsrc-wip later (within day).
2006-03-04Point MAINTAINER to pkgsrc-users@NetBSD.org in the case where nojlam1-2/+2
developer is officially maintaining the package. The rationale for changing this from "tech-pkg" to "pkgsrc-users" is that it implies that any user can try to maintain the package (by submitting patches to the mailing list). Since the folks most likely to care about the package are the folks that want to use it or are already using it, this would leverage the energy of users who aren't developers.
2006-02-15update to 3.3.4drochner3-9/+7
changes: adds support for CHECK constraints, DESC indices, separate REAL and INTEGER column affinities, a new OS interface layer design, and many other changes pkgsrc note: a selftest fails on NetBSD/i386: a loss of precision is not detected in the sum() function. Reason is that the code assumes that a "long double" keeps more significant bits than a "long long int" which is not true here. This is not a regression to 3.2.x which did just wrap on int overflows.
2006-02-05Recursive revision bump / recommended bump for gettext ABI change.joerg2-2/+5
2005-09-30Update to 3.2.7:wiz2-6/+6
2005 September 24 (3.2.7) * GROUP BY now considers NULLs to be equal again, as it should * Now compiles on Solaris and OpenBSD and other Unix variants that lack the fdatasync() function * Now compiles on MSVC++6 again * Fix uninitialized variables causing malfunctions for various obscure queries * Correctly compute a LEFT OUTER JOINs that is constrained on the left table only 2005 September 17 (3.2.6) * Fix a bug that can cause database corruption if a VACUUM (or autovacuum) fails and is rolled back on a database that is larger than 1GiB * LIKE optiization now works for columns with COLLATE NOCASE * ORDER BY and GROUP BY now use bounded memory * Added support for COUNT(DISTINCT expr) * Change the way SUM() handles NULL values in order to comply with the SQL standard * Use fdatasync() instead of fsync() where possible in order to speed up commits slightly * Use of the CROSS keyword in a join turns off the table reordering optimization * Added the experimental and undocumented EXPLAIN QUERY PLAN capability * Use the unicode API in windows 2005 August 27 (3.2.5) * Fix a bug effecting DELETE and UPDATE statements that changed more than 40960 rows. * Change the makefile so that it no longer requires GNUmake extensions * Fix the --enable-threadsafe option on the configure script * Fix a code generator bug that occurs when the left-hand side of an IN operator is constant and the right-hand side is a SELECT statement * The PRAGMA synchronous=off statement now disables syncing of the master journal file in addition to the normal rollback journals 2005 August 24 (3.2.4) * Fix a bug introduced in the previous release that can cause a segfault while generating code for complex WHERE clauses. * Allow floating point literals to begin or end with a decimal point. 2005 August 21 (3.2.3) * Added support for the CAST operator * Tcl interface allows BLOB values to be transferred to user-defined functions * Added the "transaction" method to the Tcl interface * Allow the DEFAULT value of a column to call functions that have constant operands * Added the ANALYZE command for gathering statistics on indices and using those statistics when picking an index in the optimizer * Remove the limit (formerly 100) on the number of terms in the WHERE clause * The right-hand side of the IN operator can now be a list of expressions instead of just a list of constants * Rework the optimizer so that it is able to make better use of indices * The order of tables in a join is adjusted automatically to make better use of indices * The IN operator is now a candidate for optimization even if the left-hand side is not the left-most term of the index. Multiple IN operators can be used with the same index. * WHERE clause expressions using BETWEEN and OR are now candidates for optimization * Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKE compile-time option to set its default value to "on". * Use indices to help with GLOB expressions and LIKE expressions too when the case_sensitive_like pragma is enabled * Added support for grave-accent quoting for compatibility with MySQL * Improved test coverage
2005-07-06update to 3.2.2drochner2-6/+6
from the announcement: This release includes numerous minor bug fixes, speed improvements, and code size reductions. There is no reason to upgrade unless you are having problems or unless you just want to.
2005-05-22Remove USE_GNU_TOOLS and replace with the correct USE_TOOLS definitions:jlam1-2/+2
USE_GNU_TOOLS -> USE_TOOLS awk -> gawk m4 -> gm4 make -> gmake sed -> gsed yacc -> bison
2005-04-14Update to 3.2.1xtraeme3-9/+7
2005 March 29 (3.2.1) * Fix a memory allocation error in the new ADD COLUMN comment. * Documentation updates 2005 March 21 (3.2.0) * Added support for ALTER TABLE ADD COLUMN. * Added support for the "T" separator in ISO-8601 date/time strings. * Improved support for Cygwin. * Numerous bug fixes and documentation updates. 2005 March 16 (3.1.6) * Fix a bug that could cause database corruption when inserting record into tables with around 125 columns. * sqlite3_step() is now much more likely to invoke the busy handler and less likely to return SQLITE_BUSY. * Fix memory leaks that used to occur after a malloc() failure. 2005 March 11 (3.1.5) * The ioctl on OS-X to control syncing to disk is F_FULLFSYNC, not F_FULLSYNC. The previous release had it wrong. 2005 March 10 (3.1.4) * Fix a bug in autovacuum that could cause database corruption if a CREATE UNIQUE INDEX fails because of a constraint violation. This problem only occurs if the new autovacuum feature introduced in version 3.1 is turned on. * The F_FULLSYNC ioctl (currently only supported on OS-X) is disabled if the synchronous pragma is set to something other than "full". * Add additional forward compatibility to the future version 3.2 database file format. * Fix a bug in WHERE clauses of the form (rowid<'2') * New SQLITE_OMIT_... compile-time options added * Updates to the man page * Remove the use of strcasecmp() from the shell * Windows DLL exports symbols Tclsqlite_Init and Sqlite_Init
2005-04-11Remove USE_BUILDLINK3 and NO_BUILDLINK; these are no longer used.tv1-2/+1
2005-03-23Remove the 'tcl' option and split the Makefile in two parts to aid in thejmmv4-37/+26
addition of the new sqlite3-tcl package. The TCL bindings can be easily built and installed independently, so it's better to have an standalone package rather than a build-time option. While here, fix PKGCONFIG_OVERRIDE and bump PKGREVISION to 2.
2005-03-07Added an option to build the package with tcl supportadam3-13/+32
2005-02-24Update to 3.1.3:wiz2-9/+8
2005 February 19 (3.1.3) * Fix a problem with VACUUM on databases from which tables containing AUTOINCREMENT have been dropped. * Add forward compatibility to the future version 3.2 database file format. * Documentation updates 2005 February 15 (3.1.2) * Fix a bug that can lead to database corruption if there are two open connections to the same database and one connection does a VACUUM and the second makes some change to the database. * Allow "?" parameters in the LIMIT clause. * Fix VACUUM so that it works with AUTOINCREMENT. * Fix a race condition in AUTOVACUUM that can lead to corrupt databases * Add a numeric version number to the sqlite3.h include file. * Other minor bug fixes and performance enhancements. 2005 February 1 (3.1.1 BETA) * Automatic caching of prepared statements in the TCL interface * ATTACH and DETACH as well as some other operations cause existing prepared statements to expire. * Numerious minor bug fixes 2005 January 21 (3.1.0 ALPHA) * Autovacuum support added * CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP added * Support for the EXISTS clause added. * Support for correlated subqueries added. * Added the ESCAPE clause on the LIKE operator. * Support for ALTER TABLE ... RENAME TABLE ... added * AUTOINCREMENT keyword supported on INTEGER PRIMARY KEY * Many SQLITE_OMIT_ macros inserts to omit features at compile-time and reduce the library footprint. * The REINDEX command was added. * The engine no longer consults the main table if it can get all the information it needs from an index. * Many nuisance bugs fixed.
2005-02-23Add RMD160 digests in addition to SHA1 ones.agc1-1/+2
2005-01-16Import sqlite3-3.0.8, the next major release of sqlite. Resides in paralleltv5-0/+65
with sqlite version 2 (everything in this package ends in `3'). DESCR: SQLite is a C library that implements an SQL database engine. Programs that link with 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. SQLite is not a client library used to connect to a big database server. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk.
generated by cgit v1.2.3 (git 2.46.0) at 2026-01-27 09:17:02 +0000