Page MenuHomePhabricator
Create Task
Maniphest T426808

Use node native sqlite in cxserver
Closed, ResolvedPublic2 Estimated Story Points
Actions

Description

cxserver has two dependencies for its sqlite usage. sqlite and sqlite3. sqlite last release was 3 years ago. sqlite3 package is deprecated. Given the increasing supply chain attacks and security issues around node package ecosystem, less dependencies are always better.

I propose to replace these dependecies node native sqlite which became stable in Node 24.

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Update cxserver to 2026-05-24-103047-productionoperations/deployment-chartsmaster+2 -2
scripts: migrate sqlite to node:sqlite (Node 24+)mediawiki/services/cxservermaster+53 -1 K
SectionSuggester: migrate sqlite to node:sqlite (Node 24+)mediawiki/services/cxservermaster+9 -8
TemplateTransclusion: migrate sqlite to node:sqlite (Node 24+)mediawiki/services/cxservermaster+17 -14
Customize query in gerrit

Related Objects

Event Timeline

santhosh created this task.Wed, May 20, 6:28 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptWed, May 20, 6:28 AM
gerritbot added a comment.Wed, May 20, 6:34 AM

Change #1289741 had a related patch set uploaded (by Santhosh; author: Santhosh):

[mediawiki/services/cxserver@master] alignwithmt: migrate sqlite to node:sqlite (Node 24+)

https://gerrit.wikimedia.org/r/1289741

gerritbot added a project: Patch-For-Review.Wed, May 20, 6:34 AM

Change #1289739 had a related patch set uploaded (by Santhosh; author: Santhosh):

[mediawiki/services/cxserver@master] TemplateTransclusion: migrate sqlite to node:sqlite (Node 24+)

https://gerrit.wikimedia.org/r/1289739

gerritbot added a comment.Wed, May 20, 6:34 AM

Change #1289740 had a related patch set uploaded (by Santhosh; author: Santhosh):

[mediawiki/services/cxserver@master] SectionSuggester: migrate sqlite to node:sqlite (Node 24+)

https://gerrit.wikimedia.org/r/1289740

santhosh changed the task status from Open to In Progress.Wed, May 20, 6:35 AM
santhosh claimed this task.
santhosh triaged this task as Medium priority.
santhosh added a project: LPL Essential (FY2025-26 Q3&4).
santhosh moved this task from Backlog to In Progress on the LPL Essential (FY2025-26 Q3&4) board.
Nikerabbit added projects: LPL Projects (Other), Unplanned-Sprint-Work.Wed, May 20, 1:52 PM
Nikerabbit set the point value for this task to 2.
gerritbot added a comment.Wed, May 20, 3:43 PM

Change #1289739 merged by KartikMistry:

[mediawiki/services/cxserver@master] TemplateTransclusion: migrate sqlite to node:sqlite (Node 24+)

https://gerrit.wikimedia.org/r/1289739

gerritbot added a comment.Thu, May 21, 12:03 PM

Change #1289740 merged by jenkins-bot:

[mediawiki/services/cxserver@master] SectionSuggester: migrate sqlite to node:sqlite (Node 24+)

https://gerrit.wikimedia.org/r/1289740

gerritbot added a comment.Sun, May 24, 10:30 AM

Change #1289741 merged by jenkins-bot:

[mediawiki/services/cxserver@master] scripts: migrate sqlite to node:sqlite (Node 24+)

https://gerrit.wikimedia.org/r/1289741

Maintenance_bot removed a project: Patch-For-Review.Sun, May 24, 10:30 AM
gerritbot added a comment.Mon, May 25, 6:21 AM

Change #1292915 had a related patch set uploaded (by KartikMistry; author: KartikMistry):

[operations/deployment-charts@master] Update cxserver to 2026-05-24-103047-production

https://gerrit.wikimedia.org/r/1292915

gerritbot added a project: Patch-For-Review.Mon, May 25, 6:21 AM
KartikMistry moved this task from In Progress to Pending Deployment on the LPL Essential (FY2025-26 Q3&4) board.Mon, May 25, 12:10 PM
gerritbot added a comment.Mon, May 25, 12:38 PM

Change #1292915 merged by jenkins-bot:

[operations/deployment-charts@master] Update cxserver to 2026-05-24-103047-production

https://gerrit.wikimedia.org/r/1292915

Stashbot mentioned this in T373418: Error response structure is not as documented.Mon, May 25, 12:58 PM

Mentioned in SAL (#wikimedia-operations) [2026-05-25T12:58:52Z] <kart_> Updated cxserver to 2026-05-24-103047-production (T426808, T373418)

KartikMistry moved this task from Pending Deployment to Done on the LPL Essential (FY2025-26 Q3&4) board.Mon, May 25, 12:59 PM
Maintenance_bot removed a project: Patch-For-Review.Mon, May 25, 1:31 PM
Nikerabbit closed this task as Resolved.Mon, Jun 1, 11:11 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits