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 andrewmara92 at gmail.com.
Projects
Blog
- Fix for "sqldiff: Expression tree is too large"June 20, 2025How to fix the "Expression tree is too large (maximum depth 1000)" error in sqldiff.
- Generate Unique IDs Per Request in AstroAugust 11, 2024How to generate unique ids for input and other elements per request in Astro.
- Block Analytics and Ads in Playwright TestsJuly 28, 2024How to block Google Analytics, Microsoft Clarity, Google Adsense in Playwright tests.
- Faster SQLite LIKE Queries Using FTS5 Trigram IndexesJanuary 8, 2024How to use FTS5 trigram indexes to significantly speed up LIKE and GLOB queries in SQLite.
- Copy SQLite Tables with IndexesJanuary 4, 2024How to copy tables from one SQLite database to another, including indexes and foreign key constraints.