Posts
All the articles I've posted.
Using Prisma to Bridge JavaScript Devs to Databases with Elegance
Published: at 08:00 PMConfused about Prisma's approach to database joins and when to use raw SQL versus native functions? Dive into this post for clarity. We demystify Prisma's handling of database relationships and guide you on when to leverage the precision of raw SQL within the Prisma ecosystem
Using Prisma with TypeScript for Rapid Database Query Testing
Published: at 08:00 PMPrisma, paired with TypeScript and Node.js, empowers developers with a swift, direct-to-console query testing environment. This streamlined approach facilitates quick prototyping and refinement, eliminating the need for complex service or web page integration. It's a modern developer's toolkit for effortless database interactions, offering a rapid feedback loop for the perfect query. Dive in and simplify your database journey!
Leveraging AI to Iteratively Improve Code Quality
Published: at 08:00 PMIn today's blog, we look at how AI, particularly ChatGPT, can be an invaluable collaborator in the software development process. The case in point? Creating and iteratively improving an email obfuscator for the large-scale event, Silicon Valley Code Camp. This isn't just about generating code; it's a deep dive into enhancing code quality and boosting developer productivity.
Managing Job Queues in Bull While Preventing Log Clutter from Unprocessed Jobs
Published: at 08:00 PMThis blog post explores how to efficiently manage job queues in Bull, focusing on a specific use case, email processing. We delve into the nuances of serial queue processing and discuss strategies to prevent unnecessary log clutter from jobs that find no work to execute.
How to Determine Disk Space Usage in MySQL
Published: at 08:00 PMThis blog post serves as a beginner-friendly guide to understanding disk space utilization in MySQL databases. It provides a step-by-step approach to find the size of individual tables within a specific schema and extends that to summarizing disk space for all schemas. Using simple SQL queries executed in MySQL Workbench, you can acquire both table-level and schema-level size metrics, essential for database optimization and management. The post is a valuable resource for those seeking to grasp their database's footprint.