Articles tagged "Tutorial"

Tag

4 articles found

May 1, 20264 min read

PostgreSQL for Analytics: Best Practices

Keep OLTP and analytics paths separate, pre-aggregate what dashboards repeat, and index for the filters users actually touch. Patterns we use on BI and ETL projects.

PostgreSQLAnalyticsSQL

Read →

Tutorials

April 24, 20264 min read

Building Your First Analytics Dashboard

Start with three metrics, one grain, and a schema you can query without heroics. A practical path from spreadsheet exports to a dashboard small teams can maintain.

AnalyticsDashboardPostgreSQL

Read →

Tutorials

April 17, 20264 min read

GitLab CI/CD for Next.js on Cloud Run

How we wire GitLab CI to build Next.js with the right build-time env vars, cache Docker layers, and deploy to Cloud Run without long-lived GCP keys in the repo.

GitLabCI/CDNext.js

Read →

Tutorials

April 10, 20265 min read

Building Accessible React Components

Accessibility is not a Lighthouse checkbox. These patterns cover keyboard navigation, dialog semantics, and component design we use after auditing a production Next.js site.

ReactAccessibilityNext.js

Read →