9 February 2017

UK: insurance for self driving cars

UK plans to have a car insurance that does not care whether you or the car is driving. In both cases, an accident is an accident, and you are insured either way by a uniform car insurance.
This is a major step towards the general acceptance of self driving cars.
more...

24 January 2017

Excel 2016: this workbook contains links to one or more external sources that could be unsafe

I get this message sometimes when opening a workbook. Generally I have copied a formula from another workbook instead of a value, but i always want to check before breaking things.

I used a Microsoft support article (ignored the Edge promo):

  1. Type CTRL+F (opens Find and Replace Window)
  2. Click [Options >>]
  3. Fill in these values
    1. Find What: \[
      1. the MS article uses [, but I got some false positives from that
    2. Within: Workbook
    3. Look in: Formulas
  4. Click [Find Next] to search
If after verification you want to get rid of the warning, use the advice you get by clicking the Help button in the box:
  1. On the Data tab, in the Connections group, click Edit Links
    Here you can also update and break the links, but you do not see in which cells they are used.
  2. Click [Startup Prompt...]
  3. Select the option that you want



5 December 2016

Amazon Go: shops without checkout

Amazon Go is Amazon's new concept of a brick and mortar shop.
Here's the manual:

  1. walk in
  2. pick your stuff
  3. walk out

26 November 2016

IntelliJ IDEA 2016.3 released

Some highlights in the 2016.3 IntelliJ IDEA release:

  • When looking at source code the editor now adds hints that show all parameter names in method calls for literals and null being passed in.
  • The debugger now allows you to examine the heap
  • The Resource Bundle editor now shows you which properties are unused in the project. Handy if you have tons of properties!
  • Refactoring to ES6 constructs (let, class...)

16 November 2016

China made android phones contain spyware

China made android phones have been found to contain spyware that sends your data to the Chinese government.
The malware is part of pre-installed apps made by Shanghai Adups Technolog, supplying software to ZTE and Huawei. It was found on the low budget phones made by these companies for the USA BLU phone brand.

9 November 2016

Oracle and ANSI SQL

ISO SQL is a rather weak standard.
First you can not get it unless you pay for it, which is not a good thing if you want your standard to be succesful. You can find draft versions of the latest SQL 2011 on the web however.
Second there is no official independent compliance verification.

Appendix B of the Oracle Database SQL language reference gives a detailed overview of Oracle standard compliance.

In oracle you can set the FLAGGER variable, to verify whether your command complies with the standard. It only checks compliance with the ISO SQL/92 standard though:


Finally, here's a neat overview of compatibility of SQL statements for the most popular databases.