According to the latest news from Huawei's official website, the compiler tool Ark compiler has been released. According to reports, the Ark compiler is a cross-compiler suite developed by GCC. It includes front-ends for C, C++, and Fortran, as well as libraries for these languages (such as libstdc++, libgcc, etc.). HCC runs on an X86 linux architecture server and the generated binary runs on the Aarch64 architecture server.

Preparation before installation

1) Environmental requirements

The Ark compiler supports the following 64-bit operating systems.

SUSE12sp4 and above.

Ubuntu 16.04 and above.

Other glibc versions are available in Linux distributions 2.22 and above.

2) Get the package

Installing the Ark compiler requires an open source package as shown in Table 2-1.

　　GCC 7.3.0 编译器源码包 　https://ftp.gnu.org/gnu/gcc/gcc-7.3.0/gcc-7.3.0.tar.gz
　　Binutils 2.31.1 汇编器、链接器等二进制工具集源码包 　https://ftp.gnu.org/gnu/binutils/binutils-2.31.1.tar.gz
　　Glibc 2.29 GNU libc 库源码包 https://git.linaro.org/toolchain/glibc.git/snapshot/glibc-2.29.tar.gz
　　Mpc 1.1.0 复数运算库 　https://ftp.gnu.org/gnu/mpc/mpc-1.1.0.tar.gz
　　GNU MPFR 4.0.2 多精度浮点计算库 　https://www.mpfr.org/mpfr-current/mpfr-4.0.2.tar.gz
　　isl 0.21 集和线性约束范围内整数点关系的操作库 　http://isl.gforge.inria.fr/isl-0.21.tar.gz

Install the HCC compiler

1) Operation steps

You can use the HCC tarball to install HCC anywhere under the current user privilege without affecting the use of other compilers.

a) Introduce the operation portal, for example, log in to the XX environment with the XX account.

b) Login HCC download address to download the compressed package

Hcc_arm64le.tar.gz

c) Copy the tarball to the directory you want to install.

The command script is as follows.

Cp hcc_arm64le.tar.gz /path/to/your/dir

d) Unzip the package.

The command script is as follows.

Tar zxvf hcc_arm64le.tar.gz

e) Set environment variables.

The environment variable command script is set as shown below.

Export PATH=/path/to/your/dir/hcc_arm64le/bin:$PATH

The build tools provided by the HCC compiler are in the =/path/to/your/dir/hcc_arm64le/bin directory.

2) Check after installation

After the HCC compiler is installed, you can run the aarch64-linux-gnu-gcc -v command to query the HCC version.

software download

Download source code:Download now

According to Huawei's official introduction, the Ark compiler is the first static compiler to completely replace the language virtual machine, completely without an interpreter. A compiler that takes into account Java development efficiency and C language runtime efficiency. Compared to the existing compilation mechanism:

1. The Ark compiler is a static compilation method. In the existing Android system, running an application first starts the virtual machine, then reads the application code and interprets the execution one by one. It will occupy more processing resources and affect the efficiency of program execution. Of course, there are also early or runtime compilation techniques, such as AOT or JIT, that convert some of the programs into machine code and execute them directly on the CPU. However, it is still not possible to do 100% to get rid of virtual machine execution, which is the key to the current Android camp is not as good as the IOS camp.
2. The static compilation mode of the Huawei Ark compiler can directly translate the dynamic features in the language into machine code. After the application is installed, the mobile phone can run the program at full speed, completely eliminating the drawbacks of the virtual machine and bringing about great improvement in efficiency.
3. The Ark compiler is a compiler deployed in the development environment, and the existing compilation process mainly occurs on the mobile phone, which brings additional resource consumption.

At present, the Ark compiler is compiled and optimized for the general-purpose ARM chip architecture. In the future, the capabilities of the Kirin chip will be maximized through software and hardware co-design. At the same time, the Ark compiler supports Java standard usage, and the three-party application can be compiled directly without modifying the code. But if you want to get better performance or memory improvements, you can adjust the code structure and optimize with the Ark compiler.

This shows the number of connections per each DB:

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame

show total Connections

SELECT 
    COUNT(dbid) as TotalConnections
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
    

If you need more detail, run:

sp_who2 'Active'

Note: The SQL Server account used needs the 'sysadmin' role (otherwise it will just show a single row and a count of 1 as the result)

Have you ever needed to view your chat messages while reading an article within WeChat or playing a Mini Game? It’s a hassle to back out of your article mid-stream in order to check your messages.

