Post resum 2023

Kms patinats: 

- 612

Gadgets of the year (comprats o regalats):

- iphone15 pro

- carregador inalambric iniu

- un munt de cables usb-c

Samarretes de l’any:

- Easypromos

- Palorder

- Be Stack Overflow be with you

- Pixies

- Eres tan feria de Abril, Ojete Calor

- The last sofas

- Los pollos hermanos

- Heissenberg

- Morrisey is Murder

- Homer Simpson

- Where’s Jessica Hyde

Friky coses guays:

- osv.dev

- lands.php.earth

- https://laraveldaily.com/roadmap-learning-path

- manticoresearch

- Muvon/yoda

- libsql/sqld

- hyperf

- SingleStore

- laravel-grapes

- Wazuh

- Elastic Security

- Laravel Pennant

- airops

- endoflife.date

- https://proxify.io/worlds/php

- crontab.guru

- saloon

- tauri.app

- PixiJS

- Edge|DB

- SurrealDB

- fixie.ai

- Ballerina

- bref.sh

- SudoLang

- suphle

- databricks dolly2

- https://developer.fermyon.com/spin/index

- https://laravel-package-ocean.com/

- phind.com

- sanity.io

- croquet.io

- https://pxplang.org/

- https://8values.github.io/quiz.html

- vector.dev

- https://python.langchain.com/en/latest/index.html

- LaraDumps

- Jolt

- coolbackgrounds.io

- Anker Solix

- sonnen batteries

- AI.jsx

- amigalive.com

- weezevent.com

- HTMX https://www.sitepoint.com/htmx-introduction/

- qwick.builder.io

- https://it-tools.tech/

- herd.laravel.com

- nativephp.com

- tldraw.com

- https://falconwatertech.com/

- idx.dev

- caddyserver.com

- nue.js

- Kamal

- signoz.io

- codewithrockstar.com

- wg/wrk

- rpgjs.dev

- appwrite.io

- https://resonance.distantmagic.com

- https://radapp.io/

- lychee.cli.rs

- turbineui.com

- vapor.codes

- frankenphp.dev

- PHP2JS

- QuickRequest

- Octoparse

- Fedora Asahi Remix

- dragonflydb.io

- idb-keyval

Jocs als que m'he viciat aquest any:

- Quake 2 remastered

- Warcraft Rumble

- Suika game

Grups guays que he descobert aquest any:

- Launder

- Alexanderplatz

- Muro María

- Fotos de la novia

- Bark Psychosis

- The honey buzzards

- Diavol Strain

- Minami Deutsch

- Moon Duo

- Singapore Sling

- CFM

- Acid dad

- Ringo Deathstarr

- Junip

- Sloan

- Davila 666

- The Sandwitches

- shego

- The Limiñanas

- BRONCHO

- Lucille Dupin

- Smashing Orange

- Blushing

- Píldora letal

- The Beths

- The Jaws of Brooklyn

- La Culpa

- Pencil Legs

- Dead Sullivan

- Foxes in Fiction

- Modern Baseball

Concerts:

- Sr. Chinarro, sala Wolf

- Los Punsetes + Grushenka, Salamandra

- Pixies, Sant Jordi Club

- Los Toreros Muertos, Sarau

- Ojete Calor, Sant Jordi Club

- El último vecino + Fotos de la novia, Upload

- Pantocrator, Jardins de la Sedeta

- Triàngulo de amor bizarro, Apolo

- Triàngulo de amor bizarro, Zero Tarragona

- Biznaga + Los Yolos + Enemic Interior, RAZZ2

i al Primavera:

Dimarts:

- La Paloma + Just Mustard + Far Caspian a l’Apolo 2

Dijous:

- Heather

- Terno Rei

- Alex G

- Turnstile

- OFF!

- New Order

- Le Tigre

Divendres:

- Niña Coyote eta Chico Tornado

- Bala

- Los Hacheros

- The wedding present

- Depeche Mode

- Bad Religion

- Lebanon Hanover

Dissabte:

- Grupo de expertos sol y nieve

- My morning jacket

- The Voidz

- The war on drugs

- Liturgy

