Database component

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

Recent posts on the make/core blog

View all posts tagged database.

104 open tickets in the Database component

104 open tickets defect (bug) enhancement feature request
12 14 1
5.3 1 2 0
Awaiting Review 34 21 1
Future Release 8 9 1

104 open tickets. Last 7 days: +0 tickets

33 tickets that have no replies

View list on Trac

  • #28139  WP MU legacy problems: missing database tables administration multisite
  • #28591  dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP)
  • #31624  $wpdb->prepare() named placeholders
  • #31759  Allow to set $allow_bail when creating new wpdb object to handle connection error silently
  • #32798  Add support for mysql named pipe (windows os) performance
  • #32868  Consider running utf8mb4 conversion on each database update
  • #35256  $wpdb->insert_id equals 0
  • #36242  wpdb set_sql_mode add param performance
  • #37984  Relocate either dbDelta() or wp_should_upgrade_global_tables() out of upgrade.php 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
  • #40446  Status: "InnoDB: Error: Trying to do i/o to a tablespace which exists without .ibd data file. i/o type 10, space id 102077, page no 0, i/o length 16384 bytes"
  • #40779  function_exists() audit in wp-db.php
  • #42352  Support use of native MySQLi prepared queries
  • #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
  • #44586  SQL mode test results broken in MySQL 8.0.11
  • #44973  Issues with $wpdb->get_col_info
  • #45607  Table prefix makes WordPress
  • #46145  dbDelta runs same updates on every execution
  • #46146  dbDelta not parsing enum correctly
  • #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 filter for dbDelta
  • #46739  post attributes order not working correctly
  • #46923  $wpdb->get_var() — empty sting becomes a NULL
  • #46932  dbDelta does not account for MySQL keywords being used as key names administration
  • #47280  SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17
  • #47430  wp-db: Always adds a filter on every query

3 tickets slated for 5.3

View list in Trac

  • #42151  Create a filter to add information to query data saved when SAVEQUERIES is true
  • #45604  Docs: Added description for global $wpdb docs
  • #47430  wp-db: Always adds a filter on every query

104 open tickets

Open bugs: 55. 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 triage 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: