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

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

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for WordPress Greek Community WordPress Greek Community PRO
November 19, 2016
Programming
540
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
42
Orestis Samaras - Modern WordPress Development with Composer
Avatar for WordPress Greek Community wpgr
PRO
0
29
Eleni Tsertou - Ταχύτερο website με Persistent Object Cache: Μύθος ή Αλήθεια;
Avatar for WordPress Greek Community wpgr
PRO
0
34
George Korakas - WordPress Security 2025: From Real Threats to Practical Defenses
Avatar for WordPress Greek Community wpgr
PRO
0
41
Δημήτρης Καρβούνης - Πέρα από το Admin Panel: Πώς να μιλήσεις στο WordPress σαν Developer μέσω REST API
Avatar for WordPress Greek Community wpgr
PRO
0
28
Αναστασία Αδαμούδη - Δημιουργία σύνθετου μενού πλοήγησης σε block θέματα
Avatar for WordPress Greek Community wpgr
PRO
0
20
Νίκος Μαυράκης - Κοστολογώντας τη δημιουργικότητα
Avatar for WordPress Greek Community wpgr
PRO
0
39
Jovana Smoljanovic Tucakov - AI vs. Human Content: What Works, What Backfires, and What’s Next
Avatar for WordPress Greek Community wpgr
PRO
0
38
Λεωνίδας Μηλώσης - Optimize – optimize – optimize: Caring for performance of your WordPress plugin or website
Avatar for WordPress Greek Community wpgr
PRO
0
30

Other Decks in Programming

See All in Programming
依存関係から依存物へ―Dependencyという言葉の歴史をひも解く
Avatar for j_lee_inst j_lee
0
130
Mujeres en SEO Summit 2026 - Greatest Disaster Hits en Web Performance
Avatar for Estela Franco guaca
0
190
Lemonade + Foundry Toolkit でお手軽アプリ開発
Avatar for 瀬尾佳隆 seosoft
1
370
ADKを使って簡単にAIエージェントを作ってみよう
Avatar for K1mu21 k1mu21
0
270
Creating Composable Callables in Contemporary C++
Avatar for Björn Fahller rollbear
0
160
Semantic Version 単位で戦略を柔軟に変えて、パッケージアップデートを自動化する
Avatar for daitasu daitasu
1
290
Spring Security 実践 ─ GraphQL APIで実務に役立つ 認証・認可 を学ぶ
Avatar for Wagyu wagyu
0
250
エージェンティックRAGにAWSで入門しよう！
Avatar for Har1101 har1101
9
1.7k
ECSアプリログをFireLensでコスト削減しようとしたけど諦めた話 in Fargate×Node.js
Avatar for アキキー | Akihisa Ikeda akihisaikeda
2
4.2k
気づいたらRubyで100作品 ー クリエイティブコーディングが生活の一部になるまで / 100 Ruby Sketches Later: How Creative Coding Became Part of My Life
Avatar for chobishiba chobishiba
3
600
Snowflake Summitでの新機能 CoCo / CoWork / snowflake-summit-2026-overall-what-new-coco
Avatar for Tatsuhiro tatsuhiro
1
170
正しくソフトウェアを作る、前提を疑うための認知の視点 / doubt-premise
Avatar for MinoDriven minodriven
21
6.9k

Featured

See All Featured
Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa
Avatar for AKADEMIYA2063 akademiya2063
PRO
1
150
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
200
The Anti-SEO Checklist Checklist. Pubcon Cyber Week
Avatar for Ryan Jones ryanjones
0
170
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
141
7.5k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
Avatar for Kevin Liebholz kevinliebholz
37
6.5k
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
2.8k
A brief & incomplete history of 
UX Design for the World Wide Web: 1989–2019
Avatar for Jason CranfordTeague jct
2
400
The Hidden Cost of Media on the Web [PixelPalooza 2025]
Avatar for Tammy Everts tammyeverts
2
330
Tell your own story through comics
Avatar for letsgokoyo letsgokoyo
1
960
Let's Do A Bunch of Simple Stuff to Make Websites Faster
Avatar for Chris Coyier chriscoyier
508
140k
A Soul's Torment
Avatar for Nat Ma seathinner
6
3k

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