Wednesday, September 02, 2026

The first lesson

Today I had my first lesson learning how to play the saxophone. As far as I can see at the moment, there are two separate actions that have to be learnt: how to produce a tone in a constant manner, and how to finger the correct notes. The second action doesn't bother me too much: I've already picked up a certain amount of skill. But it's the actual mechanics of producing a constant tone that have me stymied. 

It may just be that the reed in the mouthpiece is too thick (2.5 mm) and that a thinner reed will be easier. But the actual form that my mouth has to take - the embouchure - seems unnatural at the moment. My upper teeth have to grip the mouthpiece but my lower lip - not the teeth - should be on the reed. Also, it seems that I shouldn't take the mouthpiece too far into my mouth. The high notes were more difficult than the lower notes, which according to my teacher, is unusual.

No doubt this will all become easier in the future. 

I asked (tongue in cheek) which sound is worse: someone learning to play the violin or someone learning to play the saxophone. He answered that the violin sounds worse but that the saxophone is louder! So it's six of one and six of the other.



This day in blog history:

Blog #Date TitleTags
62202/09/2013The Magic of Belle IsleFilms
116402/09/2018Delphi community editionDelphi
133502/09/2020Wedding stairsPersonal, Kibbutz
141702/09/2021Once again, John MartynJohn and Beverley Martin
181202/09/2024Eight months of TemuTemu
198702/09/2025No luck with guitar stringsGuitars

Tuesday, September 01, 2026

Ajovy

Following a third appointment with my neurologist a few weeks ago, I was prescribed Ajovy which certainly is the most recent treatment for migraines and should be the most effective and with the fewest side effects. It will be difficult to tell how effective it will be during the coming month as I don't normally suffer from migraines over the summer; it's the autumn, winter and spring that are the seasons for migraines, especially with rapid changes in the weather.

I went last week to fill the prescription, but was told that there was no prescription even though the medication had been authorised by the 'regional head office', and anyway it would have to be ordered, as the pharmacy doesn't keep a stock of these syringes. During the past week I checked with my GP that she had issued the required prescription, so today I had the chance to go to the pharmacy again and collect the medication. I had fully intended to go to the kibbutz clinic so that they could show me how to use the medication; in the accompanying leaflet to the syringe, it was written that the user should be shown how to use the syringe by a doctor or nurse.

Except that when I arrived at the clinic, the nurses didn't know initially what to do. Apparently there are several members who use Wegovy, the weight loss medication that also comes in a syringe, but there one syringe is for four separate injections, whereas with Ajovy, one injects the entire contents of the syringe and the effect lasts for a month. In fact, it's possible even to inject at the same time three syringes in order to cover a three month period.

The actual mechanism of the injection is very simple: after cleaning the area (near to the belly button) and removing the needle guard from the syringe, one simply presses the syringe to the target area and holds it for 30 seconds. Initially a click is heard, which means that the needle has exited the syringe and then a few seconds later, a second click is heard, signifying that the contents of the syringe have been injected. One is told to hold the syringe in place for another 10 seconds and then one wipes the injection area with gauze. The spent syringe is sent to the clinic for disposal along with all the other 'sharps', even though the needle has retracted (this probably happens during the extra 10 seconds). 

Did I feel anything? As I was concentrating on the injection, I felt a little prick and then a mild feeling of liquid entering the body, but this was negligible. Next time I probably won't feel anything. The injection site has not turned red - in fact, I'm not too sure exactly where I injected. So good: no side effects. Below appears the syringe on top of its box; I appreciate that it might be difficult to see what is what. Here's a clue: the blue cap that appears in the lower left hand side of the picture is the needle guard, and the syringe goes from there to the right hand side of the picture.



This day in blog history:

Blog #Date TitleTags
5101/09/2006More about PipObituary, Canterbury sound
116301/09/2018The mp3 player for swimming takes its maiden plungePersonal, MP3, Swimming
141601/09/2021Adrenal venous sampling (3) - unofficial resultsHealth, Aldosterone

Monday, August 31, 2026

CD database/2

After converting all the data of this database1, the only programming that I've done so far is to define the form that retrieves concerts data according to the parameters passed along with the code necessary for adding and editing concerts. I tested this by adding the date of the concert when I saw 10cc - according to a site that I found,  they played three concerts at London's Hammersmith Odeon, on 17-19 February 1976. The entries come from the notebook in which I used to record the concerts; I threw the notebook out years ago after I copied all the data into the database so I can't check anything anymore.

There were two very interesting entries (at least, to me) towards the beginning of the list (these weren't the first concerts that I attended, but I didn't add data for those - Tom Paxton twice and Julie Felix): on 20/02/1970 I saw Fairport Convention supported by John and Beverley Martin, and on 22/03/1970 I saw Fotheringay supported by the Humblebums and Nick Drake. These data make sense of the mixed-up memories2 that I have about the support acts.

Internal links
[1] 2135
[2] 2044

This day in blog history:

Blog #Date TitleTags
5031/08/2006Pip Pyle, RIPObituary, RIP, Canterbury sound
50531/08/2012Fomer school friend knighted1972
116231/08/2018The search for the perfect mp3 playerMP3, Headphones

Sunday, August 30, 2026

CD database

Thinking about how many times I have seen Sandy Denny1 in concert caused me to wonder how many times I have seen Fairport Convention in concert*. I know that I have this datum stored in my old CD database, but since the great computer blackout2, I discovered that I don't have this program/database installed on my mobile computer. Fortunately I found a backup on a disk from several years ago so at least I could restore the program sources and data. But I couldn't run the program as the database engine involved was the Borland Database Engine (aka BDE) that has been deprecated for at least 10 years if not more. 

