Panos (@panosm) on Farcaster

Panos

@panosm

Passionate builder, books reader and classical music lover.

Athens, Greece

19Following 417Followers

Rust journey part 1 ------------------------------ - I had to provide a fix for two public Rust repositories I forked so I could do my work at Talent. - Now it’s in production and works flawlessly. - Now, I want to learn more. - I’ve started reading Programming Rust, 2nd Edition. — I’m currently at 41%. - I’ve als...

github.com

GitHub - pmatsinopoulos/advent_of_code_2025

At Talent Protocol , I have been given the chance to work on a project that involved Rust. Oct 17th 2025: It was my first Rust project production deployment. Enjoying it so far!

panosm

3mo

Hi! Me from @talent again....having another 🕺 🎉 💪 moment! I wanted to share with you my latest achievement at @talent. I have told you that we build great things here. ********* Ethereum L1 and L2 nodes! ****************** Ethereum, Base, Celo and their corresponding Testnets. I have just finished setting th...

panosm

5mo

On Zora, I am posting pictures of beautiful places I visit. One of the most beautiful places in the world is Meteora, in Greece. Here is a short collection of photos from my last visit to Meteora.

panosm

6mo

Here is how I set up TimescaleDB on AWS.

mirror.xyz

Setting Up TimescaleDB on AWS

panosm

6mo

I minted an amazing POAP! /poap

collectors.poap.xyz

POAP #7390427 | POAP Collectors

panosm

6mo

I just got my AWS SysOps Administrator - Associate certification.

credly.com

AWS Certified SysOps Administrator – Associate was issued by Amazon Web Services Training and Certification to Panagiotis Matsinopoulos.

panosm

6mo

This weekend, I will be at Web3 Summit in Athens/Greece. web3-summit.com Send me a message if you want us to meet and chat about ... anything!

web3-summit.com

Web 3 Summit is coming to Athens

panosm

7mo

I just received this NFT for taking part in the Encode Club zkML Bootcamp Q1 2025 with @encodeclub.

opensea.io

Encode Certificate #14414 - Encode Club | OpenSea

panosm

8mo

At @talent we use Postgres. In my new blog post, I explain how I query a "daily_stats" table. - "with" and "CTE" - "window functions" - "lateral" sub-queries - "generate_series" Many things to learn or refresh your memory about.

mirror.xyz

Write - Dashboard – Mirror

panosm

9mo

At @talent we use Ruby on Rails and Postgres. I am writing about a technique we use to link each SQL query with the location in the application source code that generated this SQL query. It is very useful for troubleshooting slow SQL queries.

mirror.xyz

SQL Query Annotation

panosm

10mo

My latest book review: "The Developer Facing Startup - by Adam Frankl"

mirror.xyz

[book review] The Developer Facing Startup, by Adam Frankl

panosm

10mo

Yesterday I did a very cool thing. I managed to call a Talent Protocol ( @talentent ) REST API endpoint, first via a Google Sheet and then via Looker Studio. P.S. Working at @talent is always very exciting!

panosm

10mo

Today, I implemented Point in Time pagination to access our OpenSearch database page-by-page. OpenSearch offers 4 ways to browse search results in pages: - The Scroll API - The "from" and "size" parameters - The "search_after" parameter - The Point in Time API Each one is supposed to be targeting a specific use case...