/* ==========================================================================
   Pick Click Stack Track™ — main.css (single stylesheet)
   --------------------------------------------------------------------------
   1. Design tokens       5. Top nav + burger menu   9.  Callouts
   2. Reset & base        6. Footer + bottom nav     10. Code blocks
   3. Layout helpers      7. Prose / typography      11. Glossary table
   4. Sticky header       8. Article header + byline 12. Hub cards + buttons
                         13. Utilities               14. Responsive
   ========================================================================== */


/* 1. Design tokens
   =========================================================== */
:root {
  --color-bg:               #faf7f2;
  --color-surface:          #ffffff;
  --color-text:             #28333d;
  --color-heading:          #1b242c;
  --color-muted:            #5d6b77;
  --color-accent:           #b5485d;
  --color-accent-dark:      #96374b;
  --color-accent-soft:      #f6e6ea;
  --color-rule:             #e7e0d5;

  --color-header-bg:        #1c2530;
  --color-header-text:      #f4f6f8;
  --color-header-accent:    #ecb6c1;

  --color-footer-bg:        #141b22;
  --color-footer-text:      #c7d0d8;

  --color-code-bg:          #1e242b;
  --color-code-text:        #e8eef4;
  --color-code-bar:         #151a20;

  --font-body: Charter, "Iowan Old Style", "Sitka Text", Georgia, "Times New Roman", serif;
  --font-ui:   -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;
  --font-mono: ui-monospace, "SF Mono", "Cascadia Code", "JetBrains Mono", Consolas, "Liberation Mono", Menlo, monospace;

  --container-max: 76rem;
  --content-max:   74ch;

  --radius:    12px;
  --radius-sm: 6px;
  --shadow:    0 8px 24px rgba(20, 30, 40, .08);
  --shadow-lg: 0 14px 32px rgba(20, 30, 40, .14);
}


/* 2. Reset & base
   =========================================================== */
html {
  font-size: 118.75%;      /* 19px — larger print for easy reading */
  scroll-behavior: smooth;
}

*, *::before, *::after { box-sizing: border-box; }

body {
  margin: 0;
  min-height: 100vh;
  display: flex;
  flex-direction: column;
  font-family: var(--font-body);
  font-size: 1rem;
  line-height: 1.7;
  color: var(--color-text);
  background: var(--color-bg);
  -webkit-font-smoothing: antialiased;
}

h1, h2, h3, h4 {
  font-family: var(--font-ui);
  color: var(--color-heading);
  line-height: 1.15;
  letter-spacing: -.01em;
  margin: 2.1em 0 .55em;
}

h1 { margin: 0 0 .45em; font-size: 2.1rem; }
h2 { font-size: 1.5rem; padding-bottom: .4rem; border-bottom: 1px solid var(--color-rule); }
h3 { font-size: 1.15rem; }

p { margin: 1.1em 0; }

a { color: var(--color-accent); text-decoration-thickness: 1.5px; text-underline-offset: 3px; }
a:hover { color: var(--color-accent-dark); }

img { max-width: 100%; height: auto; }

:focus-visible {
  outline: 3px solid var(--color-accent);
  outline-offset: 2px;
  border-radius: 2px;
}

::selection { background: var(--color-accent-soft); }


/* 3. Layout helpers
   =========================================================== */
.container {
  width: 100%;
  max-width: var(--container-max);
  margin-inline: auto;
  padding-inline: 1.25rem;
}

.container--article { max-width: var(--content-max); } /* ~70–74 characters/line */

.site-main { flex: 1 0 auto; padding: 3rem 0 4.5rem; }

.skip-link {
  position: absolute;
  left: -9999px;
  top: 0;
  z-index: 100;
  padding: .6rem 1rem;
  background: var(--color-accent);
  color: #fff;
  font-family: var(--font-ui);
  border-radius: 0 0 var(--radius-sm) 0;
}
.skip-link:focus { left: 0; }


/* 4. Sticky header + brand
   =========================================================== */
.site-header {
  position: sticky;          /* sticky header, pure CSS — no JS */
  top: 0;
  z-index: 60;
  background: var(--color-header-bg);
  color: var(--color-header-text);
  box-shadow: 0 1px 12px rgba(0, 0, 0, .28);
}

.header-inner {
  display: flex;
  align-items: center;
  justify-content: space-between;
  gap: 1rem;
  min-height: 68px;
  padding-block: .45rem;
}

