Up to [cvs.NetBSD.org] / pkgsrc / databases / ruby-sqlite3
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
databases/ruby-sqlite3: update to 2.4.0 2.3.0 (2024-11-20) Added * The SQLITE_DBPAGE extension is now enabled by default, which implements an eponymous-only virtual table that provides direct access to the underlying database file by interacting with the pager. See https://www.sqlite.org/dbpage.html for more information. [#578] @flavorjones * The DBSTAT extension is now enabled by default, which implements a read-only eponymous virtual table that returns information about the amount of disk space used to store the content of an SQLite database. See https://sqlite.org/dbstat.html for more information. [#580] @pawurb @flavorjones * Database#optimize which wraps the pragma optimize; statement. Also added Constants::Optimize to allow advanced users to pass a bitmask of options. See https://www.sqlite.org/pragma.html#pragma_optimize. [#572] @alexcwatt @flavorjones * SQLite3::VERSION_INFO contains a bag of metadata about the gem and the sqlite library used. SQLite3::SQLITE_PACKAGED_LIBRARIES and SQLite3::SQLITE_PRECOMPILED_LIBRARIES indicate how the gem was built. [#581] @flavorjones Fixed * Database#encoding= support for switching the database encoding to UTF-16BE, which has been broken since Database#encoding= was introduced in v1.3.12 in 2016. [#575] @miyucy * Omit mention of the pkg-config gem when failing to build from source, since it is not used. [#358] @flavorjones 2.3.1 (2024-11-25) Dependencies * Vendored sqlite is updated to v3.47.1 [#589] @flavorjones 2.4.0 (2024-12-03) Added * Database#load_extension now accepts any object that responds to #to_path, in addition to String filesystem paths. [#586] @flavorjones * Database.new now accepts an extensions: parameter, which is an array of SQLite extensions that will be loaded during initialization. The array may contain String filesystem paths and objects that respond to #to_path. [#586] @flavorjones
databases/ruby-sqlite3: update to 2.1.0
2.1.0 (2024-09-24)
Ruby
* This release drops support for Ruby 3.0. [#563] @flavorjones
Fork safety improvements
Sqlite itself is not fork-safe. Specifically, writing in a child process to
a database connection that was created in the parent process may corrupt the
database file. To mitigate this risk, sqlite3-ruby has implemented the
following changes:
* All open writable database connections carried across a fork() will
immediately be closed in the child process to mitigate the risk of
corrupting the database file.
* These connections will be incompletely closed ("discarded") which will
result in a one-time memory leak in the child process.
If it's at all possible, we strongly recommend that you close writable
database connections in the parent before forking. If absolutely necessary
(and you know what you're doing), you may suppress the fork safety warnings
by calling SQLite3::ForkSafety.suppress_warnings!.
See the README's "Fork Safety" section and adr/2024-09-fork-safety.md for
more information. [#558, #565, #566] @flavorjones
Improved
* Use sqlite3_close_v2 to close databases in a deferred manner if there are
unclosed prepared statements. Previously closing a database while
statements were open resulted in a BusyException. See
https://www.sqlite.org/c3ref/close.html for more context. [#557]
@flavorjones
* When setting a Database busy_handler, fire the write barrier to prevent
potential crashes during the GC mark phase. [#556] @jhawthorn
Documentation
* The FAQ.md has been updated to fix some inaccuracies. [#562] @rickhull
databases/ruby-sqlite3: update to 2.0.2 2.0.2 (2024-05-23) Dependencies * Vendored sqlite is updated to v3.46.0 @flavorjones
databases/ruby-sqlite3: update to 1.6.5 pkgsrc change: surely remove sqlite3 archive file. 1.6.5 (2023-09-08) Packaging * Allow setting compiler flags for the sqlite library via a --with-sqlite-cflags argument to extconf.rb. See INSTALLATION.md for more information. [#401, #402] (@flavorjones)
databases/ruby-sqlite3: update to 1.6.4 1.6.4 (2023-08-26) Dependencies * Vendored sqlite is updated to v3.43.0.
databases/ruby-sqlite3: update to 1.6.3 1.6.3 (2023-05-16) Dependencies * Vendored sqlite is updated to [v3.42.0](https://sqlite.org/releaselog/3_42_0.html). From the release announcement: > This is a regular enhancement release. The main new features are: > * SQLite will now parse and understand JSON5, though it is careful to > generate only pure, canonical JSON. > * The secure-delete option has been added to the FTS5 extension.
databases/ruby-sqlite3: update to 1.6.2 1.6.2 (2023-03-27) Dependencies * Vendored sqlite is updated from v3.41.0 to v3.41.2. Packaging * Allow compilation against system libraries without the presence of mini_portile2, primarily for the convenience of linux distro repackagers. [#381] (Thank you, @voxik!)
databases/ruby-sqlite3: update to 1.6.1 1.6.1 (2023-02-22) Dependencies * Vendored sqlite is updated to v3.41.0.
databases/ruby-sqlite3: update to 1.6.0 1.6.0 (2023-01-13) Ruby This release introduces native gem support for Ruby 3.2. This release ends native gem support for Ruby 2.6, for which upstream support ended 2022-04-12. Dependencies * Vendored sqlite3 is updated to v3.40.1.
databases/ruby-sqlite3: update to 1.5.4 1.5.4 (2022-11-18) Dependencies * Vendored sqlite is updated to v3.40.0.
databases/ruby-sqlite3: update to 1.5.2 1.5.2 (2022-10-01) Packaging This version correctly vendors the tarball for sqlite v3.39.4 in the vanilla "ruby" platform gem package, so that users will not require network access at installation. v1.5.0 and v1.5.1 mistakenly packaged the tarball for sqlite v3.38.5 in the vanilla "ruby" platform gem, resulting in downloading the intended tarball over the network at installation time (or, if the network was not available, failure to install). Note that the precompiled native gems were not affected by this issue. [#352] 1.5.1 (2022-09-29) Dependencies * Vendored sqlite is updated to v3.39.4. Security The vendored version of sqlite, v3.39.4, should be considered to be a security release. From the release notes: Version 3.39.4 is a minimal patch against the prior release that addresses issues found since the prior release. In particular, a potential vulnerability in the FTS3 extension has been fixed, so this should be considered a security update. In order to exploit the vulnerability, an attacker must have full SQL access and must be able to construct a corrupt database with over 2GB of FTS3 content. The problem arises from a 32-bit signed integer overflow. For more information please see GHSA-mgvv-5mxp-xq67.
databases/ruby-sqlite3: update to 1.5.0 Here is quote from release note. 1.5.0 (2022-09-08) Added * SQLite3::SQLITE_LOADED_VERSION contains the version string of the sqlite3 library that is dynamically loaded (compare to SQLite3::SQLITE_VERSION which is the version at compile-time). Fixed * SQLite3::Database#load_extensions now raises a TypeError unless a String is passed as the file path. Previously it was possible to pass a non-string and cause a segfault. [#339]
databases/ruby-sqlite3: update to 1.4.4 1.4.4 (2022-06-14) Fixes * Compilation no longer fails against SQLite3 versions < 3.29.0. This issue was introduced in v1.4.3. [#324] (Thank you, @r6e!) 1.4.3 (2022-05-25) Enhancements * Disable non-standard support for double-quoted string literals via the :strict option. [#317] (Thank you, @casperisfine!) * Column type names are now explicitly downcased on platforms where they may have been in shoutcaps. [#315] (Thank you, @petergoldstein!) * Support File or Pathname arguments to Database.new. [#283] (Thank you, @yb66!) * Support building on MSVC. [#285] (Thank you, @jmarrec!)
databases/ruby-sqlite3: update to 1.4.0 === 1.4.0 * Enhancements * Better aggregator support * Bugfixes * Various
Update ruby-sqlite3 to 1.3.11. === 1.3.11 / 2015-10-10 * Enhancements: * Windows: build against SQLite 3.8.11.1 * Internal: * Use rake-compiler-dock to build Windows binaries. Pull #159 [larskanis] * Expand Ruby versions being tested for Travis and AppVeyor
Add ${GEM_EXTSDIR}/gem.build_complete for new rubygems and updated ruby.
Update ruby-sqlite3 to 1.3.9. pkgsrc change: add GEM_EXTSDIR support. === 1.3.9 / 2014-02-25 * Bugfixes: * Reset exception message. Closes #80 * Reduce warnings due unused pointers. Closes #89 * Add BSD-3 license reference to gemspec. Refs #99 and #106
Update ruby-sqlite3 package to 1.3.6.
=== 1.3.6 / 2012-04-16
* Enhancements
* Windows: build against SQLite 3.7.11
* Added SQLite3::ResultSet#each_hash for fetching each row as a hash.
* Added SQLite3::ResultSet#next_hash for fetching one row as a hash.
* Bugfixes
* Support both UTF-16LE and UTF-16BE encoding modes on PPC. Closes #63
* Protect parameters to custom functions from being garbage collected too
soon. Fixes #60. Thanks hirataya!
* Fix backwards compatibility with 1.2.5 with bind vars and `query` method.
Fixes #35.
* Fix double definition error caused by defining sqlite3_int64/uint64.
* Fix suspicious version regexp.
* Deprecations
* ArrayWithTypesAndFields#types is deprecated and the class will be removed
in version 2.0.0. Please use the `types` method on the ResultSet class
that created this object.
* ArrayWithTypesAndFields#fields is deprecated and the class will be removed
in version 2.0.0. Please use the `columns` method on the ResultSet class
that created this object.
* The ArrayWithTypesAndFields class will be removed in 2.0.0
* The ArrayWithTypes class will be removed in 2.0.0
* HashWithTypesAndFields#types is deprecated and the class will be removed
in version 2.0.0. Please use the `types` method on the ResultSet class
that created this object.
* HashWithTypesAndFields#fields is deprecated and the class will be removed
in version 2.0.0. Please use the `columns` method on the ResultSet class
that created this object.
Update databases/ruby-sqlite3 package to 1.3.5.
=== 1.3.5 / 2011-12-03 - ZOMG Holidays are here Edition!
* Enhancements
* Windows: build against SQLite 3.7.9
* Static: enable SQLITE_ENABLE_COLUMN_METADATA
* Added Statement#clear_bindings! to set bindings back to nil
* Bugfixes
* Fixed a segv on Database.new. Fixes #34 (thanks nobu!)
* Database error is not reset, so don't check it in Statement#reset!
* Remove conditional around Bignum statement bindings.
Fixes #52. Fixes #56. Thank you Evgeny Myasishchev.
* Internal
* Use proper endianness when testing database connection with UTF-16.
Fixes #40. Fixes #51
* Use -fPIC for static compilation when host is x86_64.
=== 1.3.4 / 2011-07-25
* Enhancements:
* Windows: build against SQLite 3.7.7.1
* Windows: build static binaries that do not depend on sqlite3.dll be
installed anymore
* Bugfixes
* Backup API is conditionaly required so that older libsqlite3 can be used.
Thanks Hongli Lai.
* Fixed segmentation fault when nil is passed to SQLite3::Statement.new
* Fix extconf's hardcoded path that affected installation on certain systems.
Update ruby-sqlite3 package to 1.3.2.
=== 1.3.2 / 2010-10-30 / RubyConf Uruguay Edition!
* Enhancements:
* Windows: build against 3.7.3 version of SQLite3
* SQLite3::Database can now be open as readonly
db = SQLite3::Database.new('my.db', :readonly => true)
* Added SQLite3::SQLITE_VERSION and SQLite3::SQLITE_VERSION_NUMBER [nurse]
* Bugfixes
* type_translation= works along with Database#execute and a block
* defined functions are kept in a hash to prevent GC. #7
* Removed GCC specific flags from extconf.
* DEPRECATIONS
* SQLite3::Database#type_translation= will be deprecated in the future with
no replacement.
* SQlite3::Version will be deprecated in 2.0.0 with SQLite3::VERSION as the
replacement.
Update ruby-sqlite3 to 1.3.1. === 1.3.1 / 2010-07-09 * Enhancements * Custom collations may be defined using SQLite3::Database#collation * Bugfixes * Statements returning 0 columns are automatically stepped. [RF #28308] * SQLite3::Database#encoding works on 1.8 and 1.9
Update ruby-sqlite3 to 1.3.0.
Changes:
### 1.3.0 / 2010-06-06
* Enhancements
* Complete rewrite of C-based adapter from SWIG to hand-crafted one
[tenderlove]
See API_CHANGES document for details.
This closes: Bug #27300, Bug #27241, Patch #16020
* Improved UTF, Unicode, M17N, all that handling and proper BLOB
handling [tenderlove, nurse]
* Added support for type translations [tenderlove]
@db.translator.add_translator('sometime') do |type, thing|
'output' # this will be returned as value for that column
end
* Experimental
* Added API to access and load extensions. [kashif]
These functions maps directly into SQLite3 own enable_load_extension()
and load_extension() C-API functions. See SQLite3::Database API
documentation for details.
This closes: Patches #9178
* Bugfixes
* Corrected gem dependencies (runtime and development)
* Fixed threaded tests [Alexey Borzenkov]
* Removed GitHub gemspec
* Fixed "No definition for" warnings from RDoc
* Generate zip and tgz files for releases
* Added Luis Lavena as gem Author (maintainer)
* Prevent mkmf interfere with Mighty Snow Leopard
* Allow extension compilation search for common lib paths [kashif]
(lookup /usr/local, /opt/local and /usr)
* Corrected extension compilation under MSVC [romuloceccon]
* Define load_extension functionality based on availability [tenderlove]
* Deprecation notices for Database#query. Fixes RF #28192
Update ruby-sqlite3 package to 1.2.5. * Add LICENSE. === 1.2.5 / 25 Jul 2009 * Check for illegal nil before executing SQL [Erik Veenstra] * Switch to Hoe for gem task management and packaging. * Advertise rake-compiler as development dependency. * Build gem binaries for Windows. * Improved Ruby 1.9 support compatibility. * Taint returned values. Patch #20325. === 1.2.4.1 (internal) / 5 Jul 2009 * Check for illegal nil before executing SQL [Erik Veenstra] * Switch to Hoe for gem task management and packaging. * Advertise rake-compiler as development dependency. * Build gem binaries for Windows. * Improved Ruby 1.9 support compatibility.
Remove @dirrm entries from PLISTs
Update ruby-sqlite3 package to 1.2.4. Release Name: 1.2.4 Notes: This release only updates the generated C file to reflect the compatibility changes that were made to the SWIG file. Binary builds (e.g., Windows) are not affected, and need no update. In general, you will not need this update unless you are using a version of Ruby prior to 1.8.6. Release Name: 1.2.3 Notes: Mostly, this release just fixes the permissions issue on *nix platforms on the database.rb and translator.rb files. It also has a few optimizations and compatibility fixes. Changes: === 1.2.3 / 26 Aug 2008 * Fix incorrect permissions on database.rb and translator.rb [Various] * Avoid using Object#extend for greater speedups [Erik Veenstra] * Ruby 1.9 compatibility tweaks for Array#zip [jimmy88@gmail.com] * Fix linking against Ruby 1.8.5 [Rob Holland <rob@inversepath.com>]
Update ruby-sqlite3 package to 1.2.2. Changes: === 1.2.2 / 31 May 2008 * Make the table_info method adjust the returned default value for the rows so that the sqlite3 change in 3.3.8 and greater can be handled transparently [Jamis Buck <jamis@37signals.com>] * Ruby 1.9 compatibility tweaks [Roman Le Negrate <roman2k@free.fr>] * Various performance enhancements [thanks Erik Veenstra] * Correct busy_handler documentation [Rob Holland <rob@inversepath.com>] * Use int_bind64 on Fixnum values larger than a 32bit C int can take. [Rob Holland <rob@inversepath.com>] * Work around a quirk in SQLite's error reporting by calling sqlite3_reset to produce a more informative error code upon a failure from sqlite3_step. [Rob Holland <rob@inversepath.com>] * Various documentation, test, and style tweaks [Rob Holland <rob@inversepath.com>] * Be more granular with time/data translation [Rob Holland <rob@inversepath.com>] * Use Date directly for parsing rather than going via Time [Rob Holland <rob@inversepath.com>] * Check for the rt library and fdatasync so we link against that when needed [Rob Holland <rob@inversepath.com>] * Rename data structures to avoid collision on win32. based on patch by: Luis Lavena [Rob Holland <rob@inversepath.com>] * Add test for defaults [Daniel Rodr?guez Troiti?o] * Correctly unquote double-quoted pragma defaults [?ukasz Dargiewicz <lukasz.dargiewicz@gmail.com>]
Install as a gem using the pkgsrc rubygem.mk framework instead of directly into site_ruby.
Update ruby-sqlite3 to 1.2.1. Release Name: 1.2.1 Notes: Only a single change in this release: sqlite3 3.3.8 and higher have changed the format of the 'dflt_value' column for the table_info pragma. This caused breakage in apps that depend on that pragma, like Ruby on Rails. This release makes the Database#table_info helper check the libversion, and adjust the dflt_value column accordingly. If you want the new format and not the old, you can invoke the table_info pragma directly, instead of using the helper. Release Name: 1.2.0 Notes: * Fixed bug that caused crashes when type translation was asked to translate the type of a typeless column (like count(*), etc.) * Added pre-built sqlite3_api_wrap.c to remove the dependency on SWIG. * db.transaction should now catch all exceptions (bug #3981) * Removed lots of warnings when running in -w mode * Fixed problems with callbacks (thanks Sylvan Joyeux!) * Named bind parameters may now be specified as symbols, or as strings. You can also leave off the leading colon when specifying them as a string. * DL (pure-ruby) driver is now deprecated. * Bignum values may be bound in a prepared statement. * Get a more detailed error message when the connection cannot be established. * Reset the statement when binding new variables to a prepared statement.
Merge (almost replace) this package with ruby-sqlite3 in pkgsrc-wip packgaed by OBATA Akio, because the latter is more complete. Bump PKGREVISION.
Import ruby-sqlite3. This module allows Ruby programs to interface with the SQLite database engine.
Initial revision