The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,862 other subscribers

Archive for the ‘LifeHacker’ Category

Drone no-fly zones | ministerie van Infrastructuur en Milieu

Posted by jpluimers on 2018/08/20

If you ever want to fly a drone without a license in The Netherlands, be prepared that the flying zones are very limited, especially in : [Archive.isDrone no-fly zones | ministerie van Infrastructuur en Milieu

The text isn’t very clear, even to Dutch people, so there is some discussion and explanation in these links:

More temporary airspace restrictions are here:

–jeroen

Read the rest of this entry »

Posted in LifeHacker, Power User | Leave a Comment »

Ziggo – als je geen papieren factuur meer wilt

Posted by jpluimers on 2018/08/17

Als je bij Ziggo geen papieren factuur meer wilt, kun je dat op https://www.ziggo.nl/mijn-ziggo/gegevens/betalingsgegevens-wijzigen/ instellen.

–jeroen

via: [WayBack]

Posted in LifeHacker, Power User | Leave a Comment »

Hack The Box :: Penetration Testing Labs

Posted by jpluimers on 2018/08/13

Cool playground:

An online platform to test and advance your skills in penetration testing and cyber security.

Source: Hack The Box :: Penetration Testing Labs

Via [WayBack] hackthebox – Penetration testing labs This is an amazing platform – super addictive! Hack The Box is an online platform al… – Jürgen Christoffel – Google+

–jeroen

Posted in LifeHacker, Power User, Security | Leave a Comment »

Prepaid SIM cards for USA

Posted by jpluimers on 2018/08/06

This thread has some tips on pre-paid SIM cards for use in the USA: [WayBackTelefonie en mobiel internet in de VS deel 2 – Pagina 9 – AllesAmerika.com Forum

This seems to be one of the few allowing for hotspot/tethering use: [WayBack] Arieli Mobile Unlimited + Tethering Data plan | Arieli Mobile – Prepaid USA SIM Card wireless provider

Via: [WayBack] T-Mobile vergroot databundels Travel & Surf-passen voor buiten EU – Tablets en telefoons – Nieuws – Tweakers

–jeroen

Posted in LifeHacker, Power User | Leave a Comment »

Going to test some USB 3 gigabit ethernet adapters based on Realtek RTL8153 and Asix AX88179 chips

Posted by jpluimers on 2018/07/27

Later on, I might add a USB31000S in the mix, but I will do some initial testing with USB 3 gigabit ethernet adapters based on Realtek RTL8153 and Asix AX88179 chips.

Things I will focus on with my Retina MacBook Pro 2015 model are:

  • CPU usage
  • Throughput
  • Duration between reconnect on USB after suspend, and renewing the DHCP lease
  • Promiscuous mode capabilities

Some links for my references:

A first impression from the above links is that for Realtek chipset based devices, drivers are more readily included in operating systems, and these chipsets are better at VLAN handling.

–jeroen

Posted in Ethernet, LifeHacker, Network-and-equipment, Power User, USB, USB, USB-C | Leave a Comment »

Hacking the Logitech C920 & C930e Webcams – Graves On SOHO Technology

Posted by jpluimers on 2018/07/20

This could turn out in a way better quality and cheaper CCTV system than Ring offers: [WayBackHacking the Logitech C920 & C930e Webcams – Graves On SOHO Technology.

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

Read the rest of this entry »

Posted in Development, Hardware Development, LifeHacker, Power User | Leave a Comment »

Generating a million sequential numbers on the fly in a Firebird query – some solutions and speed measurements

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 ([WayBackPkLab – 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 ([WayBackAMD 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?

Read the rest of this entry »

Posted in Database Development, Development, Firebird, IKEA hacks, OracleDB, SQL, SQL Server | Leave a Comment »

Ian’s Shoelace Site – Shoelace Knots – How To Tie Your Shoes

Posted by jpluimers on 2018/07/13

I never knew there were so many ways of lacing your shoes: [WayBackIan’s Shoelace Site – Shoelace Knots – How To Tie Your Shoes

Finally research has shown how they can get loose soo fast: [WayBackScientists 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 »

Mac: when “Save time with right-click sharing from your Google Drive folder” fails…

Posted by jpluimers on 2018/07/09

A few years ago, Google Drive introduced this:

For those looking to share files more quickly, listen up. You can now share with others directly from the Google Drive folder on your Mac or PC. To share a file while inside your Google Drive folder, simply right click the file, select “Google Drive” and then click “Share.” This new feature is rolling out over the next few days.

Source: [WayBackSave time with right-click sharing from your Google Drive folder…

However, sometimes it fails. And the menu has changed as well.

By now the menu looks like this:

  • “View with Google Drive”
  • “Share using Google Drive”

If those do not appear, then:

Try to stop, then start Google Drive.

If that fails:

Read the rest of this entry »

Posted in Google, GoogleDrive, LifeHacker, Power User | Leave a Comment »

Tail it: 4 new affordable GPS trackers with global range by Morten Sæthre — Kickstarter

Posted by jpluimers on 2018/07/08

A few more days: [Archive.is] Tail it GPS

Via:

–jeroen

Posted in LifeHacker, Power User | Leave a Comment »