How to Install Manticore Search on Linux Devices

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

March 22, 2025 · 2 min · 地球人

(March 2025) Compiling and Installing PostgreSQL 17.4 on Linux

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

March 17, 2025 · 3 min · 地球人

MariaDB Server Error: Unauthenticated? Possibly a MySQL-connector-python Issue

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

March 6, 2025 · 1 min · 地球人

Raspberry Pi OS Worldwide Mirror Sites List

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

March 3, 2025 · 4 min · 地球人

How to Install Raspberry Pi OS on Raspberry Pi (2025)

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

March 1, 2025 · 2 min · 地球人

How to delete archived webpages on Archive.today?

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

February 17, 2025 · 2 min · 地球人

I tested all China's AI Apps

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

February 5, 2025 · 2 min · 地球人

hexo-submit-urls-to-search-engine Documentation

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

February 2, 2025 · 7 min · 地球人

How to find the regions of the Apple App Store where an iOS app is available for download?

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

January 27, 2025 · 3 min · 地球人

East Asia International Passenger Ferry Route Map

The webpage displays a dynamic map, marking the locations of major international passenger ferry routes in East Asia and the terminals at both ends, making it convenient for travelers to plan their trips. Map of International Passenger Ferry Routes in East Asia Blue indicates ferry routes; Red indicates the location of terminals. Click on a ferry route or terminal to view detailed information. This map needs to be accessed via the international internet and is not intended for residents of China; a gray background will be displayed when loading fails. ...

January 23, 2025 · 2 min · 地球人