Month: December 2022

Python3 regular expression to fetch Domains from a string or Paragraph.

December 20, 2022December 20, 2022 Khapchi No Comments

To generate a regular expression that can extract valid domain names without “www” from a paragraph, you can use the following pattern: This regular expression uses the following elements: This regular expression will match domain names that consist of one or more subdomains, followed by a top-level domain (TLD). For example, it will match “example.com”,…

Technology

Store JSON response from API as separate columns in MySQL table?

December 8, 2022December 20, 2022 Khapchi No Comments

To store the JSON response from an API as separate columns in a MySQL table, you will need to first create a table in your MySQL database with the appropriate columns for each field in the JSON data. The structure of the table will depend on the schema of the JSON data that you are…

Technology

How to store JSON response from an API to MySQL table?

December 8, 2022December 8, 2022 Khapchi No Comments

To store the JSON response from an API in a MySQL table, you will need to first ensure that you have MySQL installed on your computer. You can check if you have MySQL installed by running the following command: If you do not have MySQL installed, you can download and install it from the MySQL…

Technology

How to Query any REST API using Python3 easy.

December 8, 2022January 4, 2023 Khapchi No Comments

To query a REST API using Python3, you will need to first install the requests module. The requests module allows you to send HTTP requests using Python, and is widely used in the Python community. You can install the requests module using pip with the following command: Once you have installed the requests module, you…

Technology

How to fetch all DNS records of a Domain using Python3.

December 8, 2022December 8, 2022 Khapchi No Comments

To fetch all DNS records of a domain using Python3, you can use the dnspython module, which provides functions for working with DNS records. The dnspython module allows you to fetch the DNS records of a domain and access the individual fields of each record, such as the type of record, the TTL (time to…

Technology

How to make DNS lookup of an IP or Domain using Python3.

December 8, 2022December 8, 2022 Khapchi No Comments

To make DNS lookups for a domain or IP using Python3, you can use the socket module, which provides functions for working with network sockets. Specifically, you can use the gethostbyname() and gethostbyaddr() functions to perform DNS lookups for domain names and IP addresses, respectively. Here is an example of how you might use the…

Technology

How to connect to Local MySQL Db using Python3

December 8, 2022December 8, 2022 Khapchi No Comments

To connect to a local MySQL database with Python3, you will need to first ensure that you have MySQL installed on your computer. You can check if you have MySQL installed by running the following command: If you do not have MySQL installed, you can download and install it from the MySQL website: https://www.mysql.com/downloads/ Once…

Technology

Install and configure Squid3 for Ubuntu20.04 for known hosts – IP Access

December 8, 2022December 8, 2022 Khapchi No Comments

To configure Squid3 proxy on Ubuntu 20.04, you can follow these steps: This should display the Squid process and the port number it is listening on. You can now use your Squid proxy to route traffic for your network. Keep in mind that you may need to configure your network settings to use the Squid…

Uncategorized