- Maneskin

I al Cruïlla, Divendres:

- Menta

- Ciudad Jara

- Sexy Zebras

- Calavento

- Pinpilimpusssies

- Carolina Durante

- Franz Ferdinand

- Sexy Zebras

- The Offspring

- Ladilla Rusa

Pelis:

- Más allá de los dos minutos infinitos, filmin

- Topgun Maverick, amazon

- The Batman, HBO

- White noise, Netflix

- Willow, Disney+

- Decision to leave, cine

- Wonder Woman 1984, hbo

- Everything Everywhere At all once, cine

- John Wick 4, cine

- Dungeons and Dragons, Honor among thiefs, cine

- Evil Dead Rise, cine

- Licorice Pizza, Amazon Prime

- What lies below, Amazon Prime

- Ant-man and Wasp Quantum-mania, Disney+

- Spider-man Across the Spiderverse, cine

- Too big to fail, HBO

- Matrix resurrections, HBO

- Oppenheimer, cine

- Babylon, Amazon Prime

- Avatar, the way of water, Disney+

- Flamin Hot, la historia de los Doritos picantes, Disney+

- Broker, Filmin

- Kids, Filmin

- The Flash, HBO

- Tokyo Revengers

- Turbo Kid

- Benny loves you

- Awareness

- Jojo rabbit

- The good the bad and the weird

- Escape from Mogadicio

- Zombieland

- The first purgue

- Mad Heidi, Amazon Prime

- Otra ronda, filmin

- Venus, Amazon Prime

- Indiana Jones y el dial del destino, Disney+

- The Northman, Amazon Prime

I a les nits de cinema de Vic:

- Duelo del Dragón y el Tigre (1980)

- Next Sohee

- Baby Assasins 2 - Two babies

- KBKJ

- Ninja vs Shark

- Restart the earth

- Mutant Ghost Wargirl

- The great arms robbery

I a Sitges:

Dijous 5

8:30 - Tokyo Revengers 2 - Part 1 - 6.5

10:00 - Tokyo Revengers 2 - Part 2 - 6.5

12:00 - Project Silence - 7.5

14:45 - Suitable Flesh - 4

17:00 - Blackout - 2

19:15 - Let it Ghost - 6

Divendres 6

8:30 - Onyx the Fortuitous and the talisman of souls - 7.5

11:00 - Last Straw - 5.5

13:15 - Los Ojos de la Noche - 7Dissabte 7

10:45 - Apéndice - 6

12:45 - Sleep - 6.5

20:00 - Propriedade - 7

22:15 - Vive Dentro - 6

Diumenge 8

8:30 - The Sacrifice Game - 7

10:30 - There’s Something in the Barn - 7.5

12:30 - Acción mutante - 7

16:00 - Brooklyn 45 - 7.5

22:00 - El Chico y la Garza - 7.5

00:45 - Wake Up - 7.5

Dilluns 9

8:30 - El Exorcismo de Eastfield - 6

10:45 - You’ll Never Find Me - 7

13:00 - Robot Dreams - 5

20:00 - Diabolik - Ginko All’Attacco - 6

22:30 - Vincent Debe Morir - 8

01:00 - Late Night With the Devil - 8

Dimarts 10

8:30 - Hood Witch - 7

11:30 - Sand Land - 8

13:30 - Tiger Stripes - 4.5

Dimecres 11

10:45 - Nina Dei Lupi - 6

Dijous 12

17:30 - The Primevals - 5

19:45 - Smugglers - 8

22:15 - Pobres Criaturas - 9.5

Divendres 13

10:30 - Superposition - 5.5

12:45 - Where the Wind Blows - 3.5

15:45 - Rabia - 4

17:45 - Juego Prohibido - 5.5

20:15 - Concrete Utopia - 7.5

23:00 - Vermin: La Plaga - 7.5

Dissabte 14

08:45 - Riddle of Fire - 6.5

11:15 - Sorcery - 5

13:30 - Jericho Ridge - 7.5

22:30 - Lumberjack The Monster - 6.5

01:00 - We are Zombies - 7.5

Sitges Top 11:

