English tag hub: same canonical tag strings as the Spanish site (Tags in front matter); this page’s chrome and blurbs are in English.
Posts tagged: Web development
Remaining tables for the time-tracking database
SQL for roles, projects, tasks, worked hours, and permission grants across DBA, admin, web, and anonymous roles.
Read more →Database setup for the time-tracking app
Create DBA/admin/web/anon roles, a control_tiempo schema, the users table, and grants aligned with PostgREST access patterns.
Read more →Designing the database for a time-tracking app
Conceptual tables for users, roles, projects, tasks, and worked hours—the backbone of the decoupled series.
Read more →Decoupled Architectures: Building a Time-Tracking App
Overview of a decoupled stack (Debian, PostgREST, Nginx, React, PostgreSQL) for a small-company time-tracking product.
Read more →JWT Authentication with PostgREST
Why JSON Web Tokens help secure a PostgREST API, and how roles, headers, and PostgreSQL functions fit together.
Read more →PostgREST in Practice: Building a Strong REST API
What a REST API is, why it helps, and how PostgREST exposes PostgreSQL as HTTP resources—with install and first SQL steps.
Read more →Create users in the time-tracking app with React
A CreateUser component sketch that posts JSON to your API to insert rows into control_tiempo.usuarios.
Read more →React primer: ES5, ES6, and how apps run
What React is, how ES5 and ES6 differ, common runtimes (browser vs Node), and a minimal Hello World in modern syntax.
Read more →Scaffolding a React frontend for role management
Create React App (or equivalent), project layout, and the screens you need to list and edit roles against the REST API.
Read more →Project management screens in React
ListProjects and EditProject examples—fetching projects, rendering cards, and submitting create/update payloads to the API.
Read more →Role management components in React
Example ListRoles and EditRole components using hooks, fetch, and minimal forms wired to your REST API.
Read more →Calling the REST API of the time-tracking app
REST shapes for users, roles, projects, tasks, and hours; OpenAPI documentation; curl examples.
Read more →
Reviving Praderas (Day 1): technical audit and AI-agent improvement plan
Day 1 of the rebuild focused on a full audit of code, architecture, and content consistency to build a practical roadmap for iterative improvements.
Read more →Reviving Praderas (Day 10) — batch 2, EN hubs, and routing fixes (daily log)
Full Decoupled time tracking translation batch, /en/series and /en/categorias hub pages, plugin and template work, and a wall-clock vs localization time comparison (~35 min).
Read more →Reviving Praderas (Day 11) — batch 3 (security & privacy), EN tag labels, and English About
Shipped the security/privacy/geolocation cluster, English display labels for canonical tags, /en/tags and /en/about-picocms, and agent docs for remaining multilingual UI gaps—with wall-clock vs senior-time comparison.
Read more →Reviving Praderas (Day 12) — batch 4 (AI), EN archive, /en/blog language switcher, and the missing daily log
Wrap-up for work already merged to main—six AI post pairs, /en/archivo, paired blog listings for the language switcher—plus this PR that adds the ES/EN log pair that should have shipped with the same batch.
Read more →Reviving Praderas (Day 13) — batch 5 (productivity & collaboration) and wall-clock notes
Six ES→EN productivity guides (remote work, Etherpad, Redmine, Taskwarrior, Focalboard, Nextcloud+Deck), small Spanish fixes, and wall-clock vs no-AI order-of-magnitude.
Read more →Reviving Praderas (Day 14) — batches 6–8, ES→EN backlog closure, and wall clock
Twenty new pairs (mobile, crypto, general long tail), an updated Debian link in the Decoupled time-tracking series, and ~9.5 min wall clock for the translation block vs a senior counterfactual band.
Read more →Reviving Praderas (Day 15) — multilingual UI slice: EN search and shared footer
Scheduled UI backlog closure (`/en/search`, language-safe search results, and non-post footer i18n) with measured wall clock (~1m40s) and a senior-only baseline comparison.
Read more →Reviving Praderas (Day 16) — per-language sitemaps and discovery (ES/EN index)
Ship `sitemap.xml` as a sitemap index pointing to `sitemap-es.xml` and `sitemap-en.xml`, filtered using the same language rule as the rest of the site (`Multilingual::inferLang`), consistent with hreflang and the multilingual UI backlog.
Read more →
Reviving Praderas (Day 17) — cover images: ComfyUI plan + SDXL template
Planning session: alternatives to random placeholders, local ComfyUI validation (`/prompt`, SDXL ubersimple), JSON template under `scripts/comfyui/`, and a checklist to wire hero images into Pico without abandoning Markdown-first authoring.
Read more →
Reviving Praderas (Day 18) — `Image:` hero, Open Graph, responsive layout (Picsum fallback)
Optional cover from front matter, social meta, listing cards with `Image:` thumbnail or stable Picsum, CSS for in-body images and hero; ComfyUI production-ready for generation; wall-clock log.
Read more →
Reviving Praderas (Day 19) — `export_cover.py` patches `Image:` in Markdown
New --patch-markdown (and --skip-comfy) on the ComfyUI export script; dedicated Day 19 PNG; checklist row 7 update in agent docs; wall-clock log.
Read more →Reviving Praderas (Day 2) — Phase 1: fixing listing, search, and pagination (with an AI agent)
Phase 1 delivered a clean listing template, unified search behavior, restored pagination, and a meaningful sidebar recent-posts block.
Read more →
Reviving Praderas (Day 21) — `export_cover.py` and the `Translation_Key` flag
New `--translation-key` flag patches `Image:` on the ES/EN pair without listing two paths; mutually exclusive with `--patch-markdown`; dedicated Comfy cover (seed 21052026).
Read more →Reviving Praderas (Day 3) — Phase 2: navigation, categories, breadcrumbs, and related posts
Phase 2 moved the site from a flat page list to intentional navigation with category mapping, breadcrumbs, related posts by tag, and chronological previous/next links.
Read more →Reviving Praderas (Day 4) — Phase 3: metadata, taxonomy, and front matter lint
Phase 3 focused on editorial consistency by completing missing tags, normalizing date formats, and adding a front matter audit script for future safety.
Read more →Reviving Praderas (Day 5) — visual polish: spacing, readability, and brand tone without new frameworks
Day 5 focused on visual polish and readability, followed by consultant feedback, iterative UI refinements, and transparent timing notes.
Read more →Reviving Praderas (Day 6) — series and collections: chapter-based navigation without losing context
We added first-class series support in Pico, including menu integration, sidebar series navigation, and backfilling the historical time-control series.
Read more →Reviving Praderas (Day 7) — Phase 4: SEO, social metadata, and date archive
Phase 4 unified canonical and social metadata patterns, improved Spanish search stopwords, and added a date-based archive page linked from the sidebar.
Read more →Reviving Praderas (Day 8) — Phase 5: ES/EN content model, translation pairs, and hreflang
Phase 5 on this repo—English posts under blog/en, optional en/ pages, Lang and Translation_Key metadata, Multilingual plugin, language switcher, hreflang and og:locale, scoped pagination and neighbors, English listing at /en/blog.
Read more →Reviving Praderas (Day 9) — translation migration: batch plan, completed batch 1, and time estimates
Eight-batch ES→EN migration plan, plain-language explanation of AI “context,” a simple timeline, and Batch 1 for Reviving Praderas with real wall-clock time (~20 min) vs traditional localization.
Read more →Tuqan Phase 0 — Strategic foundation, audit, and initial roadmap
Kicking off the agentic modernization of Tuqan with living documentation, an audit plan, and a prioritized roadmap. First post in the Tuqan series.
Read more →