Skip to content
Live demo Every plugin below runs on this WordPress. The site resets in β€”. User demo Password FolderPressDemo1 Open the admin
Alpha Plugins

How the Alpha demo is built

The demo you are looking at runs on one VPS. These diagrams live in DiagramBlock: each block holds an editable draw.io, Excalidraw or drawDB source and is rendered here as plain SVG. Click one to zoom.

Hosting

BrowserCDNstatic assetsLoad balancerApp server 1PHP-FPMApp server 2PHP-FPMRedis cache (sessions)DatabaseMariaDBJob queue (mail, webhooks)httpsassetsasync
SVG🖶
Requests from the browser to the database

Orders

StartCollect the inputValid?yesSave and notifynoShow the errorsDone
SVG🖶
What happens after a purchase

Data model

wp_postsπŸ”‘ IDBIGINTpost_authorBIGINTpost_dateDATETIMEpost_date_gmtDATETIMEpost_contentLONGTEXTpost_titleTEXTpost_excerptTEXTpost_statusVARCHARcomment_statusVARCHARping_statusVARCHARpost_passwordVARCHARpost_nameVARCHARto_pingTEXTpingedTEXTpost_modifiedDATETIMEpost_modified_gmtDATETIMEpost_content_filteredLONGTEXTpost_parentBIGINTguidVARCHARmenu_orderINTpost_typeVARCHARpost_mime_typeVARCHARcomment_countBIGINTwp_postmetaπŸ”‘ meta_idBIGINTpost_idBIGINTmeta_keyVARCHARmeta_valueLONGTEXTwp_usersπŸ”‘ IDBIGINTuser_loginVARCHARuser_passVARCHARuser_nicenameVARCHARuser_emailVARCHARuser_urlVARCHARuser_registeredDATETIMEuser_activation_keyVARCHARuser_statusINTdisplay_nameVARCHARwp_usermetaπŸ”‘ umeta_idBIGINTuser_idBIGINTmeta_keyVARCHARmeta_valueLONGTEXTwp_termsπŸ”‘ term_idBIGINTnameVARCHARslugVARCHARterm_groupBIGINTwp_term_taxonomyπŸ”‘ term_taxonomy_idBIGINTterm_idBIGINTtaxonomyVARCHARdescriptionLONGTEXTparentBIGINTcountBIGINTwp_term_relationshipsπŸ”‘ object_idBIGINTπŸ”‘ term_taxonomy_idBIGINTterm_orderINTwp_commentsπŸ”‘ comment_IDBIGINTcomment_post_IDBIGINTcomment_authorTINYTEXTcomment_author_emailVARCHARcomment_author_urlVARCHARcomment_author_IPVARCHARcomment_dateDATETIMEcomment_date_gmtDATETIMEcomment_contentTEXTcomment_karmaINTcomment_approvedVARCHARcomment_agentVARCHARcomment_typeVARCHARcomment_parentBIGINTuser_idBIGINTwp_commentmetaπŸ”‘ meta_idBIGINTcomment_idBIGINTmeta_keyVARCHARmeta_valueLONGTEXTwp_optionsπŸ”‘ option_idBIGINToption_nameVARCHARoption_valueLONGTEXTautoloadVARCHARwp_postmeta.post_idwp_usermeta.user_idwp_term_taxonomy.term_idwp_comments.user_idwp_commentmeta.comment_id
SVG🖶
Imported from the live WordPress database

Leave a Reply

Your email address will not be published. Required fields are marked *

Keep reading

More from the blog