So before I could look at the data, I would have to convert it to a different format. At first, I thought that I could do this on the Windows 11 computer, but it turns out that FireDAC cannot read from Paradox databases. Fortunately I have an installation of Delphi 7 on a Windows XP virtual machine, and although I hadn't previously installed the BDE installed there, it wasn't difficult to install it. After searching hard in my memory, I remembered that there was a program called the Database Desktop that allows one to see the data in a BDE database; I should point out that in the BDE each table is implemented by four to six different files, so there were about 40 files that together make up the database, and not one big file as Firebird implements databases.

There is an old version of Firebird installed on the VM (no unicode) so initially I defined the seven tables that make up the database. I changed quite a few of the field names within the tables - originally I had defined several fields with names like 'cd title', that caused more than a few problems when writing the code to access the tables. At the moment, the order of the fields within each table is the same as it was in the BDE, but in Firebird it's better to have varchar fields defined at the end of each table instead of having them scattered randomly throughout the table.

After a great deal of mucking about (including one colossal bug of my own making that set me back about an hour), I had a program that converted those seven tables to a more modern format. The next stage in restoring the data was moving the database file to the Windows 11 machine then converting the database to unicode. This was partially complicated by the fact that a few of the tables had fields containing Hebrew. The conversion from win1255 to unicode took somewhat longer than I had expected and not only because of the Hebrew. For example, one field in the 'tracks' table holds the length of the track; for some reason I had stored this in a string field, such as '4:17'. One track out of the 3,217 tracks in the table had the time '4.17', so of course this table didn't convert until I fixed the errant record. 

There are two tables ('composer' and 'musician') whose primary key should be a composite of track and person, as per this blog3. But the transfer failed because there were several duplicate entries in both of these tables, i.e. the 'id' field was different (as it was an auto-increment primary key) but there were rows with the same 'track' and 'person'. I deleted these before attempting the conversion. The fact that there were duplicates means that the original program logic was flawed; duplicates cannot be created if the primary key is the composite of track and person.

So now I have a unicode database and I can set about writing the program that accesses this database. Most of the code is going to be new as the original structure left a lot to be desired. Actually, the program was originally intended to be a cd player that could display data about a cd as it was being played and that influenced the design.

A cd database is quite problematic in terms of data design because the unique 'unit' is not a cd but rather a single track - and even this isn't unique as a track can appear on both a 'normal' cd and on a compilation. A track has composers and musicians whereas a cd doesn't have composers. Of course, a track belongs to a cd. The 'concerts' table is a nice addition that doesn't affect any of the track data but can utilise the 'artists' table.

* 22 times

Internal links
[1] 2132
[2] 2041
[3] 2123



This day in blog history:

Blog #Date TitleTags
19530/08/2009The world of Henry OrientFilms
50430/08/2012Three emailsHealth, Robert Silverberg, MBA
116130/08/2018Maximum word count for submissionDBA
125530/08/2019Priority tip: beware of linked files when checking in WindbiPriority tips
133430/08/2020Evening ferrySong writing, Andros, Greece
181130/08/2024Books (new song)Song writing

Saturday, August 29, 2026

Health benefits from freezing bread

I watched a YouTube video a few days ago by "Dr Alex" in which he made the astounding statement that freezing bread - or even storing mashed potatoes in the fridge - causes the starch in the food to change its structure, and as a result, the starch becomes 'resistant starch' that the body has difficulty in metabolising. This transformed starch behaves more like dietary fiber, delaying glucose release into the bloodstream. Not only that, the undigested resistant starch passes into the large intestine, where beneficial gut bacteria ferment it into short-chain fatty acids like butyrate. This process is called retrogradation.

At first, I thought that this was another crank video, and indeed another video popped up that purports to bust this myth of converting normal starch into resistant starch. But I do have a master's degree in research and know that hearing something from one source does not make it so and that YouTube is not a reliable source of information.

Thus I looked at the literature: the first paper that appeared, entitled 'Effect of freezing and heating white bread on the glycemic response of healthy individuals'. Here's an extract:
Results: The glycemic response of the participants to frozen and reheated white bread was lower compared to fresh white bread at all time intervals. The maximum blood sugar level was reached after 30 minutes of consuming fresh bread, at 132 mg/dl. However, for reheated bread, it reached 120 mg/dl. The prolonged freezing time did not increase the amount of resistant starch, and similar results were observed for 3, 5, and 7 days of freezing in terms of decreasing blood sugar levels.
Conclusion: Frozen and reheated white bread leads to lower blood sugar levels compared to fresh white bread. This can be attributed to the formation of resistant starch during the freezing process.

I could look for more but there are plenty of hits that conform this. As it happens, the bread that I eat is baked by an artisanal baker of the kibbutz and is far from the white bread sold in supermarkets. I normally have a spare loaf in the freezer in case the baker decides to take a week off (his mother is seriously ill at the moment) and I keep the current loaf in the fridge so I am unknowingly taking advantage of this health benefit. I also keep a loaf of white sweetened bread in the freezer for the grandchildren: we take a slice out and toast it, so again even though they are eating the worst possible type of bread, we are actually mitigating the qualities that make it so bad.



This day in blog history:

Blog #Date TitleTags
19429/08/2009Nick Drake in "Ma'ariv"Nick Drake
27929/08/2010The Swell Season/The FramesSwell Season
88429/08/2015What's been happening during AugustTV series, Films, Meg Ryan
88529/08/2015Ways of encouraging companies to participate in survey for my doctoral reseachDBA, Statistics

Friday, August 28, 2026

Swimming and showering

