GitHub Hot Flash Vol.26: Hand to hand with you to do the database

Author: HelloGitHub- Dried fish

Abstract: Taking things by the hand should be the most friendly gesture for learning new things. ToyDB is a “toy” project that can’t be used in real development, but you can learn how to make a distributed database related protocol, etc. Also friendly is the abstreet mini-game that takes you through the traffic problems caused by small changes in the city. As for understanding the problem, there’s fgProf, a well-known Go developer’s open source performance sampling tool, and Tsunami, a bug detection gadget Google just opened.

The following is an excerpt from GitHub Trending at @helloGithub. Newly released | | practical and interesting, according to the project classification, the release time release time not more than 7 day program will be marked New, without the mark shows the project release more than one week. Due to the limited space in this paper, there are some projects not shown in this paper, please refer to 🌝

This article directory
- 1. This week, pushing
  - 1.1 How to do database: toyDB
  - 1.2 Security guard against Vulnerability: Tsunami
- 1. Making Trending Zhou Bang
  - 2.1 AB Mini-game: ABStreet
  - 2.2 Sound plugin: cutler.js
  - 2.3 Look like Photoshop: PhotoGIMP
  - 2.4 Microsoft Open Source: Fluent System Icons
  - 2.5 The correct position for programmers to check the weather: wttr.in
  - 2.6 Performance sampling: FGprof
  - 2.7 Internet of Things Platform: ThingsBoard
- 1. This week GitHub Trending is leading the #SQL Editor theme
  - 3.1 Help SQL: Beekeeper Studio
  - 3.2 Visualization: Falcon
  - 3.3 Multiple Database Operations: Hue
- 1. Recommended reading

1. Tweet this week

1.1 How to do database: toyDB

Star growth this week: 800+

ToyDB is a distributed SQL database. As its name suggests, toyDB is a “toy database” that is not intended for actual production, but for anyone learning the inside of a database, how to build a distributed database from scratch, including raft protocol, ACID, B+ trees, and more.

Making address – https://github.com/erikgrinaker/toydb

1.2 Security guard against Vulnerability: Tsunami

Star growth this week: 1000+

Tsunami is a free tool released by Google that performs advanced security scans designed to detect critical vulnerabilities on different computers. The Tsunami vulnerability scanning engine will allow different organizations to protect their user data.

Making address – https://github.com/google/tsunami-security-scanner

2. GitHub Trending Weekly

2.1 AB Mini-game: ABStreet

Star growth this week: 2000+

Abstreet is a project that uses games to analyze how small changes in the city will affect traffic.

Making address – https://github.com/dabreegster/abstreet

2.2 Sound plugin: cutler.js

Star growth this week: 750+

# cutler. js is a back to top plugin that, as its name suggests, works like an elevator during the process of returning to the top, and when the page returns to the top, there will be an elevator “arrived” sound.

Making address – https://github.com/tholman/elevator.js

2.3 Look like Photoshop: PhotoGIMP

Star growth this week: 400+

NewPhotoGIMP is a GIMP patch that brings the GIMP interactive experience closer to Photoshop. Project address →O web page link

PhotoGIMP tweaks GIMP, mimics The interface of Adobe Photoshop, and supports some additional features. For example, hundreds of new fonts, brand new app ICONS and launch screens, and brand new Python filters.

Making address – https://github.com/Diolinux/PhotoGIMP

2.4 Microsoft Open Source: Fluent System Icons

Star growth this week: 950+

Fluent System Icons are Microsoft’s newly opened source mobile Icons for iOS and Android.

Making address – https://github.com/microsoft/fluentui-system-icons

2.5 The correct position for programmers to check the weather: wttr.in

Star growth this week: 800+

Wttr. in is a Python widget that allows you to check the weather at your terminal. It uses WeGO for visualization and for weather forecast information using a variety of data sources.

Making address – https://github.com/chubin/wttr.in

2.6 Performance sampling: FGprof

Star growth this week: 1000+

Newfgprof is a performance sampling tool developed by well-known Go developer felixge. With the FGProf tool, you can analyze CPU and non-CPU performance consumption (such as I/O wait) in your application, which can be used to mix I/O and CPU workloads.

Making address – https://github.com/felixge/fgprof

2.7 Internet of Things Platform: ThingsBoard

Star growth this week: 550+

ThingsBoard is an open source Internet of Things platform for data collection, processing, visualization, and device management. ThingsBoard features scalability, fault tolerance, and superior performance.

Making address – https://github.com/thingsboard/thingsboard

3. This week’s GitHub Trending #SQL Editor theme is the main force

To cut to the chase, let’s take a look at this week’s selection of 3 SQL editing widgets to help you in your daily development.

3.1 Help SQL: Beekeeper Studio

Beekeeper Studio is a free open source SQL editor and database manager for Linux, Mac and Windows. Characteristics of the

An editor with syntax highlighting and automatic completion of SQL queries
Tabbed interface to perform multiple tasks
Sort and filter table data to find what you want
Reasonable keyboard shortcuts
Save the query history for later use
Record the query history, including the query statements used three days ago
Default dark theme

Making address – https://github.com/beekeeper-studio/beekeeper-studio

3.2 Visualization: Falcon

Falcon is a free, open source SQL visualization editor with data query, visualization, and other features. Supports Windows, Mac, and Linux operating systems, links to MySQL, PostgreSQL, and SQLite databases, and displays query results in different forms.

Making address – https://github.com/plotly/falcon

3.3 Multiple Database Operations: Hue

Hue An open-source Apache Hadoop UI system. Using Hue, you can interact with the Hadoop cluster on the Web console of the browser to analyze and process data. Core functions:

Data visualization
SQL editor, supporting Hive, Impala, MySQL, etc
Workflow can be edited and viewed

Making address – https://github.com/cloudera/hue