Pavol Z. Kutaj articles - 34 total
The Most Interesting (mostly) Tech Reads in February 2025
Don't Believe Him (by...
The Most Interesting (mostly) Tech Reads in January 2025
Databases in 2024: A Year in Review // Blog // Andy Pavlo - Carnegie Mellon...
How to combine rg with less in terminal
USECASE The aim of this page 📝 is to explain how to paginate the results of ripgrep (rg)...
How to Use Delta Pager without Headings
The aim of this page📝 is to explain how to configure Delta to omit hunk headers in git diff outputs,...
Explaining self-join in SQL
The aim of this page📝 is to explain self-joins in SQL and how they can be used...
How to Copy/Duplicate a File Duplicate in Vim (netrw+vinegar)
USECASE The aim of this page 📝 is to explain how to duplicate a file in Vim using the...
Explaining DELETE vs DROP vs TRUNCATE in SQL
The aim of this page📝 is to explain a difference between three similar clauses in SQL: DELETE FROM vs...
Explaining Relation and Data Independence in SQL
USECASE The aim of this page📝 is to explain data independence in relational and...
Explaining (the need for) SQL's Common Table Expressions (CTE)
usecase The concern is documenting the use of COMMON TABLE EXPRESSIONS as used repeatedly...
How to Build Personal Curicullum Locally in Python
USECASE The aim of this page 📝 is to explain how to learn SQL with Mode's tutorial using...
Explaining Null Device or Black Hole Register in Vim
The aim of this page📝 is to explain the concept of registers in Vim, particularly the black hole...
Explaining Transaction Count as Important Constraint for adding additional AWS Kinesis Consumers
USECASE The aim of this page📝 is to explain the significance of monitoring CloudWatch...
How to Create a Markdown Code Block in Vim With a Single Keystroke
The aim of this page📝 is to simplify the creation of markdown codeblock to code that is already in a...
How I'm Automating `resume.pdf` creation with Git Hooks and Pandoc
USECASE The aim of this page📝 is to explain how I automatically convert a Markdown file...
The Most Interesting Mostly Tech Reads of 2024
List of texts / podcast that caught my attention last year (2024 edition). FEB 2024 ...
Explaining Iterable vs Iterator in Python
The aim of this page📝is to demonstrate the dynamics of the 2 iteration protocols:...
How to use iPython in VS Code
The aim of this page 📝 is to explain how to use IPython as the default Python REPL (watch Sebastian...
Explaining DNS NXDOMAIN status in SOA Record Type: On Non-Existing Domains
The aim of this page📝 is to explain DNS querying and filtering using jq and doggo. This is Today I...
How to Modify Multiple Various Matches at Once in Vim
As Drew Neil instructed us in Practical Vim, it's great to decouple search (/) and Ex command (:)...
On Vim's Modal Nature and the Importance of Tools: The Example of Numbered Registers
The aim of this page📝 is to share a small perspective on Vim as a great tool — even if modal and...
How to Use Typing Module to Annotate Function Definition with Input and Output Types in Python
The aim of this page📝 is to explain how to use type hints in Python, specifically for functions that...
Explaining defaultdict in Python
USECASE The aim of this page📝 is to explain the concept and usage of Python's defaultdict...
How to use jq for URI encoding
USECASE The aim of this page📝 is to explain how to URI-encode a password in a shell script...
How to Print the Last Field in Bash with awk
USECASE The aim of this page📝 is to explain how to print the last field in a line of text...
How to Skip Empty Lines in Bash Using awk
The aim of this page📝 is to explain how to use awk in Bash to process specific lines of output and...
How to Recursively Delete PDF Files in Bash using `find`
USECASE The aim of this page📝 is to explain how to recursively delete PDF files using the...
Explaining Elastic IP Addresses in AWS
The aim of this page is to explain AWS Elastic IPs and their uses. I was under the incorrect...
Explaining CAA DNS Record
The aim of this page is to explain Certificate Authority Authorization (CAA) DNS records and how they...
Explaining tenancy in cloud computing
Understanding Tenants in Cloud Services The aim of this page is to explain what tenancy...
Comparing jq VS js String Interpolation
The aim of this page is to explain string interpolation based on the particular example of using JQ...