IdeaWell

Project ideas from Hacker News discussions.

Neki – Sharded Postgres

Original Article

Hacker News Discussion

📝 Discussion Summary (Click to expand)

Three prevalent themes in the discussion

  1. Unclear marketing / lack of upfront explanation
    Many commenters complained that the launch post (and initially the landing page) didn’t state plainly what Neki is or what problem it solves.

    “Folks, in your launch posts remember to describe what you're launching and what it's for.” — gk1
    “If I don't know what I'm reading about by the third or fourth phrase, I skip it.” — ahknight
    “The first thing I want to know … is what is Neki?” — khy

  2. Open‑source vs. proprietary stance
    A large portion of the thread debated whether Neki should be open source, criticizing the decision to keep it closed while noting the company’s history with Vitess.

    “Neki is not even open source! … Are you going to OSS this thing?” — xyzzy_plugh
    “I would love to open source Neki and I have not said we won’t.” — samlambert
    “Open source being by far the more important … makes it more suitable for long term planning.” — margalabargala

  3. CEO demeanor and competitor criticism
    Sam Lambert’s tone on Twitter and in the comments was frequently called out as defensive, antagonistic, or “asshole‑ish,” with users arguing that the constant shots at rivals hurt the product’s perception.

    “The tech might be amazing, but the CEO comes across as an asshole.” — parthdesai
    “nothing i have said is untrue… a founder … leaving to compete out of greed is a bad thing.” — samlambert
    “If someone's defense against being called an asshole is to say ‘well nothing I said was false’ they're almost certainly an asshole.” — margalabargala

🚀 Project Ideas

Generating project ideas…

ClarityScan – Landing Page Clarity Analyzer

Summary

  • Scans a startup’s landing page or blog post and scores how quickly it answers “What is this?” and “What problem does it solve?”
  • Provides actionable suggestions to improve upfront clarity, reducing bounce caused by vague messaging.

Details

Key Value
Target Audience Early‑stage SaaS founders, dev‑tool marketers, product teams
Core Feature AI‑driven copy analysis that highlights missing value proposition, jargon, and clarity score
Tech Stack Python/FastAPI backend, spaCy + LLM API (e.g., OpenAI), React + Tailwind frontend
Difficulty Medium
Monetization Revenue-ready: Freemium SaaS (free 5 scans/mo, paid plans $15‑$50/mo for unlimited scans & team collaboration)

Notes

  • HN commenters repeatedly complained that Neki’s launch page didn’t explain what the product is until far down the page (“What is Neki?”); a tool like ClarityScan would force teams to surface that answer immediately.
  • Could become a reference point in HN discussions about effective product messaging, sparking practical advice and shared best‑practices.

PostgresShardingCompare – Feature & Licensing Matrix

Summary

  • Interactive, community‑maintained comparison table of Postgres scaling solutions (Neki, Multigres, PgDog, Citus, Vitess‑FDW, etc.) with filters for open‑source status, self‑hosted vs. cloud, consistency model, pricing, and maturity.
  • Lets engineers quickly see which option meets their requirements without wading through marketing copy.

Details

Key Value
Target Audience Engineers, architects, DevOps evaluating sharding or scaling options for Postgres workloads
Core Feature Searchable matrix of features, licenses, consistency guarantees, benchmarks; ability to submit edits via PR‑style workflow
Tech Stack SvelteKit frontend, SQLite (or Postgres) backend, GitHub‑backed Markdown content for easy community contributions
Difficulty Low‑Medium (mostly curation and UI)
Monetization Hobby (open source; optional sponsorships or ads for hosting)

Notes

  • HN users asked for consistency details (“ctrl+f for 'consis' … zero hits”) and wanted to know if Neki is open source; this matrix directly answers those questions.
  • Provides a concrete resource that could be cited in future HN threads, encouraging informed debate and reducing repetitive questions.

ShardLag – Consistency & Lag Observability for Sharded Postgres

Summary

  • Lightweight agent that instruments logical replication slots on each shard of a distributed Postgres cluster to measure replica lag, cross‑shard query latency, and resharding progress, exposing metrics via Prometheus and ready‑made Grafana dashboards.
  • Gives operators visibility into consistency guarantees that are often missing from marketing materials.

Details

Key Value
Target Audience Platform engineers, SREs, and DevOps teams running sharded Postgres (Neki, Citus, Vitess‑FDW, self‑sharded)
Core Feature Real‑time lag and consistency metrics, alerting on lag spikes, visual resharding progress tracking
Tech Stack Go agent (uses libpq/pglogical), Prometheus client library, Grafana JSON model dashboards; optional Kafka connector for event streaming
Difficulty Medium‑High (requires deep understanding of Postgres replication and logical slots)
Monetization Revenue-ready: Open core – free agent, paid hosted UI/Support or advanced analytics tiers ($20‑$100/mo per cluster)

Notes

  • HN commenters expressed frustration at not being able to find consistency info for Neki (“zero hits for 'consis'”). ShardLag would give them that data directly from their own clusters.
  • Offers a practical tool for ops teams, likely to generate discussion on observability patterns for distributed databases and could be showcased in future “Show HN” posts.

Read Later