Today, new my column is released, so I take a day off.


踊るバズワード ~Behind the Buzzword(11)ブロックチェーン(5):

「ブロックチェーン」に永遠の愛を誓う ~神も法もかなわぬ無敵の与信システム


Dancing Buzzword - Behind the Buzzword (10) Blockchain(4)

Pledge Eternal Love to the Blockchain: An Invincible Credit System that Defies God and the Law



In this series about blockchain, I'm waging a negative critique of Bitcoin, but the truth is, I'm not really interested in whether I'm right or wrong.


The reason is that we will eventually find out whether Bitcoin will fail or become a fixture in the online world.

実際のところ、私は、私の知識とロジックで、持論を展開していますが ―― 結構な頻度で「予測を外してきました」。

As a matter of fact, I've been "missing predictions" quite often -- although I have my own theories, with my own knowledge and logic.


In other words, I've made a mistake.

そりゃそうでしょう。間違えますよ ―― 私、神様じゃないんだから。

Of course you're right. I'll make a mistake -- I'm not God.



However, it seems that there are many people in the world who are reluctant to admit mistakes.


"keep silent," or "reopen," or "make endless excuses", etc.


To be honest, I think this guy is painful.



Engineers and researchers are continually betrayed by their hypotheses every day.


In my case, every day, I am constantly denied my ideas by the simulations I have created, by the circuits I have created , and the devices I have created.

その結果を見て『いや! 私は間違っていない!!』と言い張っても、意味がありません。

After looking at the results, there is a meaningless to say "I am not wrong!"


Because that will only tighten my own neck.



Trained engineers/researchers act on the assumption that they are "wrong".


It's not embarrassing to make mistakes.

間違えることは、正しい答に辿りつく最短のアプローチであり、そして、「間違え続けることが、私たちの仕事」であって ――

Making mistakes is the quickest way to get to the right answer, and it's our job to keep making mistakes.


Then, "clarify the cause of the mistake and the reason for it" is a set of steps.




The reader of my book, which I introduced the other day, has continued to provide me with further information on matters related to the "Death with Dignity Declaration.


Here is an overview in bullet points (for me).


- Prepare an account that the lawyer can withdraw from (for hospitalization and funeral).


- For the above, you can make an individual contract with a lawyer.


- Make a settlement account (interest free) and put money for the time being in it.


- The requirements for adult guardianship are quite strict.


I (Ebata) have also considered using this system when my father signed up for newspapers on his own.


However, at that time, I was told by the care services that my application was highly likely to be rejected because of the "reasonable and prompt" response of my sister and me(Really).



Here is a checklist of things to consider

■Gmail, LINE, facebook 等の ITのアカウント、パスワード、および解約方法

- IT accounts, passwords, and cancellation methods for Gmail, LINE, facebook, etc.


- How to get rid of online accounts, forex accounts, and exchanges for bitcoin and other cryptocurrencies (I have another $600 worth).


- How to cancel an e-commerce portal such as Amazon, Rakuten, etc.


- Cancellation or termination of cloud servers (AWS, etc.)

■破壊すべきHDD, USBメモリのITガジェット

- HDD to be Destroyed, USB Memory IT Gadgets


- Return or erase confidential documents and equipment (that should not exist).


以前、IDとパスワードを知らせずに夫が死亡して、妻がスマホ、PC、あらゆる電子デバイスが使えなくなって、孤立してしまったという、知人の話を記載しましたが ――

I once described the story of an acquaintance whose husband died without informing her of his ID and password, leaving his wife isolated with no access to her phone, PC, or any electronic devices.


I have no doubt that this situation will arise in the case of the Ebata family.


I think I'll take this opportunity to prepare a lot of things.



Yesterday, I published an email from a person who had a "Notarized Declaration of Death with Dignity. Today, I received an email from him again with the following information.

====== ここから ======

====== From here ======


If you have your family, it is recommended that you discuss the contents with them.


It is common for family members to make decisions against the patient's will (e.g., begging for life-prolonging treatment) at the last minute.