Floating Window was initially introduced in 2017 as a way for you to save your place and minimize an article while checking other parts of WeChat like chats. We’ve now greatly expanded Floating Window so that you can “float” up to 10 different windows. Windows can be articles, document previews, or nearly any other type of content. When viewing a music or audio Mini Program, you’ll also be able to see what’s playing via our new music display in Floating Window. Floating Window makes multi-tasking within WeChat a breeze.

When viewing an article, document preview, or other content, simply swipe right and hold to minimize the article to your Floating Window.

about more features，refer to：
https://blog.wechat.com/2019/07/17/wechat-7-0-5-for-ios-and-android/

The Tencent Open Source Mirror Site has been launched recently. Its official name is Tencent Cloud Software Source, which is supported by Tencent Cloud.

The official said that the purpose of building this open source mirror station is to promote the value of free software, improve the cultural atmosphere of the free software community, and promote the application of free software in China.

Tencent's open source software image site provides downloads of major Linux distributions such as Ubuntu, Arch Linux, CentOS, and Debian, as well as popular open source projects and SDK downloads such as the Android SDK, Ceph, Flutter, Qt, and Zabbix.

In terms of speed, some netizens provided a screenshot of the Ubuntu ISO file for reference:

By using the Tencent cloud image source, the problem of slow access to the official source when installing software dependencies can be solved to some extent.

In addition, Tencent software source station supports public network access and intranet access of Tencent cloud server. Cloud servers without public network export can use software source station through intranet, which is convenient for users to freely build service structure.

公网域名 http://mirrors.cloud.tencent.com/

内网域名 http://mirrors.tencentyun.com/

Last week, the WeChat Security Center released the "Development and Promotion of the "Data Wizard" plug-in interference WeChat operation court trial 1 million compensation", once again affirmed WeChat's attitude of cracking down on external behavior. Recently, we found that some users still use third-party plug-in software developed based on Xposed, Substrate and other technical frameworks to invade the WeChat process and data, and tamper with WeChat client data and logic to achieve malicious marketing and fraud. In this regard, the WeChat security team will carry out special cleanup and continue to crack down.

The plug-in software utilizes (including but not limited to) Xposed, Substrate and other technical frameworks to inject control modules into the process space of WeChat software, modify the functions and interfaces of WeChat, add malicious functions, seriously damage user rights, and interfere with the normal operation of WeChat. It is an illegal and illegal act.

For accounts that explicitly use the plug-in function, once confirmed, the WeChat security team will make restrictions until the login is restricted; for multiple violations, the penalty will be aggravated according to the gradient processing principle. In addition, WeChat will retain all rights to pursue legal liability for exploiting malicious features such as xposed and substitute, harassing users, disrupting the platform environment, illegally profiting behavior and its business entities.

The plug-in software developed by unscrupulous merchants based on Xposed, Substrate and other technical frameworks includes, but is not limited to, the following functions: violent plus powder, message one-click group push, automatic reply robot, global virtual positioning, WeChat group automatic promotion, micro-signal batch addition and deletion Etc. These plug-in functions breed and condone malicious marketing behaviors, greatly increasing the possibility of malicious behaviors such as fraud, causing harassment and even loss to normal users, seriously disrupting the health of the platform and causing serious harm:

WeChat plug-ins provide convenient conditions for malicious marketing behavior and cause harassment to normal users of WeChat;

It is easy to be used by criminals to publish bad information and commit fraud, which has contributed to the occurrence of illegal crimes;

Without the authorization of Tencent, tampering with WeChat function, harassing normal users, undermining the ecological balance and normal operation of WeChat platform;

There are security risks such as collecting leaked user privacy information and stealing user account passwords.

WeChat team has always been committed to creating a green, safe and healthy network environment, and against any behavior that disrupts the normal use of WeChat. For such serious damage to the user experience, we will continue to crack down on the "People's Republic of China Anti-Unfair Competition Law" and other laws and regulations, as well as "Tencent WeChat Software License and Service Agreement" and "WeChat Personal Account Usage Specifications".

Finally, we appeal again, please cherish the right to use your account, for your information security and account function, please do not use any form of plug-in software, especially under the various "WeChat marketing" "micro-marketing" banner But in fact, some plug-in services or features are provided. If you have installed or are still using a plugin, please uninstall it now. If you find that friends in the circle of friends and WeChat use WeChat plug-in software, you are welcome to use the WeChat client and the small program "Tencent 110" to complain. The WeChat security team will check the content of the complaint, and once confirmed, it will be resolutely dealt with.