HOWTO: Install Google Play Store / Services onto Xiaomi Redmi 10X Pro 5G Chinese ROM 
I bought a Redmi 10X Pro 5G phone and didn't realize it only comes with Chinese ROM (Nov 2020) which does not ship default with anything to do with Google. This means, no Google Play Store. No Google account, no GMail, no Google Maps etc.

To remedy this situation, you can do the following:

1. Download "GoogleInstaller_3.0.apk" to your PC - this app is shown being installed from the (Xiaomi) Mi App Store in YouTube videos. On the 5G model of the Redmi 10X Pro, you wont be able to do what they do in the videos. Maybe its because the MIUI version on this phone is v12 ? or maybe by Nov 2020 they have updated the Mi App Store app and it is different now? I don't know, but it doesn't work like in the videos. So get the Google Installer APK instead, it is 176Kb according to Windows Explorer. I got it originally from: this page.

2. On the RM10XP5G phone, open the internet browser and go to and click on the "Get It On Aptoide" button. This takes you to Aptoide website, it will be in French, but there will be an orange button icon you can click to download the SendFilesToTV app APK. Get the APK onto the phone and install it.

3. Run SendFilesToTV on the phone, tap "Receive"

4. Install the SendFilesToTV software onto your PC. Run it. In the system tray, opposite click the tray icon for the program, and select "Send files...". Choose the Google Installer APK file and then select which device to send it to (The phone should appear automagically in a list as long as its on the same network as the PC)

5. Now on the phone, use the Files app to open the Google Installer APK file and install it. It should auto-run (going from my sketchy memory). It will be in Chinese, but basically if you see a big blue circle with Chinese writing, you can press that to continue the process of the app. It will install the Google Services Framework and Play Store etc. etc. all the good stuff.

Now that you have Google Services on the phone, you can install your favourite launcher and softwares etc.

I have not trialed this phone completely at time of writing (Nov 2020) as I just got it. I have read some ppl saying there's issues with Maps and GPS, amongst other things, usually to do with the fact it's meant to be a Chinese phone. The hardware is pretty good for the price and I got it mostly to compare the camera quality against a Redmi Note 9 Pro because my wife wanted a phone with better camera ability - so I'll see how it goes.

[ view entry ] ( 3102 views )   |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 267 )
HOWTO Compile spelldiff Extension for SQLite3 on Windows 10 
I recently was able to compile an extension for SQLite3 on Windows 10. I wanted to use the editdist3 function for SQLite3 which is used to compare how similar strings are. To get he function you have to compile the extension from source code. I will provide the compiled extension here as a DLL as well as the process to compile from source.

Firstly, I found that I had a compiler available to me on the Windows cmd prompt. I think this is because I have Qt Creator installed, which is a free download and a great tool for writing GUI programs with C++ if you know about that. So I'll assume you have gcc available to you on the command prompt.

Next, you need to download the source files from the SQLite website:
Get the sqlite-amalgamation ZIP and the sqlite-src ZIP, you will need both.

Extract the sqlite-src ZIP to a temporary folder. Open the sqlite-amalgamation ZIP and copy the sqlite3.h, sqlite3.c and sqlite3ext.h files to clipboard. Open to where you extracted the sqlite-src ZIP with Windows Explorer then go into the ext/misc folder. Paste the 3 files into that folder.

Next, open a cmd prompt and change to the sqlite-src/ext/misc folder. Enter the following command to compile the extension:
gcc -I -g -shared spellfix.c -o spellfix.dll

After a little work time, the cmd prompt will return and you should find a file called spellfix.dll in the sqlite-src/ext/misc folder.

To use the extension, it depends on how you're using SQLite. If you're using a front end program, check the menus for a Load Extension type option, and select the spellfix.dll file. You can then use the editdist3 function in SQLite.


SQLite - Spellfix Implementation
SQLite Download
Qt Creator

[ view entry ] ( 918 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 341 )
Easy Way to Track Domains in PiHole 
After you install Pi-Hole to suck ads from your network, you probably will load some domain lists (gravity lists or something they call them) to black or white list domains. If you start using your devices on the network, you'll probably find somethings don't work because domains are being blocked, and some thing wont block ads.

To monitor pihole's activity you use:

pihole -t

on the linux console command line. This will show in real-time the activity that the pihole software is undertaking. it's very hard to keep track of whats going on with this, as you have to verify the IP of the client and then try to see which domains etc. there's just generally a lot of info going on and the screen scrolls up rather quickly even with only 2 devices connected to pihole.

Instead, you should filte rthe pihole activity down to a single client, the client device you are using to troubleshoot. To do this, just use a pipe and grep the output based on the IP of the device you want to see:

pihole -t | grep .188

For example, this will show me the activity of the device on my network that is

It also filters out the lines in the output that say whether a domain was blocked or not, it will just show us that client .188 accessed whatever domain. We can then load the pihole web interface and check the Query Log to see if the domain is blocked or not, then black/whitelist it to see if it makes the desired change we want.

[ view entry ] ( 515 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 392 )
DC Crossover Series 2019 - Crisis on Infinite Earths 
For anyone looking for a list of the episodes to get to watch the 2019/2020 DC TV Show Universe crossover called Crisis on Infinite Earths, here is the list of episodes to watch from each show:

Part 1: Supergirl.S05E09
Part 2: Batwoman.S01E09
Part 3: The.Flash.S07E09
Part 4: Arrow.S08E08
Part 5: DCs.Legends.of.Tomorrow.S05E01

I looked for a list of the episode numbers to watch and could only find lists telling you the show and air-date of each episode. Looked like no one wanted to bother going to to compile a list of the actual season/episode numbers so here they are.

[ view entry ] ( 414 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 388 )

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next> Last>>