A collection of tech notes, personal reflections, and evolving thoughts about whatever’s caught my curiosity.

essay

Codbix No.7

30 November 2023
Welcome to Issue #7 of The Codbix! This week: Habits of great software engineers, Decision Making at Netflix and How to get your brain to focus.
essay

Codbix No.6

31 October 2023
Welcome to Issue #6 of The Codbix! This week: Use code visibility to illuminate unfamiliar code, Laravel community and How to Get Your Brain to Focus.
essay

Karnataka Travel Diaries

25 October 2023
One of the most memorable trips I ever had was to Karnataka in August 2012. It was part of my college tour and I had a blast with my ...
essay

Hugo image shortcode

24 October 2023
This website is built with Hugo, a static site generator that uses Markdown for writing content files...
notes

Display refresh rate

4 October 2023

The refresh rate of a display is the number of times per second that the image refreshes on the screen. For example, a 60Hz display will update the screen 60 times per second.

References

Windows Doc

essay

Hugo alert box shortcode

24 September 2023
If you are using Hugo as your static site generator, you might want to create a card shortcode that can display different types of information on your blog posts...
essay

Hugo Custom Shortcodes

2 September 2023
Writings comments in the code will help you and anyone who reads the code by giving more readability and understandings.
notes

PL SQL Constraints

27 August 2023

To find the constraints in a table

ALL_CONSTRAINTS: Provides information about all constraints accessible to the user, across all tables in the database. It includes constraint types, status, and more, but doesn’t show column-specific details.

SELECT * FROM ALL_CONSTRAINTS 
WHERE TABLE_NAME='YOUR_TABLE_NAME' 
AND OWNER = 'OWNER_NAME';

To find the constarints referring to a table.

SELECT * FROM ALL_CONSTRAINTS 
WHERE R_CONSTRAINT_NAME IN ( 
    SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS 
    WHERE TABLE_NAME='YOUR_TABLE_NAME' 
    )
AND OWNER = 'OWNER_NAME';

USER_CONS_COLUMNS: Shows details about columns associated with constraints for tables owned by the current user. It’s useful for checking specific columns involved in constraints like primary keys, foreign keys, or unique constraints.

SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, POSITION
FROM USER_CONS_COLUMNS
WHERE TABLE_NAME = 'YOUR_TABLE_NAME';
notes

The Simplest way to load CSS asynchronously

27 August 2023

Sometimes we want to load the CSS asynchronously to reduce the intial page load and you can do the same by adding media="print" onload="this.media='all' to the link as below.

<link rel="stylesheet" href="/path/to/my.css" media="print" onload="this.media='all'">

Let’s dive into the details of the above:

  • The link’s media attribute is set to print.
  • print is a media type that applies to print-based media or when the user tries to print the page.
  • By using media="print", the CSS file loads asynchronously (since it’s not needed immediately for screen display).
  • However, we still want to apply the styles to the page for screen use.
  • To achieve this, we can use the onload attribute to change the link’s media to all once it finishes loading.
References

filamentgroup