Panos MatsinopoulosSetting Up TimescaleDB on AWS
TimescaleDB is a PostgreSQL extension for high-performance real-time analytics on time-series and event data. It is basically a custom Postgres. Important: This post uses Terraform to create and destroy resources on an AWS account. Make sure that you destroy the resources as soon and as long as you don’t need them any more. Otherwise, you will be charged more than you might want.How do you set up a TimescaleDB on AWS?Unfortunately, you can’t use, at the time of this writing (Jul 2025), the ma...
Panos MatsinopoulosQuerying a Daily Stats Table - Postgres
Hero Image by Panos Matsinopoulos on ZoraThe TableI have a table named daily_stats, which keeps track of some daily metrics. Here it is:Example rows from table \`daily_stats\`The structure of the table:-- CREATE TABLE "daily_stats" ---------------------------------- CREATE TABLE "public"."daily_stats" ( "id" BigInt DEFAULT nextval('daily_stats_id_seq'::regclass) NOT NULL, "metric" Character Varying NOT NULL, "date" Date NOT NULL, "count" BigInt DEFAULT 0 NOT NULL, "lock_version" BigInt DEFAUL...
Panos MatsinopoulosGas Optimization - Yul/Assembly
Cover Image by DESPOINA MATSINOPOULOU from PixabayIntroductionRecently, I followed the Advanced Solidity Bootcamp organized by Encode Club and delivered by Extropy. Among the things we learnt, it was about gas optimization. The two many areas we touched in gas optimization were:Storage optimizationConverting Solidity to Yul/Assembly.Then I decided to apply this knowledge to one Talent Protocol production smart contract. The TalentCommunitySale.sol published in this repository here. https://gi...
Humble Software Reader, Writer and DevOps Builder, with love for Classical Music.
Panos MatsinopoulosSetting Up TimescaleDB on AWS
TimescaleDB is a PostgreSQL extension for high-performance real-time analytics on time-series and event data. It is basically a custom Postgres. Important: This post uses Terraform to create and destroy resources on an AWS account. Make sure that you destroy the resources as soon and as long as you don’t need them any more. Otherwise, you will be charged more than you might want.How do you set up a TimescaleDB on AWS?Unfortunately, you can’t use, at the time of this writing (Jul 2025), the ma...
Panos MatsinopoulosQuerying a Daily Stats Table - Postgres
Hero Image by Panos Matsinopoulos on ZoraThe TableI have a table named daily_stats, which keeps track of some daily metrics. Here it is:Example rows from table \`daily_stats\`The structure of the table:-- CREATE TABLE "daily_stats" ---------------------------------- CREATE TABLE "public"."daily_stats" ( "id" BigInt DEFAULT nextval('daily_stats_id_seq'::regclass) NOT NULL, "metric" Character Varying NOT NULL, "date" Date NOT NULL, "count" BigInt DEFAULT 0 NOT NULL, "lock_version" BigInt DEFAUL...
Panos MatsinopoulosGas Optimization - Yul/Assembly
Cover Image by DESPOINA MATSINOPOULOU from PixabayIntroductionRecently, I followed the Advanced Solidity Bootcamp organized by Encode Club and delivered by Extropy. Among the things we learnt, it was about gas optimization. The two many areas we touched in gas optimization were:Storage optimizationConverting Solidity to Yul/Assembly.Then I decided to apply this knowledge to one Talent Protocol production smart contract. The TalentCommunitySale.sol published in this repository here. https://gi...
Humble Software Reader, Writer and DevOps Builder, with love for Classical Music.
Subscribe to Panos Matsinopoulos
Subscribe to Panos Matsinopoulos
Share Dialog
Share Dialog
<100 subscribers
<100 subscribers
Yes, I liked it very much!
Yes, I recommend it to all founders of startups, especially those who target developers.
It will help you build numerous TODO lists. They constitute a good action plan for your startup to succeed.
So, it is very practical.
But I found it useful to other types of startups too.
Moreover, when I read such books I pick up lessons to apply to both my personal and professional life, because I like to read and abstract. And I like to generalize and find applications of what I read to other aspects of life too.
And this book had a lot of lessons for me to learn.
Also, it had a different perspective on things, perspective that I didn’t expect one could have.
No Spoiler: I will not reveal the secrets of the book. It’s not fair to the book author.
Affiliate link: This is where you can buy the book from.
About what Entrepreneurship and Startup is.
How developers are different. This means they have to be approached and treated differently, in a special way. The author is explaining in low-level details and with an action plan on how to do it. It tells you which is the wrong and which is the correct approach.
Be the trusted authority, the subject-matter expert. And show that you are.
What is a TAB, Technical Advisory Board and how it can help you focus the right problem searching for the right solution. The book will teach you how to set up a TAB. From recruiting to management.
Very nice chapters on how to build a story and how a story is boring without a villain. Book comes with a lot of example on good and bad stories.
The importance of evidence. Book is suggesting what kind of evidence you should build upon. What to avoid and what to pursue.
What should be your focus when you approach devs. Is it the problem, the solution, their pain?
Mistake, mistakes and mistakes. Books comes with lots of acts and actions you need to avoid. They are mistakes. But they are common.
And when the story is ready, then you have to build your presence. A lot of advises on how you should do it effectively and in way that will build trust. And it’s not only the Web site presence.
What about content creation? Should you write blog posts? Should you write books?
Take advantage of your users and customers. In a good way of course. Book will tell you how. What about the old-school social proof?
Book gives useful advises on how you should package your product. How to price it? When to price it?
Build feedback loop.
The importance of a well-designed (in terms of information and easy of read) Web Site. It deserves its own chapter. Book has it.
Developers need to adopt your product. But this deserves a pipeline.
Do you need a Marketing Team? Book will tell you how to set this up and when. Who to hire and in what order.
Special advises come from the book for those startups what are looking for funding.
gm!
I am Panos M., humble, backend software reader and writer at Talent Protocol.
Yes, I liked it very much!
Yes, I recommend it to all founders of startups, especially those who target developers.
It will help you build numerous TODO lists. They constitute a good action plan for your startup to succeed.
So, it is very practical.
But I found it useful to other types of startups too.
Moreover, when I read such books I pick up lessons to apply to both my personal and professional life, because I like to read and abstract. And I like to generalize and find applications of what I read to other aspects of life too.
And this book had a lot of lessons for me to learn.
Also, it had a different perspective on things, perspective that I didn’t expect one could have.
No Spoiler: I will not reveal the secrets of the book. It’s not fair to the book author.
Affiliate link: This is where you can buy the book from.
About what Entrepreneurship and Startup is.
How developers are different. This means they have to be approached and treated differently, in a special way. The author is explaining in low-level details and with an action plan on how to do it. It tells you which is the wrong and which is the correct approach.
Be the trusted authority, the subject-matter expert. And show that you are.
What is a TAB, Technical Advisory Board and how it can help you focus the right problem searching for the right solution. The book will teach you how to set up a TAB. From recruiting to management.
Very nice chapters on how to build a story and how a story is boring without a villain. Book comes with a lot of example on good and bad stories.
The importance of evidence. Book is suggesting what kind of evidence you should build upon. What to avoid and what to pursue.
What should be your focus when you approach devs. Is it the problem, the solution, their pain?
Mistake, mistakes and mistakes. Books comes with lots of acts and actions you need to avoid. They are mistakes. But they are common.
And when the story is ready, then you have to build your presence. A lot of advises on how you should do it effectively and in way that will build trust. And it’s not only the Web site presence.
What about content creation? Should you write blog posts? Should you write books?
Take advantage of your users and customers. In a good way of course. Book will tell you how. What about the old-school social proof?
Book gives useful advises on how you should package your product. How to price it? When to price it?
Build feedback loop.
The importance of a well-designed (in terms of information and easy of read) Web Site. It deserves its own chapter. Book has it.
Developers need to adopt your product. But this deserves a pipeline.
Do you need a Marketing Team? Book will tell you how to set this up and when. Who to hire and in what order.
Special advises come from the book for those startups what are looking for funding.
gm!
I am Panos M., humble, backend software reader and writer at Talent Protocol.
No activity yet