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. ...

This article lists two methods for requesting Archive.today website administrators to delete archived web pages. archive.today (also known as archive.is) is a web archiving service that allows users to save snapshots of web pages. It is similar to archive.org and currently operates the following websites: archive.is archive.today archive.ph archive.vn archive.fo archive.li archive.md How to delete archived web pages on Archive.today? Only website owners can request content deletion. Currently, Archive.today does not have a fully automated deletion method, and deletion operations must be performed manually by the website maintainers. ...

I tested all China AI applications as of February 1, 2025. I only did a simple test of their information retrieval capabilities. The test question is: Suppose you are an MIT PhD student, and you want to know how to buy rice. Please search for relevant information. The AI should find the following content as much as possible: Academic literature Authoritative agency announcements Websites with high-quality content (such as Zhihu) and several literature databases In the following results, I have excluded low-quality references. ...

Preface After using the hexo-submit-urls-to-search-engine plugin for Hexo, you can actively push new links from your Hexo blog to Google, Bing, and Baidu search engine webmaster platforms to improve website indexing quality and speed. This plugin allows you to send all-natural, organically-fed indexing requests to major search engines, once and for all. For example, one of my articles can now sometimes be found on Bing within 5 minutes of being published (this is the best-case scenario, and long-term stability is not guaranteed). See, that’s the power of hexo-submit-urls-to-search-engine. Baidu and Google are slightly slower. ...

This article provides three methods to help you check whether a particular application can be downloaded from the Apple App Store in different regions. Suppose you live in Hong Kong and are excitedly trying to install the ChatGPT application on your iPhone. You open the Apple App Store, but find that the application cannot be found. Then, you use the Safari browser to search for and open the download link, and after jumping to the App Store, you get the message: “This app is not currently available in your country or region.” ...

The webpage displays a dynamic map, marking the locations of major international passenger ferry routes and terminals in East Asia to facilitate travel planning for passengers. East Asia International Passenger Ferry Route Map Blue indicates the route; Red indicates the location of the terminal. Click on a route or terminal to view detailed information. This map requires access through the international internet and is not available to residents of China; a gray background will be displayed if loading fails. ...

This article introduces the differences between TikTok and RedNote. The Chinese social app RedNote, as a potential alternative to TikTok, has rapidly attracted TikTok users looking for a new platform in the past few weeks. Application Introduction TikTok (Chinese name: 抖音, literally means: Shaking Sound, Hanyu Pinyin: Douyin) is a social application developed by the Chinese company ByteDance, with the core function of browsing short videos. In January 2025, a US law called the “Protecting Americans from Foreign Adversary Controlled Applications Act” will come into effect, which may prevent TikTok from continuing to be used in the United States, so many people are looking for alternatives. ...