8000
Skip to content

refactor: Add deprecation notice for MySQL and MariaDB#6189

Merged
krynble merged 2 commits intomasterfrom
n8n-6324-mark-mysql-mariadb-as-deprecated-in-docs
May 8, 2023
Merged

refactor: Add deprecation notice for MySQL and MariaDB#6189
krynble merged 2 commits intomasterfrom
n8n-6324-mark-mysql-mariadb-as-deprecated-in-docs

Conversation

@krynble
Copy link
Copy Markdown
Contributor
@krynble krynble commented May 5, 2023

Github issue / Community forum post (link here to close automatically):

@github-actions
Copy link
Copy Markdown
Contributor
github-actions bot commented May 5, 2023

Great PR! Please pay attention to the following items before merging:

Files matching packages/**:

  • If fixing bug, added test to cover scenario.
  • If addressing forum or Github issue, added link to description.

Files matching packages/**/*.ts:

  • Added unit tests to cover new or updated functionality.

Make sure to check off this list before asking for review.

@codecov
Copy link
Copy Markdown
codecov bot commented May 5, 2023

Codecov Report

Patch coverage: 33.33% and no project coverage change.

Comparison is base (82fe638) 20.08% compared to head (b7c3571) 20.08%.

Additional details and impacted files
@@           Coverage Diff           @@
##           master    #6189   +/-   ##
=======================================
  Coverage   20.08%   20.08%           
=======================================
  Files        2626     2626           
  Lines      118218   118221    +3     
  Branches    18572    18573    +1     
=======================================
+ Hits        23740    23741    +1     
- Misses      93758    93760    +2     
  Partials      720      720           
Impacted Files Coverage Ξ”
packages/cli/src/config/schema.ts 37.50% <ΓΈ> (ΓΈ)
packages/cli/src/commands/BaseCommand.ts 55.55% <33.33%> (-1.12%) ⬇️

β˜” View full report in Codecov by Sentry.
πŸ“’ Do you have feedback about the report comment? Let us know in this issue.

@n8n-assistant n8n-assistant bot added core Enhancement outside /nodes-base and /editor-ui n8n team Authored by the n8n team labels May 5, 2023
Co-authored-by: Cornelius Suermann <cornelius@n8n.io>
@github-actions
Copy link
Copy Markdown
Contributor
github-actions bot commented May 5, 2023

βœ… All Cypress E2E specs passed

