All posts by Jonathan Dough

Content
Blank Image

Partition by SQL: Window Functions

SQL is powerful. But sometimes, just filtering and grouping data isn’t enough. There’s a secret weapon in SQL’s toolbox — Window Functions. And they get super useful when you mix them with PARTITION BY. TLDR: Window Functions let you do calculations across rows related to the current row. Adding PARTITION BY breaks the data into […]...
Content
Blank Image

Building a Contact form to send email Javascript

Creating a functional contact form on your website is an essential part of engaging with users, collecting leads, and providing support. However, one common challenge for developers is ensuring the form can send emails directly using JavaScript, especially when working on the front-end without a dedicated back-end server. In this article, we’ll explore a secure […]...