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 2016

DEF CON 22 – Dan Kaminsky – Secure Random by Default – YouTube

Posted by jpluimers on 2016/02/25

Just while I was watching a nice DEFCON video about security

I came across these two links:

It really looks like too many companies are not genuinely interested in your security.

(Prices of Crazyradio PA devices on Amazon USA didn’t just go through the roof: they ran out of them)

–jeroen

Posted in Geeky, Security | Leave a Comment »

Delphi: forward declaration of classes and interfaces, but no records.

Posted by jpluimers on 2016/02/24

As Delphi allows to forward declare both classes and interfaces, people often wonder about records.

The short answer: you can’t forward declare record types.

The long answer: you can’t directly, but you can indirectly either reference based (through pointers or callbacks with const parameters) or operator based (through operator overloading).

I think the reason forward declaration of classes and interfaces is possible because they both are reference types, so referring does not impose copying.

Anyway, the trick is this:

You can’t have forward declarations for record types. Define both Implicit operators in the second type

Source: delphi – How do I define implicit conversion operators for mutually dependent records? – Stack Overflow

–jeroen

via:

Posted in Delphi, Delphi 10 Seattle, Delphi 2007, Delphi 2009, Delphi 2010, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, Software Development | Leave a Comment »

FastMM4 moved from SF.net to GitHub – pleriche/FastMM4@245706d

Posted by jpluimers on 2016/02/23

Updated the homepage in the source and readme to reflect the move to GitHub.

Source: pleriche/FastMM4@245706d

In related news: Primož Gabrijelčič is contributing to it as well: his pull request got processed https://github.com/pleriche/FastMM4/pull/1 implemented FastReallocMem logger.

–jeroen

via: Edwin Yip Delphi Developers

 

Posted in Delphi, Development, FastMM, Software Development | Leave a Comment »

nunit – How can I view .NET trace logs in TeamCity? – Stack Overflow

Posted by jpluimers on 2016/02/23

This indeed works very well:

All console output is shown in the build log.

So when you need more context on tests that succeed, you can just output them on the Console.

A practical use: testing the sending of SMS messages over HTTPS where the intermediate proxy can change and was giving different effects.

Logging the actual proxy used correlated some run-time findings. Based on that we could write better tests.

–jeroen

via: nunit – How can I view .NET trace logs in TeamCity? – Stack Overflow.

Posted in .NET, Agile, C#, Continuous Integration, Development, MSTest, Software Development, TeamCity, Testing.NET, Unit Testing, VSTest | Leave a Comment »

Replace Boxee by Raspberry Pi as most TV support doing video+USB keybard over HDMI

Posted by jpluimers on 2016/02/22

If for instance your Boxee gets old or breaks down, you can use a Raspberry Pi as a replacement with Kodi as media player.

This combination will understand the Video+USB over HDMI which most TV supports officially named HDMI-CEC , but most vendors “invented” their own names (see list below).

The core is the kodi support for CEC.

Basically it comes down to using three cables going to the Pi: Power from TV (or some other source), HDMI to TV, and wired Ethernet. And a distribution for RaspberryPi containing kodi will work, for instance from OpenELEC Mediacenter – Download: Raspberry Pi Builds

Chad MILLER has more details on how to get this to work: My Boxee box is getting old, but I knew of no replacements. The problem is I …

Names known for HDMI-CEC via Wikipedia:

Anynet+ (Samsung), Aquos Link (Sharp), BRAVIA Link and BRAVIA Sync (Sony), HDMI-CEC (Hitachi), E-link (AOC), Kuro Link (Pioneer), INlink (Insignia), CE-Link and Regza Link (Toshiba), RIHD (Remote Interactive over HDMI) (Onkyo), RuncoLink (Runco International), SimpLink (LG), T-Link (ITT), HDAVI Control, EZ-Sync, VIERA Link (Panasonic), EasyLink (Philips), and NetCommand for HDMI (Mitsubishi).

Because of the naming, turning on CEC can be confusing: How to Enable HDMI-CEC on Your TV, and Why You Should

–jeroen

Posted in *nix, *nix-tools, Development, Hardware Development, Hardware Interfacing, HDMI, Linux, Power User, Raspberry Pi | Leave a Comment »

Linking to part of the same document in Markdown (via: Stack Overflow)

Posted by jpluimers on 2016/02/22

I love markdown, but it lacks the ability to directly create destination anchors (but MarkDownExtra however does for headers)

Anchors can be used to link within and between documents, the foundation of web navigation, and also very important inside documentation.

Luckily, Markdown allows inline HTML, so you can add an HTML destination anchor: an a element with either a name or id attribute.

XHTML deprecated the name attribute, but you should actually use it. The reason is that in HTML5, most browsers create a global JavaScript variable for each id id anchor.

In addition, you should not use a self closing a element: only XHTML supports that.

So the Markdown then becomes something like this:


