Gareth Powell's Avatar

Gareth Powell

@gmmapowell.bsky.social

One of the few who recognize the total and complete pointlessness of life.

33 Followers  |  22 Following  |  354 Posts  |  Joined: 18.11.2024  |  1.7068

Latest posts by gmmapowell.bsky.social on Bluesky

Building a Stock Watching App Carrying on from where we left off, it's time to build an app to watch these stock prices in Neptune. This consists of three parts: a ...

OK, it's time to carry on with exploring neptune. I'm ready to build a web application. Step 1 is to build a client:

ignorancemaybestrength.blogspot.com/2025/08/buil...

12.08.2025 10:36 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Manchester's memorial to the victims of nuclear bombs in Hiroshima and Nagasaki.

Manchester's memorial to the victims of nuclear bombs in Hiroshima and Nagasaki.

Now another 40 years have passed. But once again, it doesn't feel we'll make another 40.

06.08.2025 11:12 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
Right to buy in England β€˜fuelled housing crisis and cost taxpayers Β£200bn’ Common Wealth report calls discounted sales of council homes one of the β€˜largest giveaways in UK history’

"Right to Buy" was always a flawed - if not outright bad - policy. It should have included a clause requiring replacement social houses to be built with the money raised.

Given Thatcher's overall policies, though, I have to assume she wanted homeless people.

www.theguardian.com/society/2025...

03.08.2025 15:59 β€” πŸ‘ 1    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Preview
Starmer and Reeves should prepare UK for wealth tax, say top economists PM could raise β€˜tens of billions’ while positioning Britain as progressive, say Thomas Piketty and others

Yes. A consultation and debate. Point out the self interest of those who oppose it.

www.theguardian.com/business/202...

28.07.2025 19:54 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
Get early retirees off the golf course and back to work – why early retirement isn’t good for UK plc Giving up work in your 50s is a wealthy indulgence that should be discouraged – the new pension commission needs to widen its remit

Tail. Wagging dog.

Summary: we all need to be forced to work until we drop dead to keep the economy afloat.

Guardian readers deserve better.

www.theguardian.com/business/202...

26.07.2025 21:06 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

What is the connection between Luis Matos and his walk up music?

23.07.2025 17:36 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Notifying Watchers I think I've reached the point where I've actually done all the Neptune experiments that I really need to do. Now I'm going to start movi...

And, finally for now, If we are going to build an actual webapp, we need to track endpoints associated with users so that we can notify them when stock prices change.

ignorancemaybestrength.blogspot.com/2025/07/noti...

22.07.2025 17:25 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Finding Watchers Now I want to turn it around the other way and consider what happens when a stock price changes. On this occasion, I have a fixed stock i...

Once you've done a query in one direction, the other is easy.

ignorancemaybestrength.blogspot.com/2025/07/find...

22.07.2025 17:25 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Always be careful what you predict.

I have now wrapped up those "few...cases" but it was harder than what had gone before and were pretty orthogonal. So I now have *two* blobs of code to refactor.

Oh, well.

21.07.2025 09:14 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Watching Stocks I'll often approach software from the top down, but often from the bottom up. I'm sure there's a lot of interestingly psychology behind t...

Now that we have all that data in the database(s), we can run a query to traverse the relationships and figure out what the current prices are of the stocks watched by a given user.

ignorancemaybestrength.blogspot.com/2025/07/watc...

21.07.2025 08:31 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Cleaning Neptune While refactoring, I realized that I didn't have any code to clean a Neptune database, or indeed, any idea about how to go about it. Presu...

And given that we've written some detritus, we need to be able to clean everything out and start again.

ignorancemaybestrength.blogspot.com/2025/07/clea...

20.07.2025 23:21 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Building a Graph So now we turn the question of building a "serious" sized graph. Not too serious, of course. I'm not even going to build something that w...

Finally, we can get around to building a full graph of users and stocks (and the relationships between them).

ignorancemaybestrength.blogspot.com/2025/07/buil...

20.07.2025 23:21 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Every test I wrote felt like it just needed a few lines of corresponding code.
The only real problem I ran into was with my tokenization code and that's a mess so I need to rewrite that now.
I stil have a few prefix/postfix cases to cover; I'll proablh do those on my flight down to Altanta tomorrow.