====== ここまで ======

====== To here ======


As a matter of fact, I am also planning to make a "Notarized Declaration of Death with Dignity," and the reason is exactly the "family".



As you may know, I am the one who made the decision to "kill" my father.


This was a judgment based on my own beliefs, based on my own learning, knowledge, examples and "reason".


Even now, I have no regrets.


Nevertheless, it is true that it was a lot of pressure to judge other people's lives by my own beliefs.



In contrast, my daughters, who will be the judges of my life, seem to be "completely unprepared.


Ebata: "Since I've been so clear about how I want to die, I want you to 'kill me properly' in a way that conforms to my will. You are my last line of defense"


Senior daughter: "Hmm, but I'm confident that if a doctor were to tell me in a strong tone of voice that I should prolong your life. I would easily snap"


Ebata: "Oh, my..."


Senior daughter: "Well, I won't resist for three minutes. I'm sure the doctor will break me down right away"


Ebata: "That's not good enough for me..."

次女:「そもそも、それは、パパの命のことでしょう?! パパがちゃんと万全の手配をしておきなさい! 自分ことは自分で、でしょ?」

Junior daughter: "In the first place, it's about your life, isn't it? You have to make sure everything is in order! You can take care of yourself, can't you?"



Unfortunately, my daughters are the ones with the "reason" in this case.


It seems that I need to pre-install a "batch process" that will automatically activate when I am unable to express my will.


I have to be prepared for 'how to get myself killed' with that kind of determination.



I have another parent (my mother) who is living in a bedridden state.

母は、過去に一回、延命治療に関して、自らジャッジをするチャンスがあり、そこで意見 ―― 延命を希望する ―― を表明しました。

My mother has had the chance to make her own judgments about life-prolonging treatment once before, and she has expressed her opinion -- that she wants to prolong her life.


However, I don't know what my mother is thinking about now.


My mother is no longer allowed to express her "change of judgement".


Therefore, my mother's "final judgment" has become the principle and lock for my current actions (her care and life-prolonging treatment).


私の両親が、私に残してくれた最大の教えは ―― その是非や功罪や重圧や葛藤があったとしても、

The greatest lesson my parents left for me was -- no matter the pros and cons, the merits and demerits, the pressures and conflicts,

―― 自分の命の取り扱いは、自分で決めなければならない

"I have to decide how to handle my own life"


that is the necessity of this "self-determined death", I believe.



Previously, I wrote a column whose title is

見せろ! ラズパイ ~実家の親を数値で「見える化」せよ

Let me see! Raspberry Pi - "Visualize" your parents in numerical form.



I received an email from a reader of this column who said that he had actually prepared a "Notarized Declaration of Death with Dignity.



I thought this email would be of great value to many people, so I asked for and received permission to publish it in full.


It is reprinted below.

===== ここから =====

===== from here =====

江端 智一 様

Mr. Tomoichi Ebata


I'm Chaos, a retired *****-based former researcher/engineer.


I always enjoy reading your series of columns.


I had a chronic illness and come to create a Death with Dignity Declaration, but then the COVID-19 pandemic hit us and I panicked and notarized the document.


In addition, I notarized the will, property management contract, voluntary guardianship contract, and the person's wishes after death that cannot be stipulated in the will (no funeral, scattering of bones at sea).


I found Mr. Ebata's series of articles very helpful. Thank you very much.



Rather than a declaration of death with dignity, it was more like a DNR declaration.


(*)DNR: Denial of resuscitation


My biggest fear is that I will be bedridden for an unnecessary length of time and that I will develop dementia.


I also did some research and the only way to legally refuse life-prolonging treatment is to leave a notarized letter.


The original is kept at the notary public's office, some are kept by the lawyer, and the certified copy is kept by the person himself.


Notaries are available for a fee, but they will travel to your home.


I emailed the draft back and forth, revised it, and processed it at home.


I was able to use a word processor to create documents, which was helpful.



Since both ventilators and ECMO are useless if I have COVID-19, I made the following policy.