Pobres Criaturas - 9.5

Smugglers - 8

Sand Land - 8

Vincent Debe Morir - 8

Late Night With the Devil - 8

Onyx the Fortuitous and the talisman of souls - 7.5

Project Silence - 7.5

We are Zombies - 7.5

Jericho Ridge - 7.5

Concrete Utopia - 7.5

Vermin: La Plaga - 7.5

Sitges Bottom 11:

Blackout - 2

Where the Wind Blows - 3.5

Rabia - 4

Suitable Flesh - 4

Tiger Stripes - 4.5

Sorcery - 5

The Primevals - 5

Robot Dreams - 5

Juego Prohibido - 5.5

Last Straw - 5.5

Superposition - 5.5

Series:

- The Crown s5, s6, netflix

- Apagón s1, movistar+

- Shadow and bone, netflix

- Esterno notte, filmin

- Three-Body, youtube

- Willow, disney+

- Northern Exposure, filmin

- The Last of Us, HBO

- The Consultant, Amazon prime

- Swarm, Amazon prime

- The office (BBC), Filmin

- Attack on Titan, s1, s2, s3, s4, special1, Amazon Prime

- Invincible, Atom Eve, Amazon Prime

- From, HBO s1, s2

- Invasion, AppleTV+ s1, s2

- Winning time, la dinastía de los Lakers, HBO, s2

- El cuerpo en llamas, Netflix

- GenV, Amazon Prime

- El peor de los males, Disney+

- Utopia (US), Amazon Prime

- El otro lado, Movistar+

- Poquita fé, Movistar+

Llibres:

- The pragmatic programmer

- Boom and bust, a Global history of financial bubbles

- The Haçienda, cómo no dirigir un club, Peter Hook

- Fingers crossed, Miki Berenyi

- Macro Festivales, Nando Cruz

- La fábrica de cretinos digitales, Michael Desmurget

Comics:

- El mercenario, V. Segrelles

- Querida Becky, Garth Ennis

- Crossed vol1, Garth Ennis

- Guardianes de la galaxia 3, El vórtice negro

- Ironman, demon in the bottle

- Hellboy vol1

- Crossed vol2, vol3, vol4

- Atac als titans vol1

- Molts a Marvel Unlimited

Teatre:

- Las Ruinas, Blas Infante

- Berto Romero, Lo nunca visto, Coliseum

- Faemino y Cansado, 17 veces reloaded

Documentals:

- Good night Oppy

- Todo y nada: Ciencia asombrosa de espacio vacío

- Arny, historia de una infámia (HBO)

- La gran distracció, TV3

- Cowspiracy

- Girl Gang: El preu de ser influencer, TV3

- Taxme if you can, filmin

- Carl Icahn, el millonario incansable, HBO

- Becoming Warren Buffet, HBO

- Icónica Chamorro, rtve play

- Eduard Punset, la urgencia del tiempo, rtve play

- La gran estafa de los teleoperadores, HBO

- Las cintas de Rosa Peral, Netflix

- El curioso caso de Natalia Grace

- Generació Porno, 3cat

- Surviving Utoya, 3cat

- La industria de lligar, 3cat

- No me llames Ternera, Netflix

- Running with the Devil: The Wild World of John McAfee, Netflix

- Fantastic Machine, Filmin

- Plastic Disasters, HBO

- Los años de la transición, HBO

- Nuñez, 3cat

Podcasts:

- Nadie sabe nada

- Quieto todo el mundo

Hotels als que he anat:

Cid, Sitges

Estació del Nord, Vic

Casa Boumort

Lauria, Tarragona

Ultonia, Girona

Restaurants:

- Can Recasens

- San Kil

- Little Korea

- Shangai Stories

- Da Emanuele

- Dolsotbap

- La Forquilla

- Els Pescadors

- Pocha

- Os familia

- Shifu ramen

- Casa Lupe

- La barraca del Delta

- El racó del port

- Puerto Escondido

- Can Calopa

- L’Aliança d’Artés

- El Raier

Sortides al Extranjer:

Desert

Curts:

Desert

Exits:

Desert

