summaryrefslogtreecommitdiff
path: root/databases/sqlite
AgeCommit message (Collapse)AuthorFilesLines
2003-06-25Update sqlite to 2.8.3. Major relevant changes:tsarna3-28/+6
2003 June 4 (2.8.3) - Fix a problem that will corrupt the indices on a table if you do an INSERT OR REPLACE or an UPDATE OR REPLACE on a table that contains an INTEGER PRIMARY KEY plus one or more indices. - Add the ability for INSERT and UPDATE statements to refer to the "rowid" (or "_rowid_" or "oid") columns. - Other important bug fixes 2003 May 17 (2.8.2) - Fix a problem that will corrupt the database file if you drop a table from the main database that has a TEMP index. 2003 May 16 (2.8.1) - Reactivated the VACUUM command that reclaims unused disk space in a database file. - Added the ATTACH and DETACH commands to allow interacting with multiple database files at the same time. - Added support for TEMP triggers and indices. - Added support for in-memory databases. - Removed the experimental sqlite_open_aux_file(). Its function is subsumed in the new ATTACH command. - The precedence order for ON CONFLICT clauses was changed so that ON CONFLICT clauses on BEGIN statements have a higher precedence than ON CONFLICT clauses on constraints. - Many, many bug fixes and compatibility enhancements.
2003-03-29Place WRKSRC where it belongs, to make pkglint happy; ok'ed by wiz.jmmv1-3/+2
2003-02-17Add http://www.sqlite.org/ as download site.taca1-2/+3
2003-02-17Update sqlite to version 2.8.0.agc3-7/+7
An update to 2.7.5 was provided in PR 19719 by Jarkko Torppa. Main changes are support for endian-neutral databases, and a huge number of bug fixes.
2002-10-25Prefer BUILDLINK_PREFIX.* to BUILDLINK_DIR.wiz1-2/+2
2002-10-12buildlink1 -> buildlink2.wiz1-3/+3
2002-10-12Unused.wiz1-34/+0
2002-08-25Merge changes in packages from the buildlink2 branch that havejlam1-0/+19
buildlink2.mk files back into the main trunk.
2002-01-31Major upgrade of Sqlite from version 2.1.7 to version 2.2.5reinoud2-5/+5
Lots of bug fixes in SQL parsing and supports more weildy SQL code like using the right of an AS in athe column list of a SELECT as part of an expression in the WHERE, ORDER BY, GROUP BY and/of HAVING clauses. For a full report see the changelog on http://www.hwaci.com/sw/sqlite/changes.html
2002-01-03Revert previous changes so that they can be done in the approriate way.agc2-5/+5
2002-01-03*** empty log message ***reinoud2-5/+5
2001-12-30Don't use c99 uint*_t types, since they're not defined on 1.5.2 andagc1-3/+3
previous releases. Instead, fall back on the trusty u_int*_t types from <sys/types.h> Fixes a problem uncovered on a recent 1.5.2 bulk build.
2001-12-15Small typo fixes to make `pkglint' happier....reinoud2-3/+2
2001-12-15Updated SQLite package to version 2.1.7 fixingreinoud2-5/+5
1) locking problems due to a few race conditions 2) fixing a bug in `create temporary table' wich could contaminate the main database file opened too 3) bug fix in b-tree subsystem that could sometimes cause the first row of a table to be repeated during a database scan.
2001-12-05Update sqlite package to version 2.1.4 (2001-12-04) incorporating lockupreinoud7-183/+8
bugs removal, fixing the behaviour of comparison operators so that they are consistent with the order of entries in an index, correct handling of integers in SQL expressions that are larger than what can be represented by the machine integer and locking protocol fixes. The author also incorporated my suggestions after the messy LP64 patches I made; its now a lot more clean allthough there are still a few warnings but they are checked and OK.
2001-11-19SQLite is now on version 2.1.1 incorporating many changes, enhancementsreinoud1-0/+1
and bugfixes including support for 16Mb rows. For a full change see the website's changelog at http://www.hwaci.com/sw/sqlite/changes.html The file format changed! so please dump the database in SQL with .dump in the old version and import it later in the new version.
2001-11-19Just noted that some important bugfixes were made to version 2.1.0 to makereinoud2-5/+5
version 2.1.1
2001-11-19Update SQLite package to version 2.1.0 from 2.0.5reinoud4-64/+14
2001-11-01Move pkg/ files into package's toplevel directoryzuntum2-1/+1
2001-10-20Hmm... shouldn't have forgotten to ad the patches themselves.... (AHUM)reinoud6-0/+222
2001-10-20Patch to make sqlite work on LP64 machines. I tried to make the patch asreinoud2-4/+10
less invasive as posible without rewriting stuff. The main problems were the assumption that a pointer and an int had the same size. Also there were strange casts near calculations that were not nessisary.
2001-10-16Add buildlink.mk file for use by other package Makefiles.jlam1-0/+34
2001-10-16databases/sqlite: SQL Database Engine In A C Libraryjlam5-0/+71
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.