Database component

WordPress database abstraction is implemented at wp-db.php.

Recent posts on the make/coreCore Core is the set of software required to run WordPress. The Core Development Team builds WordPress. blogblog (versus network, site)

View all posts tagged database.

163 open tickets in the Database component

163 open tickets defect (bug) enhancement feature request
9 13 0
Awaiting Review 62 44 7
Future Release 10 16 2

163 open tickets. Last 7 days: -1 ticketticket Created for both bug reports and feature development on the bug tracker.

52 tickets that have no replies

View list on Trac

  • #28139  WP MU legacy problems: missing database tables administration multisitemultisite Used to describe a WordPress installation with a network of multiple blogs, grouped by sites. This installation type has shared users tables, and creates separate database tables for each blog (wp_posts becomes wp_0_posts). See also network, blog, site
  • #28591  dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP)
  • #31759  Allow to set $allow_bail when creating new wpdb object to handle connection error silently
  • #32868  Consider running utf8mb4 conversion on each database update
  • #35256  $wpdb->insert_id equals 0
  • #36242  wpdb set_sql_mode add param performance
  • #39273  Updating to 4.7 can break serialized data because $wpdb->determine_charset now forces utf8 when DB_CHARSET is set to utf8mb4
  • #39748  Function to insert or update DB value
  • #40150  VARCHAR/TEXT inefficiencies
  • #42703  WP_Query: Swap parsing date into own method
  • #44292  Make use of protected process_fields
  • #44386  Problem with utf8mb4_unicode_ci collation for arabic content
  • #44973  Issues with $wpdb->get_col_info
  • #46145  dbDelta runs same updates on every execution
  • #46179  Make fetch_array accessible in $wpdb performance
  • #46287  Add insert_ignore() method to wpdb to avoid unecessary boilerplate code
  • #46452  dbDelta given the same PRIMARY KEY and normal KEY produces no error, reports table created successfully, but the table is not created
  • #46565  Mixed engine in tables, could bring to major WP failure! Also there is a small fix that could avoid that.
  • #46576  short-circuit filterFilter Filters are one of the two types of Hooks https://codex.wordpress.org/Plugin_API/Hooks. They provide a way for functions to modify data of other functions. They are the counterpart to Actions. Unlike Actions, filters are meant to work in an isolated manner, and should never have side effects such as affecting global variables and output. for dbDelta
  • #46739  post attributes order not working correctly
  • #46923  $wpdb->get_var() — empty sting becomes a NULL
  • #46932  dbDelta does not account for MySQLMySQL MySQL is a relational database management system. A database is a structured collection of data where content, configuration and other options are stored. https://www.mysql.com/. keywords being used as key names administration
  • #47818  $wpdb should update ->insert_id also when `LAST_INSERT_ID(…)` is found
  • #47994  The additions of a new wp_posts table columns called post_level and post_patriarch
  • #49363  wpdb::query() does not detect LOAD DATA as an insert statement type
  • #49482  Non-english slug can sometimes cause an error in WordPress query
  • #49654  maybe_drop_table
  • #51762  Unix authentication support via unix_socket
  • #52527  Better RAM handling in wp-db.php
  • #53033  Remove comments, pingPing The act of sending a very small amount of data to an end point. Ping is used in computer science to illicit a response from a target server to test it’s connection. Ping is also a term used by Slack users to @ someone or send them a direct message (DM). Users might say something along the lines of “Ping me when the meeting starts.”, to_ping columns from posts table
  • #53320  Why delete_metadata and update_metadata slow performance? performance
  • #54235  Script for handling metadata in wp_postmeta
  • #54560  Return null from wpdb::get_results when query fails
  • #54627  Adding More Timestamp columns to database
  • #54834  Mysql gone away when importing DB on create wp_posts indexes
  • #55202  A proper (error) message should be show when mysql setting autocommit=0
  • #55907  Failed to insert log entry: value too long
  • #55938  WP prefix on installation – instructions to be indicated
  • #57000  wp_usermeta table is emptied because of a wrong query being executed
  • #57072  WordPress 6.1 uses wrong database collation
  • #58180  Specify the REGEXP format for meta_query
  • #58559  Database error bugbug A bug is an error or unexpected result. Performance improvements, code optimization, and are considered enhancements, not defects. After feature freeze, only bugs are dealt with, with regressions (adverse changes from the previous version) being the highest priority. in wordpress current version
  • #58694  Enhancementenhancement Enhancements are simple improvements to WordPress, such as the addition of a hook, a new feature, or an improvement to an existing feature. in wordpress Database APIAPI An API or Application Programming Interface is a software intermediary that allows programs to interact with each other and share data in limited, clearly defined ways.
  • #58826  Please add a default post relations table
  • #59106  Add secondary index on `wp_posts` table to improve media queries performance
  • #59281  Support for Database Cursor
  • #59639  Dedicated tables for media libary performance sustainability
  • #59974  MAX_JOIN_SIZE wp-blog-header.php
  • #60077  Class UnexpectedValueException not found
  • #60254  Add filter to class-wpdb.php#query that allows to return data from filter return value
  • #60983  wp update 6.5 and 6.5.2 rewrite multisite bdd entries wp_options.siteurl and wp_options.home
  • #62104  Multisite triggers UPDATE queries on _sitemeta of almost 150k character

163 open tickets

Open enhancements: 73 View list on Trac
Open tasks: 0 View list on Trac
Open feature requests: 9 View list on Trac
Open defects: 81 View list on Trac

Help maintain this component

Component maintainers:

Many contributors help maintain one or more components. These maintainers are vital to keeping WordPress development running as smoothly as possible. They triagetriage The act of evaluating and sorting bug reports, in order to decide priority, severity, and other factors. new tickets, look after existing ones, spearhead or mentor tasks, pitch new ideas, curate roadmaps, and provide feedback to other contributors. Longtime maintainers with a deep understanding of particular areas of Core are always seeking to mentor others to impart their knowledge.

Want to help? Start following this component! Adjust your notifications here. Feel free to dig into any ticket.

Contributors following this component: