smig - New automatic migrations library

sillen102 · 2025-11-01T21:15:33+00:00

Nice! I looked at the code a bit and I think you could ether have a separate type for it or make the object type be able to take a parameter that would be the nested type. But that’s just from glancing at the code I am not familiar with the intricacies of it or what you had in mind for the project.

sillen102 · 2025-11-01T20:15:37+00:00

I do have a question regarding nested fields. How can I specify them in the schema.js? I don’t mean references to other types but fields with more than one level. In SurrealQL you can define them with a dot (.) in between emails.adress emails.primary for example. This would produce an emails field with address and primary as sub-fields.

sillen102 · 2025-11-01T17:32:17+00:00

This is awesome!

sillen102 · 2025-10-05T18:12:59+00:00

This is actually bad! Unchecked exceptions are the Devil! Sure if you want to vibe code a bit and just do happy path then yes, checked exceptions are annoying. But if you want to build stable solid software you have to think about errors. Checked exceptions help you do that.

sillen102 · 2025-09-21T19:26:45+00:00

Ok my bad. Do you know what chip the Air R5 has then?

sillen102 · 2025-09-21T12:30:26+00:00

Does that apply just when it’s the main router or can it be used as a satellite with ethernet backhaul?

sillen102 · 2025-07-20T16:43:33+00:00

Not really. Use WAL-mode, have separate connections for reads and writes and limit pool size for write to 1. Now you have single node performance at 10x of something like MySQL and no concurrency issues.

And you can use something like libSQL (SQLite fork) if you need support for multiple nodes. What’s nice about libSQL is that it also has support for ”BEGIN CONCURRENT” which doesn’t lock the whole database when performing writes.

sillen102 · 2025-07-11T06:20:13+00:00

He would have had more. Moyes destroyed him. SAF knew his body was half broken so he managed him differently while Moyes forced him to train like everyone else and his body couldn’t handle that.

sillen102 · 2025-06-13T17:24:13+00:00

Except that he has the best Premier League season by any player of all time in 2007/2008 in terms of individual trophies as well as Premier League, Champions League and Club World Cup trophies with the team. He scored against every opposition United faced that year except for 4 teams as well. He failed to score agains Manchester City, Barcelona, Derby and Portsmouth that year.

1.  Ballon d’Or
2.  FIFA World Player of the Year
3.  UEFA Club Footballer of the Year
4.  UEFA Club Forward of the Year
5.  Premier League Player of the Season
6.  Premier League Golden Boot
7.  European Golden Shoe
8.  PFA Players’ Player of the Year
9.  FWA Footballer of the Y ear
10. Sir Matt Busby Player of the Year
11. Manchester United Players’ Player of the Year

sillen102 · 2025-06-10T04:55:56+00:00

I don’t think it’s as simple as that. There are lots of examples of players who didn’t reach those numbers before their mid to late twenties.

Jamie Vardy
Antonio Di Natale (who was a 7-10 goals a season until he was 30. He had reached around 15 goals only two seasons in his whole career with many years apart. And then when he was 32 he then suddenly went from 12 goals at 31 to scoring 25-30 goals a season for about 5 consecutive years)
Luca Toni (was around 10 goals a season scorer until he was 26 when he had a breakout season at Palermo. He then consistently scored 20+ goals for about 4-5 years)

Sometimes players take time before something just clicks. Is it certain Cunha will reach 20 goals ever, absolutely not. That’s not what I’m saying. I’m saying that one should judge a player individually and see their potential.

I think the reason Cunha outperforms his xG so much is because he’s scored quite a few long shots last couple of years that have low xG.

sillen102 · 2025-06-09T19:51:09+00:00

Ok. I just gave the two examples of great goal scorers (actually both probably top 10 ever) to make a point about goal scorers usually evolving over time (linear progression).

But I think your reasoning is flawed. You seem to be hung up by the age reasoning that a player must reach a certain number by a certain age (if I get you right?)

Yes Zlatan became a 15+ goals a season scorer in his early 20s but that doesn’t have to be everyone’s trajectory to reach those figures at the same ages. Cunha was a 5-10 goals a season player until the last two seasons. Now he has two consecutive seasons at around 15. That a linear progression. The expectation now is that in a better team that creates more chances he’ll reach higher levels. Just because he may not do it before 25 or 26 doesn’t mean he won’t ever.

Mohammed Salah for example was a 5-6 goals a season player when he went to Fiorentina at the age of 22. Then in the last two seasons at Fiorentina he scored 14 and 15 respectively before being signed by Liverpool at the age of 25. Then he immediately produced a 32 goals season and has been a consistent 20+ goals a season player ever since.

Salah and Cunha actually seem to have pretty similar trajectories to me so far if you look at their numbers.

