'Very Sleepy' 0.7.2 - C++ profiler now with API

I've just posted a new release of the forked Very Sleepy code on github. Release 0.7.2 adds a first version of a DDE based API, allowing the profiled program to enable and disable capturing of profile frames. This can come in very handy for example if you want to capture only a certain section of code...

As always, the release can be downloaded here.


Convert 7 or 8 character string into excel date

Today my wife asked me to fix one of her spreadsheets. One column contained a date encoded in either 7 or 8 characters in the format DMMYYYY or DDMMYYYY, but she needed the data as actual dates.

Here's the quick formula for this (assuming Y2 contains the date string):

=IF(LEN(Y2)=7,
             DATE(MID(Y2,4,4),MID(Y2,1,1),MID(Y2,2,2)),
             DATE(MID(Y2,5,4),MID(Y2,1,2),MID(Y2,3,2)))

Viewing asset dependencies in unity3d

For a current contracting project (yes, I am for hire Wink) I had to do a cleanup pass on some assets in Unity3D. Basically what had happened was that somebody copied an entire directory tree resulting in a lot of assets with the same name (but of course a different GUID). At this stage nobody knew which assets were current and used by the levels, and which ones were not...

I've whipped up a quick editor script that simply lists all the assets that are currently directly and indirectly used in the active level. Selecting one of the assets will ...


Enhancements to 'Very Sleepy' C++ CPU profiler

I've been using the excellent CPU sampling profiler Very Sleepy for quite a while now. The most recent version however had one serious problem for me: sporadic GetThreadContext failures that resulted in aborting the profiler.

Additionally there were some other improvements I was interested in, and since I couldn't find any public depot for the source I decided to create one at github.

The latest forked version can be downloaded here. It includes the following changes:

  • fixed the sporadic GetThreadContext-related profile abort
  • fixed symbol lookup issues if EXE is started from profiler
  • added option to pause/resume profiling ...

A few useful bitcoin links

Sort of a reminder for myself...


How to automatically backup your hard earned bitcoin (with python)

Imagine a hard disk crash... and suddenly your hard earned bitcoins are gone! Doing a normal file system backup might not do you any good either - the wallet.dat file can not really be backed up while the Bitcoin app is running.

One solution is to use the JSON RPC call that triggers the Bitcoin app to create a 'safe copy' of the current wallet.dat file. In order to use this call you have to run the app in 'server' mode (so that it accepts RPC calls):

Then after downloading & extracting the attached zip file edit a few configuration ...


Hello world

... is this thing on? Testing... 1.. 2.. 3... <pfft> <pfft>

I guess so :-)


Daily archives