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

• 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.