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

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

Avatar for WordPress Greek Community WordPress Greek Community
November 19, 2016
Programming
2
520

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

Avatar for WordPress Greek Community

WordPress Greek Community

November 19, 2016
Tweet

More Decks by WordPress Greek Community

See All by WordPress Greek Community
Thanassis Zannias - Flexible WordPress Dev Environment with Docker
Avatar for WordPress Greek Community wpgr
0
35
Andreas Karavanas - AI Supercharged Landing Pages
Avatar for WordPress Greek Community wpgr
0
45
Όμορφα, γρήγορα και οικονομικά websites με WordPress
Avatar for WordPress Greek Community wpgr
0
46
Unlocking creativity - Marilia Darilli
Avatar for WordPress Greek Community wpgr
0
80
Έλλη Μουχτάρη - Χτίσε το προσωπικό σου brand και απόκτησε τους πελάτες που θες
Avatar for WordPress Greek Community wpgr
0
56
Ioannis Kastorinis - WooCommerce technical automations in the real world
Avatar for WordPress Greek Community wpgr
0
79
Christos Paloukas - Cache me if you can, a journey through caching layers in WordPress
Avatar for WordPress Greek Community wpgr
0
84
Ευάγγελος Πάλλης - Malware Cleanup & Protection
Avatar for WordPress Greek Community wpgr
0
97
Νίκος Μαυράκης - Κοστολογώντας τη δημιουργικότητα
Avatar for WordPress Greek Community wpgr
0
72

Other Decks in Programming

See All in Programming
まだ間に合う！Claude Code元年をふりかえる
Avatar for nogu nogu66
5
920
著者と進める！『AIと個人開発したくなったらまずCursorで要件定義だ！』
Avatar for yasuna yasunacoffee
0
170
大規模Cloud Native環境におけるFalcoの運用
Avatar for Chihiro Hasegawa owlinux1000
0
220
re:Invent 2025 のイケてるサービスを紹介する
Avatar for maroon1st maroon1st
0
150
LLM Çağında Backend Olmak: 10 Milyon Prompt'u Milisaniyede Sorgulamak
Avatar for Selçuk Usta selcukusta
0
140
ZJIT: The Ruby 4 JIT Compiler / Ruby Release 30th Anniversary Party
Avatar for Takashi Kokubun k0kubun
1
300
公共交通オープンデータ × モバイルUX 複雑な運行情報を 『直感』に変換する技術
Avatar for Tsubasa SEKIGUCHI tinykitten
PRO
0
170
PostgreSQLで手軽にDuckDBを使う！DuckDB&pg_duckdb入門/osc25hi-duckdb
Avatar for Takahashi Ikki takahashiikki
0
210
モデル駆動設計をやってみよう ワークショップ開催報告(Modeling Forum2025) / model driven design workshop report
Avatar for haru860 haru860
0
290
Kotlin Multiplatform Meetup - Compose Multiplatform 외부 의존성 아키텍처 설계부터 운영까지
Avatar for Suhyeon Kim wisemuji
0
140
AI時代を生き抜く 新卒エンジニアの生きる道
Avatar for coconala_engineer coconala_engineer
1
470
実は歴史的なアップデートだと思う AWS Interconnect - multicloud
Avatar for maroon1st maroon1st
0
270

Featured

See All Featured
Lightning talk: Run Django tests with GitHub Actions
Avatar for Sarah Abderemane sabderemane
0
94
Imperfection Machines: The Place of Print at Facebook
Avatar for Scott Boms scottboms
269
13k
Agile Actions for Facilitating Distributed Teams - ADO2019
Avatar for Mark Kilby mkilby
0
98
CSS Pre-Processors: Stylus, Less & Sass
Avatar for Bermon Painter bermonpainter
359
30k
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.1k
The innovator’s Mindset - 
Leading Through an Era of Exponential Change - McGill University 2025
Avatar for Jean-Marc De Jonghe jdejongh
PRO
1
72
Mind Mapping
Avatar for Hélio Medeiros helmedeiros
PRO
0
42
Code Reviewing Like a Champion
Avatar for maltzj maltzj
527
40k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
122
21k
End of SEO as We Know It (SMX Advanced Version)
Avatar for Michael King ipullrank
2
3.8k
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
34
How to make the Groovebox
Avatar for あそなす asonas
2
1.9k

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