launchbadge/sqlx (sqlx)
### [`v0.7.4`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#074---2024-03-11)
[Compare Source](https://togithub.com/launchbadge/sqlx/compare/v0.7.3...v0.7.4)
38 pull requests were merged this release cycle.
This is officially the **last** release of the 0.7.x release cycle.
As of this release, development of 0.8.0 has begun on `main` and only high-priority bugfixes may be backported.
##### Added
- \[[#2891]]: feat: expose getters for connect options fields \[\[[@saiintbrisson](https://togithub.com/saiintbrisson)]]
- \[[#2902]]: feat: add `to_url_lossy` to connect options \[\[[@lily-mosquitoes](https://togithub.com/lily-mosquitoes)]]
- \[[#2927]]: Support `query!` for cargo-free systems \[\[[@kshramt](https://togithub.com/kshramt)]]
- \[[#2997]]: doc(FAQ): add entry explaining prepared statements \[\[[@abonander](https://togithub.com/abonander)]]
- \[[#3001]]: Update README to clarify MariaDB support \[\[[@iangilfillan](https://togithub.com/iangilfillan)]]
- \[[#3004]]: feat(logging): Add numeric elapsed time field elapsed_secs \[\[[@iamjpotts](https://togithub.com/iamjpotts)]]
- \[[#3007]]: feat: add `raw_sql` API \[\[[@abonander](https://togithub.com/abonander)]]
- This hopefully makes it easier to find how to execute statements which are not supported by the default
prepared statement interfaces `query*()` and `query!()`.
- Improved documentation across the board for the `query*()` functions.
- Deprecated: `execute_many()` and `fetch_many()` on interfaces that use prepared statements.
- Multiple SQL statements in one query string were only supported by SQLite because its prepared statement
interface is the *only* way to execute SQL. All other database flavors forbid multiple statements in
one prepared statement string as an extra defense against SQL injection.
- The new `raw_sql` API retains this functionality because it explicitly does *not* use prepared statements.
Raw or text-mode query interfaces generally allow multiple statements in one query string, and this is
supported by all current databases. Due to their nature, however, one cannot use bind parameters with them.
- If this change affects you, an issue is open for discussion: [https://github.com/launchbadge/sqlx/issues/3108](https://togithub.com/launchbadge/sqlx/issues/3108)
- \[[#3011]]: Added support to IpAddr with MySQL/MariaDB. \[\[[@Icerath](https://togithub.com/Icerath)]]
- \[[#3013]]: Add default implementation for PgInterval \[\[[@pawurb](https://togithub.com/pawurb)]]
- \[[#3018]]: Add default implementation for PgMoney \[\[[@pawurb](https://togithub.com/pawurb)]]
- \[[#3026]]: Update docs to reflect support for MariaDB data types \[\[[@iangilfillan](https://togithub.com/iangilfillan)]]
- \[[#3037]]: feat(mysql): allow to connect with mysql driver without default behavor \[\[[@darkecho731](https://togithub.com/darkecho731)]]
##### Changed
- \[[#2900]]: Show latest url to docs for macro.migrate \[\[[@Vrajs16](https://togithub.com/Vrajs16)]]
- \[[#2914]]: Use `create_new` instead of `atomic-file-write` \[\[[@mattfbacon](https://togithub.com/mattfbacon)]]
- \[[#2926]]: docs: update example for `PgConnectOptions` \[\[[@Fyko](https://togithub.com/Fyko)]]
- \[[#2989]]: sqlx-core: Remove dotenvy dependency \[\[[@joshtriplett](https://togithub.com/joshtriplett)]]
- \[[#2996]]: chore: Update ahash to 0.8.7 \[\[[@takenoko-gohan](https://togithub.com/takenoko-gohan)]]
- \[[#3006]]: chore(deps): Replace unmaintained tempdir crate with tempfile \[\[[@iamjpotts](https://togithub.com/iamjpotts)]]
- \[[#3008]]: chore: Ignore .sqlx folder created by running ci steps locally \[\[[@iamjpotts](https://togithub.com/iamjpotts)]]
- \[[#3009]]: chore(dev-deps): Upgrade env_logger from 0.9 to 0.11 \[\[[@iamjpotts](https://togithub.com/iamjpotts)]]
- \[[#3010]]: chore(deps): Upgrade criterion to 0.5.1 \[\[[@iamjpotts](https://togithub.com/iamjpotts)]]
- \[[#3050]]: Optimize SASL auth in sqlx-postgres \[\[[@mirek26](https://togithub.com/mirek26)]]
- \[[#3055]]: Set TCP_NODELAY option on TCP sockets \[\[[@mirek26](https://togithub.com/mirek26)]]
- \[[#3065]]: Improve max_lifetime handling \[\[[@mirek26](https://togithub.com/mirek26)]]
- \[[#3072]]: Change the name of "inner" function generated by `#[sqlx::test]` \[\[[@ciffelia](https://togithub.com/ciffelia)]]
- \[[#3083]]: Remove sha1 because it's not being used in postgres \[\[[@rafaelGuerreiro](https://togithub.com/rafaelGuerreiro)]]
##### Fixed
- \[[#2898]]: Fixed docs \[\[[@Vrajs16](https://togithub.com/Vrajs16)]]
- \[[#2905]]: fix(mysql): Close prepared statement if persistence is disabled \[\[[@larsschumacher](https://togithub.com/larsschumacher)]]
- \[[#2913]]: Fix handling of deferred constraints \[\[[@Thomasdezeeuw](https://togithub.com/Thomasdezeeuw)]]
- \[[#2919]]: fix duplicate "\`" in FromRow "default" attribute doc comment \[\[[@shengsheng](https://togithub.com/shengsheng)]]
- \[[#2932]]: fix(postgres): avoid unnecessary flush in PgCopyIn::read_from \[\[[@tsing](https://togithub.com/tsing)]]
- \[[#2955]]: Minor fixes \[\[[@Dawsoncodes](https://togithub.com/Dawsoncodes)]]
- \[[#2963]]: Fixed ReadMe badge styling \[\[[@tadghh](https://togithub.com/tadghh)]]
- \[[#2976]]: fix: AnyRow not support PgType::Varchar \[\[[@holicc](https://togithub.com/holicc)]]
- \[[#3053]]: fix: do not panic when binding a large BigDecimal \[\[[@Ekleog](https://togithub.com/Ekleog)]]
- \[[#3056]]: fix: spans in sqlite tracing ([#2876](https://togithub.com/launchbadge/sqlx/issues/2876)) \[\[[@zoomiti](https://togithub.com/zoomiti)]]
- \[[#3089]]: fix(migrate): improve error message when parsing version from filename \[\[[@abonander](https://togithub.com/abonander)]]
- \[[#3098]]: Migrations fixes \[\[[@abonander](https://togithub.com/abonander)]]
- Unhides `sqlx::migrate::Migrator`.
- Improves I/O error message when failing to read a file in `migrate!()`.
[#2891]: https://togithub.com/launchbadge/sqlx/pull/2891
[#2898]: https://togithub.com/launchbadge/sqlx/pull/2898
[#2900]: https://togithub.com/launchbadge/sqlx/pull/2900
[#2902]: https://togithub.com/launchbadge/sqlx/pull/2902
[#2905]: https://togithub.com/launchbadge/sqlx/pull/2905
[#2913]: https://togithub.com/launchbadge/sqlx/pull/2913
[#2914]: https://togithub.com/launchbadge/sqlx/pull/2914
[#2919]: https://togithub.com/launchbadge/sqlx/pull/2919
[#2926]: https://togithub.com/launchbadge/sqlx/pull/2926
[#2927]: https://togithub.com/launchbadge/sqlx/pull/2927
[#2932]: https://togithub.com/launchbadge/sqlx/pull/2932
[#2955]: https://togithub.com/launchbadge/sqlx/pull/2955
[#2963]: https://togithub.com/launchbadge/sqlx/pull/2963
[#2976]: https://togithub.com/launchbadge/sqlx/pull/2976
[#2989]: https://togithub.com/launchbadge/sqlx/pull/2989
[#2996]: https://togithub.com/launchbadge/sqlx/pull/2996
[#2997]: https://togithub.com/launchbadge/sqlx/pull/2997
[#3001]: https://togithub.com/launchbadge/sqlx/pull/3001
[#3004]: https://togithub.com/launchbadge/sqlx/pull/3004
[#3006]: https://togithub.com/launchbadge/sqlx/pull/3006
[#3007]: https://togithub.com/launchbadge/sqlx/pull/3007
[#3008]: https://togithub.com/launchbadge/sqlx/pull/3008
[#3009]: https://togithub.com/launchbadge/sqlx/pull/3009
[#3010]: https://togithub.com/launchbadge/sqlx/pull/3010
[#3011]: https://togithub.com/launchbadge/sqlx/pull/3011
[#3013]: https://togithub.com/launchbadge/sqlx/pull/3013
[#3018]: https://togithub.com/launchbadge/sqlx/pull/3018
[#3026]: https://togithub.com/launchbadge/sqlx/pull/3026
[#3037]: https://togithub.com/launchbadge/sqlx/pull/3037
[#3050]: https://togithub.com/launchbadge/sqlx/pull/3050
[#3053]: https://togithub.com/launchbadge/sqlx/pull/3053
[#3055]: https://togithub.com/launchbadge/sqlx/pull/3055
[#3056]: https://togithub.com/launchbadge/sqlx/pull/3056
[#3065]: https://togithub.com/launchbadge/sqlx/pull/3065
[#3072]: https://togithub.com/launchbadge/sqlx/pull/3072
[#3083]: https://togithub.com/launchbadge/sqlx/pull/3083
[#3089]: https://togithub.com/launchbadge/sqlx/pull/3089
[#3098]: https://togithub.com/launchbadge/sqlx/pull/3098
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.
[ ] If you want to rebase/retry this PR, check this box
This PR contains the following updates:
0.7.3
->0.7.4
Release Notes
launchbadge/sqlx (sqlx)
### [`v0.7.4`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#074---2024-03-11) [Compare Source](https://togithub.com/launchbadge/sqlx/compare/v0.7.3...v0.7.4) 38 pull requests were merged this release cycle. This is officially the **last** release of the 0.7.x release cycle. As of this release, development of 0.8.0 has begun on `main` and only high-priority bugfixes may be backported. ##### Added - \[[#2891]]: feat: expose getters for connect options fields \[\[[@saiintbrisson](https://togithub.com/saiintbrisson)]] - \[[#2902]]: feat: add `to_url_lossy` to connect options \[\[[@lily-mosquitoes](https://togithub.com/lily-mosquitoes)]] - \[[#2927]]: Support `query!` for cargo-free systems \[\[[@kshramt](https://togithub.com/kshramt)]] - \[[#2997]]: doc(FAQ): add entry explaining prepared statements \[\[[@abonander](https://togithub.com/abonander)]] - \[[#3001]]: Update README to clarify MariaDB support \[\[[@iangilfillan](https://togithub.com/iangilfillan)]] - \[[#3004]]: feat(logging): Add numeric elapsed time field elapsed_secs \[\[[@iamjpotts](https://togithub.com/iamjpotts)]] - \[[#3007]]: feat: add `raw_sql` API \[\[[@abonander](https://togithub.com/abonander)]] - This hopefully makes it easier to find how to execute statements which are not supported by the default prepared statement interfaces `query*()` and `query!()`. - Improved documentation across the board for the `query*()` functions. - Deprecated: `execute_many()` and `fetch_many()` on interfaces that use prepared statements. - Multiple SQL statements in one query string were only supported by SQLite because its prepared statement interface is the *only* way to execute SQL. All other database flavors forbid multiple statements in one prepared statement string as an extra defense against SQL injection. - The new `raw_sql` API retains this functionality because it explicitly does *not* use prepared statements. Raw or text-mode query interfaces generally allow multiple statements in one query string, and this is supported by all current databases. Due to their nature, however, one cannot use bind parameters with them. - If this change affects you, an issue is open for discussion: [https://github.com/launchbadge/sqlx/issues/3108](https://togithub.com/launchbadge/sqlx/issues/3108) - \[[#3011]]: Added support to IpAddr with MySQL/MariaDB. \[\[[@Icerath](https://togithub.com/Icerath)]] - \[[#3013]]: Add default implementation for PgInterval \[\[[@pawurb](https://togithub.com/pawurb)]] - \[[#3018]]: Add default implementation for PgMoney \[\[[@pawurb](https://togithub.com/pawurb)]] - \[[#3026]]: Update docs to reflect support for MariaDB data types \[\[[@iangilfillan](https://togithub.com/iangilfillan)]] - \[[#3037]]: feat(mysql): allow to connect with mysql driver without default behavor \[\[[@darkecho731](https://togithub.com/darkecho731)]] ##### Changed - \[[#2900]]: Show latest url to docs for macro.migrate \[\[[@Vrajs16](https://togithub.com/Vrajs16)]] - \[[#2914]]: Use `create_new` instead of `atomic-file-write` \[\[[@mattfbacon](https://togithub.com/mattfbacon)]] - \[[#2926]]: docs: update example for `PgConnectOptions` \[\[[@Fyko](https://togithub.com/Fyko)]] - \[[#2989]]: sqlx-core: Remove dotenvy dependency \[\[[@joshtriplett](https://togithub.com/joshtriplett)]] - \[[#2996]]: chore: Update ahash to 0.8.7 \[\[[@takenoko-gohan](https://togithub.com/takenoko-gohan)]] - \[[#3006]]: chore(deps): Replace unmaintained tempdir crate with tempfile \[\[[@iamjpotts](https://togithub.com/iamjpotts)]] - \[[#3008]]: chore: Ignore .sqlx folder created by running ci steps locally \[\[[@iamjpotts](https://togithub.com/iamjpotts)]] - \[[#3009]]: chore(dev-deps): Upgrade env_logger from 0.9 to 0.11 \[\[[@iamjpotts](https://togithub.com/iamjpotts)]] - \[[#3010]]: chore(deps): Upgrade criterion to 0.5.1 \[\[[@iamjpotts](https://togithub.com/iamjpotts)]] - \[[#3050]]: Optimize SASL auth in sqlx-postgres \[\[[@mirek26](https://togithub.com/mirek26)]] - \[[#3055]]: Set TCP_NODELAY option on TCP sockets \[\[[@mirek26](https://togithub.com/mirek26)]] - \[[#3065]]: Improve max_lifetime handling \[\[[@mirek26](https://togithub.com/mirek26)]] - \[[#3072]]: Change the name of "inner" function generated by `#[sqlx::test]` \[\[[@ciffelia](https://togithub.com/ciffelia)]] - \[[#3083]]: Remove sha1 because it's not being used in postgres \[\[[@rafaelGuerreiro](https://togithub.com/rafaelGuerreiro)]] ##### Fixed - \[[#2898]]: Fixed docs \[\[[@Vrajs16](https://togithub.com/Vrajs16)]] - \[[#2905]]: fix(mysql): Close prepared statement if persistence is disabled \[\[[@larsschumacher](https://togithub.com/larsschumacher)]] - \[[#2913]]: Fix handling of deferred constraints \[\[[@Thomasdezeeuw](https://togithub.com/Thomasdezeeuw)]] - \[[#2919]]: fix duplicate "\`" in FromRow "default" attribute doc comment \[\[[@shengsheng](https://togithub.com/shengsheng)]] - \[[#2932]]: fix(postgres): avoid unnecessary flush in PgCopyIn::read_from \[\[[@tsing](https://togithub.com/tsing)]] - \[[#2955]]: Minor fixes \[\[[@Dawsoncodes](https://togithub.com/Dawsoncodes)]] - \[[#2963]]: Fixed ReadMe badge styling \[\[[@tadghh](https://togithub.com/tadghh)]] - \[[#2976]]: fix: AnyRow not support PgType::Varchar \[\[[@holicc](https://togithub.com/holicc)]] - \[[#3053]]: fix: do not panic when binding a large BigDecimal \[\[[@Ekleog](https://togithub.com/Ekleog)]] - \[[#3056]]: fix: spans in sqlite tracing ([#2876](https://togithub.com/launchbadge/sqlx/issues/2876)) \[\[[@zoomiti](https://togithub.com/zoomiti)]] - \[[#3089]]: fix(migrate): improve error message when parsing version from filename \[\[[@abonander](https://togithub.com/abonander)]] - \[[#3098]]: Migrations fixes \[\[[@abonander](https://togithub.com/abonander)]] - Unhides `sqlx::migrate::Migrator`. - Improves I/O error message when failing to read a file in `migrate!()`. [#2891]: https://togithub.com/launchbadge/sqlx/pull/2891 [#2898]: https://togithub.com/launchbadge/sqlx/pull/2898 [#2900]: https://togithub.com/launchbadge/sqlx/pull/2900 [#2902]: https://togithub.com/launchbadge/sqlx/pull/2902 [#2905]: https://togithub.com/launchbadge/sqlx/pull/2905 [#2913]: https://togithub.com/launchbadge/sqlx/pull/2913 [#2914]: https://togithub.com/launchbadge/sqlx/pull/2914 [#2919]: https://togithub.com/launchbadge/sqlx/pull/2919 [#2926]: https://togithub.com/launchbadge/sqlx/pull/2926 [#2927]: https://togithub.com/launchbadge/sqlx/pull/2927 [#2932]: https://togithub.com/launchbadge/sqlx/pull/2932 [#2955]: https://togithub.com/launchbadge/sqlx/pull/2955 [#2963]: https://togithub.com/launchbadge/sqlx/pull/2963 [#2976]: https://togithub.com/launchbadge/sqlx/pull/2976 [#2989]: https://togithub.com/launchbadge/sqlx/pull/2989 [#2996]: https://togithub.com/launchbadge/sqlx/pull/2996 [#2997]: https://togithub.com/launchbadge/sqlx/pull/2997 [#3001]: https://togithub.com/launchbadge/sqlx/pull/3001 [#3004]: https://togithub.com/launchbadge/sqlx/pull/3004 [#3006]: https://togithub.com/launchbadge/sqlx/pull/3006 [#3007]: https://togithub.com/launchbadge/sqlx/pull/3007 [#3008]: https://togithub.com/launchbadge/sqlx/pull/3008 [#3009]: https://togithub.com/launchbadge/sqlx/pull/3009 [#3010]: https://togithub.com/launchbadge/sqlx/pull/3010 [#3011]: https://togithub.com/launchbadge/sqlx/pull/3011 [#3013]: https://togithub.com/launchbadge/sqlx/pull/3013 [#3018]: https://togithub.com/launchbadge/sqlx/pull/3018 [#3026]: https://togithub.com/launchbadge/sqlx/pull/3026 [#3037]: https://togithub.com/launchbadge/sqlx/pull/3037 [#3050]: https://togithub.com/launchbadge/sqlx/pull/3050 [#3053]: https://togithub.com/launchbadge/sqlx/pull/3053 [#3055]: https://togithub.com/launchbadge/sqlx/pull/3055 [#3056]: https://togithub.com/launchbadge/sqlx/pull/3056 [#3065]: https://togithub.com/launchbadge/sqlx/pull/3065 [#3072]: https://togithub.com/launchbadge/sqlx/pull/3072 [#3083]: https://togithub.com/launchbadge/sqlx/pull/3083 [#3089]: https://togithub.com/launchbadge/sqlx/pull/3089 [#3098]: https://togithub.com/launchbadge/sqlx/pull/3098Configuration
đ 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 has been generated by Renovate Bot.