Archive for 2019
Posted by jpluimers on 2019/01/16
A while back I wrote on Generating a million sequential numbers on the fly in a Firebird query – some solutions and speed measurements.
SQL Server has different features and performance characteristics so here are some links on doing similar things in SQL Server:
As always: if performance is important, measure before starting to optimise!
Via: [WayBack] sql – All hour of day – Stack Overflow
–jeroen
Posted in Database Development, Development, Firebird, SQL, SQL Server | Leave a Comment »
Posted by jpluimers on 2019/01/16
With the advent of WebSockets, it looks like TCP tunnels over HTTP/HTTPS are gaining more ground and I need to put some research time in them.
Some old to new links:
CONNECT requests are not supported by many HTTP proxies, especially in larger organisations, so chisel and crowbar have a much bigger chance there.
And of course there is SoftEtherVPN/SoftEtherVPN: A Free Cross-platform Multi-protocol VPN Software. * For support, troubleshooting and feature requests we have http://www.vpnusers.com/. For critical vulnerability please email us. (mail address is on the header.).
However, that is a VPN solution which is much broader than just a single TCP tunnel. You can so similar things with OpenVPN, but over HTTP/HTTPS, also requires CONNECT:
SoftEtherVPN seems to be more versatile though. I blogged about that before, but back then didn’t have needs for it yet. VPN over HTTPS: Ultimate Powerful VPN Connectivity – SoftEther VPN Project.
–jeroen
via: [WayBack] VPN through only http – Server Fault answer by [WayBack] neutrinus
Posted in Communications Development, Development, HTTP, https, Internet protocol suite, Network-and-equipment, OpenVPN, Power User, TCP, VPN, WebSockets, Windows-Http-Proxy | Leave a Comment »
Posted by jpluimers on 2019/01/16
I need to document this properly later, but here are some links I used when fiddling with iframe elements:
A few things I learned:
- You can either put the iframe elements in different divs then arrange the divs, or put a different ID on each iframe and arrange the iframe. In either case you will need a
float: left; in your style and a width: 100vw in the div around all your frames.
- Be aware that
100% isn’t 100% out of the box: default browser styles have a margin around your page and a border around an iframe.
So you will need to fiddle with margin and border-width inside your styles for body and iframe. Easiest is to set them to none or 0.
- Viewport width/height works easier for me than raw %.
- For one-off situations, I like the good old meta refresh over fiddling with JavaScript.
–jeroen
Posted in CSS, Development, HTML, Web Development | Leave a Comment »
Posted by jpluimers on 2019/01/15
Interesting library with ditto command-line tools: [Wayback/Archive] oath-toolkit / oath-toolkit · GitLab.
It allows you to perform all sorts of OAUTH operations from your code or terminal window including generation and verification of OAUTH tokens through [WayBack] OATHTOOL.
Which allows you to do TOTP “zero fucktor” authentication. [WayBack/Archive] Zero Fucktor Authentication – Kristian Köhntopp – Google+: [WayBack] Zero Factor Authentication – The Isoblog.
The project has it’s home at [WayBack] OATH Toolkit, but the repository has done some traveling and for now ended up at GitLab: [Wayback/Archive] oath-toolkit / oath-toolkit together with the web-site source [Wayback/Archive] oath-toolkit / website.
Edit 20230917
Read the rest of this entry »
Posted in Development, Power User, Security, Software Development | Leave a Comment »
Posted by jpluimers on 2019/01/15
Though the Google Calendar UI does not support EXRULE and EXDATE to exclude certain slots (via dates or rules) from recurring events.
The API supports them: [WayBack] Google Calendar API, RRULE and EXDATE – Stack Overflow
–jeroen
Posted in Communications Development, Development, Google, GoogleCalendar, HTTP, Internet protocol suite, Power User, REST, TCP | Leave a Comment »
Posted by jpluimers on 2019/01/14
The TCP BBR congestion control algorithm was introduced in September 2016 and became available in Linux kernel 4.9 in July 2017 after being in the news for a good 5 months (see links below). It strives for better bandwidth use and lowering latency on big data pipes.
This post is a reminder myself to see how widespread that is on recent distributions for both end-user and server systems.
Via:
–jeroen
Posted in Network-and-equipment, Power User | Leave a Comment »
Posted by jpluimers on 2019/01/14
Two videos that show how to cut open the E46 diamond shaped car key to replace the battery are below.
Far cheaper than a ~ EUR 200 replacement key: [Archive.is] what did you pay for your E46 diamond key replacement? – E46Fanatics
Parts needed:
- Panasonic VL2020 Akku – http://amzn.to/2emKNVN or 2016 (non-rechargeable but should be compatible)
- 66 12 2 155 753 BMW Schlüssel-Emblem
Tools needed:
- Vise/Vice (German: Schraubstock)
- very sharp knife
- super glue
Related Related: door lock and key problems; FM Antenna problems
–jeroen
Read the rest of this entry »
Posted in cars, E46 320i touring, LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2019/01/14
Another follow up on Life after Google+ – Lars Fosdal:
[WayBack] GitHub – RomainVialard/Google-Plus-Community-Migrator
This repository presents a way to export posts from a Google+ community (in this case the Google Apps Script community), along with comments & likes (plusones) using the Google+ REST API and import them in a Firebase Database, then use Firebase Hosting to display those posts. To see a live result, simply open this URL: https://apps-script-community-archive.firebaseapp.com/
It depends on the G+ REST API (so it will die earlier than G+ itself) and hosts on Google.
Related:
–jeroen
Posted in G+: GooglePlus, LifeHacker, Power User, SocialMedia | Leave a Comment »
The Wiert Corner - irregular stream of stuff 