Summary

I have a ton of scrap wood (woodworking is my hobby) and time to spare in my job search. So here I am coding Snuky by the bonfire—finishing a new feature that enables me to take control of each job opportunity and refine my process for other job opportunities.

Issues Encountered

Drizzle ORM

I chose Drizzle ORM for Snuky because I like exploring new technologies. I've used Prisma, Sequelize, and Postgres.js for most of my JavaScript career and don't have issues with them, but I prefer not to rely on the same tools repeatedly. Drizzle is new to me and I want to see how intuitive it is and how it compares to what I've already used.

Interoperability

When I migrated the project from using SQLite to Postgres, I had to change my Drizzle ORM queries. For example, here's some code showing how to get my resumes using SQLite and Postgres implementations. I'm using drizzle-orm@~0.45.2 here btw.

const db = drizzle ( /* configs */ )

// SQLite impl const result = await db . select () . from ( resumes ) .…