Posts in category “Tips”

SqlSugar: Connection open error . The given key '25971' was not present in the dictionary.

Solution: put charset=utf8mb4 into the connection string.

Conquering GitHub with Your Keyboard: The Power of "gh"

Tired of that browser tab switcheroo just to manage your GitHub tasks? Enter "gh", the command-line superhero that streamlines your workflow.

Why "gh" Rocks

For us command-line ninjas, "gh" is a game-changer. Ditch the endless tab dance! Create a pull request, find yours, it's all right there in your terminal.

Gettin' Started with "gh"

Installation's a breeze, no matter your OS:

  • Windows: Chocolatey to the rescue! Run choco install gh in your command prompt.
  • Linux: Package manager to the rescue! For Ubuntu/Debian, use sudo apt install gh.
  • macOS: Homebrew's your friend. Just run brew install gh in your terminal.

"gh" Setup: Simple as Can Be

Windows users might need to add gh.exe to their PATH for easy access, but Linux and macOS users can just dive right in. No extra setup, just pure productivity.

Exploring "gh"'s Awesomeness

Ready to unleash the power? Here's a taste:

  • See Your Pull Requests: gh pr view keeps you in the loop, no browser needed.
  • Create Pull Requests in a Flash: gh pr create gets things rolling directly from your terminal.

These are just a peek – "gh" has tons more to offer. Explore the docs and discover features that fit your workflow perfectly.

The Verdict

In our time-crunched world, tools like "gh" are golden. By harnessing the command line, you can streamline your GitHub tasks and focus on the real prize: killer code. Give "gh" a try and see how it transforms your development game!

The simplest way to change visudo editor from nano to vi

If you are using ubuntu or debian, the answer is

sudo apt purge nano

It is not a joke, it works! Reference

Surely there is a regular way

sudo update-alternatives --config editor

which is also good. But I love the former way, as it also removes the nano editor, which I nearly never use.

how to do sudo without asking a password

sudo visudo, then add a line at the end of the editor

your-user-name ALL=(ALL:ALL) NOPASSWD:ALL

save and exit, done!

How to get WiFi to work after installing Ubuntu or Lubuntu on Macbook?

Applications I am using on LikeBook S61's android 4.2 system

Although the Android 4.2.2 system that comes with the S61 is outdated, KOReader still runs very well on it (remember to turn off the full-screen switch). The following list is the result of many nights spent searching and trying various versions before finally deciding to keep them. Even if it can be useful to a friend, I am very pleased.

APK File Description
com.duokan.reader-5.0.2-free-www.apkshub.com.apk Duokan Reader, just installed it out of habit as a backup reader. Personally, I find its reformatting of scanned PDFs to be better than KOReader's.
com.gacode.relaunchx_200106000.apk A file manager friendly to e-ink screens.
com.UCMobile.intl_11.4.0.982-10384_minAPI14_apkmirror.apk UC Browser, better than the stock browser, allows easy page scrolling when browsing web pages.
english-dictionary-offline-4-2.apk A classic offline dictionary.
GoldenDict-1.6.7-Android-4.1+-free.apk A domestic dictionary that supports Stardict format, so you can use the dictionaries you have for KOReader directly with it. Why the need for a separate dictionary program? Because the OCR part of KOReader for Android 4.2.2 has a bug and can't OCR before looking up words. When encountering unfamiliar words while reading scanned PDFs, having an independent dictionary to look them up means you don't have to reach for your phone again.
koreader-v2023-06-1.apk The main reading program, I use it for reading every day.
org.ds.simple.ink.launcher-1.2-release.apk Replaces the stock launcher.
SimpleSSHD-27.apk A small SSH server, convenient for syncing ebooks with the rsync program.
tusky.apk The only Mastodon client version I found that still works for Android 4.2, needs to be used with a https://mstdn.plus account.

For ease of downloading, I have compressed the above APK files into a zip package, feel free to download if needed.

中文版 （Chinese version)

虽然S61自带的 android 4.2.2 系统已经老态龙钟，然而 KOReader在上面跑得还是非常好（记着关掉 full screen开关）。以下清单是我花了不少个夜晚寻找尝试各种版本之后最后决定留用的结果，哪怕能对一个朋友有用，我也很欣慰了。

  • com.duokan.reader-5.0.2-free-www.apkshub.com.apk 多看阅读，只是出于以前的习惯装了它做为备用的阅读器。我个人觉得它的扫描版pdf重排比koreader的要好用。
  • com.gacode.relaunchx_200106000.apk 一个对 e ink 屏友好的文件管理器
  • com.UCMobile.intl_11.4.0.982-10384_minAPI14(armeabi-v7a)(nodpi)_apkmirror.com.apk UC 浏览器，比自带的那个好用，在浏览器网页时可以方便的上下翻页
  • english-dictionary-offline-4-2.apk 一个经典的离线词典
  • GoldenDict-1.6.7-Android-4.1+-free.apk 一个国产词典，支持 stardict 格式，所以你用于 koreader的词典，能直接另拷贝一份给它用。为什么需要单独的词典程序？因为支持android 4.2.2 的koreader程序ocr那部分有bug，没法先ocr再取词。在读扫描版pdf时遇到的生词，有个独立的词典查词，就不用再去摸手机了。
  • koreader-v2023-06-1.apk 主阅读程序，日常都用它看书
  • org.ds.simple.ink.launcher-1.2-release.apk 代替自带的launcher
  • SimpleSSHD-27.apk 一个小巧的ssh server，方便我用 rsync 程序同步ebook
  • tusky.apk 我找到的唯一尚可用于android 4.2的mastodon 客户端版本，需要配合 https://mstdn.plus 账号服用。

为方便下载，我已经将以上apk文件压缩成一个zip包，欢迎有需要的朋友下载。