UK Election 2019

So, no vote for us.  Shame about the 15-year rule.  Particular as we lived in Raaab's constituency.

This was 2017:

https://www.theguardian.com/politics/ng-interactive/2017/may/08/general-election-2017-poll-tracker-who-is-in-the-lead

This is today 2019:

https://www.theguardian.com/politics/ng-interactive/2019/dec/11/election-opinion-polls-uk-2019-latest-poll-tracker-tories-labour

Looks pretty similar if you ask me.   Labour slightly further behind the Tories, but Libdems have a fair bit more....

Will be an interesting night tomorrow.

Just so you know... Retirement in Spain Post Brexit

1) We left in 2006 and thus have been stripped of our right to vote the upcoming election due to the 15 year rule.

2) So that I can say in the future that no-one I know "didn't know this"...

Please read the requirements for a RETIREMENT VISA in Spain - for 3rd country nationals.

http://www.exteriores.gob.es/Consulados/SANFRANCISCO/en/ConsularServices/Documents/visas/RetirementVisa.pdf

(This is the Spanish California Consulate Document)

In particular:

- Minimum income required is 25,560 Euros annually plus 6,390 Euros per each additional family member

- Proof of having international medical insurance - This will cost upwards of 350 Euros per month at age 65+ = 4200 Euro per year

(Note that pre-existing conditions will NOT be covered by private medical insurance)

 

I've highlighted a few fun things that will need to be provided by Brits in the future if they want to retire to Spain.

 

 

Check constraint that is a field has a particular value ensure that another field must be filled in.

DB time!

So this post regards "normalisation", or lack of, permitting me to be more lazy, and have simpler databases - what's not to like?

I had a DB table "users", and two distinct classes of user:  Adult and Child.  Now the business logic demands that the Adult users have an email address entered, whereas the child user doesn't necessarily need one.

The Boyce-Cod or whatever blah blah method would be to have 2 tables, but that means loads of JOINs, the inability to view the entire user list in one place, and more logic everywhere.

I'd prefer to have 1 table "Users", but how to enforce the business logic above?

So I've discovered a way - using CHECK CONSTRAINTS in MS SQL 2012+

The "redmouse" is a child user, it is optional whether he has a email address or not.

([role]='Adult' AND [emailaddress] IS NOT NULL OR ([role]='Child' AND [emailaddress] IS NOT NULL OR [role]='Child' AND [emailaddress] IS NULL))

Allows me to denormalise to my hearts content and yet retain the rock solid data stability that we all crave.

Similarly above the "childDoB" column is only relevant to "child" users.   For fun what would be the CHECK CONSTRAINT for that rule?

Land Rover Discovery 3/LR3 upper rear grab handle removal

I'm not very good with DIY.  Has to be said.  So I bought a Upper Cargo Shelf. Very nice it is too..  So I need to fit it....  How hard can this be??

Comes with a A4 page of written instructions.  Very 70s I must say...

Anyway so apparently I need to "pry back the plastic covers".  I'm trying to "pop" the bloody things out from the bodywork.  Lucky a neighbour walks by and clears things up for me.

There is a plastic "flap" that covers the screws.

So I know there aren't any photos online of that..  I've checked,  so if you in the same boat as me....  Now you know.

Natureo De-alcoholised Wine from Torres

I just finished this bottle off... I'd opened it for a family friend who visited as he was not boozing.

It "looks" very good... looks a lot like wine

Tastes pleasant.. (however doesn't taste like wine)

so worthwhile keeping a bottle or 2 in I think... psychologically useful if you fancy a glass, but shouldn't really.

If you are thirsty and have a fair bit in the glass, you can glug it down (it's grape juice more or less) and that is something that doesn't happen with wine.  People looking at you will think you are a maniac...

I've had a idea for Boris.

This is what he should do.

He should go to Brussels and demand:

1) End of EU commissioner/president appointments.  These should be directly elected by the Members States populations.. think "US President"-style elections.
2) Move the European Court of Justice or the European Central Bank to somewhere in the UK (not London)
3) End the monthly move of the European Parliament to Strasbourg.
4) Probably a few other things he can come up with...

THEN

Come back to the UK and offer this new deal (and Remain) or full out (with all the implications like loss of NI and subsequently Scotland) to the people in a new referendum.

Waste rubbish dump in La Massana Andorra

There is a community waste disposal location in La Massana. 

Shared with the Ordino comú it is situated on the main road between the two towns, opposite the Elf petrol station.

It is open between 8 am and 4pm Monday through Saturday.