How to change the internal links of all the posts in wordpress

 When you change the url pattern of a Wordpress installation some internal links can still be pointing to the old pattern of urls.

To mitigate this problem you can use a plugin like redirection in order to redirect old pattern urls to the new ones. With this solution you can solve the problem of internal links and of external links too (that you don't have control).

However, it's recommended to change all the internal links inside your content to avoid innecessary redirections.

For this reason we've created a procedure to update the content of all the posts, looking for urls that already are redirected and replacing them for the new ones.

IMPORTANT: This procedure assume that you have already installed and configured the redirection plugin and you have good knowledge of Linux commands and MySQL.

The procedure is as follows:

- Dump the wp_posts table using mysqldump

- Backup this dump just in case

- Launch a query to get all the replacement commands

- Launch replacement commands to replace all the strings in the dump

- Upload the modified dump into mysql

1) Dump the wp_posts table to a file

mysqldump -u <user> -p<password> -h <host> <db> wp_posts > wp_posts.sql

2) Make a backup of the file, just in case...

cp wp_posts.sql wp_posts.bk.sql

3) Then launch this select using your favorite MySQL client or PHPMyAdmin.

The idea of the sql query is to get all the redirection redirects that are enabled in the Wordpress database (table wp_redirection_items) and generate a Linux command (sed) that substitute all the urls in the content from the original ones to the new ones.

select 
concat("sed -i 's/"
,replace(url,'/','\\/'),"/"
,replace(action_data,'/','\\/'),"/g' wp_posts.sql") cmd
from (
	select substr(url,1,length(url)-1) url
	, if(substr(action_data,length(action_data))='/', substr(action_data,1,length(action_data)-1), action_data) action_data
	, action_type, status, action_code
	, url original_url, action_data original_action_data
	from wp_redirection_items
	where url like '%/'
	union all
	select url
	, if(substr(action_data,length(action_data))='/', substr(action_data,1,length(action_data)-1), action_data) action_data
	, action_type, status, action_code
	, url original_url, action_data original_action_data
	from wp_redirection_items
	where url not like '%/'
) t 
where status='enabled'
and action_type='url'
and action_code=301
group by cmd;

A sample line that are returned by the sql query above is:

sed -i 's/\/blog\/2013\/03\/prepare-your-promotions-xxx/\/blog\/prepare-your-promotions-xxx/g' wp_posts.sql

4) Then execute all the lines in your Linux box it will replace all the urls that match /blog/2013/03/prepare-your-promotions-xxx by /blog\/prepare-your-promotions-xxx
because in my case I've changed the url pattern to avoid the date in the url.

Copy the results of all the lines into your Linux box in the same folder where you have generated the backup of the table wp_posts 
(you must have the utility sed installed (available in 99% of Linux installations)).

5) Upload the dump again

mysql -u <user> -p<password> -h <host> <db> < wp_posts.sql

Hope this help you.

Adding percentages to labels in amcharts5

 Amcharts5 is a very powerful graphics library, however the documentation is really scarce.

If you want to add the percentage of a value in some label you must use the undocumented valuePercentTotal attribute in the desired text label, for example.

legendValueText: "[bold {fill}]{value} {valuePercentTotal.formatNumber('0.00p')}[/]"

Generates a label like this:

This value can be used in different labels and can be formatted as the other attributes like "value".

Hope this helps

 

Post resum 2022

Com cada any deixo aquí un resum del meu any 2022 sense editar molt. Un any marcat pel meu canvi  de feina d'Omatech (després de gairebé 16 anys) cap a Easypromos, on em sento molt ben acollit.

Kilòmetres patinats: 238, cal millorar!

Exits:

- Adsmurai x15

Gadgets of the year (comprats o regalats):

- LG Gram

- Airpods Pro Max

- Navalla suïssa

Samarretes del any:

DESERT

Friky coses guays:

- n8n.io

- parceljs

- mermaid

- sidecar

- browsershot

- lando.dev

- bitsy

- Xata

- Redox

- Stackblitz

- loom

- matomo

- facebook/lexical

- redpanda

- mattermost

- loadforge

- filamentphp

- bun.sh

- zig

