  |
はてなキーワード: SETとは
単純に言えば、どんなリョナなやレイプものを作っても見ても、犯罪者にならない人は元からならないし、
こういう生きるためにパンを盗んだとは明らかに違う問題(生まれつきの性質)に対しては
これからは逃げないでしっかりと向き合っていかなければいけない。特性大事
サイコパスだって巷で言われていることが「やっべ、ちゃんと再調査したら違ったわ、てへぺろ」って日常だからな
例
↓
［適当な訳］
アスリートでもないのに心拍数が低いのはサイコパスの傾向があるよ
脳と自律神経の働き方に特徴があり、恐怖や興奮などの刺激が感じにくいのではと考えられているよ
Am I a psychopath? You asked Google – here’s the answer
If you’re not an athlete, and your heart rate is lower than average, you may be interested to discover that bradycardia, as it’s known, is more strongly correlated with psychopathy than smoking is with lung cancer.
That doesn’t mean everyone with a slow heart rate is a psychopath, but a very high percentage of psychopaths have slow heart rates.Why on earth would that be the case?
It turns out that there are a number of physiological traits strongly linked to psychopathy, including tell-tale patterns of activation in the brain and autonomic nervous system.
One theory is that psychopaths inherit a set of genes that make it harder to experience fear or excitement.
↓
［適当な訳］
今までの研究のサンプル数が少ないのでやり直してみたら、サイコパス は特別に心拍数が低い とか無かったよ
Resting heart rate and psychopathy: Findings from the Add Health Survey
引用元：
https://www.biorxiv.org/content/10.1101/205005v3
Despite the prior linkages of low resting heart rate to antisocial behavior broadly defined, less work has been done examining possible associations between heart rate to psychopathic traits.
(中略)
No significant relationship between heart rate and psychopathic traits, or heart rate and a measure of cold heartedness, was found after controlling for age, sex, and race.
うおおおおおおおおお！！！！
うんち！wボンバイエ！！
うんち！wボンバイエ！！
ファイッ！ww ファイッ！wwファイッ！ww
ドスドズドズドスブズブズブブ
よろしくンギーwwwwwwwww(産声)
ちーん€ちーん€ちーん€ちーん€
This name refers to a folk story set in the time when smuggling was a significant industry in rural England, with Wiltshire lying on the smugglers' secret routes between the south coast and customers in the centre of the country.The story goes that some local people had hidden contraband barrels of French brandy from customs officers in a village pond. While trying to retrieve it at night, they were caught by the revenue men, but explained themselves by pointing to the moon's reflection and saying they were trying to rake in a round cheese. The revenue men, thinking they were simple yokels, laughed at them and went on their way. But, as the story goes, it was the moonrakers who had the last laugh. In the words of Wiltshire shepherd William Little who recounted the story to writer John Yonge Akerman: “ Zo the excizeman ’as ax’d ’n the question ’ad his grin at ’n,…but they’d a good laugh at ’ee when ’em got whoame the stuff.
ってことらしいです
ここまで読んでいただいた読者の方、
Google翻訳してみた。
"I love You." がダメなのと5行目の主語がyouになってしまっている以外は結構やるやん。
"delicious is delicious" はイマイチか。
Pudding is delicious. I love You.
Fruit jelly is ... delicious is delicious.
It has a fresh and fruity feel and the texture is reproduced with the flesh and seeds.
But if you have raw fruit and superb fruit jelly lined up, you'll get the fruit, right?
If you have eggs and milk set and pudding side by side, take the pudding.
和訳がつめこみすぎてるだけで原語だとわりと聞けるってのは赤鼻のトナカイも同じなんだけど
“London Bridge Is Falling Down” Lyrics
London Bridge is falling down,
London Bridge is falling down,
My fair Lady.
Build it up with wood and clay,
Wood and clay, wood and clay,
Build it up with wood and clay,
My fair Lady.
My fair Lady.
Build it up with bricks and mortar,
Bricks and mortar, bricks and mortar,
Build it up with bricks and mortar,
My fair Lady.
Bricks and mortar will not stay,
Bricks and mortar will not stay,
My fair Lady.
Build it up with iron and steel,
Iron and steel, iron and steel,
Build it up with iron and steel,
My fair Lady.
Iron and steel will bend and bow,
Bend and bow, bend and bow,
Iron and steel will bend and bow,
My fair Lady.
Build it up with silver and gold,
Silver and gold, silver and gold,
Build it up with silver and gold,
My fair Lady.
Silver and gold will be stolen away,
Silver and gold will be stolen away,
My fair Lady.
Watch all night, watch all night,
My fair Lady.
Suppose the man should fall asleep,
Suppose the man should fall asleep?
My fair Lady.
Give him a pipe to smoke all night,
Smoke all night, smoke all night,
Give him a pipe to smoke all night,
My fair Lady.
レジストリ書き換えでキーボードのレスポンスを爆速にするのは一番使い勝手が良かったが、会社のパソコンではできればやりたくない。
EasyMotionは1日で使わなくなった。
{}()[]での移動はカーソルがどこに飛ぶのかわからないので使い物にならない。
Ctrl+F, Ctrl+Bも同様にカーソルがわけわからんところに飛ぶので混乱する。
Ctrl+U, Ctrl+Dはデフォルトでは移動しすぎて同じく使えないが、set scroll=5 としたら使えそう。
マーク機能は面倒くさくて一度しか使ったことないし使う気もない。
%はかっこまで移動しなくてはいけないので使えない。
w, b, W, Bはよく使うが正直どこに行くのかわからなくてイライラする。
f,F,t,T使ってない。どれがどれか覚えられない。
^ 使いたいがキーボード見ずに押せない。代わりに<Space>h と<Space>lに^と$を割り当てているがこれは便利
:{Number} 使わない
まだ模索中
Person person = new Person();
この書き方が謎なんだが、必ずこう書くものなのか？
Person Person では何か不味いのだろうか。
変数の前の「Set」みたいな…ただのClassおまじないだと思って良いのだろうか。
People Person = new People();
これはアリだよな？
{
{
Person person = new Person();
person.firstName = "山田";
person.lastName = "太郎";
Console.WriteLine(person.GetFullName()); // "山田 太郎" と表示される
}
}
public class Person
{
// FirstName プロパティ
private string firstName;
public string FirstName
{
get { return firstName; }
}
// LastName プロパティ
private string lastName;
public string LastName
{
get { return lastName; }
}
{
return firstName + " " + lastName;
}
}
午前中にC#について聞いてた人がいて、ついでに聞きたい。
Person person = new Person();
new Person(); としたら、勝手に「Person.cs」の中の「Person」クラスを探してくれるんだろうか。
前の増田が言っていた、Listのやつも知りたい。
paizaとかで入門動画見てれば分かるだろうか。
https://www.facebook.com/fumio.fumiko/posts/2360650130668865
https://www.facebook.com/fumio.fumiko/posts/2372833612783850
https://www.facebook.com/fumio.fumiko/posts/2404866119580599
https://www.facebook.com/fumio.fumiko/posts/2362445173822694
・はてなブログでずっと僕の悪口エントリを書きつづけている人がいて（ツイッターでもずっと粘着されてる）、ただのつまらない悪口なので（だからこそガチだと思う）放っているのだけど、そろそろ目に余るものが…。こういうのが「低能先生」になるのではないかな。株式会社はてなさん何とかして…。
・この人、僕がツイッターやブログを更新しなくても毎日はてなブログで言及している。嫌がらせすぎる。そして完全にアレですね。
・ツイッターはブロック、ブログは更新せずなのに、相変わらず粘着されているのだけど、何とかならないものですかね。なんらかの心の疾患だと思ってますけど、こういう人がいるかぎり「はてなブログ」で更新を続けるのはちと難しいですね。
・僕に粘着してる人、今日も昼間から元気に粘着してる。暑いのにご苦労様。お薬多めに出しときますねー。
・しかし、僕に粘着してくる人、何とかならないかな。運営は、内容は個人の意見の範囲だから何もできないという見解でそれは納得できるけど、頻度が嫌がらせレベルなのはどうなのか。大爆音じゃなくても耳障りな騒音をずっと鳴らされたら嫌なもんだけどね。
・例の人の件、株式会社はてな様に対応を依頼したら、違法行為ではないから何も出来ないとのこと。予想通りだったけど迅速な回答には本当に感謝（さすが！）。やっぱ我慢するしかないか。とはいえ記事を書くたびに粘着されて不愉快な気持ちになるのも精神衛生上よろしくないので、はてなブログは更新停止。インターネットをつまらなくしているのはごく一部のアホなんだよね…。
https://www.facebook.com/fumio.fumiko/posts/2364214453645766
https://www.facebook.com/photo.php?fbid=2418323331568211
https://www.facebook.com/photo.php?fbid=2367414109992467&set=a.104289222971645&type=3
これを見る限り粘着してる人は二人いる。
片方はこの人。
http://www.hobonichi-ramen.com/
しかし、こちらについてはブログを確認しても、そのような記事が見当たらない。
これってどういうこと？
俺個人はフミコフミオ死ぬほど嫌いなのだが、こういう嫌がらせはよくない。
フミコフミオはフミコフミオで人を馬鹿にするようなことばかり書く癖に批判には一切向き合わないクズであるとは思うが、いちいち相手にする必要はない。
多分嫌がらせしてるやつは、私みたいに嫌いだけどその上で無視できないからこういう頭の悪い行為に出てるんだろうが、あきらめたて距離をとった方がいい。
こういう憎まれっ子世に憚るを体現してるような奴はほかにもたくさんいることを理解しよう。
粘着してる人たちは、なぜホリエモンは赦せてフミコフミオはゆるせないのかよく考えた方がいい。
お前がフミコフミオに粘着してる理由は一見正当だが、なぜフミコフミオだけ？に答えられない以上ただの好き嫌いでしかない。
誰もお前を認めてくれたりはしないし誰もお前を愛さない。
I. INTRODUCTION
These Terms of Use and End User License Agreement (collectively, the “Agreement”) together with all the documents referred to in it constitute a legally binding agreement made between you as a natural person (“you”, “your” or “user”) and We (“we,” “us” or “our”), concerning your access to and use of the software application for mobile devices (the “App”).
All the documents that relate to the App are hereby expressly incorporated herein by reference.
Please read this Agreement carefully before you download, install or use the App.
It is important that you read and understand this Agreement as by downloading, installing or using the App you indicate that you have read, understood, agreed and accepted the Agreement which takes effect on the date on which you download, install or use the App. By using the App you agree to abide by this Agreement.
If you do not agree with (do not accept) this Agreement, or if you do not agree at least with one of the provisions of this Agreement, you are not authorized to, and you may not access, download, install or use the App and you must ly discontinue downloading, installing the App and remove (delete) the App from any mobile device in your possession or under your control.
We reserve the right, at our sole discretion, to make changes or modifications to this Agreement at any time and for any reason. We will keep you informed about any changes by updating this Agreement and you waive any right to receive specific notice of each such change. It is your responsibility to periodically review this Agreement to stay informed of updates. You will be subject to, and will be deemed to be aware of and to have accepted, the changes in any revised Agreement by your continued use of the App after the date such revised Agreement is posted.
III. RESTRICTIONS ON WHO CAN USE THE APP
In order to download, install, access or use the App, you must (a) be eighteen (18) years of age or older.
All users who are minors in the jurisdiction in which they reside (generally under the age of 18) must have the permission of, and be directly supervised by, their parent or guardian to use the App, so if you are between the ages of thirteen (13) and seventeen (17) years and you wish to use download, install, access or use the App, before doing so you must: (a) assure and confirm (if needed) that your parent or guardian have read and agree (get your parent or guardian’s consent) to this Agreement prior to you using the App; (b) have the power to enter a binding contract with us and not be barred from doing so under any applicable laws.
Parents and guardians must directly supervise any use of the App by minors.
Any person under the age of thirteen (13) years is not permitted to download, install, access or use the App.
You affirm that you are either more than eighteen 18 years of age, or an emancipated minor, or possess legal parental or guardian consent, and are fully able and competent to enter into the terms, conditions, obligations, affirmations, representations, and warranties set forth in this Agreement, and to abide by and comply with this Agreement.
IV. GENERAL TERMS
The App is a utility program designed to enhance your device experience. The App allows to scan any types of document to high quality PDF or JPEG; to save and store any scan copies of documents on your mobile devices; to share your scans via email; upload scanned documents to cloud services like box, Evernote or Google Drive (see the full performance list on the App’s page on itunes.apple.com). All documents shall be stored locally on your device and shall never be sent to any third-party unless you export them to other apps or devices by means of the App.
The App is intended only for your personal non-commercial use. You shall use the App only for the purposes, mentioned above.
V. PRIVACY POLICY
Your privacy is very important to us. Accordingly, we have developed the Privacy Policy in order for you to understand how we process, use and store information including personal data. Access to the App and use of the Services is subject to the Privacy Policy. By accessing the App and by continuing to use the Services, you are deemed to have accepted the Privacy Policy, and in particular, you are deemed to have acknowledged the ways we process your information as well as appropriate legal grounds for processing described in the Privacy Policy. We reserve the right to amend the Privacy Policy from time to time. If you disagree with any part of the Privacy Policy, you must immediately stop using the App and Services. Please read our Privacy Policy carefully.
VI. END USER LICENSE AGREEMENT
By using the App, you undertake to respect our intellectual rights (intellectual rights related to the App’s source code, UI/UX design, content material, copyright and trademarks, hereinafter referred to as the “Intellectual Property Rights”) as well as those owned by third parties.
As long as you keep using the App, we you a limited, non-exclusive, non-transferable non-sublicensable, non-assignable and revocable license to access and use the App pursuant to this Agreement on any Apple-branded products that you own or control except that the App may be accessed and used by other accounts associated with you via Family Sharing or volume purchasing (the “License”).
The source code, design and content, including information, photographs, illustrations, artwork and other graphic materials, sounds, music or video (hereinafter – the “works”) as well as names, logos and trademarks (hereinafter – “means of individualization”) within the App are protected by copyright laws and other relevant laws and/or international treaties, and belong to us and/or our partners and/or contracted third parties, as the case may be.
In the event of any third party claim that your possession and use of the App infringes that third party’s intellectual property rights, Apple will not be responsible for the investigation, defense, settlement and discharge of any such intellectual property infringement claim.
These works and means of individualization may not be copied, reproduced, retransmitted, distributed, disseminated, sold, published, broadcasted or circulated whether in whole or in part, unless expressly permitted by us and/or our partners and/or contracted third parties, as the case may be.
All rights, title and interest in and to the App and its content, works and means of individualization as well as its functionalities (1) are the exclusive property of We and/or our partners and/or contracted third parties, (2) are protected by the applicable international and national legal provisions, and (3) are under no circumstances transferred (assigned) to you in full or in part within the context of the license herewithin.
We will not hesitate to take legal action against any unauthorized use of our trademarks, names or symbols to protect and restore our rights. All rights not expressly ed herein are reserved. Other product and company names mentioned herein may also be the trademarks of their respective owners.
You agree not to use the App in any way that:
is unlawful, illegal or unauthorized;
is defamatory of any other person;
infringes any copyright, right or trademark of any other person;
advocates, promotes or assists any unlawful act such as (by way of example only) copyright infringement or computer misuse.
You shall not make the App available to any third parties. In addition, you shall not modify, translate into other languages, reverse engineer, decompile, disassemble or otherwise derivative works from the App or any documentation concerning the App.
You shall not transfer, lend, rent, lease, distribute the App, or use it for providing services to a third party, or any rights to the App or any documentation concerning the App to a third party.
Misuse of any trademarks or any other content displayed on the App is prohibited.
You shall not copy and/or duplicate and/or distribute and/or publish and/or use any content in the App, directly or indirectly, by way of a violation of our Intellectual Property Rights.
Moreover, you shall not make any attempts to use the App or part thereof for malicious intentions.
Also we are not responsible for the way you use the App.
It is clarified that we may adopt, against a user who violated the present Agreement, any legal measures at our disposal pursuant to the applicable laws.
All disputes arising from the usage of the App, shall be governed by and construed in accordance with the laws of the United States of America, and shall be submitted to the sole jurisdiction of the competent courts of New York, New York, the United States of America.
VIII. AVAILABILITY OF THE APP, SECURITY AND ACCURACY
In order to use the App, you are required to have a compatible mobile phone or tablet, and internet access. However, please note that we offer you widgets that save translations and allow you to access them later in offline mode.
The App is available for downloading and installing on handheld compatible mobile devices running Apple iOS Operating System 11.0 with minimum system requirements.
We do not warrant that the App will be compatible with all hardware and software which you may use.
We make no warranty that your access to the App will be uninterrupted, timely or error-free. Neither does Apple have an obligation whatsoever to furnish any maintenance and support services with respect to the App.
You acknowledge the App is provided via the internet and mobile networks and so the quality and availability of the App may be affected by factors outside our reasonable control.
The version of the App may be upgraded from time to time to add support for new functions and services.
We may change or update the App and anything described in it without noticing you. If the need arises, we may suspend access to the App, or close it indefinitely.
You also warrant that any information that you submit to us is true, accurate and complete, and you agree to keep it actual at all times.
You can discontinue using our Services at any time by choosing the relevant option in your iTunes Account Settings. If you decide not to use the App for any reason you should uninstall the App.
The App is provided on a paid basis. You will need to pay a one-time fee of $14.99 in order to download the App. Once you download the App, you will get access to all its features.
Prices are in U.S. dollars, may vary in countries other than the U.S. and are subject to change without notice.
You may be charged by your communications service provider for downloading and/or accessing the App on your mobile phone or tablet device, so you should check the terms of agreement with your operator. This may include data roaming charges if you do this outside your home territory. All these charges are solely your responsibility. If you do not pay the bills related to your mobile phone or tablet device, then we assume that you have the permission from the person that does it before incurring any of these charges.
X. THIRD PARTY WEBSITES AND RESOURCES
The App may link you to other sites on the Internet and contracted third parties to provide you certain services. We have no control over and accept no responsibility for the content of any website or mobile application to which a link from the App exists (unless we are the provider of those linked websites or mobile applications). Such linked websites and mobile applications are provided “as is” for your convenience only with no warranty, express or implied, for the information provided within them.
You acknowledge that you must comply with applicable third party terms of agreement when using the App. You are solely responsible for and bear all risks arising from your use of any third-party websites or resources.
If you have any queries, concerns or complaints about such third party websites or mobile applications (including, but not limited to, queries, concerns or complaints relating to products, orders for products, faulty products and refunds) you must direct them to the operator of that third party website or mobile application.
YOU AGREE THAT YOUR USE OF THE APP AND ITS SERVICES SHALL BE AT YOUR SOLE RISK. THE SERVICES AND ALL THE MATERIALS, INFORMATION, SOFTWARE, CONTENT INTEGRATED IN THE APP ARE PROVIDED “AS IS” AND “AS AVAILABLE”. WE DO NOT MAKE ANY WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, WITH REGARD TO THE MERCHANTABILITY, TECHNICAL COMPATIBILITY OR FITNESS FOR A PARTICULAR PURPOSE OF ANY SERVICE, PRODUCTS OR MATERIAL PROVIDED PURSUANT TO THIS AGREEMENT. WE DO NOT WARRANT THAT THE FUNCTIONS CONTAINED ON OR THROUGH THE SERVICES WILL BE AVAILABLE, UNINTERRUPTED OR ERROR-FREE, THAT DEFECTS WILL BE CORRECTED, OR THAT THE SER Permalink | 記事への反応(0) | 23:18
G:KotMの初期の数字を見ると、これがかなり大きな失敗に向かっていることは明らかだ。
次回作(現在のところ最終版)は来年公開予定の「ゴジラvsコング」。
その映画はすでにポストプロダクションの段階に入っているので、KotMの失敗を考慮して中止になることはなさそうだ。
では、Legendaryにはこれ以上何ができるのだろうか。
KotMは異常値のようだ。
Legendaryは、Monsterverseの存続はすべて、KotMとGvKがどのように受け入れられるかにかかっていると述べている。
どうすればGvKを成功に導くことができるのでしょうか?
この時点でまだ可能ですか?
Monsterverseはまだ存続可能なのだろうか、それともこのシリーズは 「Failed Cinematic Universe」 シリーズに追加されるだけなのだろうか。
With early numbers for G:KotM coming in, it seems clear that this is headed towards being a rather large flop.
The next (and as of now, final) film planned for the Monsterverse is "Godzilla vs. Kong", set to be released next year.
With that film already deep into postproduction, it seems unlikely that it will be cancelled in light of KotM flopping.
So what more can Legendary do? The first Godzilla and Kong made good money and were well-received by critics.
KotM seems to be the outlier.
Legendary has stated that the continued existence of the Monsterverse all hinges on how KotM and GvK are received.
How can they turn GvK into a success?
Is it even still possible at this point?
Can the Monsterverse still be viable, or is this just another franchise to add to the Failed Cinematic Universe pile?
reddit より
Terms of Use
1. By using MathX, you are agreeing to these Terms of Use
2. MathX can hide photos and videos in the encrypted storage area protected by a PIN code or fingerprint. It also offers a secure private cloud storage
3. Scanner service can be provided on free or paid basis
4. Payment will be charged to iTunes Account at confirmation of purchase
5. Account will be charged for renewal within 24-hours prior to the end of the current period, and identify the cost of the renewal
6. Auto-renew option can be turned off in your iTunes Account Settings
7. Subscriptions are managed by the user
8. You can discontinue Scanner service at any time in your iTunes Account Settings
9. We reserves the right to terminate this Agreement at any time at its sole discretion for any reason
10. YOU AGREE THAT YOUR USE OF THE SERVICES SHALL BE AT YOUR SOLE RISK. WE DOES NOT MAKE ANY WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, WITH REGARD TO THE MERCHANTABILITY, TECHNICAL COMPATIBILITY OR FITNESS FOR A PARTICULAR PURPOSE OF ANY SERVICE, PRODUCTS OR MATERIAL PROVIDED PURSUANT TO THIS AGREEMENT. YOU SPECIFICALLY ACKNOWLEDGE THAT WE DOES NOT MAKE ANY WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, AS TO THE LEGALITY OF THE USE OF ANY OF THE MathX SERVICES IN ANY PARTICULAR STATE OR IN ANY COUNTRY OTHER THAN THE UNITED STATES OF AMERICA
11. IN NO EVENT SHALL WE BE LIABLE FOR DAMAGES OF ANY TYPE, WHETHER DIRECT OR INDIRECT, ARISING OUT OF OR IN ANY WAY RELATED TO THE SERVICES PROVIDED BY THE MathX. WE SHALL NOT BE LIABLE UNDER ANY CIRCUMSTANCES FOR ANY SPECIAL, CONSEQUENTIAL, INCIDENTAL, EXEMPLARY OR PUNITIVE DAMAGES, OR LOSS OF PROFIT OR REVENUES, EVEN IF WE HAS BEEN SPECIFICALLY ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. WE SHALL NOT BE LIABLE UNDER ANY CIRCUMSTANCES FOR DAMAGES ARISING OUT OF OR IN ANY WAY RELATED TO PRODUCTS, SERVICES AND/OR INFORMATION OFFERED OR PROVIDED BY THIRD-PARTY VENDORS AND ACCESSED THROUGH THE WEBSITE, THE APPLICATION OR BY ANY OTHER MEANS. YOU ALSO SPECIFICALLY ACKNOWLEDGE THAT WE IS NOT LIABLE FOR COSTS OR DAMAGES ARISING OUT OF PRIVATE OR GOVERNMENTAL LEGAL ACTIONS RELATED TO YOUR USE OF ANY OF THE MathX SERVICES IN ANY COUNTRY.
12. These Terms of Use shall be governed by and construed in accordance with the laws of the United States of America. We makes no representations that the Service is appropriate or available for use in other locations. Those who access or use the Service from other jurisdictions do so at their own volition and are responsible for compliance with local law.
13. You affirm that you are either more than 18 years of age, or an emancipated minor, or possess legal parental or guardian consent, and are fully able and competent to enter into the terms, conditions, obligations, affirmations, representations, and warranties set forth in these Terms of Use, and to abide by and comply with these Terms of Use.
SQLアンチパターンではないが、デッドロックについても投げっぱなしのあのSELECT FOR UPDATEの説明はなんなのかね。
1回のトランザクションでupdateを2回発行する場合と1回のSQLで複数行のアップデートをする時はデッドロックのリスクを考慮するってだけで、かなり初心者にはありがたいと思うんだけどね。
tA =# begin; tA =# update t1 set column = value where id = 1; tB =# begin; tB =# update t1 set column = value where id = 2; tA =# update t1 set column = value where id = 2; tB =# update t1 set column = value where id = 1; tB =# ERROR: デッドロックを検出しました
tA =# begin; tA =# update t1 set column = value where id = 1; tB =# begin; tB =# update t1 set column = value -- update all record tA =# update t1 set column = value where id = 2; tA =# ERROR: デッドロックを検出しました
あと、先勝ち後負けを実現するのはSELECT FOR UPDATEではなく楽観的ロックな。
tA =# begin; tA =# select updated_at from t1 where id = 1; updated_at ---------------------------- 2019-03-24 06:17:37.952893 tB =# begin; tB =# select updated_at from t1 where id = 1; updated_at ---------------------------- 2019-03-24 06:17:37.952893 tA =# update t1 set column = column - 1 where id = 1 and update_at = '2019-03-24 06:17:37.952893' and column > 0; UPDATE 1 tB =# update t1 set column = column - 1 where id = 1 and update_at = '2019-03-24 06:17:37.952893' and column > 0; UPDATE 0
外部キー嫌いがアンチパターンなのは同意だが、間違った外部キーの使い方するほうがよっぽどアンチパターンじゃないか？
外部キー貼らなかったことによって、俺はこんな被害だしたぜっての是非教えてほしい。
すぐに思いついたケースは
とかを思いついたがこんなケースで合ってるのか？こんなケースより間違った外部キーの使い方したほうが家に帰れなくなるケースのほうが多いと思うぞ。間違った使い方をしていて、システムが太ってくるとこんなケースが出てくる。
特に下2つは害悪で、SQLアンチパターンをコピペして、「おまえらw外部キー嫌いはアンチパターンだぞwww」ってやるのもいいけど、同じくらい間違った使い方を注意喚起したほうがいいと思うよ。DB識者のなかでは「そんなの常識w」かもしれないが何もしらない初心者が真似をしてお家に帰れなくなるのは辛くないか？
そんな経験していると、DB初心者は「せや！ユーザテーブルに退会フラグか論理削除フラグ持ったろwww うはw俺天才www」とかなって今度は削除フラグ持つなおじさんが出てくるぞ。しまいにはこれですよ。
http://b.hatena.ne.jp/entry/s/qiita.com/ponkotuy/items/6049388d564fb4385f4e
初心者どうしたらいいんでしょうね(*_*) 是非、DB識者には明るい未来を示して欲しいね。
俺？俺はAndroidのエンジニアでSQLiteは使わないから関係ないね。
RDB初心者の俺が恐れ多くも案を出すと、FKを作成する前に、そのテーブルの性質を予測することが大事なんじゃないかね？大量に発生するログデータなのか、大事なトランザクションデータなのか、第2正規化しただけのただの情報テーブルなのか。大事なトランザクションデータだったら親が削除された時にどこにどうやって退避するか。大量のログデータだったら、親が削除される時どうアプローチするか。とか恐れ多くも予測するね。
ちなみに外部キーないからER図出せないってのはそれはツールの作りであって、FK制約とは関係ないんじゃないの。バリデーション(外部キー)はセキュリティ対策(ER図を作成する)の為、実装するってのと個人的に同じことだと思っている。
差別や偏見の増長になるので積極開示しないだけで、犯罪者になりやすい傾向、犯罪者になりやすい生育環境 ってのはある
例えば、発達障がい、中でもアスペやCU特性(Callous-Unemotional Traits：無感覚非感情的特徴)など
ただ強制じゃないので、親の意識が相当高くないと、大学や国立病院に足を運ぼうとはならないと思う
そもそも、親がこれだけ意識が高ければ、子が犯罪者になるとは考えにくい
なお、犯罪者にならないサイコパスは成功したサイコパスといい、
CEO や 外科医 や 弁護士 や 警察官 や シェフ などに多いそう
なおワイはサイコパスの心拍数が低いのは顕著な傾向だと無批判に思ってきたが(例えばこういうの↓)
Am I a psychopath? You asked Google – here’s the answer
If you’re not an athlete, and your heart rate is lower than average, you may be interested to discover that bradycardia, as it’s known, is more strongly correlated with psychopathy than smoking is with lung cancer.
That doesn’t mean everyone with a slow heart rate is a psychopath, but a very high percentage of psychopaths have slow heart rates.Why on earth would that be the case?
It turns out that there are a number of physiological traits strongly linked to psychopathy, including tell-tale patterns of activation in the brain and autonomic nervous system.
One theory is that psychopaths inherit a set of genes that make it harder to experience fear or excitement.
適当に
心拍数が低い＝サイコパスではないが、アスリートでもないのに心拍数が低いのはサイコパスの傾向が高いよ
脳と自律神経の働き方に特徴があり、恐怖や興奮などの刺激が感じにくいのではと考えられているよ
今日、改めてググってみたら、
今までの研究のサンプル数が少ないのでやり直してみたら、
サイコパス は特別に心拍数が低い とか無かったよってあったわ
ほえ〜 ↓
Resting heart rate and psychopathy: Findings from the Add Health Survey
引用元：https://www.biorxiv.org/content/10.1101/205005v3
Despite the prior linkages of low resting heart rate to antisocial behavior broadly defined, less work has been done examining possible associations between heart rate to psychopathic traits.
(中略)
No significant relationship between heart rate and psychopathic traits, or heart rate and a measure of cold heartedness, was found after controlling for age, sex, and race.
