Ai Gone Rogue

Learn Claude Code in 2 Hours- youtube.com/playlist?list=…

4 hours ago the /amazon-sql-interview page on @sqlquest had an 82% bounce rate. Right now it's 68%. Here's what actually moved it and the 3 lessons I'd pin on the wall of any builder shipping in public ↓

Claude'ye üniversitede hangi bölümü tercih edeyim diye sordum. Bilgisayar mühendisliği dedi. Bana mantıklı geldi :) 🔮 5-10 yıl sonra dönüşümü: "Klasik yazılımcılık" (kod satır satır yazma) AI'a devredilecek. Ama yazılım mühendisinin değeri katlanarak artacak — çünkü AI'ı kim yönetecek, AI'ın yazdığı kodu kim doğrulayacak, sistemleri kim tasarlayacak? Bu işleri yapan insan. Yani "kod yazan" olmayacaksın, "AI ajanlarına strateji veren mimar"olacaksın. Bu rol şimdiden 200K-500K dolar maaşları görüyor dünyada.

The takeaway: AI retrieval = 2-tier distribution. Brand queries pull from your site's llms.txt + structured data. Generic queries pull from Reddit + aggregator blogs. Showing up for brand queries is table stakes. Showing up for generic queries is the real game.

Yapay zeka acaip gaza getiriyor.. unheard of falan.. tutmayın beni xD Aşağıdaki yoruma dikkat Three different types of users, three different feedback mechanisms, all closed within 24 hours. That's unheard of. Most founders have one feedback loop closed in a week.

I noticed something weird in my analytics this week: ChatGPT is now referring traffic to my site. Not huge yet. But it's a channel that didn't exist 6 months ago. So I ran an experiment to understand it 👇

The experiment: I asked ChatGPT three questions about SQL practice tools. 1/ "Best free SQL practice site?" 2/ "Practice SQL in the browser, no install — what are my options?" 3/ "SQL Quest vs DataLemur — which is better?" Three different answers. Three different insights.

It’s been 2 months since it slipped brotha

@delveroin sqlquest.app working on this duolingo for sql

who’s building something cool AND useful? Drop your URL lets send some traffic

@mscode07 sqlquest.app

DROP YOUR SAAS!! 👇

@pmitu sqlquest.app duolingo for sql

Solo founders, what are you building? Share your product 👇

SEO isn't one thing. it's a signal stack, 5 layers deep: • canonical tag • HTTP redirect direction • sitemap • internal link graph • schema.org markup one contradiction = Google ignores you. mine had THREE contradictions compounding. audit your whole stack, not one layer.

@vercel @garrytan @patrickc 24-hour update: shipped 9 MORE company interview pages while that thread was getting eyeballs. sqlquest.app now has 12 FAANG + marketplace + finance SQL prep surfaces live. Template-driven SEO with @claudeai — 10 min per page. building in public continues 🛠️

prepping a data interview? → sqlquest.app • 125 SQL challenges, free • AI tutor for hints • 6 company-specific pages (Amazon, Google, Meta, Netflix, Stripe, Apple) • 10 more shipping next week • no signup, just type SELECT built in public. flaws and all. #buildinpublic #SEO #SQL

24-hour update on the SEO autopsy: • USA just flipped to our #1 traffic source (37%, overtook Turkey) • Google organic 7x'd (6 visits in 24h vs 5/week before) • company pages are getting actual clicks — amazon (4), netflix (3), stripe (3), google (2), meta (2) • 54% of traffic is mobile • @buildwithkoray gave me free keywordkick access to roast my SEO this weekend, @ardent__dev got me onto everfeatured the fixes are working. wild to watch in real-time 📊 building in public keeps paying off.

Just shipped: every SQL challenge on sqlquest now tagged by company. Amazon: 34 questions Google: 32 Airbnb: 27 Meta: 22 JPMorgan: 19 + 7 more 60 landing-page CTAs now route to pre-filtered views. /amazon-sql-interview → /app?company=Amazon → 34 matching questions. Built on a flight from analytics: - 82% bounce on company pages = bait-and-switch - Users landed expecting "Amazon questions," saw generic list - @datalemur nails this pattern — we didn't Shipped end-to-end in 2h with @claudeai. Auto-generator script (scripts/augment-companies.mjs) so the data stays fresh. 402 tests pass. Live on main. Next: mobile UX. 54% of traffic is on phone and I know some stuff is rough there. #buildinpublic #saas #sql

spent 3 months building SEO pages Google had never indexed also had 3 copies of my homepage competing with itself for pagerank also a redirect error flagged weeks ago that nobody showed me tonight i audited everything. full autopsy of my own SEO catastrophe 🧵

@sherifgjini get 20 new users

Whats your target this week? - launch that product - get 20 new users - polish your product - building

@sflorimm sqlquest.app teaching sql with ai

hi guys new week! what are you building ?

@BuffetDesigns sqlquest.app teaching sql with ai

Show me your design, website, or project that you’re working on👇