langgenius/dify

[Refactor/Chore] use sqlite3 or Testcontainers to do sql test

Open

#32,454 opened on Feb 21, 2026

View on GitHub
 (36 comments) (1 reaction) (3 assignees)TypeScript (22,210 forks)batch import
good first issueno-issue-activityproject#dify🙏 help wanted

Repository metrics

Stars
 (141,412 stars)
PR merge metrics
 (Avg merge 2d 1h) (508 merged PRs in 30d)

Description

Self Checks

  • I have read the Contributing Guide and Language Policy.
  • This is only for refactors or chores; if you would like to ask a question, please head to Discussions.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report, otherwise it will be closed.
  • 【中文用户 & Non English User】请使用英语提交，否则会被关闭 ：）
  • Please do not modify this template :) and fill in all the required fields.

Description

now it's hard to do SQL improvement since all the query is patch.

https://github.com/langgenius/dify/pull/38159

or

Testcontainers will be much easier.

Motivation

Improve DX

Additional Context

Chat with llm https://g.co/gemini/share/abe5288b661a (chat is in Chinese).

Contributor guide

Research direction
Understand the current SQL test setup, identify queries that need testing, configure Testcontainers with Docker, and replace existing patch based tests.
Tech stack
typescriptsql
Domain
backendtesting
Issue type
Refactor
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
TypeScriptSQLGitDocker
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60