The number of lengths that I've been swimming has slowly been increasing - today I swam 34 and I might have swum more if I hadn't had to return home at a specific time. I always used to have a hot shower when I arrived home, trying to warm up my shoulders and thighs. But as it happens, I was rereading a book entitled 'Swimmingly' (about the author's experiences in open water swimming, ie rivers and the sea, not swimming pools), when I came across this passage.

No hot showers at the Serpentine, thankfully, otherwise you’d get a lot of people emerging from the freezing lake and heading straight into a hot shower. Which is a really ugly thing to do, because you don’t recover for the rest of the day. When you’ve been in cold water for a while and your core temperature has sunk, the capillaries shrink. They contract as you get cold. Your body’s trying to get as much heat into its core as possible. So if you go and get hot after being cold for a long period of time, the capillaries open and the blood flows to your skin, robbing the efficient heating process your body’s going through.

Having a hot shower before going to bed is recommended, as the hot water causes the blood vessels to dilate and so the body loses heat which is ideal if one is going to sleep. But in order to recover after a swim, it's better to shower in cold water, as illogical as it may seem. So today my shower was cool and even though I swam more today that I have on any previous day this year, I am not tired and feel no need to lie down for a rest. Of course, part of this is because my body is getting more and more used to the swimming, but I believe that the cold shower also plays a part in this lack of desire.



This day in blog history:

Blog #Date TitleTags
19328/08/2009Firebird date fields, continuedProgramming, Firebird, dbExpress
50328/08/2012Disappointing blood test resultsHealth
62128/08/2013Nothing moreMIDI, Sandy Denny
133328/08/2020Time sheets and perceived valueERP, DBA, Organisation behaviour
181028/08/2024More on internal links in the blog managerProgramming, Blog manager program

Wednesday, August 26, 2026

Sandy Denny: a people's history

A few years ago, I bought a book called "Gonna see all my friends" and subtitled "A people's history of Fairport Convention". I thought that the book might provide an up-to-date history of this long running band, as the two previous books ("Meet on the ledge", "The Woodworm years", IIRC) only went as far as possibly 1990 - and that was 26 years ago! Reading the book, I was quickly disabused of this notion: the book consisted of short piece by numerous people, mainly recording their attendance at concerts or meeting the various musicians that played in the band. It was somewhat self-congratulatory and I'm not sure that I even finished reading it. Obviously someone who contributed text to the book was going to buy it and so I felt that it was somewhat like a 'vanity press' book: here's the text, here's £100 (probably much more now), print me 100 copies. The same company has published several books in the same vein.

So when I heard that they were compiling a similar book about Sandy Denny, initially I was in two minds as whether to contribute or not. Eventually I sent three different pieces to the publisher: one standard piece about how I learnt about Sandy and about the concerts where she appeared that I attended. I also sent one piece that had previously appeared in this blog, one about her songwriting style1 and one about the an Israeli radio station playing her songs. 

The Sandy book arrived yesterday and I've been reading it since. As the book is arranged in chronological order, my first piece appears under the heading 22 March 1970, Colston Hall Bristol, which is where I saw Fotheringay, etc. I notice that the piece has been lightly edited but it still takes up an entire page.

If the book is going to continue in chronological order, then it seems that the other two pieces won't appear. Although I don't want to emphasize my contributions, this is a shame, as the pieces that I've read are almost entirely factual in the style of "I went to this concert", "I heard this record" and "I met someone who went to school with" with no critical content whatsoever. I've paged through the book, looking especially at the last third that includes pieces by Joe Boyd, Andrew Batt (compiler of many Sandy compilations) and others; whilst this part has a different tone, my extra contributions appear not to appear.

So here's the contribution that didn't get used: One Israeli radio station plays the 'Unhalfbricking' version of 'Who knows where the time goes' about once a week, although recently I heard what must be the original version from 'Sandy and the Strawbs' as it was only Sandy playing acoustic guitar and singing the original arrangement. I wonder how on earth the station managed to lay their hands on this version - it didn't come from me! My wife has become extremely enamoured of the song (finally, after 43 years of marriage!) and asked me to add it to her telephone playlist. She then asked if there were any other songs that she might like - I could think of at least one hundred - and so I sent her 'I'll keep it with mine'. It occurs to me now that IKIWM has several similarities to WKWTTG in terms of harmony - although in fact it should be written the other way around, as IKIWM was written in 1964 by Bob Dylan and WKWTTG was written in 1968 by Sandy Denny. There are several formal correspondences: both songs have three verses, neither song has a chorus, and both feature each song's title as the last line of every verse. Dylan does this frequently whereas Denny does it less often. The arrangements also are similar with Richard Thompson playing guitar obbligatos. There is a world of difference between the original Strawbs' version (Sandy solo) and the Fairport version, and today I wonder how much the arrangement of WKWTTG was inspired - if at all - by what they did with the Dylan song. Occasionally I wish the radio station would play some other song from 'Unhalfbricking', although I assume that they have some computer file and not the physical cd or even vinyl.



Internal links
[1] 825



This day in blog history:

Blog #Date TitleTags
27826/08/2010Updates (mainly The Swell Season)DCI Banks, Peter Robinson, Swell Season, Time signatures
39726/08/2011Implicit vs explicit joins (SQL)/2SQL
61926/08/2013Chaining functionalityERP
180826/08/2024Internal links in the blog managerProgramming, Blog manager program

Friday, August 14, 2026

More on the 1972 Nahal entertainment group

This morning I stumbled onto a treasure trove of pictures and factoids regarding the Nahal troupe, from its beginning until at least 1972. This helped me fill reveral gaps in my knowledge about the 1972 troupe. I realise that probably only a few people are interested in this material, but it's important to me.

First is a picture - captioned, so that one can see who played what - of the musicians from that time.

This picture establishes some facts: the flautist is Riva Shechter and she appears on stage during 'comradeship'. So much for CoPilot's opinion that it was probably a professional flautist. There's a passage about her written by the ranking soldier, Shimon Weitzman:

The flute was almost always used in the band's songs. My friend Benny Nagari asked to get him a flautist. I remembered the beautiful girl on the kibbutz, she was a year younger than me (not what you think), the blonde with the bright eyes, who I used to follow as a teenager. When we learned about all the possible types of musical instruments, she started with the flute and did wonders with it. She had another advantage besides being from Kibbutz Sasa, where I came from. Her mother and my adopted mother were twin sisters.

On the left is Danny Pe'er who played keyboards and apparently was a combat medic before he became part of the troupe. He later went on to play three different shows with Yehonatan Geffen, and later played in Gazoz, alongside Gidi Gov.

Another captioned picture that partially solves another lacuna in my knowledge: who was who in the song 'The Ballad of Yitzchak Sadeh" (this coincidentally was the name of the drummer pictured above!). Unfortunately the quality of the picture is poor but sufficient to see who is seated/standing where so that they can be matched in the videoShimon Weitzman is the one holding the microphone (note that in the video, there are no microphones to be seen; I seem to recall that there were some strung above the performers). I am most interested in who sings the second verse; unfortunately it's not possible to do so from this picture. Had I read the caption a bit better, I would have noticed that the person I am interested is not in the picture! He would have been to the far right, outside of the frame.

Why the second verse? The singer had good stage presence and later told the amusing story (in a mixture of Hebrew and Italian) of an Italian boat captain who is hired to take illegal immigrants from Italy to Palestine (as it was then). The name that I originally considered for this role turned out to be one of the musicians, so obviously I still didn't know who it was.

But the following picture nails the identity. Again, a very poor quality picture but it's captioned and that's what is important. Gidi Gov can be seen here on the far right wooing his future wife (they married in 1977), but I was interested in the second soldier when going left to right. This is Itzik Ben Melech, a name with which I am not familiar. According to Wikipedia, he has been active both as a singer and as an actor, but our paths have never crossed.


Shimon Weitzman wrote a book about his days in the Nahal; I'll try and get a copy of this although I suspect that it might be a private printing.



This day in blog history:

Blog #Date TitleTags
27614/08/2010Bad boyDCI Banks, Peter Robinson, Police procedurals
39114/08/2011OptimisationsProgramming, Delphi
165714/08/2023Nutrition and blood testsHealth, Nutrition

Wednesday, August 12, 2026

The 1972 Nahal army entertainment group

54 years ago, give or take a day or two, I and my year group went to see a performance of the Nahal army entertainment group when we were in Israel for the first time. As I wrote1 19 years ago, On the Sunday, we all collected in the cafeteria. This was my 16th birthday, and I felt like I was holding court. After lunch, we travelled to Kibbutz Mevo Chama, which is on the Golan Heights, overlooking the Sea of Galilee: a magical view. In the evening, we had a short "get to meet the kibbutz and its people" as well as a birthday party for me. A wonderful evening.... On the penultimate day of our stay, I arranged for us to go and see the Army entertainment troupe who were appearing not far away. In those far off days, these troupes were the best entertainment in Israel, and we saw the best of those troupes, in one of its best line ups. Not that we understood a word of what they said! But the songs were great.

Over the past month or so, I've been listening to several of the songs from that performance and thinking about them. The opening song was one that was played frequently on the radio and we were all familiar with it at the time. As the record had applause between songs, and as the sparse sleeve notes said that the show was recorded at Kibbutz Givat HaShlosha in recognition of 30 years of the Palmach, I presumed that the record was a live recording. It's only been in the past month that I noticed that several of the vocals were double tracked and that there were no visible microphones. Slowly it dawned on me that this was a studio recording with applause added at a later date - a fake live recording.


There is another song from a bit later in the show, a song from the heady days of 1948, called 'comradeship'; this begins with a duet between a male soldier playing the mandolin and a female soldier playing the flute. The mandolinist is a recognised top guitarist in Israel, although his active playing days seem to be over. I wondered who was playing the flute; CoPilot told me that it was probably a professional flautist and not one of the performers as one might imagine. Again no microphones are visible.

I remember years ago trying to match the names of the songs as listed on the sleeve with the songs listed on the record's central label and with those that were playing. It seemed to me that there was one extra song that played but was not listed; this was a real shame as the song was beautifully arranged, played and sung. It was only in the last month that again I became interested in what this song could be. Someone uploaded to YouTube all the songs and skits of the double record, and this mysterious song can be found: 'Emek', aka the Jezreel Valley. Here is a link to the song, but this is not the only one on YouTube. Here is another, and the uploader's comments are very interesting.

From a hidden bonus track on "Palnach"nik", 1972: A typical Sanderson arrangement (+ Hendrix and Clapton hints) of a sweeping hymn full of love for the land, the human soul and life in full drive; Amazing solo: Gideon Gov; background musicians: Yardena Arazi, Ephraim Shamir and more of the best of the Palmach production of the time. The audience - in ecstasy! (and rightly so). Recorded at a public performance at Kibbutz Givat Hashlosha to mark the 30th anniversary of the Palmach.

There are two very interesting factoids in that paragraph: the first is that the song was indeed a hidden bonus track, partially explaining why the title didn't appear on the sleeve. The other is that Gidi Gov played the guitar solo (especially at around the 3:58 mark); I hadn't considered Gov to have been more than a capable guitarist (what The Band would have called 'a strummer') but CoPilot assures me that Gov really did know how to play the guitar but he stopped playing in public when he concentrated more on his vocals.

There is even a third, albeit truncated, video available on YouTube that is most interesting; this mixes shots of the original settlers working the land spliced together with shots of the Nahal group performing the song. The direction of the filming could have been improved. This recording is definitely different from that on the record - and singers can be seen singing into microphones.

According to CoPilot, the reason why this song was a hidden bonus track is that it was part of the 30th anniversary show but not part of the regular show. Most if not all of the performances on the records were studio recordings, documenting the show. The third video makes me wonder whether this was the actual live recording from the 30th anniversary and that what appears on the record is a studio recording. Gidi Gov is clearly not playing a guitar in that third video. The notes for this version state that the arrangement was by Danny Sanderson, who was in the previous Nahal troupe and would go on to found Kaveret.

Going back to our stay in Israel: I was part of the 'cultural committee' that arranged activities from the group. I don't know who else was with me - if anyone - as I remember three events that I proposed. The army show was one; when in Jerusalem, we went to a nearby cinema to see the original version of 'Far from the madding crowd', and at some stage we went to hear some chamber music at the old railway station which wasn't far from where we stayed. The only piece that I remember from that show was ' 'Introduction and Allegro' by Ravel; I found this in one of the classical records in my school's collection and recorded it to cassetter whilst reading a newspaper in the background (I can be heard turning a page). In the pre-YouTube days of the 1990s , I looked for this and eventually found it on a cd. This is considered one of Ravel's minor works, but I like it all the same.

Internal links
[1] 98



This day in blog history:

Blog #Date TitleTags
61612/08/2013PuzzlePuzzles
75012/08/2014Robin Williams, RIPFilms, Obituary
165512/08/2023Eli, continuedERP, Obituary
165612/08/2023Walk exactly 3,967 steps in a dayWalking
180112/08/2024Genesis of a new songSong writing
198412/08/2025Yet another excisionHealth, BCC

Saturday, August 08, 2026

Learning to play the saxophone

I don't think that I've mentioned it here before, but one of the activities that I mean to do in my retirement is learning how to play the saxophone. I have registered at the local academy which is all of 200 metres from my home; lessons will start some time in September.

I thought that I should get a head start and so I looked for some on-line books that would explain various aspects. "How to play saxophone in easy way" by Louis Harris and Carla Tyler seemed to fit the bill, but when I read it, I was quickly dissuaded. The title should have given me a hint but I only saw it now - the word 'in' should probably have been replaced by the word 'the'.

This book reads as if it were written in some language then badly translated into English. For example, what does "The body is cone like fit as a fiddle, like the oboe, however the bend is progressively particular at the chime." mean? The same paragraph continues "Saxophones might be straight or bended, however straight ones are progressively normal." What sort of copy editing has been done to allow the following phrase? "The Alto saxophones are littler", or "While purchasing a pre-owned saxophone, guarantee that the keys aren't boisterous or spilling."

It was around this stage (and I've quoted from only the first few pages) that I gave up, and if I had a physical copy of the book, I would have thrown it at the wall. It's bad enough trying to learn about with saxophone without having one to hand, but I shouldn't have to try and translate this nonsense as well.

I await my lessons (an hour a week) with baited breath.



This day in blog history:

Blog #Date TitleTags
50108/08/2012Back to normal (well, almost normal)Health
74908/08/2014Twenty five years agoPersonal
124908/08/2019Night walkingWalking
133008/08/2020Masked songsKibbutz
179808/08/2024Pedal board at the beginning of August 2024Pedal board
198308/08/2025The Tu b'Av performanceMusical group

Friday, August 07, 2026

LIfestyle changes

After a week of retirement, I've made several lifestyle changes. The days have felt like seven Fridays or Saturdays: I get up, take the dog for a walk, go swimming on most days, have breakfast, do a bit of programming work, read a book, eat lunch, have a nap, work a bit more, watch some old television series ('Sherlock', 'Teachers'), take the dog for a walk then go to bed. Obviously that's not exactly how any of my days plays out, but it's more or less the framework.

The nap is probably a result of the swimming and/or the intense heat, even though I turn on the air conditioner at about 10 am and don't turn it off until 8 pm - but we sleep with another air conditioner working in the bedroom. Obviously this is all going to change in a month or so.

I've mentioned here and there the mysterious stomach pains1 from which I've been suffering over the past year. I have noticed that I never seem to get any pain on Fridays and Saturdays, but I never really analysed this until about two weeks ago. I also didn't get any pain on the days when I would travel, and this provided an important clue. When I used to work a full day (this doesn't include July as I would swim on a few workdays), I would start work at 7 am, have a cup of tea and biscuit at 8 am, repeat at 9 am and possibly 10 am. On weekends and travelling days, I drink far less tea and with greater intervals between each cup.

Over the past week, I have been limiting myself to one cup of tea in the morning (at about 10 am) and one in the afternoon and there have been no pains whatsoever. Yesterday I forgot myself and had one cup at 10 am and another at 11 am. The pain didn't wait for very long before making its presence felt, lasting until I went to sleep. This really was the proof of my hypothesis that it is the tea that is causing the pain (or more likely, the tea is causing something that causes the pain).

As it happens, I had a return appointment with the gastro-enterologist yesterday afternoon. After I showed him the results of the lower body CT that I did (everything is ok), I tentatively asked whether it was possible that drinking tea could cause the pain. Yes, he said: it's well known that tea and coffee weaken the lower esophageal sphincter (this is the valve that prevents stomach contents from coming back up into the esophagus). Well, it was news to me. Anyway, the result of this consultation was that the pain would disappear by my making lifestyle changes, and now is the appropriate time to do. How can I justify having a British passport if I don't drink tea all day?

It's not clear to me what I'll be drinking in the future: I'll probably have to go back to drinking tisanes. I made a cup of blackcurrant tisane a few days ago but it was very bitter and I didn't enjoy it at all. Maybe something citrus flavoured would be better. 

With regard to swimming, I have already swum more times this year that I have in previous years and so obviously have swum more lengths. Including this morning, I have now swum 39 times with a total of 822 lengths - an average of 21.08 lengths/swim. Obviously at the beginning of the season I swam less then as I was getting into shape, for now every swim is 24 lengths plus. This is dependent somewhat on how many other people are in the pool at the same time; yesterday started off with plenty of room in the pool, but later on more people came in and I had to take evasive action a few times in order to avoid someone crashing into me. After I swam the regular 24 lengths, I got out and drank my juice. By the time I had finished the bottle, I saw that the vigourous swimmers had left, so I went back in and swam another four lengths with no difficulty.

Internal links
[1] 2109



This day in blog history:

Blog #Date TitleTags
74807/08/2014Blackberries (or are they blackcurrants?)Health, Food science
96707/08/2016Turning a corner?Health, Personal, CPAP
198207/08/2025Video camerasVideo camera

Saturday, August 01, 2026

Glen Hansard RIP

I didn't learn about Glen's death via the Guardian as usual but through a blog  I read that occasionally grabs my interest. I understand that Glen was killed in a motorcycle accident in Dublin, aged 56.

Like the person who wrote that blog, I first became aware of Glen via The Commitments, although from thereon our paths diverged slightly. I listened to and loved the music of the Swell Season, starting with 'Strict joy'1 then moving backwards to the soundtrack of the film 'Once'2 and then even further to the eponymous 'Swell Season' disc. I also have some of his solo works, although I don't like them as much as the SS material.

For some reason, quite often songs of the Swell Season play through my swimming headphones*; these tracks are chosen at random, so it's curious that they get so much attention.

As I was telling my wife the news, the radio was playing "Falling slowly". Coincidence? After the song ended, the DJ gave a short obituary that sounded as if it was taken directly from Glen's Wikipedia page.

* Saturday swimming playlist included two songs by the Swell Season, although they were both from the concert disk of 'Strick Joy' with vocal by Markéta Irglová.

Internal links
[1] 231
[2] 733



This day in blog history:

Blog #Date TitleTags
49901/08/2012Diary of a coughHealth
106001/08/2017Donating blood (3)Donating blood

Friday, July 31, 2026

Joining the ranks of the idle rich

This is the way the world ends
Not with a bang but with a whimper
(T.S. Eliot, 'The Hollow Men')

I've already quoted this epigraph at the end of my MBA studies and it seems pertinent to quote it again today. I have now joined the ranks of the idle rich, although I'm not idle and I'm not rich. In plain language, I have retired from full-time work.

I sent the parting letter to everyone at work as well as to some outside people with whom I have contact. I received in return some warm replies, and the chairman of the board (who lives in Canada) even telephoned me yesterday afternoon to thank me for all my work.

My last day was subdued: we had set up a test server the previous evening and someone had forgotten to turn off the task scheduler, so in the morning I saw many duplicate reports in my mail box. Once that was fixed, I went over procedures that would send me emails, changing the destination of those mails. A few more fixes and that was that. I had forgotten to remove myself from all the groups to which I belong, which would mean that every day a multitude of reports would be sent to my (now closed) email address; I fixed this in the evening.

So now I become a contractor and it will be interesting to see how often I will be contacted and how many hours I can charge throughout the month. I suspect that there'll be frequent consultations in the coming week but then this should taper off.

I don't feel anything special at the moment, although as it is the weekend, effectively nothing is unusual. The first moment of change will be on Sunday morning; I am cancelling the alarm clock that would wake me at 5:30 am. The swimming pool is closed on Sundays so I don't even have to get up in time to swim.



This day in blog history:

Blog #Date TitleTags
27231/07/2010How things have changedLiterature
74531/07/2014Feral systemsDBA
105931/07/2017Mobile CPAPCPAP
197631/07/2025No more normal ... and how science fiction handles mental illnessPsychology, Robert Silverberg, Non-fiction books

Thursday, July 30, 2026

Minor accident

About ten days ago, I slipped on the stairs leading to our flat. Fortunately, I was almost at the bottom of the staircase so I only fell two steps. My right forearm took most of the impact although somewhere else in my body also got hit. I lay there for a few minutes without moving, trying to get my breath back. I was taking the dog for her early morning walk - she didn't pull me causing me to slip, and when I was lying on the staircase, she simply waited for me to get up. It's not clear to me how I managed to slip - I think that my feet touched the front edge of the stair instead of the back.

Looking at my forearm a bit later, I could see that there was a minor abrasion but I didn't pay much attention to it. When I showed my arm to my wife, she said that there was a huge swelling in the area that I hadn't noticed because it was on the 'dark side of my arm'. It wasn't hurting very much (if at all), but I took an ibuprofen pill to help control the swelling.

Over the past few days, the arm hurts only if I rest it on something (like a chair arm) or raise it to the height of my eyes. It does not hurt when swimming. It was at the pool a few days ago that I noticed that my inner forearm has turned yellow and that there is a red area not at the same place as the abrasion.

The red area is easy to see but the yellow part, which starts slightly after the wrist and continues to past the elbow can't easily be seen in the photo. I don't want to manipulate the colours too much as otherwise it won't look natural.

The yellow is of course internal bruising and shows that the impact caused much more damage than I originally thought. But there are no broken bones, and it's just a matter of time until everything sorts itself out.



This day in blog history:

Blog #Date TitleTags
18830/07/2009Speed IIIProgramming, Office automation
27130/07/2010Nice workDavid Lodge
61530/07/2013SynchronicityTV series
105830/07/2017Sing Street (2) - A few more observationsFilms
152130/07/2022Kate Bush - a little harmonic analysisKate Bush, Music theory
164930/07/2023The swimming pool show - addenda and updatesMusical group
197530/07/2025The making of "Five leaves left"Nick Drake, Joe Boyd

Tuesday, July 28, 2026

Parting letter

Following is the text that I sent this morning to all the employees. Yesterday I attended my 'farewell party' in Karmiel, after which several people came up to me for chats.


Dear friends,

After 37 years at Tzora Furniture and then in the Global family, it is time for me to end a significant chapter in my professional life and retire. I arrived at Kibbutz Tzora in 1989 and was immediately assigned to work at the factory. Since then, I have gone on a long and fascinating journey — from accounting, through the implementation of ERP systems, to the development and implementation of computer solutions that have become an integral part of the company's daily operations.

Over the years, I have had the privilege of working alongside dedicated, professional, and above all, good people. I have learned from each and every one of you, and our collaborations have always been a source of pride and satisfaction. Most of the time, I have enjoyed serving you, introducing new processes, and solving challenges together that came up almost every week.

I apologize if I have offended anyone along the way. Any disagreement or unpleasantness has always stemmed from our shared desire to do the job better — never from a personal standpoint.

The late CEO, Eli, used to say that there are no problems, only challenges. I must say that at times you have challenged me greatly, but I am happy to say that the challenges created synergy, and in the end both sides benefited. I believe that these challenges have made me feel much younger than my biological age.

I am finishing work a few days before my 70th birthday with a great sense of satisfaction. Two goals have accompanied me throughout the years: to improve the flow of information between the company's departments, and to empower the employees. I believe that we have succeeded in both goals, and I am leaving behind a good infrastructure and legacy for the future. Many times I have been happy that the work fits me like a glove, but in reality that is because I designed the role quite a bit myself and could not have done it without your support, so thank you.

Thank you for years of trust, cooperation, professionalism and friendship. I wish you all great success in the future.

Best regards

Noam



This day in blog history:

Blog #Date TitleTags
18628/07/2009Speed, speed, speedProgramming, Office automation
27028/07/2010The in-basket 5In-basket
61328/07/2013A neat hack: right clicking a grid's title barProgramming, Delphi, ClientDataSet
115828/07/2018100 yearsPersonal
197328/07/2025Adding comments to the blog manager programBlog manager program

Saturday, July 25, 2026

Redefining primary keys as composites

On the weekends, I've been occupied with updating one of the OP's database programs to Delphi 12CE and unicode. I'm becoming very familiar with this so the conversion has been straightforward for most of the time. I'm not going to write about that today.

I was working on the forms that allow data in the MATSCALE table to be edited; this table is really a 'junction table' that defines which 'scales' are connected to which 'purposes', where the 'purposes' table contains entries such as 'work', 'absorption to kibbutz' and similar. Had I was defining this table for the first time instead of inheriting something that I defined 20 - if not 30 - years ago, then I would probably have only the two columns, 'purpose' and 'scale', that together would create the primary key. I have found it occasionally difficult to work with such a primary key and find it easier to create an auto-increment integer that can serve as the primary key.

It occurred to me early this morning on the dog walk that I could take a leaf out of the way that Priority defines tables; there must always be a primary key (denoted U, for unique) and there can be an autoincrement (denoted A), where this column often serves as a foreign key in other tables. Although I have never done this before, I should change the MATSCALE keys so that the primary key is purpose + scale, leaving 'id' as an autoincrement that is not a key. This way, the same scale can never be defined twice for the same purpose.

Having the idea was relative simple but implementing it was hard. The first thing that I did was to duplicate the MATSCALE table, including copying the data, so that I would have an easy to access the table with all the data should I need to restore it. I had tried various means of changing the primary key, but none of them worked until I found the following solution: first, define 'id' as a normal integer instead of being an autoincrement (this was in case of having to recopy the data). Then I defined both 'purpose' and 'scale' as not null, committing each change in turn. Then I was able to edit the primary key, adding the two new columns and removing the original column. I then reconnected the 'id' column to the key generator. I dropped the copied table, of course.

So now I have an autoincrementing column that is not the primary key; the actual PK is combined of two columns. I am documenting this in case I decide to implement the same idea elsewhere. I know that there are similar tables in both this database and in the management database.



This day in blog history:

Blog #Date TitleTags
9725/07/2007Life is stranger than artPersonal
9825/07/20071972 - the year I've been leading up toIsrael, Habonim, Kibbutz, Richard Thompson, 1972
18425/07/2009Better late than never - IIRichard Thompson, Fleetwood Mac, Albion Band
26925/07/2010The in-basket 4Programming, Delphi, In-basket, Resource files
38725/07/2011Human Resources Management resultsMBA, HRM
88025/07/2015Vinyl log 21 - 25 JulyRichard Thompson, Vinyl log
105625/07/2017Guitar cornerGuitars
124625/07/2019Running a procedure from a screen triggerPriority tips
197025/07/2025Ding Dong, the witch is dead!Personal

Thursday, July 23, 2026

Challenges and out of the box solutions

I wrote1 yesterday about how the old CEO would challenge me with various problems. I forgot to mention that my manager mentioned that often she would come to me with questions that either I could solve on the spot or those that needed a bit more thought (see the accompanying picture). Often I would solve 'the impossible' either in the shower or when walking the dog.

I also mentioned that there appears to be a bug in Priority regarding certain SQL queries although I won't go into detail about the bug here. I went out with the dog for our early morning walk and a solution for fixing this bug popped into my mind. It's not a complete fix, but it's good enough for the time being. The only way to get there was to ignore the standard method of doing something (which appears to be bollixed at the moment) and find an out of the box method. It helps to do this when one is far away from a keyboard.

Internal links
[1] 2121



This day in blog history:

Blog #Date TitleTags
9623/07/2007Favourite filmsFilms, Woody Allen, Meg Ryan, Diane Keaton, Kevin Kline, Hugh Grant
26823/07/2010Porting the Amateur Reasoner/2Prolog, Bill Thompson
105423/07/2017This bird has flown: the enduring beauty of Rubber SoulBeatles
164523/07/2023The beginnings of a new songHealth, David Lodge, Song writing
196823/07/2025Dave Cousins RIPObituary, Sandy Denny

Wednesday, July 22, 2026

The season of farewell parties

There are six more workdays left until I retire as a full-time salaried employee. I will be working after this, but as a freelancer who chooses his own hours and doesn't have to hear from the entire workforce. So in the days that are left, it is time to part from as many employees as possible.

Today there was a 'farewell party' in the branch where I have worked for the past 36 years, my 'home team'. First, my manager, the chief financial officer, praised me to kingdom come in front of all the employees there (about 20). At first this was OK but towards the end became a little embarassing. She spoke about how I have always served professionally whoever would come to me for help, and how I have solved many thorny problems over the years. She told how I have created an information eco-system for the company, creating reports and work protocols that have advanced the company over the years. This was as much for those who are not aware of what I have done over the years as it was for those who were well aware.

I began my speech by noting that whenever I attend a funeral on the kibbutz, I hear the deceased being praised in glowing terms, and I always think that it's a shame that the deceased never got a chance to hear all these wonderful things being said about him/her. I have the advantage of being alive to hear my 'eulogy'. I then talked a little about how it was in the early days, and how certain workers who are still with us began their employment. I said that like on Yom Kippur when we all request forgiveness for anything bad that we might have done, I request forgiveness from anyone with whom I might have had a dispute: if so, these disputes were always on a professional basis and not personal. I did say that I have personal and professional satisfaction from the legacy that I am leaving behing. I also recalled the late CEO who would often substitute the word 'challenge' for 'problem'; he challenged me frequently and I doubt that I could have achieved the same results had he not been there with his challenges. I mentioned that this branch implemented ERP 'by the book' and would always use it as an example to the other branches who frequently did their hardest to implement ERP as it is not meant to be implemented; I had to find ways that their protocols could match those in Priority as much as possible.

Several people came up to me personally after the speeches to shake my hand and say a few words. Most surprisingly, one was a new employee who said that he didn't know me but that he had heard of me and wanted to wish me well. That was very kind of him.

There will be another such 'party' in Karmiel next Monday; there it will quite different as first of all, my connection with that factory started only in around 2008 if not later, and secondly because I am only there once or twice a month, so all communication is either by email or by online meetings. My manager will not be there, but I will hear either from the CEO or from the factory manager (if not both) what they have to say.

There will probably be some form of 'party' in Tel Aviv towards the end of August as well as a special celebration for the finance department to which I belong.

I am not resting on my laurels: there are still some thorny problems to be solved at work that only I can deal with. After a minor upgrade a week and a half ago, there are several procedures that have stopped working for most people (but not for me), where the problem seems to be connected with choosing parts as input.  I figured out how I can run these procedures under the debugger when the person running the procedure is not me but an ordinary employee. I saw that when I run these procedures, a normal SQL statement is created, but when they run the procedure, a ridiculous statement is created that apparently joins one part with the entire table of parts, causing the procedure to crash eventually . I have passed examples of this problem on to the company that gives us professional support, but I haven't heard back from them yet.

I have prepared a general farewell letter to be sent to the entire company by email some time next week. I will send it a few days before I finish as it would be nice to read what people have to say. After I retire, my account will be closed so that no one can write to me anymore with their problems - or even their best wishes. I will leave a message 'this email address will self-destruct in ten seconds', but I doubt that many people will get the reference. I must also remember to write to the company that supports us, although I will stay in contact with them, only with a different email address.



This day in blog history:

Blog #Date TitleTags
26622/07/2010Porting the Amateur ReasonerProgramming, AI
26722/07/2010Beef ratatouieCooking
61222/07/2013Transferring cassettesPersonal, Old recordings
74122/07/2014Rice and beansCooking
74222/07/2014And now for something completely differentFilms
88222/07/2015Vinyl log 20 - 22 JulyVinyl log, Fotheringay
179322/07/2024Italian phrasesItaly
196722/07/2025Resuscitating the Donner octave pedalPedal board

Sunday, July 19, 2026

Rugby, cricket and music: memories of 1968/9

Yesterday's post1 about the death of Gary Sobers (and previously, JPR Williams2 and Mike Procter3) show how important professional sports (even though rugby was amateur) to me at an early age. After all, I was a few weeks short of my 12th birthday when I saw Sobers in the flesh. For a few years, I was a junior member of Bristol RFC and Gloucestershire CC, allowing me entrance to the members' area and a much better view of the games. It wouldn't be for another year before sports began giving way to music as my primary hobby, or as I should say, obsession.

I don't think that I realised at the time, but I was lucky to see Sobers in the flesh because it seemed that once a player had reached international level, he stopped playing at the club/county level. As I noted in the obituary of JPR Williams, I saw him a week or so before his international debut and would never have seen him again. I was very surprised at some stage to discover that Bristol RFC was the home club of John Pullin who played hooker for the English rugby team and even captained it at one stage: I had never seen him play for the club.

And as for music: I remember that sometime in 1968 I bought a mini-guitar that had four strings (it wasn't a ukelele) and tuned it in some strange way. I suddenly started writing songs although they have been lost forever and I have no idea what they might have been about. I do remember that I was in France4 in the spring of 1969 and wrote some form of a song on some odd stringed instrument; I realised afterwards that I had written a copy of 'Eleanor Rigby'.

I learnt my first guitar chords at the summer camp of 1969, along with writing the lyric for a song. This was the true rebirth of my interest in music which grew and grew and no doubt had a negative influence on my performance at school.

Internal links
[1] 2119
[2] 1706
[3] 1722
[4] 239



This day in blog history:

Blog #Date TitleTags
9419/07/2007What I did at work todayProgramming, ERP, Thermal printers
74019/07/2014Statistics with SQL (Firebird)Programming, Delphi, SQL, Firebird, Statistics
96419/07/2016When the music's overDCI Banks, Peter Robinson, Police procedurals
124319/07/2019Making the Greece holiday videoHoliday, Home movies, Andros, Athens, Greece
164319/07/2023If this is jazz then I'm all for itAmbient music, Matthew Halsall
179019/07/2024Sorting on two columnsProgramming, Delphi, Office automation