Location>code7788 >text

A Tetris Game Written in SQL "GitHub Hot Topics"

Popularity：975 ℃/2024-09-10 08:26:15

Before we get started on last week's top open source projects, here's a piece of open source news: Nginx has officially migrated to GitHub.

Recently, Nginx officials announced that they have migrated the Nginx open source project from Mercurial to the GitHub code hosting platform, and have started accepting contributions in the form of PRs, Issues feedback, and feature requests, etc. The Nginx project on GitHub is finally "alive"!

GitHub address →/nginx/nginx

Back to last week's popular open source projects, one project really opened my eyes: Tetris-SQL, a Tetris game written in pure SQL. The game's logic and graphics are implemented in SQL, and the core SQL file is just over 500 lines of code, with implementation details and explanations included in the project. The project includes implementation details and explanations. After the shock, let's have a look at some useful development tools, such as chsrc, an all-platform source-swapping tool, WatchYourLAN, a lightweight IP scanning tool, and linutil, a cross-distribution Linux toolkit, which are tools that can solve a certain pain point.

Of course, how can we not have interesting and fun open source projects? The open-source character cultivation game vue-XiuXianGame and the air traffic control online simulator openscope, they are not only interesting, but also can be played at the click of a button.

  • Table of Contents for this article
    • 1. Popular open source projects
      • 1.1 Tetris game written in SQL: Tetris-SQL
      • 1.2 Lightweight IP Scanning Tool: WatchYourLAN
      • 1.3 Cross-Distribution Linux Toolkit: linutil
      • 1.4 Online air traffic control simulator: openscope
      • 1.5 Clean and customizable RAG WebUI: kotaemon
    • 2. HelloGitHub Hot Reviews
      • 2.1 Open source text-based fairy cultivation game: vue-XiuXianGame
      • 2.2 A common source-changing tool for all platforms: chsrc
    • 3. Conclusion

1. Popular open source projects

1.1 Tetris game written in SQL: Tetris-SQL

Main language: PLpgSQL，Star：400，Weekly growth: 400

This project is a Tetris game implemented using only SQL code, demonstrating the power of the SQL language (Turing-complete). It controls the game logic and display through tables and query statements in a PostgreSQL database. Although the project includes Python scripts, they are only used to translate user input into SQL commands. The project also provides out-of-the-box installation and detailed implementation instructions, which, in addition to being fun, can be used as a hands-on project to help explain advanced SQL concepts and deepen your understanding of SQL.

GitHub address →/nuno-faria/tetris-sql

1.2 Lightweight IP Scanning Tool: WatchYourLAN

Main language: Go，Star：3.3k，Weekly growth: 1.2k

This is a self-contained IP scanning tool with web interface, which can be used as a lightweight monitoring platform. It can scan IPs and ports in local/public networks to help users monitor the online and offline status of hosts in real time and record historical data. It also sends out notifications when new devices are detected, allowing operations personnel to quickly understand the current changes in the network, thus making it easier to maintain and track the status of network devices.

GitHub address →/aceberg/WatchYourLAN

1.3 Cross-Distribution Linux Toolkit: linutil

Main language: Rust，Star：1.4k，Weekly growth: 700

This project is a command-line tool designed specifically for Linux to simplify everyday Linux tasks. It uses the Rust language to develop the command line interface and provides a range of commonly used automation scripts and commands compatible with multiple Linux distributions, with features including software installation, system optimization, and security configuration (firewall).

GitHub address →/ChrisTitusTech/linutil

1.4 Online air traffic control simulator: openscope

Main language: JavaScript，Star：600

This is a multiplayer air traffic control simulator developed in JavaScript that simulates a realistic air traffic environment and management. It provides intuitive radar and map views and supports simulation of aircraft takeoffs, landings, flight path planning and air traffic flow management, as well as complex scenarios such as weather, emergencies, and different aircraft and airport environments.

GitHub address →/openscope/openscope

1.5 Clean and customizable RAG WebUI: kotaemon

Main language: Python，Star：11k，Weekly growth: 5k

This project allows you to quickly build a clean, easy-to-customize RAG application with a web interface that allows users to interact with local documents via chat. It's easy to use and feature-rich, with support for multiple users, document previews, multimodal interactions, and embedded LLM APIs and native LLMs.

GitHub address →/Zeyi-Lin/HivisionIDPhotos

2. HelloGitHub Hot Reviews

In this section, we will introduce you to the top open source projects on the HelloGitHub website this week. Meanwhile, we look forward to your sharing your insights and experiences of using these open source projects with us.

2.1 Open source text-based fairy cultivation game: vue-XiuXianGame

Main language: Vue

This is a fairy cultivation simulator based on Developed, interactive text game for players who like placement and fairy cultivation games.

Project Details→/repository/e73a691ffcfa4d0e92a05912fe8c0b46

2.2 A common source-changing tool for all platforms: chsrc

Main language: C

This project can switch to domestic mirror sources for common Linux distributions, programming languages and software with a single command. Written in C, it is efficient and lightweight, and supports speed measurement, multi-platform and project-level source switching, which is suitable for optimizing download speed or solving the scenario of source limitation.

Project Details→/repository/7666ba91e01e4a59be5809b02d9e8ff6

3. Conclusion

Above is the whole content of this issue of "GitHub Hot Spot", I hope you can find the open source projects you are interested in here, if you have other fun, interesting GitHub open source projects you want to share, welcome to theHelloGitHub Share and discuss with us.

Past Review

  • Save money on open source projects
  • 5 Interesting Python Open Source Projects
<Previous Next>