SEARCH KEYWORD -- DATA ENGINEERING

  Privileged users get removed from database in GoDaddy shared hosting

GaDaddy is a famous web hosting platform where many people put their websites on its platform. If one has low budget and wanna a shared hosting, you can buy the service at GoDaddy and share some hosting resource with others. In such cases, there would be resource limit based on different plans. In this post, we will discuss one scenario which caused our application down caused by database usage on shared hosting plan and hope it helps readers who encounter similar issues. The issue we encounter...

   CPANEL,DATABASE,GODADDY,PRIVILEGED USER     2021-05-25 23:06:50

  Install and configure git plugin in Eclipse

When developing using IDE, it's always a good experience if everything can be done in the IDE including development, testing and version control. This also applies to Eclipse.  In this post, we will show the process of installing and configuring git plugin in Eclipse. The pre-requisite is that you have git installed on your local machine.  The detailed steps for installing and configuring git plugin are below. 1. Installing Git plugin Install using "Install New Software..." menu. ...

   ECLIPSE,GITHUB,GIT PLUGIN     2018-10-13 04:22:06

  Install and enable redis extension in PHP 5.X on Windows

Redis is frequently used as a caching layer for web applications to improve its performance. In PHP 5.x, if one wants to use Redis, the redis extension needs to be installed and enabled first. This post will show how to install and enable redis extension on Windows with PHP 5.X. Basically there are two dlls to be downloaded: php_redis.dll and php_igbinary.dll. Below are detailed steps Go to http://windows.php.net/downloads/pecl/releases/redis/2.2.7/ and find the respective php_redis zip ma...

   PHP,WINDOWS,REDIS,PHP 5.6     2021-07-11 03:52:18

  Why (offset, limit) is slow in database select?

Starting from a problem Five years ago when I was working at Tencent, I found that MySQL request speed was very slow in the pagination scenario. With only 100,000 data, a select query on a single machine took about 2-3 seconds. I asked my mentor why, and he asked in return, "In an indexing scenario, what is the time complexity to get the nth largest number in MySQL?" The pursuit of the answer Confirming the scenario Assuming there is an index on the "status" column, a query like "select * from t...

   SLOW,LIMIT,OFFSET,MYSQL     2023-03-12 05:21:02

  How to check when an API is introduced in GoLang

Normally people would not pay much attention to which GoLang version is being used as lots of functions are backward compatible. However there are cases where GoLang version does matter as some functions may not be supported by old version of GoLang. For example, strings.Builder is introduced in Go 1.10, but below code would fail to be compiled on Go 1.10. package main import ( "fmt" "strings" ) func main() { var b strings.Builder b.WriteString("polarisxu") fmt.Println(b.Cap()) } The ...

   GOLANG,API VERSION,GO TOOL     2021-02-07 00:43:24

  Baidu is in a deadly crisis

In past few days, there was some news about Baidu(China's Google) which put this search engine giant in China in a devastating position. The news is about that the owners of a Tieba(Similar to Google Group) were replaced by a sponsored organization without notifying the original owners. This irritated the original owners of the Tieba and also the public. People are complaining that Baidu is doing something ridiculous and evil. The name of the Tieba group which was sold by Ba...

   BAIDU,NEWS,CHINA     2016-01-13 07:56:17

  Find where the start up page is set in Firefox

Recently I encountered a weird behavior where a strange webpage showing up every time when I launched my Firefox. The first thought came into my mind is that my homepage of Firefox had been tampered. It might be changed because some software changed my browser settings to promote something. So the next immediate thing I went to check was to see my Firefox browser settings. To my surprise, the homepage setting was not touched. It would still open the Momentum screen which would display some beaut...

   WINDOWS,FIREFOX,HOMEPAGE,STARTUP PAGE,HAO123     2021-10-02 02:28:53

  Install and use GSpace to install apps from Google Play on Huawei Harmony OS

Huawei has released its own branded mobile OS Harmony OS sometime back and some Huawei device models now support installing or upgrading to use Harmony OS. Since this OS is Huawei's own OS and it doesn't come with Google Play by default which most of the current Android apps are hosted on. In this case, how can someone install the apps from Google Play on Huawei Harmony OS or use GMS services like Google Play, Google Maps? The solution provided by Huawei is to install GSpace which is an APP cont...

   HUAWEI,GOOGLE PLAY,HARMONYOS     2021-08-01 04:23:58

  Google transferred a domain name to a Chinese company for free

Google just completed a domain transfer to another company in China. The interesting part is that this domain transfer is for free. The story begins with a recent tweet from the CEO Dash Huang of a Chinese game company called X.D. Network Inc who claims that they obtained the domain name taptap.cn from Google for free. From the tweet, Mr. Huang expressed his appreciation to Google for freely transferring the domain name taptap.cn to their company. Their company launched some product ...

   GOOGLE,TAPTAP.CN,TAPTAP     2021-09-29 11:17:18

  Your Ultimate Guide to Restoring Database Backups in SQL Server 2012

Summary: Let’s learn how to restore a SQL Server database backup for SQL Server 2012. There are various methods of taking database backups, which include using T-SQL code, SQL Server Management Studio, or third-party applications. These backups taken are purposely saved to be restored when the database becomes corrupt or crashes, migrating the database, making a copy of the database, and other business requirements. In this crash course, we will be focusing on how to restore SQL Server da...

   BACKUP,MSSQL     2024-09-24 09:38:09

RECENT