mike-works / sql-fundamentals

Mike North's SQL Fundamentals and Professional SQL Courses
https://frontendmasters.com/courses/sql-fundamentals/
BSD 3-Clause "New" or "Revised" License
169 stars 108 forks source link

fix(deps): update dependency sqlite3 to v5 #316

Open renovate[bot] opened 4 years ago

renovate[bot] commented 4 years ago

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
sqlite3 4.2.0 -> 5.1.7 age adoption passing confidence

Release Notes

TryGhost/node-sqlite3 (sqlite3) ### [`v5.1.7`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.7) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.1.6...v5.1.7) #### What's Changed - Updated bundled SQLite to v3.44.2 by [@​daniellockyer](https://togithub.com/daniellockyer) - Replaced `@mapbox/node-pre-gyp` with `prebuild` + `prebuild-install` (https://github.com/TryGhost/node-sqlite3/commit/605c7f981abbcf980cb44f54abba285de9a69a23) by [@​daniellockyer](https://togithub.com/daniellockyer) - this should fix a lot of bundling issues reported by the community - Improved `RowToJS` performance by removing `Napi::String::New` instantiation by [@​daniellockyer](https://togithub.com/daniellockyer) - Various minor code refactors and improvements (thanks [@​zenon8adams](https://togithub.com/zenon8adams)!) #### New Contributors - [@​zenon8adams](https://togithub.com/zenon8adams) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1701](https://togithub.com/TryGhost/node-sqlite3/pull/1701) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.1.6...v5.1.7 ### [`v5.1.6`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.6) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.1.5...v5.1.6) #### What's Changed - Fixed glibc compatibility by hardcoding lower version for `log2` by [@​daniellockyer](https://togithub.com/daniellockyer) - Add generic type annotations for Statement and Database get/all/each methods callback rows by [@​stevescruz](https://togithub.com/stevescruz) in [https://github.com/TryGhost/node-sqlite3/pull/1686](https://togithub.com/TryGhost/node-sqlite3/pull/1686) #### New Contributors - [@​stevescruz](https://togithub.com/stevescruz) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1686](https://togithub.com/TryGhost/node-sqlite3/pull/1686) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.1.5...v5.1.6 ### [`v5.1.5`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.5) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.1.4...v5.1.5) #### What's Changed - 🔒 Fixed code execution vulnerability due to Object coercion by [@​daniellockyer](https://togithub.com/daniellockyer) - Updated bundled SQLite to v3.41.1 by [@​daniellockyer](https://togithub.com/daniellockyer) - Fixed rpath linker option when using a custom sqlite by [@​jeromew](https://togithub.com/jeromew) in [https://github.com/TryGhost/node-sqlite3/pull/1654](https://togithub.com/TryGhost/node-sqlite3/pull/1654) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.1.4...v5.1.5 ### [`v5.1.4`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.4) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.1.3...v5.1.4) #### What's Changed - Fixed glibc compatibility by downgrading CI to Ubuntu 20 by [@​daniellockyer](https://togithub.com/daniellockyer) in [https://github.com/TryGhost/node-sqlite3/pull/1664](https://togithub.com/TryGhost/node-sqlite3/pull/1664) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.1.3...v5.1.4 ### [`v5.1.3`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.3) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.1.2...v5.1.3) #### What's Changed - Updated bundled SQLite to v3.40.0 by [@​daniellockyer](https://togithub.com/daniellockyer) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.1.2...v5.1.3 ### [`v5.1.2`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.2) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.1.1...v5.1.2) #### What's Changed - Updated bundled SQLite to v3.39.4 by [@​daniellockyer](https://togithub.com/daniellockyer) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.1.1...v5.1.2 ### [`v5.1.1`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.1) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.1.0...v5.1.1) #### What's Changed - Added Darwin ARM64 binaries by [@​daniellockyer](https://togithub.com/daniellockyer) in [https://github.com/TryGhost/node-sqlite3/pull/1594](https://togithub.com/TryGhost/node-sqlite3/pull/1594) A huge thanks to [MacStadium](https://www.macstadium.com/) for providing an M1 Mac Mini so we can offer ARM64 binaries. **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.1.0...v5.1.1 ### [`v5.1.0`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.1.0) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.11...v5.1.0) ✨ We're very excited to announce node-sqlite3's first minor release of v5, packed with features and improvements. If you encounter any problems, please open a detailed issue using the [templates](https://togithub.com/TryGhost/node-sqlite3/issues/new/choose). #### What's Changed - Updated bundled SQLite to v3.39.3 by [@​daniellockyer](https://togithub.com/daniellockyer) - Added ability to receive updates from `sqlite3_update_hook` by [@​soukand](https://togithub.com/soukand) in [https://github.com/TryGhost/node-sqlite3/pull/1267](https://togithub.com/TryGhost/node-sqlite3/pull/1267) - Added support for setting SQLite limits by [@​paulfitz](https://togithub.com/paulfitz) in [https://github.com/TryGhost/node-sqlite3/pull/1548](https://togithub.com/TryGhost/node-sqlite3/pull/1548) - Added library types file by [@​bpasero](https://togithub.com/bpasero) in [https://github.com/TryGhost/node-sqlite3/pull/1527](https://togithub.com/TryGhost/node-sqlite3/pull/1527) - Added `package-lock.json` to `.gitignore` by [@​JoelEinbinder](https://togithub.com/JoelEinbinder) in [https://github.com/TryGhost/node-sqlite3/pull/1628](https://togithub.com/TryGhost/node-sqlite3/pull/1628) - Fixed remaining method declarations by [@​alexanderfloh](https://togithub.com/alexanderfloh) in [https://github.com/TryGhost/node-sqlite3/pull/1633](https://togithub.com/TryGhost/node-sqlite3/pull/1633) - Fixed importing `sqlite3#verbose` using destructuring syntax by [@​mahdi-farnia](https://togithub.com/mahdi-farnia) in [https://github.com/TryGhost/node-sqlite3/pull/1632](https://togithub.com/TryGhost/node-sqlite3/pull/1632) #### New Contributors - [@​JoelEinbinder](https://togithub.com/JoelEinbinder) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1628](https://togithub.com/TryGhost/node-sqlite3/pull/1628) - [@​mahdi-farnia](https://togithub.com/mahdi-farnia) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1632](https://togithub.com/TryGhost/node-sqlite3/pull/1632) - [@​soukand](https://togithub.com/soukand) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1267](https://togithub.com/TryGhost/node-sqlite3/pull/1267) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.11...v5.1.0 ### [`v5.0.11`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.11) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.10...v5.0.11) #### What's Changed - Restored compatibility for Alpine 3.15 by [@​daniellockyer](https://togithub.com/daniellockyer) in [https://github.com/TryGhost/node-sqlite3/pull/1626](https://togithub.com/TryGhost/node-sqlite3/pull/1626) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.10...v5.0.11 ### [`v5.0.10`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.10) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.9...v5.0.10) #### What's Changed - Updated bundled SQLite to v3.39.2 by [@​daniellockyer](https://togithub.com/daniellockyer) - Addressed CodeQL warnings by [@​bpasero](https://togithub.com/bpasero) in [https://github.com/TryGhost/node-sqlite3/pull/1614](https://togithub.com/TryGhost/node-sqlite3/pull/1614) #### New Contributors - [@​bpasero](https://togithub.com/bpasero) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1614](https://togithub.com/TryGhost/node-sqlite3/pull/1614) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.9...v5.0.10 ### [`v5.0.9`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.9) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.8...v5.0.9) #### What's Changed - Updated bundled SQLite to v3.39.1 by [@​daniellockyer](https://togithub.com/daniellockyer) - Fixed method declarations to conform with napi default for methods by [@​alexanderfloh](https://togithub.com/alexanderfloh) in [https://github.com/TryGhost/node-sqlite3/pull/1510](https://togithub.com/TryGhost/node-sqlite3/pull/1510) - Fixed propagation of async hook ids through callbacks by [@​alexanderfloh](https://togithub.com/alexanderfloh) in [https://github.com/TryGhost/node-sqlite3/pull/1511](https://togithub.com/TryGhost/node-sqlite3/pull/1511) - Updated sqlcipher homebrew CPPFLAGS location by [@​frovere](https://togithub.com/frovere) in [https://github.com/TryGhost/node-sqlite3/pull/1613](https://togithub.com/TryGhost/node-sqlite3/pull/1613) #### New Contributors - [@​alexanderfloh](https://togithub.com/alexanderfloh) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1510](https://togithub.com/TryGhost/node-sqlite3/pull/1510) - [@​frovere](https://togithub.com/frovere) made their first contribution in [https://github.com/TryGhost/node-sqlite3/pull/1613](https://togithub.com/TryGhost/node-sqlite3/pull/1613) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.8...v5.0.9 ### [`v5.0.8`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.8) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.7...v5.0.8) #### What's Changed - Reverted https://github.com/TryGhost/node-sqlite3/commit/5063367567fd1abe47bafc2095fb4f9090a260e3, which was causing a segfault with certain queries ([https://github.com/TryGhost/node-sqlite3/issues/1605](https://togithub.com/TryGhost/node-sqlite3/issues/1605) and [https://github.com/TryGhost/node-sqlite3/issues/1606](https://togithub.com/TryGhost/node-sqlite3/issues/1606)) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.7...v5.0.8 ### [`v5.0.7`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.7) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.6...v5.0.7) #### What's Changed - Updated bundled SQLite to v3.38.4 by [@​daniellockyer](https://togithub.com/daniellockyer) in [https://github.com/TryGhost/node-sqlite3/pull/1604](https://togithub.com/TryGhost/node-sqlite3/pull/1604) - Improved performance by fetching column names once by [@​daniellockyer](https://togithub.com/daniellockyer) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.6...v5.0.7 ### [`v5.0.6`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.6) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.5...v5.0.6) #### What's Changed - Updated bundled SQLite to v3.38.3 by [@​daniellockyer](https://togithub.com/daniellockyer) in [https://github.com/TryGhost/node-sqlite3/pull/1593](https://togithub.com/TryGhost/node-sqlite3/pull/1593). This fixes an upstream bug in SQLite that was reported here: [https://github.com/TryGhost/node-sqlite3/issues/1589](https://togithub.com/TryGhost/node-sqlite3/issues/1589) - Added Node 18 to CI by [@​daniellockyer](https://togithub.com/daniellockyer) in [https://github.com/TryGhost/node-sqlite3/pull/1587](https://togithub.com/TryGhost/node-sqlite3/pull/1587) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.5...v5.0.6 ### [`v5.0.5`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.5) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.4...v5.0.5) #### What's Changed - Fixed building on certain systems ([https://github.com/TryGhost/node-sqlite3/issues/1584](https://togithub.com/TryGhost/node-sqlite3/issues/1584)) by [@​daniellockyer](https://togithub.com/daniellockyer) - General repository maintenance by [@​daniellockyer](https://togithub.com/daniellockyer) Thank you to everyone reporting issues with building `sqlite3` or the prebuilt binaries 🙂 If you encounter an problem, please search open and closed issues for existing reports or open a new issue with as much system information as possible. **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.4...v5.0.5 ### [`v5.0.4`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.4) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.3...v5.0.4) #### What's Changed - Added prebuilt Linux musl binaries - [@​daniellockyer](https://togithub.com/daniellockyer) - Added prebuilt Linux ARM64 binaries - [@​daniellockyer](https://togithub.com/daniellockyer) - Fixed older glibc compatibility - [@​daniellockyer](https://togithub.com/daniellockyer) **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.3...v5.0.4 ### [`v5.0.3`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.3) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.2...v5.0.3) #### What's Changed - Updated bundled SQLite to v3.38.2 - [@​daniellockyer](https://togithub.com/daniellockyer) - Enabled math functions in compiler options - [@​kewde](https://togithub.com/kewde) - Updated `node-gyp` to v8.x - [@​daniellockyer](https://togithub.com/daniellockyer) - Re-enabled Node-API v6 builds - [@​daniellockyer](https://togithub.com/daniellockyer) - Fixed segfault of invalid toString() object by [@​kewde](https://togithub.com/kewde) in [https://github.com/TryGhost/node-sqlite3/pull/1450](https://togithub.com/TryGhost/node-sqlite3/pull/1450) - Fixed building on MacOS Monterey 12.3 - [@​daniellockyer](https://togithub.com/daniellockyer) - Replaced Python extraction script with JS by [@​xPaw](https://togithub.com/xPaw) in [https://github.com/TryGhost/node-sqlite3/pull/1570](https://togithub.com/TryGhost/node-sqlite3/pull/1570) - Switched prebuilt binary hosting to GitHub Releases - [@​daniellockyer](https://togithub.com/daniellockyer) #### Known Problems - [https://github.com/TryGhost/node-sqlite3/issues/1578](https://togithub.com/TryGhost/node-sqlite3/issues/1578) - the minimum glibc version for prebuilt binaries was bumped to 2.29. We hope to bring this back down within the next few releases but you will need to compile from source if your system ships with a lower version. - Prebuilt binaries for Linux do not work on musl systems. This should be fixed with https://github.com/TryGhost/node-sqlite3/commit/8b2cdd948a382b58162cb491f745ba9167dc7b0f but you will need to compile from source to use v5.0.3. **Full Changelog**: https://github.com/TryGhost/node-sqlite3/compare/v5.0.2...v5.0.3 ### [`v5.0.2`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.2) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.1...v5.0.2) - disable N-API v6 ### [`v5.0.1`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.1) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v5.0.0...v5.0.1) - dep: node-addon-api to ^3.0.0 [#​1367](https://togithub.com/mapbox/node-sqlite3/pull/1367) - bug: bad comparison of c string [#​1347](https://togithub.com/mapbox/node-sqlite3/pull/1347) - build: Install files to be deployed [#​1352](https://togithub.com/mapbox/node-sqlite3/pull/1352) - sqlite3: upgrade to 3.32.3 [#​1351](https://togithub.com/mapbox/node-sqlite3/pull/1351) - bug: worker threads crash [#​1367](https://togithub.com/mapbox/node-sqlite3/pull/1367) - bug: segfaults [#​1368](https://togithub.com/mapbox/node-sqlite3/pull/1368) - typo: broken link to MapBox site [#​1369](https://togithub.com/mapbox/node-sqlite3/pull/1369) ### [`v5.0.0`](https://togithub.com/TryGhost/node-sqlite3/releases/tag/v5.0.0) [Compare Source](https://togithub.com/TryGhost/node-sqlite3/compare/v4.2.0...v5.0.0) - prebuilt: Node 14 support, dropped support for all version of Node < 10 [#​1304](https://togithub.com/mapbox/node-sqlite3/pull/1304) - prebuilt: add electron 7.2 [#​1324](https://togithub.com/mapbox/node-sqlite3/pull/1324) - napi: refactor codebase to use N-API instead of NAN (+ various improvements) [#​1304](https://togithub.com/mapbox/node-sqlite3/pull/1304) - trace: don't require throw to add trace info for verbose [#​1317](https://togithub.com/mapbox/node-sqlite3/pull/1317) - ci: remove permission setting [#​1319](https://togithub.com/mapbox/node-sqlite3/pull/1319)

