HN user

matthijs

51 karma
Posts1
Comments35
View on HN

Using `truncate` in combination with `cascade` is another that I found unexpected:

"Automatically truncate all tables that have foreign-key references to any of the named tables, or to any tables added to the group due to CASCADE."

So it will simply clear out other tables that reference table to truncate, even if you have `on delete set null` and the foreign key column is null.

https://www.postgresql.org/docs/current/sql-truncate.html

I've been using a HP Spectre x360 (13") with Ubuntu 18.04 for the last couple of weeks and it's been working very well for me. I even use the tablet mode when reading PDFs.

Price wise it's quite cheap (same specs as the Dell: i7, 16GB, 1TB SSD, 4k screen) as you can usually find a coupon online. For me it was about EUR300 cheaper than the XPS currently is. So far everything has worked out of the box with exception of the fingerprint reader on the side.

You account is your phone number which is a really smart thing I think. Therefore you do not have to add each of your contacts one by one. And when someone in your contact list installs WhatsApp they automatically show up in your WhatsApp contacts.

It's the quickest direct replacement for SMS.

Last month I was forced to use a netbook for a week and decided to install Ubuntu with Unity on it. I was really impressed with the user experience. I was probably just as efficient (if not more) than on my macbook!

Taking a look at the definition of Crimes per capita it states: "Note: Crime statistics are often better indicators of prevalence of law enforcement and willingness to report crime, than actual prevalence. Per capita figures expressed per 1,000 population.".

According to the crime statistics for The Netherlands the rape victims rate is 0.8% versus 0.4% for the united states [1] (its definition being: "People victimized by sexual assault (as a % of the total population)". However looking at the rapes per capita[2] The Netherlands has 0.1 per 1000 vs 0.3 for the US.

Additionally the murder rate in the US is about 5 times higher than in The Netherlands[3]. The Dutch rate is without attempts, but still I doubt if it would get even close to that in the US.

[1] http://www.nationmaster.com/graph/cri_rap_vic-crime-rape-vic...

[2] http://www.nationmaster.com/graph/cri_rap_percap-crime-rapes...

[3] http://en.wikipedia.org/wiki/List_of_countries_by_intentiona...

Even a really close up picture of a face will be seen as nudity. Trying to detect a body (or parts of a body) and determine how much skin is visible would probably be a better approach.

Also quite relevant is this site: http://www.yangsky.com/researches/physicallinguistics/PLUnde... Besides a "breast detector/nipple detector" he also created a couple of weird detectors like a "cowgirl sex position detector" among others. (The link is sfw, the individual detectors are not)

How will the betting companies react to this? Could they possibly block the hedge fund?

Some time ago I read an article about someone giving betting tips (having it right more often than not), where betting sites subscribed to his service and as soon as he gave an update modified the odds.

Note that the full-text modes only support prefix searching. For postfix you could either reverse the field your looking for (redundant data in your table), or use something like sphinx; which nowadays has great integration with MySQL.

Not sure if this is still the case, but with the hp laptops I own (especially ugly with the small HP mini's) the laptops looks good but they add the HUGE ugly power adapters.

With my hp mini the adapter is like 3/4th the size of the laptop itself. It's those details (a pretty big one in this case) that makes Apple products so good. Apple's MagSafe is awesome.

My university just migrated to Gmail (about 2 weeks ago). 30k students and about 8200 faculty and staff members.

It beats the 2 different systems we had to use before (one exchange account and one squirrel mail faculty account), and is probably more secure as well.

"After you've purchased your own domain, we also make it super easy to set up your own personalized email boxes, calendars, and wikis using Google Apps."

They make it super easy by setting the dns settings to Google apps, or is there anything else involved? (Setting the dns records is already well documented on the Google apps site and not hard at all).

I really like the Steam Play concept and hope all the older Valve games I bought will use this feature.

Finally no more or at least less reboots to windows

Yeah there are quite a few out there ;), most of them use some kind of template php script though (they all look alike).

For now it will run like this, no ads, we mainly use it to test new stuff that we might use in the future for other projects.

For example the smtp server is custom to make sure it can handle huge amounts of mail (to learn some more about writing high performance servers). Also the realtime "new message" notification system is written in node.js which we are now using for different projects because it works so well.