One of the most useful queries in all of Postgres. Shows you how often indexes are used so you can trim the ones that don't matter. SELECT indexrelname, idx_scan FROM pg_stat_user_indexes WHERE schemaname = '{schema}' AND relname = '{table}';

If this tweet gets 1000 likes, I'm moving to Australia and becoming the nation's greatest breakdancer

Self-employment was never about freedom to me. I like freedom, but I had more of it at a corporate job. But I was lacking ownership. I was building a small part of someone else's vision. Now, I have less freedom and less money, but at least the vision I'm building is my own.

Web scraping is tough. 90% of the tech issues at Content Raptor involve our site scrapers. When a new user comes onboard, we have to scrape every ranking page on their site and match it against all the ranking keywords. And it needs to happen in a matter of minutes to get

AI will replace coders in a year, but software engineers will be safe for 5 years. Content writers are basically gone now. Content strategists are safe for at least 3 years. Want to survive the next several years? Move up the value chain.

We're 10 days in. Who is seeing changes from this core update?

Trying out Cursor today as a Vscode+Copilot alternative. HMU with your best tips

99% of people doing SEO are not SEOs.

Indie devs, what tool are you using for user flow diagrams and general UX design?

Write good content. Not for SEO but because you give two shits about your customers.

If people will sink $1,000s into winning fake trophies in mobile games, they'll spend $100/month for your SaaS that makes them real-world money

Deep in user flow diagrams this week. Compiling a lot of notes from user 1x1s into huge improvements to the app. Build -> Measure -> Learn -> ...

Go fix your internal linking. Internal links can: 1. Help users find relevant content 2. Guide customers down your funnel 3. Let Google know which pages to rank for which terms 4. Improve your site's crawlability for search engines

You: We want annual billing Content Raptor: Releases annual billing You: We want a discounted annual plan Content Raptor: Gives 2 months free on all annual plans Your move.

If your olive oil is smaller than this, I don’t trust your cooking

I just had an inspiration for a massive improvement to the way Content Raptor identifies and prioritizes SERP entities for content optimization (Yes, I know I'm a nerd). Put on a pot of coffee, I've got a long night of coding ahead of me.

Damn… cracking down on AI content reddit.com/r/Blogging/com…

SEO in 2024 summarized in 3 posts: