This blog is rated  R⃣ , viewer discretion is advised

Re-index page on Google Search Console

Request indexing webpage with Google used to be fun and simple, now it's a tedious task especially when you have tons of old pages ready to be crawled yet Google is reluctant to move.

Here is a simple script to speed up the stacks of page you have click in …

Posted

stdout

人教版语文课程《一只奶酪》

起初是娃的一个作业,被打了叉,百思不得其解

于是翻开课文仔细读一下

一块奶酪 作者:辛勤

蚂蚁队长集合好队伍,向大家 …

Posted

stderr

软件开发流程高血压五步曲

有个说他们实习生按字面意思回答了一个题

正经的回答是什么呢?

  1. design
  2. develop
  3. test
  4. fix
  5. deploy

还是

1 ...Sales guy tells you he sold a product
2 ...That doesn't exist
3 …

Posted

stdin

美国自来水 TDS 这么高?

看到个讲 Solar Roof 视频

他们家的 filtered tap water 测出来 TDS 为 358ppm

tap water 测出来 TDS 是 435 ppm,

说加州的市政供水很硬,有大量的钙、镁离子。都不 …

Posted

stdout

TiDB 的日期比较和 MySQL 不兼容

MySQL的

> select VERSION()
+-----------+
| VERSION() |
+-----------+
| 8.0.15-6  |
+-----------+


> select NOW() > '';
+------------+
| NOW() > '' |
+------------+
| 1          |
+------------+

> show warnings;
+---------+------+----------------------------------------+
| Level   | Code | Message                                |
+---------+------+----------------------------------------+
| Warning | 1292 | Truncated incorrect datetime value: '' |
+---------+------+----------------------------------------+

TiDB:

> select VERSION()
+--------------------+
| VERSION()          |
+--------------------+
| 5.7.25-TiDB-v5.1.0 |
+--------------------+
1 row in set

> select NOW() > '';
+------------+
| NOW() > '' |
+------------+
| <null>     |
+------------+

> show warnings;
+---------+------+------------------------------+
| Level   | Code | Message                      |
+---------+------+------------------------------+
| Warning | 1292 | Incorrect datetime value …

Posted

stdout

Reddit UGC ranking (2021-09)

Subs ranking by daily comments

# sub cmts
1 AskReddit 112821
2 teenagers 50489
3 CryptoCurrency 43918
4 soccer 33827
5 Kanye 31862
6 memes 31607
7 FreeKarma4U 29070
8 Superstonk 27203
9 politics 24951
10 AmItheAsshole 24459
11 news 21112
12 worldnews 19963
13 PublicFreakout …

Posted

stdin

记一次离奇的梦

先是梦见去一个泥泞的乡间瞎逛,路上看到田间地上躺一人,很脸熟,左看右看发现长得极像中学同学W;

W居然失去了双 …

Posted

stderr

MySQL on duplicate key in SQLAlchemy

A simple function to upsert something atomically into MySQL

def upsert(val1, val2, **kwargs):
    """upsert val1-val2 pair into mysql and return the pk"""
    from sqlalchemy.dialects.mysql import insert
    from sqlalchemy.sql.expression import func

    # this val1-val2 pair should have UNIQUE KEY constraint in MySQL table.
    stmt = insert(MyModel.__table …

Posted

stdout

自由意志

人有自由意志吗?今天听刚哥 说Robert Sapolsky 的书 Behave。书中说到:

1980 年代,神经生理学家本杰明·李贝特(Benjamin Libet)做了一个被传诵至今的经 …

Posted

stderr

Clarkson's Farm 观后感

Clarkson's Farm 居然是我对现代机械化农业入门的第一个的片子。乱写一些

  1. 兰博基尼的拖拉机(Lamborghini R8 270 DCR)真是 nb。40个前进档,40个后 …

Posted

stderr