Any personal favourites that are not so linear that you would like to suggest?

Its early still. I guess some patience and effort is needed! The journey is home. :)

It’s the ActivityPub API (client to server) where clients supposed to interface with so that you could have one client, for all fedi. But turns out server implementations (Lemmy, mastodon etc) find it not so well designed or performant or adequate (or idk what else) so instead they implement their own client APIs, effectively making clients being specific to the server rather than interoperable (one client that could understand all servers). It’s reasonable though, it’s just … I thought… that this was already done and established… but well…

That feels it went seriously bad

He seems to be nearby, will post pictures after !

I’d take my kids there. Give them markers and crayons. Let them roam…

That’s a very inspiring idea. Thanks for that!

This captures exactly my inner feeling regarding the fact that no fedi servers implement the C2S api … (I just realised)

But really, this is very well done, thanks for sharing

yea my bad, it looks open source :D

Then maybe I got confused sorry. Somebody mentioned it and then the post was saying it’s a service I thought it wasn’t open. Will check it properly later. Shouldn’t have spoke so quickly I guess

However it does not look like it is open source.

Isn’t that a (implementation) detail beyond the point of uselessness though? The big point for me is there. To keep it with the metaphor, that tree is also quite a complex structure, yet still useless.

At a first level it certainly is an issue with PHP, but PHP was also designed by a human. That design comes with its own problems right? I guess what I said is just a generalisation of PEBKAC as all (mostly all) software is designed by some human. Fact that it’s a different chair may as well be considered not a PEBKAC ? Yes it’s philosophical or simply which perspective you choose to see.

Haven’t played with amphp/parallel but maybe worth a look to see how/if sockets are shared there.

Glad to hear it. All of it actually. Sounds you are content with it now.

Had to Google PEBKAC. Aren’t all problems like that?

Could this be of any help ? https://www.firsttimersonly.com/

Personally I was wondering the same too, so I thought to focus on libraries/projects that I already like or find the codebase exciting in some way. Haven’t done any major contribution though, with the little time I have available. So… i dont know if that is good advice or not, just something that makes sense to me.

However let me just bring into mind that we recently defederated from some Lemmy instances and for which reasons we did that (as beehaw I mean).

Friendica, I believe, federates their groups. You can see them from mastodon as a user. I guess in AP vocabulary they are an actor. You can post to the group from mastodon too.

Unique as in, only one left?

Also how’s the setup? You setup for example 5 max children in fpm and 5 persistent connections? Per server? So your overall connections to the db server will be 5x your server instances?

If you setup 5 fpm children and less connections, one child will eventually reuse from another, but only when the connection is free (does not do a query for another process or pdo does not consume a resultset). If it tries to do a query at that time it will have to wait and it will block. This is my understanding. Also how you do transactions with persistent connections?

This has evolved into such an interesting conversation.

You can check with is_resource maybe?

With the single process, you can cache queries in memory depending on how the data change for example and the frequency they have.

The manual https://www.php.net/manual/en/pdo.connections.php

Has some interesting notes and also

https://www.php.net/manual/en/function.pg-connect.php

Mentions a force_new kind of setting if you need. I think not PDO but the constant you might be able to pass.

Also SO has some stuff users say

https://stackoverflow.com/questions/3332074/what-are-the-disadvantages-of-using-persistent-connection-in-pdo

Personally, I don’t try to optimize so hard in PHP (5 to 10ms due to db connection). There is always an improvement on the way things work, like how the code works that would probably give you a magnitude of performance. Just saying!