- orchid

- remix

- prisma.io

- sveltekit

- baserow.io

- plausible.io

- fresh.deno.dev

- railway.app

- astro

- openai and Dall-e

- simplemvc

- squirephp https://github.com/squirephp/squire

- sushi php

- https://laravel.initializer.dev/

- ponylang.io

- https://github.com/JuliaLang/julia

- VemtoApp

- jsoncrack

- qwick.builder.io

- NocoDB

- FrankenPHP

- glitch.com

- locust.io

- https://whatthediff.ai

- https://turbo.build/

- rectorphp

- twill

- bref.sh

- spiral.dev

- ulid https://github.com/ulid/spec

- Mitosis

- sulu.io

- alpine.js

- blitz.js

- synthesia

- Nanocrazor

Jocs als que m'he viciat aquest any:

- PUBG New State

- Plants vs zombies 2

- Tetris99

- Katamari

Grups guays que he descobert aquest any:

- Desenterradas

- Dry Cleaning

- Grasias

- Dan Romer

- Clise to Modern

- Robot Emilio

- Ovlov

- Big Thief

- Dexist

- Wet Leg

- Pillow Queens

- Nation of Language

- Yawners

- Ezekiel

- Mitski

- Just Mustard

- Portico quartet

- Lund quartet

- Whatever, Dad

- Cuchillas

- Radiator Hospital

- Secundaria

- High Vis

- Policias y Ladrones

- Videoclub

- El diablo de Shangai

- Indian Summer

- Porridge Radio

- La Paloma

- Childbirth

Concerts als que he anat:

- Ojete Calor al Sant Jordi Club

- Los Punsetes + Marcelo Criminal a l’Apolo

- Just Mustard + Calibra al Sidecar

- Menta + El Diablo de Shangai a la sala VOL.

- The Cure al Palau Sant Jordi

- McEnroe + El verbo odiado a l’Apolo2

Pelis que he vist:

- Spiderman no way home

- La mano de Dios

- Don’t look up

- While we’re young 

- Marriage Story

- Attack the block

- Sputnik

- Ad Astra

- O que arde

- Gone Girl

- The French Dispatch

- The Adam Project

- Driven

- El método Williams

- All eyes off me

- Déjame caer

- Los Cronocrimenes

- Monster

- Lizzie

- Tourists

- Utoya

- Dr. Strange en el multiverso de la locura

- Moonfall

- Eternals

- Iron Sky

- Heat

- Peninsula

- Dredd

- Oranges Sanguines

- Apnee

- Prey

- Day shift

- To your last death

- Incendies

- El reino de la belleza

- Softie

- Yo, Cristina F

- Satan’s Slave

- Blonde

- X

- Sissy

- Deep Water

- Host

- Planeta rojo

- As Bestas

- Barbarian

- Captive State

- Troll

- Mantícora

- Your Lost Memories

Series a les que m’he enganxat:

- The book of Bobba Fett

- Curb your enthusiasm s4, s5, s6, s7, s8, s9, s10, s11

- Celebrity Bake Off España

- Station Eleven

- Curb your entusiashm

- All of us are dead

- Peacemaker

- Euphoria s2

- Mai neva a ciutat s1, s2, s3

- The Dropout

- Winning time

- The Boys s3

- Locomia

- Crims s1, s2, s3

- Love, Death + Robots s1, s2

- Maricon perdido

- Stranger Things s4

- Children of Dune

- Narco Saints

- Dahmer

- La liga de los hombres extraordinarios

- Antidisturbios

- The Bear

- Autodefensa s1, s2

Curts:

- Cerdita

Llibres que he llegit:

- Conversaciones con Ana Curra

- Domain Driven Design in PHP

- Radical Candor

- Astrofísica para gente con prisas

- From zero to sold

Comics:

- Dinastia de X / Potencias de X

- Dawn of X

- Hierba

- The Hellfire gala

- X lives of Wolverine / X deaths of Wolverine

- The trial of Magneto

- Destiny of X

- La patrulla X y los Nuevos titanes

- X-Factor

- DUNE I

- I molts més amb Marvel Unlimited

Teatre:

