Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Mauricio Gelves - WordPress Database: What’s be...

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for WordPress Greek Community WordPress Greek Community PRO
November 19, 2016
Programming
530
2

Mauricio Gelves - WordPress Database: What’s behind those 12 tables - WordCamp Athens 2016

Avatar for WordPress Greek Community

WordPress Greek Community PRO

November 19, 2016

More Decks by WordPress Greek Community

See All by WordPress Greek Community
Filippos Karailanidis - Beyond ChatGPT: AI Toolkit for the WordPress Developer
Avatar for WordPress Greek Community wpgr
PRO
0
27
Orestis Samaras - Modern WordPress Development with Composer
Avatar for WordPress Greek Community wpgr
PRO
0
20
Eleni Tsertou - Ταχύτερο website με Persistent Object Cache: Μύθος ή Αλήθεια;
Avatar for WordPress Greek Community wpgr
PRO
0
20
George Korakas - WordPress Security 2025: From Real Threats to Practical Defenses
Avatar for WordPress Greek Community wpgr
PRO
0
23
Δημήτρης Καρβούνης - Πέρα από το Admin Panel: Πώς να μιλήσεις στο WordPress σαν Developer μέσω REST API
Avatar for WordPress Greek Community wpgr
PRO
0
17
Αναστασία Αδαμούδη - Δημιουργία σύνθετου μενού πλοήγησης σε block θέματα
Avatar for WordPress Greek Community wpgr
PRO
0
11
Νίκος Μαυράκης - Κοστολογώντας τη δημιουργικότητα
Avatar for WordPress Greek Community wpgr
PRO
0
23
Jovana Smoljanovic Tucakov - AI vs. Human Content: What Works, What Backfires, and What’s Next
Avatar for WordPress Greek Community wpgr
PRO
0
15
Λεωνίδας Μηλώσης - Optimize – optimize – optimize: Caring for performance of your WordPress plugin or website
Avatar for WordPress Greek Community wpgr
PRO
0
18

Other Decks in Programming

See All in Programming
AI時代の脳疲弊と向き合う ~言語学としてのPHP~
Avatar for Sakurai sakuraikotone
1
1.8k
CS教育のDX AIによる育成の効率化
Avatar for ニフティ株式会社 niftycorp
PRO
0
170
Migration to Signals, Signal Forms, Resource API, and NgRx Signal Store @Angular Days 03/2026 Munich
Avatar for Manfred Steyer manfredsteyer
PRO
0
200
2026-03-27 #terminalnight 変数展開とコマンド展開でターミナル作業をスマートにする方法
Avatar for SUZUKI Masashi masasuzu
0
270
存在論的プログラミング： 時間と存在を記述する
Avatar for Akihito Koriyama koriym
5
720
Claude Codeログ基盤の構築
Avatar for giginet giginet
PRO
7
3.8k
Linux Kernelの1文字のミスで 権限昇格ができた話
Avatar for rona rqda
0
2.2k
Everything Claude Code OSS詳細 — 5層構造の中身と導入方法
Avatar for techs-targe targe
0
160
RSAが破られる前に知っておきたい 耐量子計算機暗号(PQC)入門 / Intro to PQC: Preparing for the Post-RSA Era
Avatar for mackey0225 mackey0225
3
100
GoのDB アクセスにおける 「型安全」と「柔軟性」の両立 - Bob という選択肢
Avatar for tak tak848
0
290
車輪の再発明をしよう！PHP で実装して学ぶ、Web サーバーの仕組みと HTTP の正体
Avatar for H1R0 h1r0
2
470
20260320登壇資料
Avatar for 松井遼(まついはるか) pharct
0
140

Featured

See All Featured
Exploring anti-patterns in Rails
Avatar for Elle Meredith aemeredith
2
300
A better future with KSS
Avatar for Kyle Neath kneath
240
18k
What the history of the web can teach us about the future of AI
Avatar for Ines Montani inesmontani
PRO
1
500
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
0
850
Organizational Design Perspectives: An Ontology of Organizational Design Elements
Avatar for Dr. Kim W Petersen kimpetersen
PRO
1
660
Deep Space Network (abreviated)
Avatar for Tony Rice tonyrice
0
98
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.2k
Un-Boring Meetings
Avatar for Sebastian Deterding codingconduct
0
250
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
2
880
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.4k
The Curse of the Amulet
Avatar for Matthew Lei leimatthew05
1
11k
Practical Orchestrator
Avatar for Shlomi Noach shlominoach
191
11k

Transcript

  1. WordPress Database: What’s behind those 12 tables? Mauricio Gelves |

    @maugelves

  2. Do you know this Masterpiece?

  3. None
  4. None
  5. None

  6. A love story

  7. None

  8. Set of columns Data types Indexes The table anatomy

  9. Table rows

  10. I’m Rebel!

  11. Normalization

  12. Process to avoid: • Data redundancy • Unnecessary updates •

    Data integrity problems
  13. None
  14. None
  15. None
  16. None
  17. None

  18. WordPress code of conduct:
 No political jokes are allowed

  19. UPDATE tbl_students SET president = '<new president name>' WHERE president

    = 'Prokopis Pavlopoulos' On every change:

  20. Normalized tables: FK’s (Foreign Keys)

  21. ¿Is WordPress Rebel?

  22. • wp-posts • wp-term-taxonomy

  23. None
  24. None
  25. None

  26. 33,3333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333 333333333333333333333333333333333333333

    333333333333333333333333333333333333333 333333333333333333333333333333333333…%

  27. ¿Why WordPress powers 26% of all websites?

  28. ES FLEXIBLE

  29. KEY => VALUE

  30. wp_posts WordPress’ Heart.

  31. wp_posts

  32. ¿Where’s the rest of the information?

  33. Meta Tables wp_posts => wp_postmeta wp_users => wp_usermeta wp_comments =>

    wp_commentmeta wp_terms => wp_termmeta

  34. KEY VALUE => wp_posts

  35. KEY VALUE => Usuarios

  36. SHE ’S ORGANIZED

  37. KEY VALUE => wp_options

  38. SHE’S ADAPTABLE

  39. Taxonomies

  40. Taxonomías Simple terms Which taxonomy has?

  41. Es muy fácil comunicarse con ella: Diapositiva: una mujer con

    un teléfono It’s easy to talk to her

  42. SQL Structured Query Language

  43. Estructura de consulta: Which column/s? Which table/s? Should we filter

    the search?

  44. ¿Do we have to know SQL to work with WordPress?

  45. WordPress Functions:

  46. What if we need Meta values?

  47. WordPress Functions:

  48. and for more complex searches?

  49. WP_Query

  50. None
  51. None
  52. None

  53. CUSTOM TABLES How and why?

  54. Why Custom Tables?: • Efficiency (Inner joins) • Efficiency (calculated

    fields) • Space (uncompleted fields) • Data security

  55. How to create a Custom Tables?: • Create it on

    plugin/theme activation
  56. None

  57. How to create a Custom Tables?: • Create it on

    plugin/theme activation • UI implementation with WP_List class
  58. None

  59. http://wpengineer.com/2426/wp_list_table-a-step-by-step-guide/

  60. Because of this and more I’m in love with the

    WordPress database.

  61. Thank you! @maugelves