- Don't use unnecessary life-prolonging treatment. Don't waste medical resources.


- Let me die comfortably. Prioritize palliative care.


- Maximize the time I can move freely and minimize the time from hospitalization to death (even if my total life span may be shortened).


- To prevent the doctor in charge from being prosecuted for medical malpractice, he was allowed to administer IV glucose and oxygen.


- Prohibit surgery even if cancer is found (time spent sleeping in surgery is wasted)


- Specify the treatment to be refused (e.g., tracheal intubation/incision, central venous drip feeding, dialysis, gastrostomy).


I have COPD caused by smoking, and it progresses irreversibly.


(*)Chronic Obstructive Pulmonary Disease


I am receiving home oxygen therapy with an oxygen concentrator.


I'm not going to use the nursing care insurance until the very last minute because of the risk of infection from the helpers.


It was dangerous to go out, so I stopped taking physical examinations and medical checkups.



I've been posting and serializing a column called "Introduction to Finding Information on Infectious Diseases" under the pseudonym of a certain Anonymous on Kadokawa's novel site, kakuyomu.jp.


If you have time, please have a look.


I solved the mathematical epidemiology model SIR numerically (I have Maple and an 8-core Xeon machine + 64 Gbyte ECC memory). I think that 80% of Uncle (Dr. Nishiura)'s claims were correct.


I hope to read about it in your series of column on the theme of "Can enhanced PCR testing control the spread of infection?"


I recommend enhanced PCR testing and detection isolation.

SIRでは、無症状感染者を積極的に検出/隔離すればRt < 1 に向かうはず。

According to the SIR, active detection/isolation of asymptomatic infected patients should lead to Rt < 1.



Although the first day of spring has passed, it is still very cold.


I pray that you will take care of yourself in the midst of the Corona disaster.


I am looking forward to your further works.


インターネット老人会会員 Chaos 拝

Sincerely yours

Chaos, as Internet Seniors Association Member

===== ここまで =====

===== to here =====



Also, it seems that the former prime minister has been making gaffes and slip of the tongue incidents.


I remember him well for the "Ehime Maru" accident, but other than that, all I remember is the gaffe and tongue twister incident.


Nevertheless, since he has held many important positions, I believe he must have strong political abilities (such as coordination and glaring).

政治家とは、そうい資質を持って貰わなければ困るのも確かです ―― 『無理を通してナンボ』です。

Politicians need to have such qualities -- they can't be forced to do anything.



As for this gaffe, I will not participate.


I don't have the time, energy, or inclination to use social media to criticize anyone or anything.


If I am going to criticize, I want to focus on the content and the target of the criticism.


Once a target has been locked, they will continue to criticize it, persistently and persistently.


For the time being, the target will be limited to politicians and the content will be "IT" and "Corona".


ですので ―― 例の元首相について言えば、

So, speaking of the former prime minister, that is

―― イット革命(*)

"It revolution"



(*) He referred to the IT revolution in this way, at a meeting with bureaucrats when he first took office.


「接触確認アプリ「COCOA」、Android版は昨年9月から事実上機能せず 政府謝罪」

"The Android version of COCOA, an app for confirming contact with patients with new coronas, has been effectively disabled since last September, and the government has apologized"

Andoroidスマホを持っている人は激怒していいし、政府は床に頭を擦りつけて謝るべきだ ―― それでいいし、そうでなくてはならない。

People with Android phones should be outraged, and the government should apologize for scraping its head on the floor. That's fine, and that should be.


It is outrageous that the system has not been functioning since the end of September 2020.


I also think that people who have Android phones can file a lawsuit under the State Compensation Act against the government on the grounds that they have been put at risk


(I think this is equivalent to "gross negligence" under Article 1, Section 2, but I know it is difficult to determine the damages.)



That's why, as an engineer, I'm the only one who's willing to say it.

―― Andoroidのスマホって、そういうこと、結構、あるよね

"Android phones do that a lot, don't they?"




I have always thought that it would be a good idea to distribute dummy software that simulates an infected terminal.