- Faemino y Cansado. Quien tuvo, retuvo

Documentals:

- Autosuficientes

- Warning: This drug may kill you

- 4 hours at the Capitol

- Devastados por el cristal

- Arcadeology

- Almost Ghosts

- Jimmy Savile, a British Horror Story

- The push

- Tell me who I am

- Natalie Wood, entre bambalinas

- Val

- Jane Fonda en cinco actos

- We were once Kids

- The John Wayne Gacy Tapes

- Los Anarquistas

- Keep sweet pray and obey

- Wall Street: David contra Goliat

- Swiped

- Orgasm Inc.

- Ummo, La España alienígena

- Entre la terra i el cel: Guerra

- Criptomonedas: guía para principiantes

- La Sagrada Família

- Osel

- Salvar al Rey

Podcasts:

- itnig

- X-Rey s1, s2

- Le llamaban Padre

Sortides al Extranjer:

DESERT

Hotels als que he anat:

- Granados 83

- Hotel Petit Mirador

- Ultonia, Girona

Restaurants:

- Ikoya

- Kanada Ya

- La Nansa, Sitges

- Els pescadors

- Lluerna, Santa Coloma

- La barraca del Delta, Amposta

- El Racó del Port, Les cases d’Alcanar

- Draps, Girona

Sitges 2022:

38 pelis, 800kms, 16 peatges

Pelis vistes:

Dijous 6:

- Hunt

- King of screen

- The breach

- Blood flower

- Carnifex

- Deep fear

Divendres 7:

- Polaris

- After Yang

- Satan’s Slave Communion

- [REC] Terror sin pausa

- Flesheater

Dissabte 8:

- Kids vs Aliens

- Saloum

- Mal de ojo

- Flux gourmet

- The Lair

Diumenge 9:

- Tales from the Occult

- Resurrection

Dilluns 10:

- Family Dinner

- Rubikon

- Occhiali neri

Dimarts 11:

- Megalomaniac

- Slash back

- Incroyable mais vrai

- Emergency declaration

- The Knocking

- Christmas bloody Christmas

Dimecres 12:

- Shepherd

- Fumer fait tousser

Dijous 13:

- Glorious

- Social Distancing

- Pearl

Divendres 14:

- Harbinger

- Viejos

Dissabte 15:

- Wolfkin

- La exorcista

- Sisu

- Alienoid

Ranking millors pelis (de millor a pitjor):

- Sisu

- Fumer fait tousser

- Pearl

- Glorious

- Incroyable mais vrai

- Satan’s Slave Communion

- Resurrection

- Mal de ojo

- Megalomaniac

- Deep Fear

- (menció especial al documental de [REC])

Ranking pitjors pelis (de pitjor a… bé):

- Occhiali neri

- Social Distancing

- Tales from the Occult

- Carnifex

- Polaris

Grups vistos al Primavera Sound 2022:

Dijous:

Aiko el grupo - 18:15 - Ouigo

Les Savy Fav - 18:55 - Binance

Richard Dawson - 19:05 - Plenitude

Dinosaur Jr. - 20:00 - Cupra

Sharon Van Etten - 21:05 - Binance

Yo la tengo - 22:20 - Cupra

Tame Impala - 22:55 - Estrella Damm

Pavement - 00:40 - Pull & Bear

Divendres:

Pinpilinpussies - 16:30 - Ouigo

Cariño - 17:15 - Binance

Beach Bunny - 18:00 - Cupra

Manel - 19:00 - Pull & Bear

Fontaines DC - 20:05 - Estrella Damm

Shellac - 20:50 - Plenitude

Beck - 21:20 - Pull & Bear

Parquet Tours - 22:35 - Plenitude

Jehnny Beth - 23:30 - Ouigo

Dissabte:

Die Katapult - 18:45 - Tous

Automatic - 19:55 - Ouigo

Black Country New Road - 20:40 - Binance

Nick Cave and the bad seeds - 22:00 - Pull & Bear

Bauhaus - 22:55 - Binance

Gorillaz - 00:15 - Estrella Damm

Que tingueu un molt bon any 2023!

Agustí