Posted by jpluimers on 2018/07/20
via: [WayBack] Until recently I did not know that this was possible, but people are hacking the venerable Logitech C920 and C930e webcams. – Lars Fosdal – Google+
–jeroen
Some nice pictures of stereo camera configuration by Joe C Hecht at https://plus.google.com/+JeroenPluimers/posts/9T8u82E8rH2
Posted in Development, Hardware Development, LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2018/07/19
The testing was done with Firebird 2.5.x x86 on Windows 7 x64.
Where other relational database platforms have plenty of opportunities to generate sequences (see for instance the below links on Oracle and SQL Server), with Firebird you can use a WITH RECURSIVE query construct that normally is being used to manage tree structures ([WayBack] PkLab – Firebird: Tree data mangement with recursive CTE).
However, that uses query stack which has a depth limit of 1024 levels. When you reach the limit, Firebird gives you an error like this:
with
recursive
sequence(n) as (
-- When you select more than 1024 values, this error occurs:
-- Error while fetching data: Too many concurrent executions of the same request
select 0 -- start
from rdb$database
union all
select sequence.n + 1
from sequence
where sequence.n < 1023 -- finish
)
select sequence.n
from sequence
--where sequence.n in (24, 38)
order by sequence.n
It however is a pretty quick and CU bound solution: on my system ([WayBack] AMD A8-7600 @ 3.1 Ghz), it runs 1000 records within ~0.1 seconds.
In such a short time, it’s hard to see how the speed is bound, so I wanted to go for some orders of magnitude more. In ~0.1 seconds, the processor executes about 0.3 * 10^9 cycles generating 1000 numbers which is ~ 300-thousand cycles per number. That sounds like a lot of cycles for so few numbers. Would this become a better ratio for more numbers?
Posted in Database Development, Development, Firebird, IKEA hacks, OracleDB, SQL, SQL Server | Leave a Comment »
Posted by jpluimers on 2018/07/17
I wasn’t expecting it to be so easy to install PowerShell on Mac OS X:
brew install Caskroom/cask/powershell
In the background it executes this script: https://github.com/caskroom/homebrew-cask/blob/master/Casks/powershell.rb. which indirectly goes through the URL template https://github.com/PowerShell/PowerShell/releases/download/v#{version}/powershell-#{version}.pkg.
On other non-Windows systems, you have to go through GitHub yourself: https://github.com/powershell/PowerShell. The PowerShell team at Microsoft has many more repositories including the Win32-OpenSSH port which you can find through https://github.com/PowerShell.
At the time of writing, PowerShell was available for these platforms:
Platform Downloads How to Install Windows 10 / Server 2016 (x64) .msi Instructions Windows 8.1 / Server 2012 R2 (x64) .msi Instructions Windows 7 (x64) .msi Instructions Windows 7 (x86) .msi Instructions Ubuntu 16.04 .deb Instructions Ubuntu 14.04 .deb Instructions CentOS 7 .rpm Instructions OpenSUSE 42.1 .rpm Instructions Arch Linux Instructions Many Linux distributions .AppImage Instructions macOS 10.11 .pkg Instructions Docker Instructions
The first version I installed on Mac OS X was this: ==> Downloading https://github.com/PowerShell/PowerShell/releases/download/v6.0.0-alpha.17/powershell-6.0.0-alpha.17.pkg
By now I really hope it is out of Alpha state.
–jeroen
via:
Posted in *nix, Apple, CommandLine, Development, iMac, Linux, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, openSuSE, Power User, PowerShell, PowerShell, Scripting, Software Development, SuSE Linux, Ubuntu | Leave a Comment »
Posted by jpluimers on 2018/07/16
It seems netsh is something different than bash or csh as it is the command-line interface to many (all?) Windows Firewall settings.
So I need to put some time into learning it.
This gives you all the names of firewall rules, ready for text searching it (with find, grep, etc):
netsh advfirewall firewall show rule name=all
An alternative might be PowerShell as it too has a lot of Windows Firewall plumbing: [WayBack] How to manage the Windows firewall settings with PowerShell – James O’Neill’s blog
Choices, choices.
–jeroen
via: [WayBack] windows firewall – How can I use netsh to find a rule using a pattern – Server Fault
Posted in Firewall, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2018/07/16
Source: Disable HTML5 Autoplay – Chrome Web Store
Via:
–jeroen
Posted in Chrome, Google, Power User | Leave a Comment »
Posted by jpluimers on 2018/07/13
I never knew there were so many ways of lacing your shoes: [WayBack] Ian’s Shoelace Site – Shoelace Knots – How To Tie Your Shoes
Finally research has shown how they can get loose soo fast: [WayBack] Scientists unravel mystery of the loose shoelace | Science | The Guardian
via: [WayBack] Unravelling [yes, pun intended] the mysteries of the unknotting shoelace. – Lars Fosdal – Google+
–jeroen
Interesting app (knots 3d) and comments at https://plus.google.com/+JeroenPluimers/posts/Nv7teC8CUqY
Posted in LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2018/07/13
People are (rightfully) freaking out about their privacy as the Senate voted to let internet providers share your private data with advertisers. While it’s important to protect your privacy,…
Interesting: easy setup allows for creating disposable VPN servers.
–jeroen
Posted in *nix, IPSec, Network-and-equipment, Power User, VPN | Leave a Comment »
Posted by jpluimers on 2018/07/11
An interesting re-use: [WayBack] Transform Your ESP8266 Board into a USB to Serial Board Easily with Arduino Serial Bypass Sketch
Via: [WayBack] If you don’t have a USB to TTL board around, you can use an +ESP8266 board instead (or any other Arduino compatible boards with USB). – Jean-Luc Aufranc – Google+
–jeroen
Posted in Development, ESP8266, Hardware Development, IoT Internet of Things, Network-and-equipment, Power User | Leave a Comment »
Posted by jpluimers on 2018/07/10
#IoT + Google Maps Geocoding API
Convert between addresses & geographic coordinates to determine the location of devices relative to known addresses https://goo.gl/BfwYTF
Edit 202400819: the Googl link above will die, and the link it pointed to (enterprise.google.com/maps/iot) back then pointed to [Wayback/Archive] IoT & Smart Location of Things – Google Maps, Google Cloud.
Source: [WayBack] IoT & Smart Location of Things – Google Maps, Google Cloud
Via: [WayBack] Google Maps API – Google+
--jeroen
Posted in Development, IoT Internet of Things, LoRa - Long Range wireless communications network, Network-and-equipment, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2018/07/09
Since I will likely have to enable Skype in a relatively restricted environment, here are some links that likely will help me getting IP lists to open up:
–jeroen
Posted in Internet, Power User, routers, Skype | Leave a Comment »
The Wiert Corner - irregular stream of stuff 