backend.engg.wikiText and Pattern matching in PostgresText 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...Jan 18, 2024·7 min read
backend.engg.wikiURL redirectionURL 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...Jan 18, 2024·5 min read
backend.engg.wikiAssigning a rate-based rule to WebACL in WAF classic on AWSYou 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...Jan 18, 2024·2 min read
backend.engg.wikiCGI and mod_perlCGI 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...Jan 18, 2024·4 min read
backend.engg.wikiHub vs Switch vs RouterHubSwitchRouter 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...Jan 18, 2024·1 min read