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

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

A717e9d055b2284e573b2412e32f5397?s=47 WordPress Greek Community
November 19, 2016
Programming
2
260

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

A717e9d055b2284e573b2412e32f5397?s=128

WordPress Greek Community

November 19, 2016
Tweet

More Decks by WordPress Greek Community

See All by WordPress Greek Community
Η τέλεια στρατηγική προώθησης ενός WordPress/Woo website - Γιάννης Δεβελέκος
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
25
Cookies και άλλες τεχνολογίες στην ιστοσελίδα μου: Τελικά τι μπορώ να χρησιμοποιώ; - Βασίλης Καρκατζούνης
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
22
Making the most of WooCommerce - Δημήτριος Σελημίδης
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
9
Making WordPress faster and greener - David Hilditch [ΕΝ]
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
13
It is not a sprint is a marathon… running your eshop - Ιωάννης Καστορίνης
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
9
Scaling WooCommerce - Δημήτρης Χατζημιχαηλίδης
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
16
Let’s burst our bubble: projects, products, estimates and forecasts. - Tassos Koutlas
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
15
Page Experience road - Fellyph Cintra [ΕΝ]
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
13
Building with Patterns: Introduction and next steps - Νίκος Τσεκούρας
A717e9d055b2284e573b2412e32f5397?s=48 wpgr
0
9

Other Decks in Programming

See All in Programming
Go言語仕様輪読会の開催を通じた振り返り
5e511bb6d01d856b4ec7a0e5b1f6a2f0?s=48 syumai
1
140
roadmap to rust 2024
F0493f5bcb4cc9fdccc54ae3e8ab6bd0?s=48 matsu7874
1
560
Microsoft Teams の 会議アプリ開発のはじめかた / How to start Microsoft Teams app development
9cdd446fb259ec93e52d4388f60197f8?s=48 karamem0
0
1.4k
近況PHP / PHP in now a days
271fad8d53cd1f12f2b4b6d38e3d7bd3?s=48 uzulla
4
1.4k
WindowsコンテナDojo：第2回 Windowsコンテナアプリのビルド、公開、デプロイ
E5eb221d34d4ffbe973f8542b4c3a00e?s=48 oniak3ibm
PRO
0
130
Practical Advanced Kotlin in Practice
4580c218737149bf44d012a110612010?s=48 rock3r
3
130
Managing gRPC with Wire
05162bc961c3654218bf1839974a4f35?s=48 oldergod
2
150
Get Ready for Jakarta EE 10
B489790e1a844284d7cd1fa2cd6e021f?s=48 ivargrimstad
0
1.9k
競プロへの誘 -いざな-
Efbc292fd2e2c4caa0ede1d1532804a9?s=48 u76ner
0
320
microCMS × Shopifyで、ECサイトがリニューアル後急成長した話
1f1d874ed952074278d27fad3fb870b8?s=48 microcms
0
450
TDX22: User-Mode DB Ops
3cf3d4d85fad3d196c1127018a370418?s=48 ca_peterson
3
1.1k
PublishでWebサイトを構築してみた / generate_website_with_publish
42a6a049ac8f5265f31858a9509217fb?s=48 uhooi
2
110

Featured

See All Featured
Why You Should Never Use an ORM
88bc30284c6a424b63a92aad27d0ba36?s=48 jnunemaker
PRO
47
5.5k
5 minutes of I Can Smell Your CMS
465724d73fe3a92c0879fdfb43a3a6f3?s=48 philhawksworth
196
18k
The Brand Is Dead. Long Live the Brand.
A415db3ac9e9668acbc1fb36eead84ac?s=48 mthomps
45
2.7k
CSS Pre-Processors: Stylus, Less & Sass
7559f6cff1f5efc2d210965febd4d71c?s=48 bermonpainter
349
27k
Fashionably flexible responsive web design (full day workshop)
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
396
62k
Reflections from 52 weeks, 52 projects
E43f8dfd01057f8304f5f8fb9a294d7d?s=48 jeffersonlam
337
17k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
651dcfe41723207fbb0aa044a4f7c07f?s=48 dotmariusz
100
5.9k
Building Flexible Design Systems
91cefdf141106fa10674aae74ce05890?s=48 yeseniaperezcruz
310
33k
Statistics for Hackers
56c4053438af8e8b90d6f53cbb7573be?s=48 jakevdp
781
210k
Embracing the Ebb and Flow
C9b18d9dff88a9dd2393364c2b3b21bd?s=48 colly
73
3.3k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
38
12k
Streamline your AJAX requests with AmplifyJS and jQuery
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
125
8.5k

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