.brand {
  font-family: var(--font-ui);
  font-weight: 700;
  font-size: 1.05rem;
  line-height: 1.2;
  letter-spacing: .01em;
  color: #fff;
  text-decoration: none;
}
.brand sup { font-size: .55em; color: var(--color-header-accent); }


/* 5. Top nav (desktop) + burger menu (mobile)
   =========================================================== */
.nav-burger { display: none; }            /* burger hidden on desktop */

.top-nav ul {
  list-style: none;
  margin: 0;
  padding: 0;
  display: flex;
  align-items: center;
  gap: 1.75rem;
}

.top-nav a {
  display: inline-block;
  font-family: var(--font-ui);
  font-size: .95rem;
  color: var(--color-header-text);
  text-decoration: none;
  padding: .35rem 0;
  border-bottom: 2px solid transparent;
}
.top-nav a:hover { border-bottom-color: var(--color-header-accent); }
.top-nav a[aria-current="page"] { color: #fff; border-bottom-color: var(--color-header-accent); }

.nav-burger__summary {
  list-style: none;
  cursor: pointer;
  align-items: center;
  display: inline-flex;
  padding: .55rem .6rem;
  border-radius: var(--radius-sm);
  color: #fff;
}
.nav-burger__summary::-webkit-details-marker { display: none; }
.nav-burger__summary:hover { background: rgba(255, 255, 255, .08); }

.nav-burger__icon { display: inline-flex; flex-direction: column; gap: 5px; }
.nav-burger__bar {
  display: block;
  width: 26px;
  height: 2.5px;
  border-radius: 2px;
  background: #fff;
  transition: transform .18s ease, opacity .18s ease;
}


/* 6. Footer + bottom nav
   =========================================================== */
.site-footer {
  flex-shrink: 0;
  background: var(--color-footer-bg);
  color: var(--color-footer-text);
  padding: 2.5rem 0 2rem;
}

.bottom-nav ul {
  list-style: none;
  margin: 0 0 1.1rem;
  padding: 0;
  display: flex;
  flex-wrap: wrap;
  gap: .5rem 1.9rem;
}

.bottom-nav a {
  font-family: var(--font-ui);
  font-size: .95rem;
  color: var(--color-footer-text);
  text-decoration: none;
}
.bottom-nav a:hover { color: #fff; text-decoration: underline; text-underline-offset: 3px; }

.site-footer__legal {
  margin: 0;
  font-family: var(--font-ui);
  font-size: .82rem;
  line-height: 1.6;
  color: #8fa0ae;
}


/* 7. Prose / typography
   =========================================================== */
.prose ul, .prose ol { margin: 1.15em 0; padding-left: 1.6em; }
.prose li { margin: .45em 0; }

.prose blockquote {
  margin: 1.6em 0;
  padding: .2em 0 .2em 1.25em;
  border-left: 4px solid var(--color-accent);
  color: var(--color-muted);
  font-style: italic;
}

.prose hr { border: 0; border-top: 1px solid var(--color-rule); margin: 2.75rem 0; }
.prose strong { color: var(--color-heading); }

.lede { font-size: 1.13rem; line-height: 1.55; color: var(--color-heading); }


/* 8. Article header & byline
   =========================================================== */
.article-header { margin-bottom: 2.25rem; }

.eyebrow {
  margin: 0 0 .55rem;
  font-family: var(--font-ui);
  font-size: .78rem;
  font-weight: 700;
  letter-spacing: .14em;
  text-transform: uppercase;
  color: var(--color-accent);
}

.byline {
  margin: 0;
  display: flex;
  flex-wrap: wrap;
  gap: .25rem .65rem;
  align-items: baseline;
  font-family: var(--font-ui);
  font-size: .95rem;
  color: var(--color-muted);
}
.byline__author { font-weight: 600; color: var(--color-heading); }
.byline__sep { opacity: .6; }


/* 9. Callouts (product ads)
   =========================================================== */
.callout {
  margin: 2.5rem 0;
  padding: 1.6rem 1.8rem;
  border-radius: var(--radius);
  border: 1px solid var(--color-rule);
  background: var(--color-surface);
  box-shadow: var(--shadow);
}

.callout--product {
  border-left: 6px solid var(--color-accent);
  background: linear-gradient(180deg, #ffffff, var(--color-accent-soft));
}

.callout__eyebrow {
  margin: 0 0 .35rem;
  font-family: var(--font-ui);
  font-size: .75rem;
  font-weight: 700;
  letter-spacing: .13em;
  text-transform: uppercase;
  color: var(--color-accent);
}
.callout__title { margin: 0 0 .45rem; font-size: 1.3rem; }
.callout__text { margin: 0 0 1.05rem; }

.button {
  display: inline-block;
  font-family: var(--font-ui);
  font-size: .95rem;
  font-weight: 600;
  padding: .65rem 1.3rem;
  border-radius: 999px;
  border: 1.5px solid var(--color-accent);
  background: var(--color-accent);
  color: #fff;
  text-decoration: none;
  cursor: pointer;
}
.button:hover { background: var(--color-accent-dark); border-color: var(--color-accent-dark); color: #fff; }

.button--ghost { background: transparent; color: var(--color-accent); }
.button--ghost:hover { background: var(--color-accent); color: #fff; }


/* 10. Code blocks
   =========================================================== */
.code-block {
  margin: 2.25rem 0;
  border-radius: var(--radius);
  overflow: hidden;
  background: var(--color-code-bg);
  box-shadow: var(--shadow);
}

.code-block__bar {
  display: flex;
  align-items: center;
  justify-content: space-between;
  gap: 1rem;
  padding: .55rem 1rem;
  background: var(--color-code-bar);
  font-family: var(--font-ui);
  font-size: .85rem;
  color: #aebbc7;
}

/* Decorative quote marks around the filename — CSS-only, so they never
   end up inside the text a reader copies. */
.code-block__filename::before { content: "\201C"; color: var(--color-header-accent); margin-right: .15rem; }
.code-block__filename::after  { content: "\201D"; color: var(--color-header-accent); margin-left: .15rem; }

.code-block__copy {
  font-family: var(--font-ui);
  font-size: .8rem;
  color: #cfd8e0;
  background: rgba(255, 255, 255, .08);
  border: 1px solid rgba(255, 255, 255, .2);
  border-radius: 999px;
  padding: .25rem .85rem;
  cursor: pointer;
}
.code-block__copy:hover { background: rgba(255, 255, 255, .16); color: #fff; }
.code-block__copy.is-copied { color: #8fe0b0; border-color: #8fe0b0; }

.code-block__pre {
  margin: 0;
  padding: 1.25rem 1.5rem;
  overflow-x: auto;
  white-space: pre;               /* never soft-wrap — pasted text stays exact */
  font-family: var(--font-mono);
  font-size: .92rem;
  line-height: 1.65;
  color: var(--color-code-text);
  tab-size: 2;
}
.code-block code { font-family: inherit; font-size: inherit; color: inherit; }


/* 11. Glossary table
   =========================================================== */
.table-wrap {
  margin: 1.75rem 0;
  overflow-x: auto;
  border: 1px solid var(--color-rule);
  border-radius: var(--radius);
  background: var(--color-surface);
  box-shadow: var(--shadow);
}

.glossary {
  width: 100%;
  min-width: 640px;
  border-collapse: collapse;
  font-size: .98rem;
}

.glossary th, .glossary td {
  padding: .75rem 1rem;
  text-align: left;
  vertical-align: top;
  border-bottom: 1px solid var(--color-rule);
}

.glossary thead th {
  font-family: var(--font-ui);
  font-size: .78rem;
  font-weight: 700;
  letter-spacing: .08em;
  text-transform: uppercase;
  color: var(--color-muted);
  background: #f4eee4;
}

.glossary tbody tr:last-child td { border-bottom: 0; }
.glossary tbody tr:hover { background: var(--color-accent-soft); }

.glossary td:first-child { font-weight: 700; color: var(--color-heading); }

.glossary td:nth-child(2) {
  font-family: var(--font-ui);
  font-size: .84rem;
  color: var(--color-muted);
  white-space: nowrap;
}


/* 12. Hub cards
   =========================================================== */
.hub-cards {
  display: grid;
  grid-template-columns: repeat(auto-fit, minmax(240px, 1fr));
  gap: 1.3rem;
  margin: 1.75rem 0;
}

.hub-card {
  display: flex;
  flex-direction: column;
  gap: .35rem;
  padding: 1.5rem 1.6rem;
  border-radius: var(--radius);
  border: 1px solid var(--color-rule);
  background: var(--color-surface);
  color: var(--color-text);
  text-decoration: none;
  box-shadow: var(--shadow);
  transition: transform .16s ease, box-shadow .16s ease, border-color .16s ease;
}
.hub-card:hover {
  transform: translateY(-3px);
  box-shadow: var(--shadow-lg);
  border-color: var(--color-accent);
  color: var(--color-text);
}

.hub-card--sheets { border-top: 5px solid #2d8f6f; }   /* Google Sheets green */
.hub-card--db     { border-top: 5px solid #2f6fb0; }   /* MySQL blue */

.hub-card__eyebrow {
  font-family: var(--font-ui);
  font-size: .75rem;
  font-weight: 700;
  letter-spacing: .12em;
  text-transform: uppercase;
  color: var(--color-accent);
}
.hub-card__title {
  font-family: var(--font-ui);
  font-size: 1.4rem;
  font-weight: 700;
  color: var(--color-heading);
}
.hub-card__desc { color: var(--color-muted); }
.hub-card__cta {
  margin-top: .4rem;
  font-family: var(--font-ui);
  font-weight: 600;
  color: var(--color-accent);
}


/* 13. Utilities & placeholders
   =========================================================== */
.sr-only {
  position: absolute;
  width: 1px;
  height: 1px;
  margin: -1px;
  padding: 0;
  overflow: hidden;
  clip: rect(0, 0, 0, 0);
  white-space: nowrap;
  border: 0;
}

.placeholder-note {
  font-family: var(--font-ui);
  font-size: .9rem;
  padding: .9rem 1.05rem;
  border: 1.5px dashed var(--color-accent);
  border-radius: var(--radius-sm);
  background: var(--color-accent-soft);
  color: var(--color-accent-dark);
}


/* 15. Hold page (under construction)
   =========================================================== */
.hold {
  margin-top: .75rem;
  padding: 2.4rem 2rem;
  border: 1px solid var(--color-rule);
  border-top: 5px solid var(--color-accent);
  border-radius: var(--radius);
  background: var(--color-surface);
  box-shadow: var(--shadow);
}

.hold h1 {
  font-size: 2.3rem;
  margin: .55rem 0 1rem;
}

.hold .lede { margin-top: 0; }

.hold__note {
  margin: 1.9rem 0 0;
  padding-top: 1.3rem;
  border-top: 1px solid var(--color-rule);
  font-family: var(--font-ui);
  font-size: .95rem;
  color: var(--color-muted);
}

/* 14. Responsive
   =========================================================== */
@media (max-width: 760px) {
  html { font-size: 112.5%; }     /* 18px on smaller screens */
  .hold h1 { font-size: 1.75rem; }
  .site-main { padding: 2.25rem 0 3.25rem; }
  .article-header h1 { font-size: 1.75rem; }
  h2 { font-size: 1.35rem; }

  /* switch from desktop nav to burger */
  .top-nav--desktop { display: none; }
  .nav-burger { display: block; }
  .nav-burger__summary { display: inline-flex; }

  .top-nav--mobile {
    position: absolute;
    top: 100%;
    left: 0;
    right: 0;
    background: var(--color-header-bg);
    padding: .7rem 1.25rem 1.1rem;
    box-shadow: 0 16px 28px rgba(0, 0, 0, .32);
  }

  .top-nav--mobile ul { flex-direction: column; align-items: stretch; gap: .25rem; }
  .top-nav--mobile a {
    display: block;
    padding: .6rem .55rem;
    border-bottom: 0;
    border-left: 3px solid transparent;
    border-radius: 4px;
  }
  .top-nav--mobile a:hover { background: rgba(255, 255, 255, .06); border-left-color: var(--color-header-accent); }
  .top-nav--mobile a[aria-current="page"] { border-left-color: var(--color-header-accent); }

  /* burger turns into an X while open */
  .nav-burger[open] .nav-burger__bar:nth-child(2) { opacity: 0; }
  .nav-burger[open] .nav-burger__bar:nth-child(1) { transform: translateY(7.5px) rotate(45deg); }
  .nav-burger[open] .nav-burger__bar:nth-child(3) { transform: translateY(-7.5px) rotate(-45deg); }
}

@media (prefers-reduced-motion: reduce) {
  * { transition-duration: .01ms !important; animation-duration: .01ms !important; }
  html { scroll-behavior: auto; }
}