@pradeepchodisetti

Text and Pattern matching in Postgres

Jan 18, 2024 · 7 min read · Text matching is a pretty common problem while working with SQL. LIKE, SIMILAR TO and POSIX are pretty common querying use cases. But, taking advantage of indexes when using these is something to pay attention to. A simple b-tree index on a text/varc...

URL redirection

Jan 18, 2024 · 5 min read · URL redirection is a concept where a browser when visits a source URL gets redirected to a destination URL. There are multiple reasons to do so some of which are :- Want users to always visit your site on HTTPS instead of HTTP. Have a shortened URL...

Assigning a rate-based rule to WebACL in WAF classic on AWS

Jan 18, 2024 · 2 min read · You can assign rules to your WebACL in your WAF classic but what you can also do are assign rate-based rules to it. You will use this when you need to apply rate-limiting at your WAF level. And if you are trying to do it via Cloudformation like below...

CGI and mod_perl

Jan 18, 2024 · 4 min read · CGI CGI or Common Gateway Interface is a standard protocol that defines how web servers and external programs can communicate. It allows web servers to execute programs written in various languages, such as Perl, Python, and PHP, in response to web r...

Hub vs Switch vs Router

Jan 18, 2024 · 1 min read · HubSwitchRouter FunctionConnects devices within a LAN in a simple broadcast mannerConnects devices within a LANConnects networks and allows devices to communicate across them OSI layerLayer 1 (physical)Layer 2 (data-link)Layer 3 (network) Data t...