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 April, 2014

Updating Windows Defender signatures (only) on Windows 8, 7 and XP (via: twm’s blog)

Posted by jpluimers on 2014/04/08

Based on Updating Windows Defender signatures (only) » twm’s blog (thanks Thomas!), I found it would not work on all my Windows systems.

So I wrote a small batch file that works on my Windows 8.x, 7 and XP systems: Read the rest of this entry »

Posted in Power User, Windows, Windows 7, Windows 8, Windows 8.1, Windows XP | Leave a Comment »

Obtaining a sub-interface from an interface (via: Stack Overflow: Delphi)

Posted by jpluimers on 2014/04/08

Eric Grange (author of DWS) asked for some interface magic: delphi – Obtaining a sub-interface from an interface – Stack Overflow.

–jeroen

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

Software on RAMdisk can be at least 10x faster than on SSD

Posted by jpluimers on 2014/04/08

Wow nice tip in the comments of this article: Hynix ontwikkelt ddr4-module met capaciteit van 128GB – Computer – Nieuws – Tweakers.

Posted in Uncategorized | Leave a Comment »

Connect feedly to over 300 apps with Zapier | Building Feedly

Posted by jpluimers on 2014/04/08

Looks like a kind of ifttt: Connect feedly to over 300 apps with Zapier | Building Feedly.

Posted in Uncategorized | Leave a Comment »

Spring4D now has projects for Appmethod, but it cannot support Appmethod in the automated build engine.

Posted by jpluimers on 2014/04/08

Recently I pushed two sets ofchanges for Spring4D with packages and test projects that support Appmethod. The test projects are configured to use Firemonkey (conditional define FMX) as that is what Appmethod is centered around.

This weekend I filed Appmethod issue AP-64 that prevents Spring4D and other open source projects to automatically build the underlying projects. Since the new Quality site does not (yet?) make reports on public reports visible to the public, the full report is at the end of this post.

The issue comes down to that Embarcadero has intentionally made the command-line compilers dysfunctional. They are there, but – as you see when running this small batch file – they all will display “This version of the product does not support command line compiling.“. It makes it impossible for open source projects to just distribute the sources, and ship a small build tool that builds and installs the compiled binaries into the available products. So this issue doesn’t only affect Spring4D. The large JCL open source project also requires the command-line compilers.

In the past, only some free or trial products came without the command-line compilers, and I personally am anxious why the command-line compilers were crippled. On the other hand – even though the compiler DLLs list themselves as version 19.50, the functionality in Appmethod basically is the same as in RAD Studio XE5.

The Spring4D team regrets the lack of command-line compiler support in Appmethod. We really hope this restriction is removed soon, preferably in this version, but – since the docteam is prepping for XE6, Delphi XE6 is around the corner (the first XE6 webinar is in slightly more than a week from now) and Appmethod is based on the most recent Delphi version – in a future version.

We could go the long path of encapsulating the DLL versions of the compilers, but those do not have a public API. Reverse engineering that would cost a lot of effort, which we’d rather put into enhancing Spring4D.

If Another thing we could do – if we’d get the compilers, or Embarcadero would build the Spring4D sources with them – is provide precompiled packages for every Appmethod version. We’d rather not do that either because of the exact same reason: extra effort that we’d rather spend on other Spring4D things.

So for now, the Spring4D team keeps the Appmethod support as is. If there are people interested, they can manually compile and install the packages and test projects from within the IDE.

–jeroen


for /f "usebackq tokens=2* delims= " %%c in (`reg query HKEY_CURRENT_USER\Software\Embarcadero\BDS\13.0 /v RootDir`) do (
dir "%%d\bin\dcc*.exe"
for %%c in ("%%d\bin\dcc*.exe") do %%c
)

Full bug report: Read the rest of this entry »

Posted in Appmethod, Delphi, Development, Software Development | 4 Comments »

Heartbleed: Serious OpenSSL zero day vulnerability revealed | ZDNet

Posted by jpluimers on 2014/04/08

The fixed OpenSSL 1.01g is already available in source and for many platforms.

When do they become available anyone using OpenSSL 1.01 or 1.02 must deploy the patched version as fast as possible.

You also need to have all your certificates re-issued.

During the vulnerability period, your private keys may have been exposed, and there is no way to tell that they were not exposed.

Note the official binaries for Win32 1.01g are not available for yet (expect them soon), but the Indy team made Win32 and Win64 versions available.

Note that OpenSuSE did a backport of the patch to 1.01e for 12.3 and 13.1. Older openSuSE versions do not have updates for this issue, but you want to upgrade anything lower than 0.98 as they contain serious other vulnerabilities.

–jeroen

via

Posted in *nix, Delphi, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi 6, Delphi 7, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Development, Linux, OpenSSL, openSuSE, Power User, Security, Software Development, SuSE Linux | 7 Comments »

Venn Diagrams of SQL Join queries (via: Data Visualization – Google+)

Posted by jpluimers on 2014/04/08

Some great venn diagrams of SQL JOINs via Data Visualization – Google+ of which I wish they were PNG:

Thanks to that link, I found the original article and images by C.L. Moffat!

Click on the image to view a larger version.

–jeroen Read the rest of this entry »

Posted in Access, Database Development, DB2, Development, Firebird, InterBase, MySQL, OracleDB, PostgreSQL, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 7 | Leave a Comment »

Mac OS X: Snow Leopard (10.6) and Lion (10.7) had this, but time remaining on battery icon is gone since Mountain Lion (10.8)

Posted by jpluimers on 2014/04/07

Every once in a while, some major OS vendor removes a really useful feature.

