Posting to Bluesky via the API from PHP – Part Six – Handling Handles and Oversized Images

January 3, 2024 | 1 comment

NOTE: This post is mainly about how I developed the php2Bluesky library. If you are looking for information on using the library in your own code please see here: https://github.com/williamsdb/php2Bluesky/

I wrote a series of posts towards the end of the year that took you step-by-step through using the Bluesky API to post to the social network. Having used the code Patrick Delahanty got in touch to say that he had found a couple of issues. Firstly, handling user handles and secondly dealing with large images. Let’s take a look at both of those.

Handling User Handles

As with … Read the rest

Changing your Bluesky handle to be your own domain

December 27, 2023 | 2 comments

I’m liking Bluesky, which is a little like a rough around the edges X without the toxicity found there. And here’s a neat thing you can do on Bluesky that you can’t on X. If you have your own domain you can use that as your Bluesky handle. In the rest of this article, we’re going to look at how you do that.

Why would you want to do it?

First off why would you want to do so and what are the implications of making the change? I see a number of reasons to make the change:

  1. it
… Read the rest

Automatically Restarting Unresponsive MySQL Service

October 29, 2023 | Comment

This blog and others that I run are all hosted on a cloud server with MySQL installed locally. Occasionally MySQL becomes unresponsive and I have to login to the server to kick it back into life by restarting msqld.

The most likely reason for MySQL becoming unresponsive is lack of resources so the best solution would be to increase the size of the server – however, that requires money that I don’t want to spend. Therefore, the next best option was to write a script to detect when MySQL was unavailable. Enter mysqladmin.

mysqladmin — A MySQL Server Administration Program

… Read the rest

Working out my credit card statement date in Excel

September 7, 2023 | Comment

This might be the most niche post I have ever done but I hope that it might prove useful to someone.

My credit card bill gets made up on or around the tenth of each month but, for reasons I won’t go into here, I needed to much more accurately predict when it was actually going to be created. Through a combination of searching and testing, I discovered that in my case it is always made up on the sixth working day of the month. Turns out that there is an Excel (and Google Sheets) function that can help with … Read the rest

Day One Encryption

July 19, 2023 | Comment

TL;DR the Day One local database is not encrypted.

After my last post on querying the Day One database, I was asked the question: what happens if you have your journals encrypted?

Before we get into that, let’s look at the Day One encryption options. You can turn on encryption on a journal-by-journal basis and it is on by default. This must have changed at some point as my original journal is not encrypted and newer ones are. Despite being able to choose which journals are encrypted and which aren’t selectively there is only one encryption key meaning that … Read the rest

The Move from LastPass is Complete

July 14, 2023 | Comment

In December 2022 LastPass announced to their users that they had been subject to a data breach. This led me to consider moving to another password manager which I did, settling on 1Password.

I transferred over 1,700 passwords and I calculated that changing an average of three a day was going to take me a year and a half to change them all. Well, it has been somewhat quicker than that as I have finished! In doing so I have reduced the number from 1,700 to 677.

I thought that it might be useful to know what I did … Read the rest

Transitioning from Twitter API v1.1 to v2 (Part 1)

June 1, 2023 | Comment

As part of The Twitter Debacletm I have spent the last few weeks trying to get my Twitter bot working again which has taken quite a bit of effort.

I thought it might be worth looking at what I did to get my bot working again once access to the API was cut in February. As there is so much in this I have broken it down into two parts:

  1. setting up your project and getting the keys you require to use the API
  2. calling the API from PHP

Getting the keys

I struggled to find which keys to … Read the rest

How to Restore Twitter to Something Useful

January 16, 2023 | Comment

Since the takover of Twitter by Elon Musk changes have been coming thick and fast. Some, such as Twitter Blue, have been well reported and endlessly debated. Others, such as the change to the timeline, less so. It is the latter that I am going to concentrate on today.

Twitter has long tried to encourage behaviour that it wants rather than what the consumer might want. This means pushing tweets from people that you might not follow but others you follow do, in the hope that you will build your own followers. The problem with this is that you end … Read the rest

Mastodon and verifying websites

November 24, 2022 | Comment

Mastodon is all the rage at the moment as Twitter is driven into the ground in full public view by new overlord, Elon Musk. I’m not going to go into the pros and cons of Mastodon here but looking at one specific thing that is different to Twitter – the automatic validation of websites.

Getting your verification link

In the profile section Mastodon allows you to record up to four pieces of metadata. This can be anything you want, such as location or pronouns, and you can also record your website addess here too. You can put any link … Read the rest

Accessing Local Resources over the Internet with Packetriot

November 1, 2019 | Comment

When I am doing any development, such as for PostRecycler, I do the coding on my laptop running Apache, PHP and MySQL locally via MAMP. This is fine until I need to share work with others which means I have to either upload the work onto a public server or do it via screen sharing. Neither are particularly ideal.

I was vaguely aware of the service ngrok which allows you to expose your local services on the web and then, via Reddit, saw the similar service Packetriot which does a similar thing so I thought I would give … Read the rest