@krynble krynble merged commit 0673a39 into master May 8, 2023
@krynble krynble deleted the n8n-6324-mark-mysql-mariadb-as-deprecated-in-docs branch May 8, 2023 10:16
MiloradFilipovic added a commit that referenced this pull request May 9, 2023
* master: (31 commits)
  feat(Date & Time Node): Overhaul of the node (#5904)
  refactor: Add deprecation notice for WEBHOOK_TUNNEL_URL (#6194)
  refactor: Add deprecation notice for WEBHOOK_TUNNEL_URL (#6194)
  feat(HubSpot Node): Overhaul the HubSpot Node (#4337)
  ci: Create a nightly v1 docker image (no-changelog) (#6197)
  refactor(core): Add deprecation notice for own mode (#6195)
  feat(core): Update config defaults for for v1 (no-changelog) (#6196)
  test(Read Binary Files Node): Unit tests (no-changelog) (#5459)
  refactor: Add deprecation notice for MySQL and MariaDB (#6189)
  test: Create custom jest error messages using jest-expect-message (no-changelog) (#5666)
  fix(core): Move nodeExecute InternalHook calls to hookFunctionsSave (#6193)
  fix(FTP Node): Use filename instead of remote filepath for downloaded binary data (#6170)
  ci: Fix test database cleanup (no-changelog) (#6188)
  refactor(core): Delete boilerplate code across migrations (no-changelog) (#5254)
  refactor(editor): Add infix to Pinia stores (no-changelog) (#6149)
  ci: Fix linting issues on master (no-changelog) (#6186)
  fix(editor): Update and add design system checkbox component to Editor (#6178)
  fix(editor): Display SSO entry in Settings on Cloud (#6181)
  feat(Code Node): Add Python support (#4295)
  fix(editor): Update and fix storybook (was failing to run in local dev mode) (#6180)
  ...

# Conflicts:
#	packages/editor-ui/src/stores/nodeTypes.store.ts
#	packages/nodes-base/nodes/Postgres/Postgres.node.ts
#	packages/nodes-base/nodes/Postgres/v2/actions/versionDescription.ts
MiloradFilipovic added a commit that referenced this pull request May 9, 2023
…rce-mapper-ui-P2

* feature/resource-mapping-component: (31 commits)
  feat(Date & Time Node): Overhaul of the node (#5904)
  refactor: Add deprecation notice for WEBHOOK_TUNNEL_URL (#6194)
  refactor: Add deprecation notice for WEBHOOK_TUNNEL_URL (#6194)
  feat(HubSpot Node): Overhaul the HubSpot Node (#4337)
  ci: Create a nightly v1 docker image (no-changelog) (#6197)
  refactor(core): Add deprecation notice for own mode (#6195)
  feat(core): Update config defaults for for v1 (no-changelog) (#6196)
  test(Read Binary Files Node): Unit tests (no-changelog) (#5459)
  refactor: Add deprecation notice for MySQL and MariaDB (#6189)
  test: Create custom jest error messages using jest-expect-message (no-changelog) (#5666)
  fix(core): Move nodeExecute InternalHook calls to hookFunctionsSave (#6193)
  fix(FTP Node): Use filename instead of remote filepath for downloaded binary data (#6170)
  ci: Fix test database cleanup (no-changelog) (#6188)
  refactor(core): Delete boilerplate code across migrations (no-changelog) (#5254)
  refactor(editor): Add infix to Pinia stores (no-changelog) (#6149)
  ci: Fix linting issues on master (no-changelog) (#6186)
  fix(editor): Update and add design system checkbox component to Editor (#6178)
  fix(editor): Display SSO entry in Settings on Cloud (#6181)
  feat(Code Node): Add Python support (#4295)
  fix(editor): Update and fix storybook (was failing to run in local dev mode) (#6180)
  ...

# Conflicts:
#	packages/editor-ui/src/stores/nodeTypes.store.ts
@janober
Copy link
Copy Markdown
Member
janober commented May 25, 2023

Got released with n8n@0.228.2

@luizeof
Copy link
Copy Markdown
Contributor
luizeof commented Jun 2, 2023

Hello @janober @Joffcom, is there any prediction of version or date for mysql to become deprecated? This is important to organize the community to migrate to postgres.

Will SQLite be maintained?

@Joffcom
Copy link
Copy Markdown
Member
Joffcom commented Jun 2, 2023

Hey @luizeof

It is being removed in 1.0 which will be available in a few weeks.

SQLite will remain as the default option. You can find a list of the breaking 1.0 changes here: https://docs.n8n.io/1-0-preview/

@csuermann
Copy link
Copy Markdown
Contributor

Quick update: We decided not to remove support for MySQL / MariaDB in the upcoming version 1 just yet, but it is still advisable to switch to PostgreSQL or SQLite.

@Soetens
Copy link
Copy Markdown
Soetens commented Jul 28, 2023

Quick update: We decided not to remove support for MySQL / MariaDB in the upcoming version 1 just yet, but it is still advisable to switch to PostgreSQL or SQLite.

To be sure, this is about the storage of n8n itself and not about the mysql node?

@Joffcom
Copy link
Copy Markdown
Member
Joffcom commented Jul 29, 2023

@Soetens you got it πŸ‘ this is just for the backend and not the node.

@axot
Copy link
Copy Markdown
axot commented Apr 24, 2025

I’d like to continue supporting MySQL. Is there any free PostgreSQL service available? For MySQL, i'm using TiDB Serverless.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

core Enhancement outside /nodes-base and /editor-ui n8n team Authored by the n8n team Released skip-e2e

Projects

None yet

Development

Successfully merging this pull request may close these issues.

7 participants

0