Dockerfile_of_SQLite3

What's Changed

• chore: bump-up base image version to Alpine Linux 3.20.3
• fix: issue #51 Create provenance attestations by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/52
• feat: github action - docker scout by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/53
• fix: attestation of provenance with mode max by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/55

Full Changelog: https://github.com/KEINOS/Dockerfile_of_SQLite3/compare/3.46.0-20240523...3.46.1-20240813

What's Changed

SQLite Release 3.46.0 On 2024-05-23

See https://www.sqlite.org/releaselog/3_46_0.html

1. Enhance PRAGMA optimize in multiple ways, to make it simpler to use:
   1. PRAGMA optimize automatically implements a temporary analysis limit to prevent excess runtime on large databases.
   2. Added the new 0x10000 bitmask option to check for updates on all tables.
   3. Automatically re-analyze tables that do not have sqlite_stat1 entries.
2. Enhancements to the date and time functions:
   1. The strftime() SQL function now supports %G, %g, %U, and %V.
   2. New modifiers 'ceiling' and 'floor' control the algorithm used to resolve ambiguous dates when shifting a date by an integer number of months and/or years.
   3. The 'utc' and 'localtime' modifiers are now no-ops if SQLite knows that the time is already in UTC or in the localtime, respectively.
3. Add support for underscore ("_") characters between digits in numeric literals.
4. Add the json_pretty() SQL function.
5. Query planner improvements:
   1. The "VALUES-as-coroutine" optimization enables INSERT statements with thousands of rows in the VALUES clause to parse and run in about half the time and using about half as much memory.
   2. Allow the use of an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records.
   3. Improved recognition of cases where the value of an SQL function is constant because all its arguments are constant.
   4. Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms containing uncorrelated subqueries.
6. Allocate additional memory from the heap for the SQL parser stack if that stack overflows, rather than reporting a "parser stack overflow" error.
7. JSON changes:
   1. Allow ASCII control characters within JSON5 string literals.
   2. Fix the -> and ->> operators so that when the right-hand side operand is a string that looks like an integer it is still treated as a string, because that is what PostgreSQL does.
8. Allow large hexadecimal literals to be used as the DEFAULT value to a table column.

Hashes:

• SQLITE_SOURCE_ID: 2024-05-23 13:25:27 96c92aba00c8375bc32fafcdf12429c58bd8aabfcadab6683e35bbb9cdebf19e
• SHA3-256 for sqlite3.c: 094429ea827fcd32275e767134bc6c7b9ea394a2c5a9e653dd0a0690b2c11358

Changes on this repo

• Changes by create-pull-request action by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/49

Full Changelog: https://github.com/KEINOS/Dockerfile_of_SQLite3/compare/3.45.3-20240415...3.46.0-20240523

What's Changed

• Changes by create-pull-request action by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/48

Full Changelog: https://github.com/KEINOS/Dockerfile_of_SQLite3/compare/3.45.2-20240312...3.45.3-20240415

What's Changed

• Switched container scan from Trivy and Dockle to Grype.
• Changes by create-pull-request action by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/45

Full Changelog: https://github.com/KEINOS/Dockerfile_of_SQLite3/compare/3.44.2-20231124...3.45.0-20240115

What's Changed

• Changes by create-pull-request action by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/40
• Changes by create-pull-request action by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/41

Full Changelog: https://github.com/KEINOS/Dockerfile_of_SQLite3/compare/3.41.2-20230519...3.43.1-20230911

What's Changed

Full Changelog: https://github.com/KEINOS/Dockerfile_of_SQLite3/compare/3.41.2-20230322...3.41.2-20230519

Feat: Weekly update in case the base OS was updated.

Fix #32 CVE-2022-3996

• SQLite 3.38.3 2022-04-27 12:03:15 9547e2c38a1c6f751a77d4d796894dec4dc5d8f5d79b1cd39e1ffc50df7b3be4

What's Changed

• fix : Vulnerability warnings by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/10
• docs: Add SECURITY.md as the security policy by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/11
• feat: Create snyk-container.yml by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/12
• feat: Automated build via GitHub actions by @KEINOS in https://github.com/KEINOS/Dockerfile_of_SQLite3/pull/13

Full Changelog: https://github.com/KEINOS/Dockerfile_of_SQLite3/compare/3.34.0-2020121723...3.38.2-20220326

• fix: #6 CIS-DI-0001 Last user should not be root so set to user "sqlite".
• fix: #7 CIS-DI-0005 Enable content trust for Docker while analyzing in GitHub Actions.
• fix: #8 CIS-DI-0006 Add HEALTHCHECK instruction to the container image
• chore: Add comment and some cleaning up
• docs: Add status badge and fix document

• fix: issue #3 "Add Tcl configuration definitions"