CVS log for pkgsrc/databases/sqlite3/options.mk
Up to [cvs.NetBSD.org] / pkgsrc / databases / sqlite3
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Revision 1.10: download - view: text, markup, annotated - select for diffs
Sun Mar 30 06:18:06 2025 UTC (19 months, 2 weeks ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2026Q3-base,
pkgsrc-2026Q3,
pkgsrc-2026Q2-base,
pkgsrc-2026Q2,
pkgsrc-2026Q1-base,
pkgsrc-2026Q1,
pkgsrc-2025Q4-base,
pkgsrc-2025Q4,
pkgsrc-2025Q3-base,
pkgsrc-2025Q3,
pkgsrc-2025Q2-base,
pkgsrc-2025Q2,
HEAD
Diff to: previous 1.9: preferred, colored
Changes since revision 1.9: +3 -3
lines
sqlite3: updated to 3.49.1
Prior changes from version 3.49.0 (2025-02-06):
Enhancements to the query planner:
Improve the query-time index optimization so that it works on WITHOUT ROWID tables.
Better query plans for large star-query joins. This fixes three different performance regressions that were reported on the SQLite Forum.
When two or more queries have the same estimated cost, use the one with the fewer bytes per row.
Enhance the iif() SQL function so that it can accept any number of arguments greater than or equal to two.
Enhance the session extension so that it works on databases that make use of generated columns.
Omit the SQLITE_USE_STDIO_FOR_CONSOLE compile-time option which was not implemented correctly and never worked right. In its place add the SQLITE_USE_W32_FOR_CONSOLE_IO compile-time option. This option applies to command-line tools like the CLI only, not to the SQLite core. It causes Win32 APIs to be used for console I/O instead of stdio. This option affects Windows builds only.
Three new options to sqlite3_db_config(). All default to "on".
SQLITE_DBCONFIG_ENABLE_ATTACH_CREATE
SQLITE_DBCONFIG_ENABLE_ATTACH_WRITE
SQLITE_DBCONFIG_ENABLE_COMMENTS
Replace Autotools with Autosetup for the configure script used in the precompiled amalgamation tarball. The configure script for the canonical source code was changed to Autosetup in the previous (3.48.0) release. Only the main SQLite configure script in the amalgamation tarball is changed. The (deprecated) configuration script use by TEA subdirectory of the amalgamation tarball still relies on Autotools.
Various minor patches and fixes for problems seen in the 3.48.0 release.
Changes in this specific patch release, version 3.49.1 (2025-02-18):
Improve portability of makefiles and configure scripts.
Fix a bug in the concat_ws() function, introduced in version 3.44.0, that could lead to a memory error if the separator string is very large (hundreds of megabytes).
Enhanced the SQLITE_DBCONFIG_LOOKASIDE interface to make it more robust against misuse.
Revision 1.9: download - view: text, markup, annotated - select for diffs
Thu Dec 26 22:04:28 2024 UTC (22 months, 2 weeks ago) by riastradh
Branches: MAIN
CVS tags: pkgsrc-2025Q1-base,
pkgsrc-2025Q1
Diff to: previous 1.8: preferred, colored
Changes since revision 1.8: +3 -16
lines
databases/sqlite3: Spruce up build options.
1. Document reasoning for each of the build-time options available and
set a rubric for which ones to enable in future updates.
2. Enable some options that look well-justified. I went through all
the options at https://www.sqlite.org/compile.html, applied the
rubric, and compared to several other general-purpose packaging
systems.
(Happy to discuss and amend the rubric and the choice of options --
this should be viewed as a starting point for review, testing, and
tweaking, not an inviolably final decision.)
3. Nix PKG_OPTIONS that are default-on upstream -- these haven't done
anything in a while. If you want to add these back, then:
(a) they should be in PKG_SUGGESTED_OPTIONS (because they're
already enabled by default upstream), and
(b) you'll have to set and test the appropriate SQLITE_OMIT_*
option.
Options removed:
- deserialize (default-on upstream anyway)
- fts (default-on upstream anyway)
- sqlite3-dbstat (unconditionally enabled in pkgsrc now because
needed by downstream packages)
Options remaining:
- icu
4. Nix some deprecated options like SQLITE_ENABLE_LOAD_EXTENSION.
Additions to CONFIGURE_ARGS:
--enable-fts3 (paranoia, default-on upstream anyway)
--enable-fts4 (paranoia, default-on upstream anyway)
--enable-fts5 (paranoia, default-on upstream anyway)
--enable-math (paranoia, default-on upstream anyway)
--enable-rtree (paranoia, default-on upstream anyway)
--enable-session
Removals from CONFIGURE_ARGS: none
Additions to CFLAGS:
-DSQLITE_ENABLE_DBSTAT_VTAB
-DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_ENABLE_HIDDEN_COLUMNS
-DSQLITE_ENABLE_STMTVTAB
Removals from CFLAGS:
-DSQLITE_ENABLE_LOAD_EXTENISON (default-on upstream now; need
SQLITE_OMIT_LOAD_EXTENSION to reverse)
-DSQLITE_ENABLE_MATH_FUNCTIONS (replaced by --enable-math for better
build-time error checking)
PR pkg/58448: databases/sqlite3 is missing dbstat option
Revision 1.8: download - view: text, markup, annotated - select for diffs
Fri Jul 19 17:11:54 2024 UTC (2 years, 3 months ago) by riastradh
Branches: MAIN
CVS tags: pkgsrc-2024Q4-base,
pkgsrc-2024Q4,
pkgsrc-2024Q3-base,
pkgsrc-2024Q3
Diff to: previous 1.7: preferred, colored
Changes since revision 1.7: +6 -2
lines
databases/sqlite3: New sqlite3-dbstat option.
Enables the DBSTAT virtual table:
https://sqlite.org/dbstat.html
No revbump because option is default-off for now.
PR pkg/58448
Revision 1.7: download - view: text, markup, annotated - select for diffs
Mon Feb 20 07:28:31 2023 UTC (3 years, 8 months ago) by wiz
Branches: MAIN
CVS tags: pkgsrc-2024Q2-base,
pkgsrc-2024Q2,
pkgsrc-2024Q1-base,
pkgsrc-2024Q1,
pkgsrc-2023Q4-base,
pkgsrc-2023Q4,
pkgsrc-2023Q3-base,
pkgsrc-2023Q3,
pkgsrc-2023Q2-base,
pkgsrc-2023Q2,
pkgsrc-2023Q1-base,
pkgsrc-2023Q1
Diff to: previous 1.6: preferred, colored
Changes since revision 1.6: +2 -6
lines
sqlite3: remove rtree option, this has been turned-on by default for some time
Revision 1.6: download - view: text, markup, annotated - select for diffs
Mon Mar 23 19:37:54 2020 UTC (6 years, 7 months ago) by rmind
Branches: MAIN
CVS tags: pkgsrc-2022Q4-base,
pkgsrc-2022Q4,
pkgsrc-2022Q3-base,
pkgsrc-2022Q3,
pkgsrc-2022Q2-base,
pkgsrc-2022Q2,
pkgsrc-2022Q1-base,
pkgsrc-2022Q1,
pkgsrc-2021Q4-base,
pkgsrc-2021Q4,
pkgsrc-2021Q3-base,
pkgsrc-2021Q3,
pkgsrc-2021Q2-base,
pkgsrc-2021Q2,
pkgsrc-2021Q1-base,
pkgsrc-2021Q1,
pkgsrc-2020Q4-base,
pkgsrc-2020Q4,
pkgsrc-2020Q3-base,
pkgsrc-2020Q3,
pkgsrc-2020Q2-base,
pkgsrc-2020Q2,
pkgsrc-2020Q1-base,
pkgsrc-2020Q1
Diff to: previous 1.5: preferred, colored
Changes since revision 1.5: +6 -2
lines
sqlite3: add 'deserialize' option.
Revision 1.5: download - view: text, markup, annotated - select for diffs
Fri Dec 14 19:36:37 2012 UTC (13 years, 11 months ago) by drochner
Branches: MAIN
CVS tags: pkgsrc-2019Q4-base,
pkgsrc-2019Q4,
pkgsrc-2019Q3-base,
pkgsrc-2019Q3,
pkgsrc-2019Q2-base,
pkgsrc-2019Q2,
pkgsrc-2019Q1-base,
pkgsrc-2019Q1,
pkgsrc-2018Q4-base,
pkgsrc-2018Q4,
pkgsrc-2018Q3-base,
pkgsrc-2018Q3,
pkgsrc-2018Q2-base,
pkgsrc-2018Q2,
pkgsrc-2018Q1-base,
pkgsrc-2018Q1,
pkgsrc-2017Q4-base,
pkgsrc-2017Q4,
pkgsrc-2017Q3-base,
pkgsrc-2017Q3,
pkgsrc-2017Q2-base,
pkgsrc-2017Q2,
pkgsrc-2017Q1-base,
pkgsrc-2017Q1,
pkgsrc-2016Q4-base,
pkgsrc-2016Q4,
pkgsrc-2016Q3-base,
pkgsrc-2016Q3,
pkgsrc-2016Q2-base,
pkgsrc-2016Q2,
pkgsrc-2016Q1-base,
pkgsrc-2016Q1,
pkgsrc-2015Q4-base,
pkgsrc-2015Q4,
pkgsrc-2015Q3-base,
pkgsrc-2015Q3,
pkgsrc-2015Q2-base,
pkgsrc-2015Q2,
pkgsrc-2015Q1-base,
pkgsrc-2015Q1,
pkgsrc-2014Q4-base,
pkgsrc-2014Q4,
pkgsrc-2014Q3-base,
pkgsrc-2014Q3,
pkgsrc-2014Q2-base,
pkgsrc-2014Q2,
pkgsrc-2014Q1-base,
pkgsrc-2014Q1,
pkgsrc-2013Q4-base,
pkgsrc-2013Q4,
pkgsrc-2013Q3-base,
pkgsrc-2013Q3,
pkgsrc-2013Q2-base,
pkgsrc-2013Q2,
pkgsrc-2013Q1-base,
pkgsrc-2013Q1,
pkgsrc-2012Q4-base,
pkgsrc-2012Q4
Diff to: previous 1.4: preferred, colored
Changes since revision 1.4: +3 -2
lines
build with the same options as the NetBSD builtin version,
bump PKGREV
Revision 1.4: download - view: text, markup, annotated - select for diffs
Tue May 17 11:23:53 2011 UTC (15 years, 6 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2012Q3-base,
pkgsrc-2012Q3,
pkgsrc-2012Q2-base,
pkgsrc-2012Q2,
pkgsrc-2012Q1-base,
pkgsrc-2012Q1,
pkgsrc-2011Q4-base,
pkgsrc-2011Q4,
pkgsrc-2011Q3-base,
pkgsrc-2011Q3,
pkgsrc-2011Q2-base,
pkgsrc-2011Q2
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +12 -6
lines
Added icu option
Revision 1.3: download - view: text, markup, annotated - select for diffs
Fri Dec 17 00:37:34 2010 UTC (15 years, 11 months ago) by agc
Branches: MAIN
CVS tags: pkgsrc-2011Q1-base,
pkgsrc-2011Q1,
pkgsrc-2010Q4-base,
pkgsrc-2010Q4
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +9 -11
lines
Add two new options for sqlite3, rtree (for multi-dimensional search optimization),
and fts (full-text searching). Both options are off by default.
Revision 1.2
Wed Mar 23 22:08:06 2005 UTC (21 years, 7 months ago) by jmmv
Branches: MAIN
CVS tags: pkgsrc-2009Q4-base,
pkgsrc-2009Q4,
pkgsrc-2008Q4-base,
pkgsrc-2008Q4,
pkgsrc-2008Q3-base,
pkgsrc-2008Q3,
pkgsrc-2008Q2-base,
pkgsrc-2008Q2,
pkgsrc-2008Q1-base,
pkgsrc-2008Q1,
pkgsrc-2007Q4-base,
pkgsrc-2007Q4,
pkgsrc-2007Q3-base,
pkgsrc-2007Q3,
pkgsrc-2007Q2-base,
pkgsrc-2007Q2,
pkgsrc-2007Q1-base,
pkgsrc-2007Q1,
pkgsrc-2006Q4-base,
pkgsrc-2006Q4,
pkgsrc-2006Q3-base,
pkgsrc-2006Q3,
pkgsrc-2006Q2-base,
pkgsrc-2006Q2,
pkgsrc-2006Q1-base,
pkgsrc-2006Q1,
pkgsrc-2005Q4-base,
pkgsrc-2005Q4,
pkgsrc-2005Q3-base,
pkgsrc-2005Q3,
pkgsrc-2005Q2-base,
pkgsrc-2005Q2,
cube-native-xorg-base,
cube-native-xorg
FILE REMOVED
Changes since revision 1.1: +1 -1
lines
Remove the 'tcl' option and split the Makefile in two parts to aid in the
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.
Revision 1.1: download - view: text, markup, annotated - select for diffs
Mon Mar 7 14:59:06 2005 UTC (21 years, 8 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2005Q1-base,
pkgsrc-2005Q1
Added an option to build the package with tcl support
CVSweb <webmaster@jp.NetBSD.org>