Andrew Mara
Hello! My name is Andrew Mara. I'm a web developer with 15+ years of experience creating custom websites for clients and running my own websites.
My development experience spans everything from PHP and WordPress back in 2006 to Ruby on Rails in the early 2010s to modern stacks like React/Next.js, Svelte/SvelteKit, and Astro.
On this blog, I'll be sharing my thoughts on web development, productivity, SEO, and whatever else I'm thinking about.
If you'd like to get in touch, you can email me at andrew.mara@protonmail.com.
Projects
Blog
- Generate Unique IDs Per Request in Astro August 11, 2024How to generate unique ids for input and other elements per request in Astro.
- Block Analytics and Ads in Playwright Tests July 28, 2024How to block Google Analytics, Microsoft Clarity, Google Adsense in Playwright tests.
- Faster SQLite LIKE Queries Using FTS5 Trigram Indexes January 8, 2024How to use FTS5 trigram indexes to significantly speed up LIKE and GLOB queries in SQLite.
- Copy SQLite Tables with Indexes January 4, 2024How to copy tables from one SQLite database to another, including indexes and foreign key constraints.