Posts

groupultra telegram-search is a new Telegram user chat history search tool. Some recommendations: Telegram group management bot @CSUBOT: Can send private messages to new users, send CloudFlare web verification codes to perform group entry verification, to verify whether users applying to join the group are real humans. It will not disturb other group members. Query the public network IP of this machine to access different websites, which can detect proxy shunting configurations and avoid being blocked by AI tools. You can view the IP used by users to access Chinese websites, internationally renowned AI websites, blocked international websites, and allowed international websites. Project Features According to the official documentation, Telegram Search provides the following core functions: ...

CSUBOT is an open-source super administrator bot. This article describes how to deploy CSUBOT yourself. Please read this document in its entirety first: CSUBOT Robot User Manual Recommended: Query the public IP of this machine for accessing different websites, used to check the current network environment. Prerequisites To deploy CSUBOT yourself, you need to meet at least the following conditions: Hold a domain name. (Hold at least a second-level domain name for the backend. In fact, the frontend and backend require two second-level domain names in total, but generally the frontend domain name can be provided by the deployment platform) Hold a server. Or deploy it on a platform where backend services can be deployed. If you know of a free platform where backend services can be deployed, please don’t hesitate to click here to post a comment and tell the author . Hold an unrestricted Telegram account for creating a Telegram bot and obtaining the bot’s Token Hold an unrestricted Cloudflare account to enable Cloudflare Turnstile CAPTCHA. Register an account: https://dash.cloudflare.com/ Steps Enable Cloudflare Turnstile Deploy the frontend Create a Telegram bot Configure the backend Enable Cloudflare Turnstile Click this link to open the Cloudflare Turnstile configuration panel Turnstile Component Configuration ...

CSUBOT is a super administrator bot. Currently, it can verify new members through verification codes, automatically preventing spam bots in group chats. More features will be added in the future. Advantage: Does not post verification requests in the group, avoiding interrupting group chats and disturbing other group members. You can click here to test the CSUBOT bot’s group entry review function: Join CSUBOT’s discussion group Recommended: Check the public IP of this machine when accessing different websites to check the current network environment. ...

This article briefly introduces how to enable the BBR congestion control algorithm on Windows devices, and the potential problems of using this feature currently. BBR Introduction BBR (Bottleneck Bandwidth and Round-trip propagation time) is a newer TCP congestion control algorithm developed by Google. It aims to solve the problems of low bandwidth utilization and high latency of traditional congestion control algorithms (such as Reno or CUBIC) under certain network conditions (especially in networks with a certain packet loss rate and latency). ...

In today’s highly interconnected digital age, barrier-free access to global internet information is crucial for learning, work, and personal growth. However, for various reasons, internet access is restricted in some regions. This article will focus on several free and open-source proxy client software for Apple iPhone, and analyze their characteristics in detail, hoping to provide a practical guide for iPhone users who pursue internet freedom. Related recommendation: Query the public IP of your machine accessing different websites to detect proxy routing configuration. You can open it for testing after configuring the client. ...

Manticore Search is a lightweight full-text search engine. This article will guide you through the installation process on Linux devices. Manticore Search itself is an open-source database (available on GitHub ), created in 2017 as a continuation of the Sphinx search engine. Installation Requirements . Installing directly with a package requires: Architecture: arm64 or x86_64 Manticore Columnar Library provides columnar storage and secondary indexes ; if you want to use them, you need a CPU with SSE >= 4.2. No specific disk space or RAM requirements. An empty Manticore Search instance only uses about 40MB of RSS RAM. Devices with ARM64 architecture, such as Raspberry Pi, Apple M1/M2, etc. ...

I successfully compiled and installed the latest version of PostgreSQL (17.4) on Ubuntu ARM32. The commands in this article are mainly derived from the official PostgreSQL documentation. I have actually tested every command in this article. You can see the systems that can be successfully installed here PostgreSQL Buildfarm Compile and Install PostgreSQL 17.4 1. Create a directory and enter the directory mkdir postgresql && cd postgresql mkdir postgresql: Creates a new directory named postgresql. cd postgresql: Enters the postgresql directory that was just created. 2. Download the PostgreSQL source code wget https://ftp.postgresql.org/pub/source/v17.4/postgresql-17.4.tar.bz2 wget: Downloads a file from the specified URL. https://..../postgresql-17.4.tar.bz2: Download link for the compressed source code package of PostgreSQL version 17.4. If the link is invalid, you can find a new link yourself. 3. Unzip the source code package tar xjf postgresql-17.4.tar.bz2 tar: Used to process .tar compressed files. ...

I am using the mysql-connector-python library of mysql to try to connect to the MariaDB database of other devices in the local area network, but it failed, and it exited directly without outputting any error messages. Problem Description Software version: MariaDB server 10.11.6 mysql-connector-python 9.2.0 MariaDB server, IP is 192.168.1.60 Client, IP is 192.168.1.35 Python code is as follows: import mysql.connector import logging # Configure logging logging.basicConfig(level=logging.DEBUG, format='%(asctime)s - %(levelname)s - %(message)s') try: logging.info("Connecting to the database...") connection = mysql.connector.connect( host="192.168.1.60", port=3306, user="mysql", password="xxx") logging.info("Connection established.") # Create a cursor object to execute SQL queries cursor = connection.cursor() # Get all databases logging.info("Executing SHOW DATABASES query...") cursor.execute("SHOW DATABASES") # Print all databases and the table names in each database for (database,) in cursor.fetchall(): logging.info(f"Database: {database}") # Switch to the current database cursor.execute(f"USE {database}") # Get and print all tables in the current database cursor.execute("SHOW TABLES") for (table,) in cursor.fetchall(): logging.info(f" Table: {table}") # Close the cursor and connection cursor.close() connection.close() logging.info("Connection closed.") except mysql.connector.Error as err: logging.error(f"Error: {err}") except Exception as e: logging.error(f"Unexpected error: {e}") After running this code, it exits directly without outputting any error messages. ...

Raspberry Pi OS (formerly known as: Raspbian) mirrors exist in many countries, use the site closest to you for the fastest downloads possible. The sources.list file in Raspberry Pi OS includes Debian’s standard software repositories, and raspi.list focuses on proprietary software and updates specific to Raspberry Pi devices. Together, they make up the system’s software source configuration. Raspbian Repository Mirrors run: sudo nano /etc/apt/sources.list.d/raspi.list Select a site closest to you. Please replace the original link with the link of the mirror site you selected, only replace the link part, and keep the content after the link unchanged. ...

In 2025, how to install Raspberry Pi OS (formerly known as Raspbian) on a Raspberry Pi development board? Install Raspberry Pi OS Download Raspberry Pi OS (64-bit) Lite from Operating system images – Raspberry Pi . Lite is designed to provide a minimal system environment, allowing users to install and configure software as needed. It has no graphical interface and can only be operated through the command line. If you are using a newer 64-bit Raspberry Pi device and need higher performance, it is recommended to choose the 64-bit version. If you need specific legacy software support or encounter compatibility issues, consider using the Legacy version. ...