search

msonnberger / queued

https://queued.vercel.app
3 stars 0 forks source link

Update all non-major dependencies #225

Closed renovate[bot] closed 1 year ago

renovate[bot] commented 1 year ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence Type Update
@playwright/test (source) 1.36.2 -> 1.37.1 age adoption passing confidence devDependencies minor
@sveltejs/adapter-vercel (source) 3.0.2 -> 3.0.3 age adoption passing confidence devDependencies patch
@sveltejs/kit (source) 1.22.3 -> 1.22.6 age adoption passing confidence devDependencies patch
@typescript-eslint/eslint-plugin 6.2.0 -> 6.4.1 age adoption passing confidence devDependencies minor
@typescript-eslint/parser 6.2.0 -> 6.4.1 age adoption passing confidence devDependencies minor
@vercel/analytics 1.0.1 -> 1.0.2 age adoption passing confidence dependencies patch
autoprefixer 10.4.14 -> 10.4.15 age adoption passing confidence devDependencies patch
drizzle-kit 0.19.11 -> 0.19.13 age adoption passing confidence devDependencies patch
drizzle-orm 0.27.2 -> 0.28.2 age adoption passing confidence dependencies minor
eslint (source) 8.45.0 -> 8.47.0 age adoption passing confidence devDependencies minor
eslint-config-prettier 8.8.0 -> 8.10.0 age adoption passing confidence devDependencies minor
lucide-svelte (source) 0.263.0 -> 0.268.0 age adoption passing confidence dependencies minor
oazapfts 4.7.3 -> 4.7.5 age adoption passing confidence dependencies patch
pg 8.11.1 -> 8.11.3 age adoption passing confidence dependencies patch
pnpm (source) 8.6.10 -> 8.6.12 age adoption passing confidence packageManager patch
pnpm/action-setup v2.3.0 -> v2.4.0 age adoption passing confidence action minor
postcss (source) 8.4.27 -> 8.4.28 age adoption passing confidence devDependencies patch
prettier (source) 3.0.0 -> 3.0.2 age adoption passing confidence devDependencies patch
prettier-plugin-svelte 3.0.0 -> 3.0.3 age adoption passing confidence devDependencies patch
prettier-plugin-tailwindcss 0.4.1 -> 0.5.3 age adoption passing confidence devDependencies minor
svelte (source) 4.1.1 -> 4.2.0 age adoption passing confidence devDependencies minor
svelte-check 3.4.6 -> 3.5.0 age adoption passing confidence devDependencies minor
svelte-headlessui (source) 0.0.20 -> 0.0.23 age adoption passing confidence dependencies patch
tslib (source) 2.6.1 -> 2.6.2 age adoption passing confidence devDependencies patch
vite (source) 4.4.7 -> 4.4.9 age adoption passing confidence devDependencies patch
vitest 0.33.0 -> 0.34.2 age adoption passing confidence devDependencies minor
zod (source) 3.21.4 -> 3.22.2 age adoption passing confidence dependencies minor

Release Notes