As of OS X Mountain Lion (10.8), the battery icon indicator cannot show the remaining time on battery any more, though it uses that time to indicate low power.

I’ve found that feature really useful in Lion (10.7) and Snow Leopard (10.6), and I’m pretty sure OS X versions before that also had the option to show the remaining battery (charge) time.

There is a big thread about the lack: Time remaining on Mountain Lion battery: Apple Support Communities.

A quick scan in that thread got me a these replacements:

I hope the $099 one is not written by the people that removed the feature from OS X Mountain Lion (:

After trying a few of the above, I filed a complaint at Apple – Mac OS X – Feedback, clicked on “I have this question too” in Time remaining on Mountain Lion battery and went for SlimBatteryMonitor as it uses the least menu bar estate.

Note that for most applications having icons in the menu bar, this is impossible: osx – Can I change the order of non-apple icons on the menu bar of my MacBook? – Super User.

–jeroen

via: Time remaining on Mountain Lion battery: Apple Support Communities.

Posted in Apple, Mac, Mac OS X / OS X / MacOS, Mac OS X 10.6 Snow Leopard, Mac OS X 10.7 Lion, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, OS X 10.8 Mountain Lion, Power User | Leave a Comment »

My initial thoughts on the new Community sites

Posted by jpluimers on 2014/04/06

(I just found out this post was marked “missed schedule” since April 6, 2014. It’s a [WayBack] known WordPress bug that on wordpress.com still raises it’s head every now and then. Sorry for that.)

The introduction of AppMethod wasn’t only introducing a new product based on the Object Pascal language and Firemonkey framework, it also shows which direction Embarcadero is taking with their community sites all hosted on community.embarcadero.com some of which replace parts of the EDN (Embarcadero Developer Network) sites.

These already saw the light:

Here is my initial impression on them. So below, phrasings like “it is” phrase how I feel about them.

The UI looks clean

Whereas most of the EDN sites look cluttered (some of which just look like a big landing page), the new sites look much cleaner. Less fuzz, more aimed towards their goal.

Existing EDN credentials are re-used

This is only part of the story. EDN has two credentials: a username and an email address. At the EDN sites, you can use either one. But not all community sites support that. I hope this means “not all community sites support that yet”.

So far, the Answers, Articles and Forums sections (which are hosted on the main site) understand authentication using either the username or email.

The Quality part

The community site is PHP based.

I have mixed feelings about this. On the plus side, PHP is used by many people, Embarcadero has a PHP based HTML5 Builder product (initially called Delphi for PHP, then RadPHP; well Delphi was almost called AppBuilder so that is still positive). On the negative side, even big PHP users like WordPress do horrible things with it (don’t get me started on their scheduling engine, or on breaking posts that contain source code).

Answers is new.

Answers does not have a predecessor within. It is a bit like a StackExchange site targeted at one product, but unlike StackOverflow, it feels more welcoming to new users. I hope that stays so, and that some people with capabilities like John Skeet will join it, and not the typical StackOverflow moderators  that think they can judge questions that are clearly out of their field of expertise.

I’m not yet sure how to maintain this in

Forums.

The forums server doesn’t keep articles forever: depending on the forum, the retention duration can be as little as a couple of months or less.

It means that valuable information gets lost as nobody puts this in the WayBack machine and the WayBack machine is not indexed by Google anyway.

Articles.

Currently there are the categories Tutorials, Technical Articles and Support.

Quality.

Quality is the future direction of QC. It is based on JIRA (from Atlassian). Whereas QC was developed in-house (initially bound to the then internal RAID) a long time before publicly accessible quality systems became widespread, JIRA is an external system.

QC is dated^w dead. Though [WayBack] it has a – for its age modern – WSDL API, the web interface is horrible as of nowadays standards, and even the [WayBack] Windows and [WayBack] Java clients mentioned on the [WayBack] QC home page are not a pleasant use (personally I still use the QC Plus client though it is not publicly available any more).

Embarcadero has used JIRA internally since at least 2009 (and presumably converted their internal RAID bug database to JIRA), so they have experience using it.

I love JIRA as it is the central piece in a lot of agile environments, has all its functionality on a web-based fashion backed with a publicly documented REST based  API so you can hook up native tools with ease and is in use by many closed and open source projects. There are options to host it yourself, or in the cloud or mix and match.

So I do welcome JIRA. But there are a few things that Embarcadero needs to fix:

  • Better integration with EDN login services (right now you can only login using the username you registered at EDN, but not with the email address you registered at EDN).
  • Making all reports of publicly available products also public just like on QC (I get it that bugs on products not publicly available are not visible to the public at large).

–jeroen

Posted in Appmethod, Delphi, Development, Missed Schedule, QC, SocialMedia, Software Development, WordPress | Leave a Comment »

how can I embed an mp4 video into a Firemonkey app (via: David M Williams – Google+)

Posted by jpluimers on 2014/04/06

Last week, David M Williams posted a nice question on how can I embed an mp4 video into a Firemonkey app.

The resolution – using the Deployment Manager  and TPath – was remarkably simple based on my suggestion:

That depends on your platform. Windows can embed and extract resources in your EXE. On other platforms that is either hard or impossible. I’d just deploy the mp4 with your app. `TPath` has some really nice methods to get you directories (Home, Documents, etc) in a platform neutral way, and to combine directories and filenames to form a full path name.

he went along and this was his solution:

Under Project/Deployment I add the MP4 file, then set the MediaPlayer filename property using TPath.

–jeroen

via: David M Williams – Google+ – Seeking some help – how can I embed an mp4 video into a….

Posted in Delphi, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Development, Software Development | Tagged: , , | Leave a Comment »