I think that the distribution of the simulated software can be limited to only IT experts (i.e. me) who can handle at least public key cryptosystems.


I think it would be preferable for COCOA to display one or two messages a day that say, "Your phone has confirmed a reaction to the test terminal, but it is not contact with an infected person.


「私を助けてくれるのは、過去の私だ」 ―― を実感しています。

I'm realizing that 'The only person who can help me is the past me'.


For a few years now, I've been trying to leave every bit of lousy code, every dirty script, every unsightly SQL statement on my homepage.


Of course, the description is only about "technology", so you know what I do, but you don't know what kind of work I do.

というか、意図的にそういう風に記載しています ―― 必要なら、各種の偽装情報も放り込んでいます。

Or rather, it's intentionally written that way -- with all sorts of disguised information thrown in if necessary.


Because I have a duty of confidentiality regarding my work.



All I have in my notes are the results of using the notes (public information) left by my predecessors and running them by myself.


This is basically a "memorandum transfer to future me", but at the same time, it is intended as a "small contribution to the contributions of my predecessors".

で、こんな「個人的な落書きのようなメモ」が、他の人に役に立っているのか ―― とも思えるのですが、これが結構、役に立っているみたいなんですよ。

So, I'm not sure if these "personal scribbled notes" are useful to other people, but they seem to be quite useful.


It's pretty amazing, but the page that generates the most PV on my wp.kobore.net site is


"A lot of trouble to get a single "tree" into MSYS2 (PGP key unknown)"



「"dial tcp: lookup db on no such host exit" に苦しめられる日々の終焉」

"Day by day of suffering from "dial tcp: lookup db on no such host exit"



Can you believe it?


I even wondered who was using MSYS2.



However, when I looked at the access log, it seems that there are accesses from all over the world.


People are using search engines to find this Far Eastern engineer's page.


And even if they can't read Japanese, they can probably guess what it is from the script that is written.


Whenever I have a technical problem, I try everything I can find, whether the content is in Chinese, Russian, or Arabic.


A cornered engineer will do anything.


「技術メモを世界に公開しておく」というだけのことが、世界中のエンジニアにに貢献している、ということは ―― 決して大袈裟な話ではないようです。

It's not an exaggeration to say that "making technical memos available to the world" is contributing to engineers around the world.


And this is just my personal opinion,


'Lousy code, dirty scripts, and unsightly SQL statements are useful'



Because that would be so much more helpful to me.


To be frank, a clean and concise code is of no use to me.


―― 強いリーダーシップを持っている政治家が求められている

"Politicians with strong leadership skills are in demand"


I don't know if this is true or false, but at least I'm not 'asking for it'.


Anyone who has studied modern history will immediately understand what kind of disasters such a man has brought about.


Rudolf Hitler, Joseph Stalin, Mao Zedong, Pol Pot, Nicolae Ceauescu


Some people may say, "Dictatorship is not the same as strong leadership.


I also believe that it is desirable for leaders to be strong in neighborhood associations, student councils, and private businesses.


However, a "politician" is an entity that can exercise power by being entrusted by the people or by being supported by a violent apparatus.


The combination of "strong leadership" and "politicians" is not the same as normal leadership.



The "economic measures" for the new corona disaster are difficult, but the "infection control measures" have become much clearer.


I think this is being proven by the results of the second emergency declaration.

人と「出会うな」「しゃべるな」「飯食うな」 ―― これまで、ずっと言われてきたことが、やはり正しかった。

Don't talk to people, don't meet people, don't eat with people - all the things they've been told were right.


They were right, so we'll do the right thing.


Go to a restaurant and save Japan's restaurant industry. However, go alone. And eat in silence.


If you eat while looking at your phone, the meal is enjoyable in its own way.


My diary is the best place in the world to learn about "eating alone". Please refer to it.

さて ―― この程度のことに、「強いリーダーシップ」がいるのか? 私たちは、そこまで愚かか?

Now -- do we really need "strong leadership" for something like this? Are we really so stupid?