Microsoft/playwright (@​playwright/test) ### [`v1.37.1`](https://togithub.com/microsoft/playwright/releases/tag/v1.37.1) [Compare Source](https://togithub.com/Microsoft/playwright/compare/v1.37.0...v1.37.1) ##### Highlights [https://github.com/microsoft/playwright/issues/26496](https://togithub.com/microsoft/playwright/issues/26496) - \[REGRESSION] webServer stdout is always getting printed[https://github.com/microsoft/playwright/issues/26492](https://togithub.com/microsoft/playwright/issues/26492)2 - \[REGRESSION] test.only with project dependency is not working #### Browser Versions - Chromium 116.0.5845.82 - Mozilla Firefox 115.0 - WebKit 17.0 This version was also tested against the following stable channels: - Google Chrome 115 - Microsoft Edge 115 ### [`v1.37.0`](https://togithub.com/microsoft/playwright/releases/tag/v1.37.0) [Compare Source](https://togithub.com/Microsoft/playwright/compare/v1.36.2...v1.37.0) #### ✨ New tool to merge reports If you run tests on multiple shards, you can now merge all reports in a single HTML report (or any other report) using the new `merge-reports` CLI tool. Using `merge-reports` tool requires the following steps: 1. Adding a new "blob" reporter to the config when running on CI: ```js title="playwright.config.ts" export default defineConfig({ testDir: './tests', reporter: process.env.CI ? 'blob' : 'html', }); ``` The "blob" reporter will produce ".zip" files that contain all the information about the test run. 2. Copying all "blob" reports in a single shared location and running `npx playwright merge-reports`: ```bash npx playwright merge-reports --reporter html ./all-blob-reports ``` Read more in [our documentation](https://playwright.dev/docs/test-sharding). #### πŸ“š Debian 12 Bookworm Support Playwright now supports Debian 12 Bookworm on both x86\_64 and arm64 for Chromium, Firefox and WebKit. Let us know if you encounter any issues! Linux support looks like this: | | Ubuntu 20.04 | Ubuntu 22.04 | Debian 11 | Debian 12 | | :--- | :---: | :---: | :---: | :---: | | Chromium | βœ… | βœ… | βœ… | βœ… | | WebKit | βœ… | βœ… | βœ… | βœ… | | Firefox | βœ… | βœ… | βœ… | βœ… | #### 🌈 UI Mode Updates - UI Mode now respects project dependencies. You can control which dependencies to respect by checking/unchecking them in a projects list. - Console logs from the test are now displayed in the Console tab. #### Browser Versions - Chromium 116.0.5845.82 - Mozilla Firefox 115.0 - WebKit 17.0 This version was also tested against the following stable channels: - Google Chrome 115 - Microsoft Edge 115
sveltejs/kit (@​sveltejs/adapter-vercel) ### [`v3.0.3`](https://togithub.com/sveltejs/kit/blob/HEAD/packages/adapter-vercel/CHANGELOG.md#303) [Compare Source](https://togithub.com/sveltejs/kit/compare/@sveltejs/adapter-vercel@3.0.2...@sveltejs/adapter-vercel@3.0.3) ##### Patch Changes - chore: upgrade to [@​vercel/nft](https://togithub.com/vercel/nft) version 0.23.0 ([#​10445](https://togithub.com/sveltejs/kit/pull/10445)) - Updated dependencies \[[`0f0049810`](https://togithub.com/sveltejs/kit/commit/0f00498100361ef0a4ea8b0b4e8465e442fa22a6), [`6f36aefe1`](https://togithub.com/sveltejs/kit/commit/6f36aefe13bf55cfaef14166c60ecee989061ddd)]: - [@​sveltejs/kit](https://togithub.com/sveltejs/kit)[@​1](https://togithub.com/1).22.4
sveltejs/kit (@​sveltejs/kit) ### [`v1.22.6`](https://togithub.com/sveltejs/kit/blob/HEAD/packages/kit/CHANGELOG.md#1226) [Compare Source](https://togithub.com/sveltejs/kit/compare/@sveltejs/kit@1.22.5...@sveltejs/kit@1.22.6) ##### Patch Changes - fix: correctly restore trailing slash in url pathname for data requests ([#​10475](https://togithub.com/sveltejs/kit/pull/10475)) - fix: load trailing slash option from server even when there's no load function ([#​10475](https://togithub.com/sveltejs/kit/pull/10475)) ### [`v1.22.5`](https://togithub.com/sveltejs/kit/blob/HEAD/packages/kit/CHANGELOG.md#1225) [Compare Source](https://togithub.com/sveltejs/kit/compare/@sveltejs/kit@1.22.4...@sveltejs/kit@1.22.5) ##### Patch Changes - fix: make server assets available during `vite preview` ([#​10511](https://togithub.com/sveltejs/kit/pull/10511)) - chore: upgrade `undici` to 5.23.0 ([#​10240](https://togithub.com/sveltejs/kit/pull/10240)) ### [`v1.22.4`](https://togithub.com/sveltejs/kit/blob/HEAD/packages/kit/CHANGELOG.md#1224) [Compare Source](https://togithub.com/sveltejs/kit/compare/@sveltejs/kit@1.22.3...@sveltejs/kit@1.22.4) ##### Patch Changes - fix: prevent duplicate module preload ([#​10442](https://togithub.com/sveltejs/kit/pull/10442)) - docs: Elaborate on credentialed `fetch` behaviour ([#​10421](https://togithub.com/sveltejs/kit/pull/10421))
typescript-eslint/typescript-eslint (@​typescript-eslint/eslint-plugin) ### [`v6.4.1`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/eslint-plugin/CHANGELOG.md#641-2023-08-21) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.4.0...v6.4.1) ##### Bug Fixes - **eslint-plugin:** \[no-unnecessary-condition] false positives with branded types ([#​7466](https://togithub.com/typescript-eslint/typescript-eslint/issues/7466)) ([b52658f](https://togithub.com/typescript-eslint/typescript-eslint/commit/b52658fbb6f5cf2085c94926872e6d39efaa3b01)), closes [#​7293](https://togithub.com/typescript-eslint/typescript-eslint/issues/7293) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. ### [`v6.4.0`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/eslint-plugin/CHANGELOG.md#640-2023-08-14) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.3.0...v6.4.0) ##### Bug Fixes - **eslint-plugin:** \[non-nullable-type-assertion-style] consider operator precedence when fixing ([#​7289](https://togithub.com/typescript-eslint/typescript-eslint/issues/7289)) ([bad37a2](https://togithub.com/typescript-eslint/typescript-eslint/commit/bad37a22025b718a10e70cc84b9847eb41f723d0)) - **eslint-plugin:** \[strict-boolean-expressions] replace dangerous fixer with suggestions ([#​7394](https://togithub.com/typescript-eslint/typescript-eslint/issues/7394)) ([ad8401a](https://togithub.com/typescript-eslint/typescript-eslint/commit/ad8401a5970441258cc4440a01a3acf35d861171)) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. ### [`v6.3.0`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/eslint-plugin/CHANGELOG.md#630-2023-08-07) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.2.1...v6.3.0) ##### Bug Fixes - **eslint-plugin:** \[no-extra-parens] keep parens around call expression arguments when type arguments contain parens ([#​7375](https://togithub.com/typescript-eslint/typescript-eslint/issues/7375)) ([38e5e4e](https://togithub.com/typescript-eslint/typescript-eslint/commit/38e5e4eb8624649a2b66e19a303383bebbda1e2e)) - **eslint-plugin:** \[no-restricted-imports] allow inline type qualifiers when `allowTypeImports` enabled ([#​7379](https://togithub.com/typescript-eslint/typescript-eslint/issues/7379)) ([cc9a46d](https://togithub.com/typescript-eslint/typescript-eslint/commit/cc9a46d01bce4282ff841d5ccef5445984aff8f6)) ##### Features - **eslint-plugin:** \[prefer-nullish-coalescing] allow `ignorePrimitives` option to be `true` ([#​7331](https://togithub.com/typescript-eslint/typescript-eslint/issues/7331)) ([dfcafae](https://togithub.com/typescript-eslint/typescript-eslint/commit/dfcafae515e7f4d1ae69387eb163200e455dd0ce)) ##### Reverts - Revert "chore(deps): update dependency marked to v6" ([#​7429](https://togithub.com/typescript-eslint/typescript-eslint/issues/7429)) ([7891a06](https://togithub.com/typescript-eslint/typescript-eslint/commit/7891a06892445a30c90c882d7e2f17fdf9da5601)), closes [#​7429](https://togithub.com/typescript-eslint/typescript-eslint/issues/7429) [#​7422](https://togithub.com/typescript-eslint/typescript-eslint/issues/7422) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. #### [6.2.1](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.2.0...v6.2.1) (2023-07-31) ##### Bug Fixes - **eslint-plugin:** \[no-inferrable-types] apply also for parameter properties ([#​7288](https://togithub.com/typescript-eslint/typescript-eslint/issues/7288)) ([67f93b1](https://togithub.com/typescript-eslint/typescript-eslint/commit/67f93b19f2e481a4e441635d72e81de9d5d7ad44)) - **scope-manager:** correct decorators(.length) check in ClassVisitor for methods ([#​7334](https://togithub.com/typescript-eslint/typescript-eslint/issues/7334)) ([abbb6c2](https://togithub.com/typescript-eslint/typescript-eslint/commit/abbb6c2c6d2bc1f8d4defd2060dbc473735b2cc7)) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. ### [`v6.2.1`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/eslint-plugin/CHANGELOG.md#621-2023-07-31) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.2.0...v6.2.1) ##### Bug Fixes - **eslint-plugin:** \[no-inferrable-types] apply also for parameter properties ([#​7288](https://togithub.com/typescript-eslint/typescript-eslint/issues/7288)) ([67f93b1](https://togithub.com/typescript-eslint/typescript-eslint/commit/67f93b19f2e481a4e441635d72e81de9d5d7ad44)) - **scope-manager:** correct decorators(.length) check in ClassVisitor for methods ([#​7334](https://togithub.com/typescript-eslint/typescript-eslint/issues/7334)) ([abbb6c2](https://togithub.com/typescript-eslint/typescript-eslint/commit/abbb6c2c6d2bc1f8d4defd2060dbc473735b2cc7)) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website.
typescript-eslint/typescript-eslint (@​typescript-eslint/parser) ### [`v6.4.1`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/parser/CHANGELOG.md#641-2023-08-21) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.4.0...v6.4.1) **Note:** Version bump only for package [@​typescript-eslint/parser](https://togithub.com/typescript-eslint/parser) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. ### [`v6.4.0`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/parser/CHANGELOG.md#640-2023-08-14) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.3.0...v6.4.0) **Note:** Version bump only for package [@​typescript-eslint/parser](https://togithub.com/typescript-eslint/parser) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. ### [`v6.3.0`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/parser/CHANGELOG.md#630-2023-08-07) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.2.1...v6.3.0) **Note:** Version bump only for package [@​typescript-eslint/parser](https://togithub.com/typescript-eslint/parser) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. #### [6.2.1](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.2.0...v6.2.1) (2023-07-31) **Note:** Version bump only for package [@​typescript-eslint/parser](https://togithub.com/typescript-eslint/parser) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website. ### [`v6.2.1`](https://togithub.com/typescript-eslint/typescript-eslint/blob/HEAD/packages/parser/CHANGELOG.md#621-2023-07-31) [Compare Source](https://togithub.com/typescript-eslint/typescript-eslint/compare/v6.2.0...v6.2.1) **Note:** Version bump only for package [@​typescript-eslint/parser](https://togithub.com/typescript-eslint/parser) You can read about our [versioning strategy](https://main--typescript-eslint.netlify.app/users/versioning) and [releases](https://main--typescript-eslint.netlify.app/users/releases) on our website.
vercel/analytics (@​vercel/analytics) ### [`v1.0.2`](https://togithub.com/vercel/analytics/compare/1.0.1...82d5b05236210a674d52d0e6dabbb973fd23787e) [Compare Source](https://togithub.com/vercel/analytics/compare/1.0.1...82d5b05236210a674d52d0e6dabbb973fd23787e)
postcss/autoprefixer (autoprefixer) ### [`v10.4.15`](https://togithub.com/postcss/autoprefixer/blob/HEAD/CHANGELOG.md#10415) [Compare Source](https://togithub.com/postcss/autoprefixer/compare/10.4.14...10.4.15) - Fixed `::backdrop` prefixes (by 一丝). - Fixed docs (by Christian Oliff).
drizzle-team/drizzle-kit-mirror (drizzle-kit) ### [`v0.19.13`](https://togithub.com/drizzle-team/drizzle-kit-mirror/releases/tag/v0.19.13): 0.19.13 [Compare Source](https://togithub.com/drizzle-team/drizzle-kit-mirror/compare/v0.19.12...v0.19.13) - πŸ› [Generated SQL try to drop constrains on the wrong table name when renaming](https://togithub.com/drizzle-team/drizzle-kit-mirror/issues/151) - πŸ› Removed a few unused imports from introspection in PostgreSQL - πŸ› [BUG: drizzle-kit introspect:mysql tables with pk and unique keys](https://togithub.com/drizzle-team/drizzle-kit-mirror/issues/146) - πŸ› [Running studio config don't accept mysql2 driver](https://togithub.com/drizzle-team/drizzle-kit-mirror/issues/140) - πŸ› [Cannot generate type for array of enum in postgres when introspecting](https://togithub.com/drizzle-team/drizzle-kit-mirror/issues/152) - πŸ› [\[BUG\]: schema already exists error](https://togithub.com/drizzle-team/drizzle-orm/issues/1045) - πŸ› [\[BUG\]: Renaming Tables errors out on Turso](https://togithub.com/drizzle-team/drizzle-orm/issues/1044) - ✍️ Change default host for Drizzle Studio to 0.0.0.0 and allow to specify other host values ### [`v0.19.12`](https://togithub.com/drizzle-team/drizzle-kit-mirror/releases/tag/v0.19.12): 0.19.12 [Compare Source](https://togithub.com/drizzle-team/drizzle-kit-mirror/compare/v0.19.11...v0.19.12) - πŸ› SQLite `push` changes were triggered if there is an `{ autoincrement: true }` field in a schema. This was caused by SQLite not storing proper information about the `AUTOINCREMENT` property for the column. In this release, it should treat it as expected. - πŸ› The SQLite `introspect` command was generating incorrect defaults for expressions in the output schema. - πŸ› As long as SQLite creates indexes for primary keys by default, those were not filtered in the push command. In this release, we will ignore such indexes. - πŸ› Fixed [MySQL - Introspect not importing int](https://togithub.com/drizzle-team/drizzle-kit-mirror/issues/136)
drizzle-team/drizzle-orm (drizzle-orm) ### [`v0.28.2`](https://togithub.com/drizzle-team/drizzle-orm/releases/tag/0.28.2) [Compare Source](https://togithub.com/drizzle-team/drizzle-orm/compare/0.28.1...0.28.2) #### The community contributions release πŸŽ‰ ##### Internal Features and Changes 1. Added a set of tests for d1. Thanks to [@​AdiRishi](https://togithub.com/AdiRishi)! 2. Fixed issues in internal documentation. Thanks to [@​balazsorban44](https://togithub.com/balazsorban44) and [@​pyk](https://togithub.com/pyk)! ##### Bug Fixes 1. Resolved the issue of truncating timestamp milliseconds for MySQL. Thanks to [@​steviec](https://togithub.com/steviec)! 2. Corrected the type of the get() method for sqlite-based dialects. Issue [#​565](https://togithub.com/drizzle-team/drizzle-orm/issues/565) has been closed. Thanks to [@​stefanmaric](https://togithub.com/stefanmaric)! 3. Rectified the sqlite-proxy bug that caused the query to execute twice. Thanks to [@​mosch](https://togithub.com/mosch)! ##### New packages πŸŽ‰ Added a support for [Typebox](https://togithub.com/sinclairzx81/typebox) in [drizzle-typebox](https://orm.drizzle.team/docs/typebox) package. Thanks to [@​Bulbang](https://togithub.com/Bulbang)! Please check documentation page for more usage examples: https://orm.drizzle.team/docs/typebox ### [`v0.28.1`](https://togithub.com/drizzle-team/drizzle-orm/releases/tag/0.28.1) [Compare Source](https://togithub.com/drizzle-team/drizzle-orm/compare/0.28.0...0.28.1) - πŸ› Fixed Postgres array-related issues introduced by 0.28.0 ([#​983](https://togithub.com/drizzle-team/drizzle-orm/issues/983), [#​992](https://togithub.com/drizzle-team/drizzle-orm/issues/992)) ### [`v0.28.0`](https://togithub.com/drizzle-team/drizzle-orm/releases/tag/0.28.0) [Compare Source](https://togithub.com/drizzle-team/drizzle-orm/compare/0.27.2...0.28.0) #### Breaking changes ##### Removed support for filtering by nested relations Current example won't work in `0.28.0`: ```ts const usersWithPosts = await db.query.users.findMany({ where: (table, { sql }) => (sql`json_array_length(${table.posts}) > 0`), with: { posts: true, }, }); ``` The `table` object in the `where` callback won't have fields from `with` and `extras`. We removed them to be able to build more efficient relational queries, which improved row reads and performance. If you have used those fields in the `where` callback before, there are several workarounds: 1. Applying those filters manually on the code level after the rows are fetched; 2. Using the core API. ##### Added Relational Queries `mode` config for `mysql2` driver Drizzle relational queries always generate exactly one SQL statement to run on the database and it has certain caveats. To have best in class support for every database out there we've introduced modes. Drizzle relational queries use lateral joins of subqueries under the hood and for now PlanetScale does not support them. When using `mysql2` driver with regular MySQL database - you should specify mode: "default". When using `mysql2` driver with PlanetScale - you need to specify mode: "planetscale". ```ts import { drizzle } from 'drizzle-orm/mysql2'; import mysql from 'mysql2/promise'; import * as schema from './schema'; const connection = await mysql.createConnection({ uri: process.env.PLANETSCALE_DATABASE_URL, }); const db = drizzle(connection, { schema, mode: 'planetscale' }); ``` #### Improved IntelliSense performance for large schemas We've run the diagnostics on a database schema with 85 tables, 666 columns, 26 enums, 172 indexes and 133 foreign keys. We've optimized internal types which resulted in **430%** speed up in IntelliSense. #### Improved Relational Queries Permormance and Read Usage In this release we've fully changed a way query is generated for Relational Queri API. As a summary we've made current set of changes in query generation startegy: 1. Lateral Joins: In the new version we're utilizing lateral joins, denoted by the "LEFT JOIN LATERAL" clauses, to retrieve specific data from related tables efficiently For MySQL in PlanetScale and SQLite, we've used simple subquery selects, which improved a query plan and overall performance 2. Selective Data Retrieval: In the new version we're retrieving only the necessary data from tables. This targeted data retrieval reduces the amount of unnecessary information fetched, resulting in a smaller dataset to process and faster execution. 3. Reduced Aggregations: In the new version we've reduced the number of aggregation functions (e.g., COUNT, json_agg). By using json_build_array directly within the lateral joins, drizzle is aggregating the data in a more streamlined manner, leading to improved query performance. 4. Simplified Grouping: In the new version the GROUP BY clause is removed, as the lateral joins and subqueries already handle data aggregation more efficiently. For this drizzle query ```ts const items = await db.query.comments.findMany({ limit, orderBy: comments.id, with: { user: { columns: { name: true }, }, post: { columns: { title: true }, with: { user: { columns: { name: true }, }, }, }, }, }); ``` Query that Drizzle generates now ```sql select "comments"."id", "comments"."user_id", "comments"."post_id", "comments"."content", "comments_user"."data" as "user", "comments_post"."data" as "post" from "comments" left join lateral (select json_build_array("comments_user"."name") as "data" from (select * from "users" "comments_user" where "comments_user"."id" = "comments"."user_id" limit 1) "comments_user") "comments_user" on true left join lateral (select json_build_array("comments_post"."title", "comments_post_user"."data") as "data" from (select * from "posts" "comments_post" where "comments_post"."id" = "comments"."post_id" limit 1) "comments_post" left join lateral (select json_build_array("comments_post_user"."name") as "data" from (select * from "users" "comments_post_user" where "comments_post_user"."id" = "comments_post"."user_id" limit 1) "comments_post_user") "comments_post_user" on true) "comments_post" on true order by "comments"."id" limit 1 ``` Query generated before: ```sql SELECT "id", "user_id", "post_id", "content", "user"::JSON, "post"::JSON FROM (SELECT "comments".*, CASE WHEN count("comments_post"."id") = 0 THEN '[]' ELSE json_agg(json_build_array("comments_post"."title", "comments_post"."user"::JSON))::text END AS "post" FROM (SELECT "comments".*, CASE WHEN count("comments_user"."id") = 0 THEN '[]' ELSE json_agg(json_build_array("comments_user"."name"))::text END AS "user" FROM "comments" LEFT JOIN (SELECT "comments_user".* FROM "users" "comments_user") "comments_user" ON "comments"."user_id" = "comments_user"."id" GROUP BY "comments"."id", "comments"."user_id", "comments"."post_id", "comments"."content") "comments" LEFT JOIN (SELECT "comments_post".* FROM (SELECT "comments_post".*, CASE WHEN count("comments_post_user"."id") = 0 THEN '[]' ELSE json_agg(json_build_array("comments_post_user"."name")) END AS "user" FROM "posts" "comments_post" LEFT JOIN (SELECT "comments_post_user".* FROM "users" "comments_post_user") "comments_post_user" ON "comments_post"."user_id" = "comments_post_user"."id" GROUP BY "comments_post"."id") "comments_post") "comments_post" ON "comments"."post_id" = "comments_post"."id" GROUP BY "comments"."id", "comments"."user_id", "comments"."post_id", "comments"."content", "comments"."user") "comments" LIMIT 1 ``` #### Possibility to insert rows with default values for all columns You can now provide an empty object or an array of empty objects, and Drizzle will insert all defaults into the database. ```ts // Insert 1 row with all defaults await db.insert(usersTable).values({}); // Insert 2 rows with all defaults await db.insert(usersTable).values([{}, {}]); ```
eslint/eslint (eslint) ### [`v8.47.0`](https://togithub.com/eslint/eslint/releases/tag/v8.47.0) [Compare Source](https://togithub.com/eslint/eslint/compare/v8.46.0...v8.47.0) ##### Features - [`53d7508`](https://togithub.com/eslint/eslint/commit/53d750800b1c0c1f8c29393c488bb3167bb1d2a5) feat: update regex for methods with `thisArg` ([#​17439](https://togithub.com/eslint/eslint/issues/17439)) (Francesco Trotta) ##### Bug Fixes - [`631648e`](https://togithub.com/eslint/eslint/commit/631648ee0b51a8951ce576ccd4430e09c9c8bcae) fix: do not report on shadowed constructors in `no-new-wrappers` ([#​17447](https://togithub.com/eslint/eslint/issues/17447)) (Francesco Trotta) ##### Documentation - [`a766a48`](https://togithub.com/eslint/eslint/commit/a766a48030d4359db76523d5b413d6332130e485) docs: document lack of config file names ([#​17442](https://togithub.com/eslint/eslint/issues/17442)) (James) - [`a1635d6`](https://togithub.com/eslint/eslint/commit/a1635d6198a8baf6571b3351e098e5ac960be887) docs: Update README (GitHub Actions Bot) - [`47a0859`](https://togithub.com/eslint/eslint/commit/47a08597966651975126dd6726939cd34f13b80e) docs: update `require-unicode-regexp.md` as following up [#​17402](https://togithub.com/eslint/eslint/issues/17402) ([#​17441](https://togithub.com/eslint/eslint/issues/17441)) (SUZUKI Sosuke) - [`fcdc85d`](https://togithub.com/eslint/eslint/commit/fcdc85d3a6bc14970c3349cc8d6f3a47eca172a3) docs: Update README (GitHub Actions Bot) - [`2a92b6c`](https://togithub.com/eslint/eslint/commit/2a92b6cc9520a27255520369206556e9841a3af8) docs: update with "Specifying Parser Options" ([#​17435](https://togithub.com/eslint/eslint/issues/17435)) (Cheol-Won) - [`d743ed3`](https://togithub.com/eslint/eslint/commit/d743ed3c06c62a639da0389ad27907b324ea1715) docs: add metadata for parser/processor ([#​17438](https://togithub.com/eslint/eslint/issues/17438)) (HuΓ‘ng JΓΉnliΓ ng) - [`224376c`](https://togithub.com/eslint/eslint/commit/224376cd99a08394291a9584ad9c1ea1283673c6) docs: Update README (GitHub Actions Bot) - [`a41a8e4`](https://togithub.com/eslint/eslint/commit/a41a8e4a7da14726d6fce71a023f12101fd52fdb) docs: update script names in README ([#​17432](https://togithub.com/eslint/eslint/issues/17432)) (Nitin Kumar) ##### Chores - [`bf69aa6`](https://togithub.com/eslint/eslint/commit/bf69aa6408f5403a88d8c9b71b0e58232b1ea833) chore: Update dependencies ([#​17456](https://togithub.com/eslint/eslint/issues/17456)) (Nicholas C. Zakas) - [`0e45760`](https://togithub.com/eslint/eslint/commit/0e4576012ab938b880e6f27641bff55fb4313d20) chore: package.json update for [@​eslint/js](https://togithub.com/eslint/js) release (ESLint Jenkins) - [`757bfe1`](https://togithub.com/eslint/eslint/commit/757bfe1c35b5ddab7042d388f8d21e834875fff5) chore: Remove add-to-triage ([#​17450](https://togithub.com/eslint/eslint/issues/17450)) (Nicholas C. Zakas) - [`b066640`](https://togithub.com/eslint/eslint/commit/b066640b7040ec30f740dcc803511244fe19473b) chore: standardize npm script names ([#​17431](https://togithub.com/eslint/eslint/issues/17431)) (Nitin Kumar) - [`6b2410f`](https://togithub.com/eslint/eslint/commit/6b2410f911dd2e3d915c879041c6e257d41a2f4e) chore: Update add-to-triage.yml ([#​17444](https://togithub.com/eslint/eslint/issues/17444)) (Nicholas C. Zakas) ### [`v8.46.0`](https://togithub.com/eslint/eslint/releases/tag/v8.46.0) [Compare Source](https://togithub.com/eslint/eslint/compare/v8.45.0...v8.46.0) #### Features - [`8a93438`](https://togithub.com/eslint/eslint/commit/8a9343871f7dade19d910ca8e2a4177bfca28b64) feat: `require-unicode-regexp` support `v` flag ([#​17402](https://togithub.com/eslint/eslint/issues/17402)) (SUZUKI Sosuke) - [`1a2f966`](https://togithub.com/eslint/eslint/commit/1a2f966fabe35103141d2f936180d2f1a72154db) feat: `no-useless-escape` support `v` flag ([#​17420](https://togithub.com/eslint/eslint/issues/17420)) (Yosuke Ota) - [`ee68d1d`](https://togithub.com/eslint/eslint/commit/ee68d1d9630892d99ae0d8dabe2f9f8d3b1338be) feat: `no-empty-character-class` support `v` flag ([#​17419](https://togithub.com/eslint/eslint/issues/17419)) (Milos Djermanovic) - [`853d32b`](https://togithub.com/eslint/eslint/commit/853d32baa8934c08b59a738470b72522e1505f6f) feat: deprecate no-return-await ([#​17417](https://togithub.com/eslint/eslint/issues/17417)) (Carlos Lopez) - [`d4f02e4`](https://togithub.com/eslint/eslint/commit/d4f02e4bf1b9ae4e1fc8f2bc4e4851ae3c36a127) feat: `no-control-regex` support `v` flag ([#​17405](https://togithub.com/eslint/eslint/issues/17405)) (Yosuke Ota) - [`2a35f3e`](https://togithub.com/eslint/eslint/commit/2a35f3e6ed27deafbebba48b6aec570d3abf9974) feat: `prefer-named-capture-group` support `v` flag ([#​17409](https://togithub.com/eslint/eslint/issues/17409)) (Yosuke Ota) - [`8ca8b50`](https://togithub.com/eslint/eslint/commit/8ca8b50b0425b3bad34a9505bc3095168e2f59d8) feat: Better error message for flat config plugins ([#​17399](https://togithub.com/eslint/eslint/issues/17399)) (Nicholas C. Zakas) - [`509f753`](https://togithub.com/eslint/eslint/commit/509f75395035822280245772e2a95732a0dde0e1) feat: `no-misleading-character-class` support `v` flag ([#​17406](https://togithub.com/eslint/eslint/issues/17406)) (Yosuke Ota) - [`3caf514`](https://togithub.com/eslint/eslint/commit/3caf51487decdf93a4b17765a2af2a51c337e974) feat: `no-regex-spaces` support `v` flag ([#​17407](https://togithub.com/eslint/eslint/issues/17407)) (Yosuke Ota) - [`b7fad2b`](https://togithub.com/eslint/eslint/commit/b7fad2b52f23667628cf209663795a721c88d0ba) feat: `prefer-regex-literals` support `v` flag ([#​17410](https://togithub.com/eslint/eslint/issues/17410)) (Yosuke Ota) - [`a6a3ad4`](https://togithub.com/eslint/eslint/commit/a6a3ad4ae438ea7fc3a1d97cd2555f6534b565f1) feat: `no-useless-backreference` support `v` flag ([#​17408](https://togithub.com/eslint/eslint/issues/17408)) (Yosuke Ota) - [`94954a7`](https://togithub.com/eslint/eslint/commit/94954a715448d5794f2892bf212fe986b43228ed) feat: `no-invalid-regexp` support `v` flag ([#​17404](https://togithub.com/eslint/eslint/issues/17404)) (Yosuke Ota) - [`1af6eac`](https://togithub.com/eslint/eslint/commit/1af6eac5727080c809e37c07dc729b44ef24483c) feat: adds option for allowing empty object patterns as parameter ([#​17365](https://togithub.com/eslint/eslint/issues/17365)) (Tanuj Kanti) - [`cf03104`](https://togithub.com/eslint/eslint/commit/cf03104b278fea59ef46e09f667110f5eaaf95e3) feat: Improve config error messages ([#​17385](https://togithub.com/eslint/eslint/issues/17385)) (Nicholas C. Zakas) #### Bug Fixes - [`9803c7c`](https://togithub.com/eslint/eslint/commit/9803c7c04078f0672d8a480fd39cf3bbef8017e6) fix: FlatESLint#getRulesMetaForResults shouldn't throw on unknown rules ([#​17393](https://togithub.com/eslint/eslint/issues/17393)) (Milos Djermanovic) - [`42faa17`](https://togithub.com/eslint/eslint/commit/42faa17b1c93f801b14bea2840d1d528e25c7211) fix: Update no-loop-func to not overlap with no-undef ([#​17358](https://togithub.com/eslint/eslint/issues/17358)) (Matt Wilkinson) #### Documentation - [`4d474e3`](https://togithub.com/eslint/eslint/commit/4d474e351ba6ce0242f18e55c27cb3ae17b84f63) docs: update with TypeScript info ([#​17423](https://togithub.com/eslint/eslint/issues/17423)) (James) - [`091f44e`](https://togithub.com/eslint/eslint/commit/091f44e4c72007edb2ac6d4db4eafa5501e41e94) docs: File extension named processor deprecation ([#​17362](https://togithub.com/eslint/eslint/issues/17362)) (Matt Wilkinson) - [`9254a6c`](https://togithub.com/eslint/eslint/commit/9254a6cea845dfaf2f3f52f718cb9b071853aa09) docs: Update README (GitHub Actions Bot) - [`6d6dc51`](https://togithub.com/eslint/eslint/commit/6d6dc5141f535728029eef8735854a421bc08eba) docs: fix overlapping of `open in playground` button ([#​17403](https://togithub.com/eslint/eslint/issues/17403)) (Tanuj Kanti) - [`7fc3a2c`](https://togithub.com/eslint/eslint/commit/7fc3a2ce68979a2c2a6fc779e647b3004ab6f4ac) docs: Add private class features info to no-underscore-dangle ([#​17386](https://togithub.com/eslint/eslint/issues/17386)) (Matt Wilkinson) - [`da73e58`](https://togithub.com/eslint/eslint/commit/da73e583e1703a420551d8fa8f7c70b56dc88dd5) docs: Migrating `eslint-env` configuration comments ([#​17390](https://togithub.com/eslint/eslint/issues/17390)) (Francesco Trotta) - [`80dffed`](https://togithub.com/eslint/eslint/commit/80dffed4c81dcc71fb72bc187aff2f87d141a6ed) docs: fix Ignoring Files section in config migration guide ([#​17392](https://togithub.com/eslint/eslint/issues/17392)) (Milos Djermanovic) - [`8a9abb7`](https://togithub.com/eslint/eslint/commit/8a9abb7cf424bd49d45c09345dc45ae95f29cc9d) docs: Update README (GitHub Actions Bot) - [`7e9be4b`](https://togithub.com/eslint/eslint/commit/7e9be4bd7331d0e8e8e0af0b075a2f6d28d1bea3) docs: Update README (GitHub Actions Bot) - [`0b0bbe0`](https://togithub.com/eslint/eslint/commit/0b0bbe07d4fb0870f3916e975b8ec6978f838077) docs: Update README (GitHub Actions Bot) #### Chores - [`d1eb7e4`](https://togithub.com/eslint/eslint/commit/d1eb7e46e954c64af8d7d13d087b3a18f43e6d72) chore: Update ecosystem dependencies ([#​17427](https://togithub.com/eslint/eslint/issues/17427)) (Nicholas C. Zakas) - [`fab9e97`](https://togithub.com/eslint/eslint/commit/fab9e97ef9dff40e98a5b3b97bdd3b0ff5439d46) chore: package.json update for eslint-config-eslint release (ESLint Jenkins) - [`6246711`](https://togithub.com/eslint/eslint/commit/6246711e0650d03afe044c36acde048ed2d39ee3) chore: package.json update for [@​eslint/js](https://togithub.com/eslint/js) release (ESLint Jenkins) - [`0aa0bc3`](https://togithub.com/eslint/eslint/commit/0aa0bc365a5425440c8e86c96104d0053a51b602) chore: Add PRs to triage project ([#​17421](https://togithub.com/eslint/eslint/issues/17421)) (Nicholas C. Zakas)
prettier/eslint-config-prettier (eslint-config-prettier) ### [`v8.10.0`](https://togithub.com/prettier/eslint-config-prettier/blob/HEAD/CHANGELOG.md#Version-8100-2023-08-03) [Compare Source](https://togithub.com/prettier/eslint-config-prettier/compare/v8.9.0...v8.10.0) - Added: \[max-statements-per-line]. Thanks to [@​Zamiell](https://togithub.com/Zamiell)! ### [`v8.9.0`](https://togithub.com/prettier/eslint-config-prettier/blob/HEAD/CHANGELOG.md#Version-890-2023-07-27) [Compare Source](https://togithub.com/prettier/eslint-config-prettier/compare/v8.8.0...v8.9.0) - Added: \[vue/array-element-newline]. Thanks to [@​xcatliu](https://togithub.com/xcatliu)!
lucide-icons/lucide (lucide-svelte) ### [`v0.268.0`](https://togithub.com/lucide-icons/lucide/releases/tag/0.268.0): New icons 0.268.0 [Compare Source](https://togithub.com/lucide-icons/lucide/compare/0.267.0...0.268.0) ### [`v0.267.0`](https://togithub.com/lucide-icons/lucide/releases/tag/0.267.0): New icons 0.267.0 [Compare Source](https://togithub.com/lucide-icons/lucide/compare/0.266.0...0.267.0) #### New icons 🎨 - `database-zap` ([#​1400](https://togithub.com/lucide-icons/lucide/issues/1400)) by [@​danielbayley](https://togithub.com/danielbayley) #### Modified Icons πŸ”¨ - `database-backup` ([#​1400](https://togithub.com/lucide-icons/lucide/issues/1400)) by [@​danielbayley](https://togithub.com/danielbayley) ### [`v0.266.0`](https://togithub.com/lucide-icons/lucide/releases/tag/0.266.0): New icons 0.266.0 [Compare Source](https://togithub.com/lucide-icons/lucide

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.

πŸ‘» Immortal: This PR will be recreated if closed unmerged. Get config help if that's undesired.

This PR has been generated by Mend Renovate. View repository job log here.

vercel[bot] commented 1 year ago

The latest updates on your projects. Learn more about Vercel for Git β†—οΈŽ

Name Status Preview Comments Updated (UTC)
queued βœ… Ready (Inspect) Visit Preview πŸ’¬ Add feedback Aug 21, 2023 7:00pm