Page MenuHomePhabricator
Create Task
Maniphest T343098

[epic] Data Persistence Hypothesis WE 3.2.1
Open, Needs TriagePublic
Actions

Description

If we provide replacement for selected confusing, counter-intuitive and unsafe to use APIs of the MediaWiki RDBMS library and deprecate certain functionalities (e.g accepting raw SQL) that will incentivize more developers to contribute and take ownership. This can take the form of direct implementation as well as providing support for other developers in the form of knowledge transfer and code reviews.

Related Objects
Search...

StatusSubtypeAssignedTask
 OpenLadsgroupT343098 [epic] Data Persistence Hypothesis WE 3.2.1
 ResolvedLadsgroupT335377 Create QueryBuilders for common database queries
 ResolvedLadsgroupT335378 Introduce DeleteQueryBuilder
 ResolvedLadsgroupT326274 Reduce complexity of LB and LBF (introducing IConnectionProvider)
 ResolvedLadsgroupT325389 Deprecate ILoadBalancer::getAnyOpenConnection()
 ResolvedLadsgroupT343917 Support ReadOnlyMode without internal LoadBalancer
 OpenLadsgroupT344971 Migrate Database::select usages to SelectQueryBuilder in MediaWiki core
 ResolvedLadsgroupT275713 Misc ChronologyProtector follow-up (Feb 2021)
 OpenLadsgroupT210206 Deprecate raw SQL conditions for IDatabase methods (select, insert, etc.)
 DeclinedFeatureNoneT29646 Implement Database util method for BETWEEN operator
 ResolvedaaronT318845 Disallow passing raw subqueries to IDatabase::tableName
Restricted Task
 ResolvedLadsgroupT334661 rdbms: Find a way to use IDatabase::unionConditionPermutations without raw SQL
 ResolvedLadsgroupT326181 Stop doing regex on SQL in Database
 ResolvedLucas_Werkmeister_WMDET332941 Warning: SQLPlatform::isWriteQuery fallback to regex (from Wikibase EntityUsageTable)
 ResolvedLadsgroupT332942 Warning: SQLPlatform::isWriteQuery fallback to regex (from ApiQueryRevisions)
 ResolvedLucas_Werkmeister_WMDET333339 Warning: SQLPlatform::isWriteQuery fallback to regex (from SpecialRecentChangesLinked)
 ResolvedLucas_Werkmeister_WMDET333686 Warning: SQLPlatform::isWriteQuery fallback to regex (GoogleNewsSitemap)
 ResolvedLucas_Werkmeister_WMDET333687 Warning: SQLPlatform::isWriteQuery fallback to regex (ContentTranslation)
 ResolvedLucas_Werkmeister_WMDET333688 Warning: SQLPlatform::isWriteQuery fallback to regex (CentralNotice)
 ResolvedLucas_Werkmeister_WMDET335100 Warning: SQLPlatform::isWriteQuery fallback to regex (SpecialShortPages)
 ResolvedLucas_Werkmeister_WMDET333690 rdbms: Add way to issue UNION queries without raw SQL
 ResolvedLadsgroupT335630 Switch calls to ::query() in DatabaseSqlite to use Query object
 ResolvedLadsgroupT335631 Switch calls to ::query() in DatabasePostgres to use Query object
 OpenNoneT352191 Merge or simplify ILoadBalancer::hasReplicaServers() and ::hasStreamingReplicaServers()
 ResolvedLadsgroupT314908 MediaWiki database schemas should have a way to indicate the DB/cluster
 ResolvedLadsgroupT330590 External LBs should not be exposed to developers
 OpenNoneT237839 Wire abstract schema and schema changes for extension
 OpenLadsgroupT354194 Redesign DBAccessObjectUtils
 ResolvedDaimonaT360517 Stop using DBAccessObjectUtils::getDBOptions in CampaignEvents
 ResolvedDaimonaT361026 Remove the ICampaignsDatabase abstraction
 OpenNoneT348281 Make the CampaignEvents database configuration use the new DatabaseVirtualDomains config

Event Timeline

KOfori created this task.Jul 30 2023, 5:29 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 30 2023, 5:29 PM
Ladsgroup added subtasks: T311866: Migrate Database::select usages to SelectQueryBuilder (in WMF-deployed extensions), T335377: Create QueryBuilders for common database queries.Jul 31 2023, 9:45 AM
Ladsgroup added a subtask: T326274: Reduce complexity of LB and LBF (introducing IConnectionProvider).Aug 1 2023, 10:02 AM
Ladsgroup edited subtasks, added: T344971: Migrate Database::select usages to SelectQueryBuilder in MediaWiki core, T275713: Misc ChronologyProtector follow-up (Feb 2021); removed: T311866: Migrate Database::select usages to SelectQueryBuilder (in WMF-deployed extensions).Aug 25 2023, 6:53 AM
Ladsgroup added a subtask: T210206: Deprecate raw SQL conditions for IDatabase methods (select, insert, etc.).
Ladsgroup added a subtask: T326181: Stop doing regex on SQL in Database.Aug 25 2023, 7:00 AM
Ladsgroup closed subtask T275713: Misc ChronologyProtector follow-up (Feb 2021) as Resolved.Sep 5 2023, 6:24 PM
Ladsgroup closed subtask T335377: Create QueryBuilders for common database queries as Resolved.Sep 12 2023, 9:18 AM
Ladsgroup closed subtask T326274: Reduce complexity of LB and LBF (introducing IConnectionProvider) as Resolved.Nov 28 2023, 3:56 PM
Ladsgroup added a subtask: T314908: MediaWiki database schemas should have a way to indicate the DB/cluster.Dec 22 2023, 3:55 PM
Ladsgroup added a subtask: T237839: Wire abstract schema and schema changes for extension.
Ladsgroup closed subtask T314908: MediaWiki database schemas should have a way to indicate the DB/cluster as Resolved.
Ladsgroup added a subtask: T354194: Redesign DBAccessObjectUtils.Jan 2 2024, 2:42 PM
Jdforrester-WMF subscribed.Feb 1 2024, 6:24 PM
Ladsgroup mentioned this in T314020: LoadMonitor connection weighting reimagined.Feb 16 2024, 9:55 PM
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