Andrew Mara

Welcome to my professional portfolio. I'm Andrew Mara, a seasoned full-stack web developer with over 15 years of experience specializing in custom website development for clients while also managing my own web properties.

My technical expertise encompasses a comprehensive evolution of web technologies, from PHP and WordPress to modern stacks including React/Next.js, Svelte/SvelteKit, and Astro.

Through this platform, I share professional insights on web development methodologies, productivity optimization, search engine optimization strategies, and other relevant industry topics.

For professional inquiries or collaboration opportunities, please contact me at andrew.mara@protonmail.com.

Projects

Blog

• Generate Unique IDs Per Request in Astro August 11, 2024

  How to generate unique ids for input and other elements per request in Astro.
• Block Analytics and Ads in Playwright Tests July 28, 2024

  How to block Google Analytics, Microsoft Clarity, Google Adsense in Playwright tests.
• Faster SQLite LIKE Queries Using FTS5 Trigram Indexes January 8, 2024

  How to use FTS5 trigram indexes to significantly speed up LIKE and GLOB queries in SQLite.
• Copy SQLite Tables with Indexes January 4, 2024

  How to copy tables from one SQLite database to another, including indexes and foreign key constraints.