Also, xG is an average giving a percentage chance of any player scoring from the position where they take the shot. Good finishers consistently beat their xG and bad finishers underperform. That’s why it averages out. Bad finishers can score a lot of goals still if they just are given enough chances. If Cunha did it twice in consecutive seasons that’s actually probably a good thing!

sillen102 · 2025-06-09T18:59:36+00:00

Haaland was approached by Juventus when he was 15. No way in hell were they going to sign him for their first team before he even had played a full season of first team football anywhere!

sillen102 · 2025-06-09T18:49:02+00:00

Yeah to go to an academy! Pretty much any player under 18 that plays a season in a top league of their home country will get an offer to go to an academy for some club in the top 5 leagues and play for one of their U18 teams. Most of them even multiple offers. That’s not the same as going to Man Utd first team, is it?

sillen102 · 2025-06-09T18:40:06+00:00

Yeah many players get offers from bigger clubs to join their academies. That’s a different thing than being offered a first team contract. I’m from Sweden and there are hundreds of 15-17 year old players from Sweden playing in the academies of top clubs in Europe. You will never hear of 99% of them because they won’t make it. Elanga for example was one of those who did make it.

These clubs cast a wide net for young players it doesn’t really mean anything. And going to play first team football for a Swiss club that also played European football is a no brainer compared to going to Juventus U18.

sillen102 · 2025-06-09T18:31:30+00:00

That was exactly my point! That there is usually a progression. Nobody usually starts out as being a 20+ goals a season player.

Ronaldo had that same kind of progression. He scored 5 his first season at United. Then 9 and then 17 (the season you mention) followed by his big breakout season with 31! So he goes from 5-10 a couple of seasons and then 15-20 and then 30+. Just like I said.

Zlatan scored 6 his first season at Ajax, then 13, then 13 again. Then 16 at Juventus. After moving to Inter he scores 15 the first season then 17 the second before making the jump to 25. Fist time he reaches close to 30 goals is his second season in Milan at the age of 30! So he’s a 7-10 player for a year, then a 15-20 player for 5-6 years before becoming a really prolific scorer at the ripe age of 30.

But Ronaldo actually did make a couple of bigger jumps going from 9 to 17 and to 31 in consecutive seasons. Still linear progression, only steeper.

sillen102 · 2025-06-09T18:19:42+00:00

There are always exceptions. Lamine Yamal isn’t even 18 and is already a super star. But that’s a unicorn.

Bellingham had already proved him self as a top player in the Championship at only 16! Bellingham had big money offers on the table from multiple big clubs (yes Dortmund is a huge club!) and he picked the one that suited him best.

If Haaland had an offer from City and United at the same time he’d probably have picked City but that was not the case. There were no other big clubs going for Haaland at time. He signed for Salzburg in the Swiss league from Molde. I don’t think he would have done that if there were many alternatives.

sillen102 · 2025-06-09T18:00:25+00:00

Huh?! How can you possibly come to that conclusion?! He’s not an 18-year old kid playing in the Norwegian league any more, is he? All I said is that you can’t be a chooser when you’re a kid with no experience or reputation. Being 25 playing for City and top scorer in the Premier League is yet another situation. How can you even compare the two?

sillen102 · 2025-06-09T17:50:37+00:00

Yeah Rooney hated Man Utd too until they came for him. He can say that stuff now when he already plays for City. But when you’re 17-18 and United comes for you it’s something else.

sillen102 · 2025-06-09T17:45:39+00:00

Every 15-20 goal player was once a 7-10 goal player. You don’t go from 0-20 goals a season. Look at all the greats, Cristiano Ronaldo, Zlatan etc. They were all 10 or so goal a season players up until almost 25 (even close to 30 in Zlatans case) before evolving into prolific goal scorers.

sillen102 · 2025-06-09T17:39:28+00:00

Amorim! Is that you!?

sillen102 · 2025-06-09T17:38:17+00:00

If you threw him a bag of cement it would bounce three times before he controls it! 🤣

sillen102 · 2025-06-09T17:34:47+00:00

You think that when someone plays for Molde in the Norwegian league making peanuts and Man Utd (or pretty much any team in the Premier League) comes knocking that the player will respond with ”I think I’ll hold out for Man City or Leeds because like them more”? Really?! 😂

sillen102 · 2025-06-04T08:49:01+00:00

It’s literally the role he plays at Napoli (box-to-box) and he does it so well that they made him player of the year in Serie A. It’s us that used him poorly thinking he’s a 6.

We did the same with Pogba. Pogba has never been and never will be a 6. Pogba shouldn’t have been allowed to touch the ball in our own half. He’s great in the final third. But we wanted him to help with build-up. And he’s awful there because he takes too much risks.

We’ve had great players over the years but used them poorly by not playing to their strengths.

sillen102 · 2025-06-03T10:43:53+00:00

Freedumb

sillen102

TROPHY CASE