(There are politicians and bureaucrats who are that stupid. I'm forgetful, so I'll make a list and publish it later. I'll keep updating and publishing it as new fools appear)



What is required of the government is ultra-precise control of the two handles, "economic measures" and "infection control.


This kind of ultra-precise control is based on the principle of "on-the-spot" and "prediction".

制御とは、 ―― 古典制御であれ、現代制御であれ、PIDであれ、ファジィであれ、ニューロであれ、

Control is -- whether classical control, modern control, PID, fuzzy, neuro, etc.


- "On-the-spot" to information as it is obtained from the environment.



- 'Predictions' derived from current controls




Based on the premise that the new coronas will never be completely eradicated, we will have to live in a world of coexistence with the virus.


The means to do this are "on-the-spot" and "predicting.


Of course, it has to be highly mathematical and statistical, logical, and highly targeted.

はっきりと言えることは「これをやれば完璧」 ―― そんな魔法のパラメータは存在しない、ということです。

What is clear is that there is no magic parameter of 'Do this and make it perfec'


The government will continue to declare a state of emergency and the people will immediately respond to it.

結果が出たら、緊急事態宣言を解除する ―― これを、これから何度でも繰り返すのです。

Once the results are in, the state of emergency will be lifted -- and this will be repeated as many times as necessary.


That is the work of government, and the behavioral change that is required of us.



There is no need for "strong leadership.


What is needed is "a leader who can mobilize the full power of government to perform advanced calculations and forecasts and deliver the results.



(1)"gintoyo_postgres_1 docker-entrypoint.sh Up>5432/tcp" というDockerコンンポーネントが動作中であるとする。

(2)docker exec -it gintoyo_postgres_1 psql -U postgres -d ca_sim という方法で、"ca_sim"というDBに直接アクセスできるものとする。

(3)docker exec -it gintoyo_postgres_1 bash → psql -d ca_sim -p 8910 -U postgres という方法でも"ca_sim"というDBにアクセスできるものとする


ca_sim というDBと全く同じものを、ca_sim9という名前で作る

3. 手順

(Step.1) Dockerで直接DBには入らないで、シェルでログインする
C:\Users\ebata\20210203\gintoyo>docker exec -it gintoyo_postgres_1 bash

(Step.2) シェルからDBを作成する(ここでは"ca_sim9")
root@8240d01caea2:/# createdb -U postgres ca_sim9
(Step.3) シェルからDBをコピーする(ここでは"ca_sim"→"ca_sim9") 。"-U postgres"を入れないと、"rootじゃない"等の文句を言われる
root@8240d01caea2:/# pg_dump -U postgres -Ft ca_sim | pg_restore -U postgres -d ca_sim9
■ シェルからpsqlアクセスしようとすると失敗する
root@8240d01caea2:/# psql -d ca_sim -p 8910 -U postgres
psql: error: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.8910"?
# psql -d ca_sim -U postgres
# psql -d ca_sim -p 5432 -U postgres
(Step.4) シェルから出る
root@8240d01caea2:/# exit
(Step.5) Docker exec でアクセスする
C:\Users\ebata\20210203\gintoyo>docker exec -it gintoyo_postgres_1 psql -U postgres
psql (13.1 (Debian 13.1-1.pgdg100+1))
Type "help" for help.
(Step.6) "ca_sim9"が存在するか調べる
postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
 ca_sim    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 ca_sim9   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(5 rows)
(Step.7) "ca_sim9"の中身を調べる
postgres=# \c ca_sim9
You are now connected to database "ca_sim9" as user "postgres".
ca_sim9=# \dt
                 List of relations
 Schema |          Name          | Type  |  Owner
 public | aggregate_result       | table | postgres
 public | area_definition        | table | postgres
 public | ways                   | table | postgres
 public | ways_vertices_pgr      | table | postgres
(21 rows)
ca_sim9=# \dv
               List of relations
 Schema |        Name        | Type |  Owner
 public | bus_position_view  | view | postgres
 public | user_position_view | view | postgres
(5 rows)
=======  ここまで =========