Posts

Indexes in SQL are a great way to identify and organize records. Indexing a column can also optimize queries as it reduces overhead and improves efficiency on frequently referenced columns. There are different types of SQL indexes, though this blog focuses on the contrast between clustered and non-clustered indexes. Clustered Index A clustered index points to a block of physical data and does not require a separate table for the indexed column values as it directly identifies a record in a table....

Promises… How long can one hold on to such promises? Nonetheless, this short blog refers to promises in JavaScript. There are two static methods from the Promise object that are used to handle multiple promise instances that resolves to an array of values. These methods are useful for validating and aggregating promise results....

In this blog post, I will do a short walk-through on the use of the SQL join clause and its types to retrieve related data between two tables on a simple blogging database. Come and join the venture beyond SQL. What is a SQL join? A JOIN clause is used to combine records or rows between one or more tables through a related column that references another record....

Styling with CSS is fun until you scratch your head when unexpected styling behavior starts to surface. Most of the time, web developers encounter overflowing content after applying style properties to an element. This is a “shoot yourself in the foot” moment where an element starts to overflow when setting such style properties....

Building a personal site is never an easy task, although there are tools and frameworks available for web developers to aid in the building process. In this blog, I will share with you my Hugo development experience and the bits of knowledge I’ve gained when building my personal blogging site....