X Bookmarks — 2025 KW21: Microsoft's Postgres plugin and pg_trgm type-ahead

May 22, 2025

|bookmarks

by Florian Narr

X Bookmarks — 2025 KW21: Microsoft's Postgres plugin and pg_trgm type-ahead

@kiwicopple — Microsoft's new Postgres plugin for VSCode

damn, microsoft cooking this week: new postgres plugin for vscode

◆ schema visualizer ◆ database explorer in the file navigator ◆ query history ◆ intellisense

That's a solid set of features for one release. The schema visualizer + file navigator integration is the part I'd actually use daily — jumping between code and the database structure without leaving the editor is the kind of friction that adds up. Intellisense for Postgres in VSCode has been surprisingly weak for a long time, so if this is done well, it's a real quality-of-life improvement.


@dshukertjr — pg_trgm + GIN for autocomplete

Add an auto-complete feature to your app with pg_trgm!

pg_trgm + GIN keeps iLIKE searches super quick, even with millions of rows, making them great for type-ahead search!

Smart, because this is one of those things that's not obvious until you've hit the wall with naive ILIKE '%query%' on a large table and watched it do a full sequential scan. The trigram index turns substring matching into something that actually scales — and it's built into Postgres, no external search engine needed. Worth knowing before you reach for Elasticsearch.


@filiksyos — Turning a repository into Cursor documentation

Cursor ultra tip

turn a repository into documentation

add documentation to composer and ask about it

this will save you from hours of tutorial videos

Honestly just saved this so I don't forget it exists. The underlying idea — that you can make Cursor's composer aware of an unfamiliar codebase by feeding it the repo-as-docs — is obvious in hindsight but not how most people think about it. Instead of watching someone explain a library for 45 minutes, you get a context-aware assistant that already knows the internals.


@stitchbygoogle — Google Stitch for UI generation

Meet Stitch by @GoogleLabs, the easiest and fastest product to generate great designs and UIs.

Another design-to-code tool from a major lab. The bar for "easiest and fastest" claims is pretty high at this point, but Google has the distribution to make this matter regardless. Worth trying on something real before forming a strong opinion — demo outputs are usually the best case.


@namyakhann — Bento grids that communicate, not impress

no god rays no 12-color palette no AI-generated generic images

just clean bento grids that visually sell an AI SaaS.

– clear benefits – minimal color – direct use case previews

bento doesn't need to be flashy, it needs to communicate.

design = direction.

get cute later.

Makes sense. The "get cute later" framing is the right engineering instinct applied to design — ship something clear and readable first, optimize for aesthetics once the message is nailed. Most AI SaaS landing pages do the opposite: maximum visual noise, minimum information density.


@marclou — Using Hacker News as a customer acquisition channel

Hacker News is a gold mine for your startup.

I drove 25,000+ visitors to my websites when I didn't have an audience.

But most people don't use it right...

The HN distribution advantage is real — a Show HN that lands on the front page can deliver more qualified traffic in 24 hours than months of SEO. The part most people miss is that HN readers are builders, so they will actually use what you show them rather than just click and bounce. The "not using it right" angle is vague without more context, but the underlying claim is well-documented enough to take seriously.