19.07.2025 11:44 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Coding went well on my transatlantic flight yesterday. Even though planes have wifi these days, I still like to have a project I can work on without any internet access. So I wrote the precednce parser for my deployer. I tried something radical and different and it fell out really easily.

19.07.2025 11:44 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Node Creation Syntax So, if it's not obvious, there is something wrong with our "query" (which is not a query in the normal sense but something we are trying to...

With our connectivity issues resolved, we are finally in a position to try creating nodes inside Neptune.

ignorancemaybestrength.blogspot.com/2025/07/node...

19.07.2025 07:54 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0
Preview
Ofwat to be abolished as ministers look to create new water regulator Exclusive: Move follows intense criticism of utilities over sewage spills, shareholder payouts and ballooning debts

If the new regulator does not have the power to guillotine directors of failing water companies, it will be a failure.

www.theguardian.com/business/202...

18.07.2025 12:45 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

It's the team meetings that kill me. I always want to say something but am interrupted by myself.

The three of us can't get along.

18.07.2025 12:04 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Connecting to Neptune Before we can go any further, we need to sort out the connectivity issues. Looking at the console, I can see that I have two endpoints, o...

Nothing is very easy.

A long, long detour into the dark soul of using a VPN to connect to an AWS VPC.

ignorancemaybestrength.blogspot.com/2025/07/conn...

18.07.2025 06:27 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Populating the Tables Before we can do anything else, we need to start populating the dynamo tables and then linking random things together. None of this code i...

With the infrastructure in place, we can create some sample data and figure out how to get it into the database.

ignorancemaybestrength.blogspot.com/2025/07/popu...

17.07.2025 18:33 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Classic Home White.

Reasons speak for themselves.

17.07.2025 13:41 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Reading the original post more closely, I think it was intended to be rhetorical, but if so, didn't make that point well. It's not about the *answer*, it's about the *question*. The question "how complete is this project" is simply a category error.

17.07.2025 11:03 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

I read some rando's post on LinkedIn the other day which really annoyed me. Asking one of those stupid trolling questions about "how do you know how done an agile project is?"

My thoughts in full are here: gmmapowell.com/technology/a...

17.07.2025 11:03 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Deploying Infrastructure I first thought about using Neptune several months ago, but I ran into an obstacle I'd had with any number of other things. It looked pain...

The first step (which is what had been holding this up) is to create a Neptune instance in AWS, along with some Dynamo Tables.

ignorancemaybestrength.blogspot.com/2025/07/depl...

17.07.2025 06:46 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

The first 90% of the project takes the first 90% of the time. The remaining 10% takes the other 90% (or more).

16.07.2025 10:45 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
A Graph Database This may be an uncommon opinion, but I like relational databases. In fact, when they were first around (possibly even first being mooted) t...

Last week, while I was stuck on my Tax Return project, I finally got around to exploring Graph Databases (AWS Neptune in particular). My write up of the experience begins today, and can be found here:

ignorancemaybestrength.blogspot.com/2025/07/a-gr...

16.07.2025 06:16 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Wow, I just learnt *about* three whole linguistic moods that I'd never even heard of before: optative, cohortative and desiderative. I think I may even have an understanding of what they're for.

15.07.2025 21:46 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Me and 5m other people on here...

15.07.2025 16:26 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

That's looking really good. Looking forward to giving it a go!

15.07.2025 16:11 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0
Post image

I don't know who is in charge of organizing @metrolinksocal.bsky.social but it is incredibly brittle in face of problems and there appears to be no planning around resilience.

There are literally 20-30 trams in a queue from Deansgate to Market St right now.

14.07.2025 13:26 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
Teach First job applicants will get in-person interviews after more apply using AI Graduate recruiter says much use of AI goes undetected as specialist says half of candidates are now using it

Will there come a point when people realize the traditional hiring model is just completely and hopelessly broken?

www.theguardian.com/technology/2...

13.07.2025 09:48 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

@gmmapowell is following 20 prominent accounts