Panos

@panosm

19 Following

667 Followers

Panos pfp

Here is how I set up TimescaleDB on AWS. https://mirror.xyz/panagiotismatsinopoulos.eth/09nsCECzMgVCZk0jcFZbs3DIeTQD7rH6W0IvHzaCsS4

0 reply

0 recast

0 reaction

Panos pfp

I minted an amazing POAP! /poap

0 reply

0 recast

2 reactions

Filipe Macedo pfp

just built a tennis league app in the 5min break between games 🎾 what a time to be alive

21 replies

16 recasts

163 reactions

Panos pfp

I just got my AWS SysOps Administrator - Associate certification. https://www.credly.com/badges/6859e471-7f8d-454d-b3eb-051fbd6408cc/public_url

0 reply

0 recast

1 reaction

Talent Protocol pfp

Talent Protocol

24 ETH distributed to the @base.base.eth builders so far. Keep building like you always do. We'll find you and reward you. 🫡

7 replies

6 recasts

64 reactions

Panos pfp

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

0 reply

0 recast

0 reaction

juampi 🫡 pfp

We’re about to launch a new product built for onchain creators. If you’re creating content and want more spotlight, and earn some juicy rewards, just DM me to join the early access. All feedback is welcome.

0 reply

3 recasts

11 reactions

Panos pfp

I just received this NFT for taking part in the Encode Club zkML Bootcamp Q1 2025 with @encodeclub. https://opensea.io/assets/matic/0xdBf2138593aeC61d55d86E80b8ed86D7b9ba51F5/14414

0 reply

0 recast

1 reaction

Simão pfp

Long-term, it will power: • Builder discovery for DevRels and Ecosystem Leads • Reputation-based rewards powered by https://base.builderscore.xyz • Overall Ecosystem intelligence

1 reply

1 recast

2 reactions

Talent Protocol pfp

Talent Protocol

With Farcaster now supporting @celo, it’s time to ship and get rewarded. 10,000 $CELO for the most active builders this May: • Build Farcaster mini-apps • Deploy verified smart contracts • Contribute to public crypto repos on GitHub Start earning 👇🧵

11 replies

43 recasts

175 reactions

Panos pfp

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. https://mirror.xyz/dashboard/edit/CxkN4TvWZBXmbUf7repP3LZMTXcaaVLtNwLNpKVxtik

0 reply

0 recast

0 reaction

Panos pfp

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. https://mirror.xyz/panagiotismatsinopoulos.eth/a9EF5oBgSI2yZK1ljoKwkBqwNz5QZ39TEcILGll7K9A

0 reply

1 recast

1 reaction

Talent Protocol pfp

Talent Protocol

It takes 3 simple steps to start earning @base.base.eth Builder Rewards: - Basename - Builder Score ≥ 40 - Human Checkmark Get started with a step-by-step tutorial 👇

6 replies

9 recasts

41 reactions

Talent Protocol pfp

Talent Protocol

We just hit 10M builder accounts indexed in our reputation system! To mark this milestone, @pcbo went bald. some alpha inside 👨‍🦲👀

1 reply

9 recasts

33 reactions

Panos pfp

My latest book review: "The Developer Facing Startup - by Adam Frankl" https://mirror.xyz/panagiotismatsinopoulos.eth/_32zBap20nIVicrx4wdMqZIXeus5K536PPpZtDmcUc4

0 reply

0 recast

0 reaction

Filipe Macedo pfp

AMA: drop your questions about Builder Score V2 below. Best one wins 1,000 $TALENT. We’re rolling out V2 access to all builders with Score ≥ 75, starting today. I'll be answering all questions live on Monday, 5 PM UTC 🫡 @bountybot

20 replies

8 recasts

35 reactions

Panos pfp

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!

1 reply

0 recast

5 reactions

Panos pfp

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. I used Point in Time API (which also incorporates the parameters "size" and "search_after") to write a script that browses the whole set of documents in an index. P.S. At Talent Protocol we use AWS OpenSearch to empower our search API.

0 reply

1 recast

1 reaction

Panos pfp

Hi! I am officially reviewing the Manning book "Full-stack AI for Web Developers" which will be available in Fall 2025. I am really enjoying it. It is taking me to a long journey on integrating generative AI tools with Web applications. I am learning a lot. Here is the public page of the book: https://www.manning.com/books/full-stack-ai-for-web-developers P.S. At Talent Protocol we love books #WhatIsYourBuilderScore #LifeLongLearning

0 reply

0 recast

1 reaction

Talent Protocol pfp

Talent Protocol

With Builder Score V2, real builders go up, and fake builders go down. Top users can already try it out, share feedback, and earn $TALENT. Details 👇

4 replies

13 recasts

33 reactions