$30 off During Our Annual Pro Sale. View Details »

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

WordPress Greek Community
November 19, 2016
Programming
2
290

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

WordPress Greek Community

November 19, 2016
Tweet

More Decks by WordPress Greek Community

See All by WordPress Greek Community
Git: βασικές έννοιες και λειτουργίες
wpgr
0
4
Creating a custom WooCommerce plugin
wpgr
0
65
Η τέλεια στρατηγική προώθησης ενός WordPress/Woo website - Γιάννης Δεβελέκος
wpgr
0
120
Cookies και άλλες τεχνολογίες στην ιστοσελίδα μου: Τελικά τι μπορώ να χρησιμοποιώ; - Βασίλης Καρκατζούνης
wpgr
0
46
Making the most of WooCommerce - Δημήτριος Σελημίδης
wpgr
0
26
Making WordPress faster and greener - David Hilditch [ΕΝ]
wpgr
0
39
It is not a sprint is a marathon… running your eshop - Ιωάννης Καστορίνης
wpgr
0
18
Scaling WooCommerce - Δημήτρης Χατζημιχαηλίδης
wpgr
0
22
Let’s burst our bubble: projects, products, estimates and forecasts. - Tassos Koutlas
wpgr
0
34

Other Decks in Programming

See All in Programming
Composing an API with Kotlin vol 2 (Advanced Kotlin Dev Day 2022)
zsmb
1
260
Modern Web Apps with Spring Boot & Angular
toedter
13
15k
Ship Faster With Feature Flags
davidodari
0
170
Dynamic VM Scheduling
 in OpenStack
pyama86
1
400
디자인에 이어 코딩까지 AI가 프로그램 개발을 척척? : GitHub Copilot, 어디까지 알아보셨나요
outsider
0
650
PyHack#141今日やったこと
soogie
0
100
第3回AI王YAMALEXソリューション
takashi1029
0
160
Gradioを使って機械学習モデルを一瞬でWebアプリ化
os1ma
0
170
JSConf JP 2022 introduce React Query
maminami373
1
4.9k
OMO Package of App Unity
appunity
0
830
排他制御のためだけに渋々 Redis 使ってませんか？
mpyw
7
770
個人開発でも使ってみよう Addressable Asset System
tetsujp84
0
170

Featured

See All Featured
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
23
4.4k
The Web Native Designer (August 2011)
paulrobertlloyd
76
2.1k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
reverentgeek
175
8.9k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
8
1.2k
Code Review Best Practice
trishagee
48
11k
GitHub's CSS Performance
jonrohan
1020
430k
Making the Leap to Tech Lead
cromwellryan
114
7.6k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
120
29k
Teambox: Starting and Learning
jrom
124
7.8k
Testing 201, or: Great Expectations
jmmastey
24
5.6k
Faster Mobile Websites
deanohume
294
29k
Navigating Team Friction
lara
176
12k

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