iurisilvio's comments

iurisilvio | 2 years ago | on: My notes on Gitlab's Postgres schema design (2022)

Migrating primary keys from int to bigint is feasible. Requires some preparation and custom code, but zero downtime.

I'm managing a big migration following mostly this recipe, with a few tweaks: http://zemanta.github.io/2021/08/25/column-migration-from-in...

FKs, indexes and constraints in general make the process more difficult, but possible. The data migration took some hours in my case, but no need to be fast.

AFAIK GitLab has tooling to run tasks after upgrade to make it work anywhere in a version upgrade.

iurisilvio | 8 years ago | on: Ask HN: What production features have you built using AWS Lambda/Serverless?

To be honest, I have no idea. Maybe I'm even wrong about why it works.

I have a toy service with ~200k requests/day to a public service and I was blocked all the time.

After I changed to use API Gateway + Lambda as a proxy, never had these problems again. I just monitor the 4xx and 5xx errors and they are almost zero now.

iurisilvio | 8 years ago | on: Ask HN: Anyone making passive (or not passive) income from a content site?

I'm not willing to share my sites, but I have some content websites, one of them have ~2 million pageviews/month and is enough to pay my bills. The others are small, but they improve ~10% my result.

They are 99% passive income. All of them can be improved, but I don't do anything, I have full time job and other side projects. I feel bad for not working on them, but I know it is the right decision to me.

To be honest, it was started as a SEO experiment. I have bad content in good shape (all in-page SEO tricks done). I'm sure better content can improve my results.

iurisilvio | 8 years ago | on: Ask HN: How to get real SEO improvement?

Your content is targeting nobody. Who is your target? I guess it is people learning to code.

Build your content based on that. Change your headlines to something like "Learn how to build a Twitter Bot in node.js".

Setup Google Webmasters to understand what Google is doing. Actively send your sitemap to them (it is a manual input there).

I do this content SEO a lot. People say good content is king, but after 2 years I have some websites with a lot of pageviews and the only thing I did was poor content.

page 1