Configuration

📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.



This PR was generated by Mend Renovate. View the repository job log.

renovate[bot] commented 8 months ago

⚠ Artifact update problem

Renovate failed to update an artifact related to this branch. You probably do not want to merge this PR as-is.

♻ Renovate will retry this branch, including artifacts, only when one of the following happens:

The artifact failure details are included below:

File name: yarn.lock
[09:14:38.848] INFO (73): Installing tool node@9.11.2...
[09:14:48.768] WARN (73): Npm error:
npm ERR! weird error 1
[09:14:48.771] FATAL (73): node-gyp update command failed
    err: {
      "type": "Error",
      "message": "node-gyp update command failed",
      "stack":
          Error: node-gyp update command failed
              at InstallNodeService.updateNodeGyp (/snapshot/dist/containerbase-cli.js:51412:13)
              at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
              at async InstallNodeService.install (/snapshot/dist/containerbase-cli.js:51548:7)
              at async InstallToolService.execute (/snapshot/dist/containerbase-cli.js:52054:11)
              at async InstallToolShortCommand.execute (/snapshot/dist/containerbase-cli.js:52222:14)
              at async InstallToolShortCommand.validateAndExecute (/snapshot/dist/containerbase-cli.js:2426:26)
              at async _Cli.run (/snapshot/dist/containerbase-cli.js:3539:22)
              at async _Cli.runExit (/snapshot/dist/containerbase-cli.js:3547:28)
              at async main (/snapshot/dist/containerbase-cli.js:52416:3)
    }
[09:14:49.070] INFO (73): Installed tool node with errors in 10.2s.