## <a name='possiblePlatforms'>Possible platforms</a>
Link to [possible platforms](#possiblePlatforms).

view raw

anchors.md.txt

hosted with ❤ by GitHub

In the heading, you will see the html for the destination anchor, in the link you will see the MarkDown for the internal source anchor..

The above example will render like this:

–jeroen

via: How to link to part of the same document in Markdown? – Stack Overflow.

Posted in MarkDown, Power User | Leave a Comment »

Just discovered Vysor now has mouse shortcuts too – via: Cool: Vysor screen sharing by Koush

Posted by jpluimers on 2016/02/19

Just updated Cool: Vysor screen sharing by Koush with this:

Edit 20160217: new keyboard/mouse shortcuts

  • Old: keyboard shortcuts
    • Escape -> Back Button;
    • F1 -> Menu Button;
    • Home -> Home Button;
  • New: mouse shortcuts
    • Middle Click -> Home;
    • Right Click -> Back

"Escape

Now hopefully the screen resolution thing will be fixed: [Wayback/Archive] github.com/koush/vysor.io/issues/68

–jeroen

Posted in Android, Android Devices, Chrome, Development, Google, Keyboards and Keyboard Shortcuts, KVM keyboard/video/mouse, Mobile Development, Power User, Vysor | Leave a Comment »

Parts for #Alulux and Benny 4.0 garage doors

Posted by jpluimers on 2016/02/19

Because of Repair of  #Alulux  AKS 2.0 (201237):

  • [WayBack] BENNY 4.0 (201250): Torsteuerung Benny 4.0; 230V, max Motorleistung 600 VA. Inklusive Anschlusskabel mit Schukostecker und Kabelverschraubungen, mit Totmannfreigabe über Schlüsselfunktion
  • HS2-M/868 (204052): Mini-Handsender; 868,5 MHz. 2-Befehl, für 868 MHz-Steuerungen (Benny 4.0), Detolux, Vertico
  • LSB/M (201467): Einweg-Lichtschranke; 2-Drahttechnik mit 10 m Kabel. Für Steuerung Benny 4.0, Detolux, Vertico. Als Durchfahrtsicherung.
  • EKL 2.0 (201230): Elektromechanisches Kontaktprofil, EKL, Widerstand 8,2 KOhm
  • AKS 2.0 (201237): Anschlußteile für elektromechanisches Kontaktprofil EKL, für Steuerungen mit Auswertung 8,2 KOhm (Benny 4.0, Logico 2.0), kabelgebunden
    • ANE 1: Anschlußstopfen
    • AB 82: Abschlußstopfen
    • KEM 206: Klemmkasten
    • KE: Spiralkabel
  • EKL/W: Bauteile für kabellose Wireless-Schießkantensicherung, in Anwendung mit dem elektromechanischen Kontaktprofil EKL, für Steuerungen mit Auswertung 8,2 KOhm (Benny 4.0)

All of the parts can be found in [locally archived: Planer_Garagentore.pdf] http://www.fricksonnenschutz.de/uploads/media/Planer_Garagentore.pdf

[WayBack] Benny 4.0 Anleitung

Alternatives via “Funk, Zubehör und Steuerungen für Rollltore: Handender, Empfangsteile und Steuerungen für Rollltore

Images below.

In 2019, I found a related repair at these links:

–jeroen

via:

Read the rest of this entry »

Posted in LifeHacker, Power User | Leave a Comment »

Oracle alter table drop column tips: unused columns

Posted by jpluimers on 2016/02/18

An interesting tip at alter table drop column tips for Oracle: unused columns.

I knew about the multi-column syntax for drop column, but the unused columns:

You can also drop a table column by marking it unused and then dropping the column, thusly:

alter table
    table_name
set unused column
    column_name
;

They will appear in the DBA_UNUSED_COL_TABS view.

After that:

alter table
    table_name
drop unused columns
;

You can perform the first statement for a few columns over time, then the last statement will delete them all.

Together with some other views like described in places like oracle – How to check if a column exists before adding it to an existing table in PL/SQL?, you can create nifty scripts for your meta-data maintenance.

–jeroen

via: alter table drop column tips.

Posted in Database Development, Development, OracleDB | Leave a Comment »

A script to check the frequency of Oracle log switches | Oracle DBA tips

Posted by jpluimers on 2016/02/17

A wile ago, I had a this error when trying to get the TIME portion of a DATE column:

ORA-00904: "TIME": invalid identifier

This doesn’t work in Oracle, even though when you search for Oracle convert DATE to TIME you end up at this page listing TIME as a function: 12.7 Date and Time Functions. Alas, that page is for MySQL which is owned by Oracle for a while now.

Back to the query which was like this where date_column was of type DATE.

SELECT 
    id,
    date_column, 
    TIME (date_column)
FROM some_table

That DATE type actually stores date+time, and since it was filled with Delphi TTime values, the date parts would always be “1899-12-30” (yes, I like ANSI DATE and TIMESTAMP formats). Oracle doesn’t get that, so I wanted to get the time portion.

Solutions:

Read the rest of this entry »

Posted in Database Development, Delphi, Delphi 10 Seattle, Delphi 2005, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi 7, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, OracleDB, Software Development | Leave a Comment »