HNHacker News
TopNewBestAskShowJobs

BrickTamblan

1 karma · joined January 15, 2024

submissionscomments
BrickTamblan··on Show HN: Faktor – The missing 2FA code autocomplete for Chrome
Sounds like one factor auth with 2 passwords
BrickTamblan··on Show HN: Natural Language to SQL "Text-to-SQL" API
How does someone take structured data from a database and turn it into unstructured data for an LLM? I know RAG is a thing but they talk in terms of documents not tables and fields.

Could the LLM derive that same California sales answer from just knowing the dataset, but not by writing sql?

BrickTamblan··on Postgres as queue
I’m not sure if this is the same as pg queues but I just started using pg_notify with channels, and it’s so good.

Row update occurs as normal express api, but at the end I call pg_notify on some channel name. I pickup the message in a new thread via polling, and perform aggregate queries to a agg table. It’s like materialized views, but with no wasteful refreshes. Then I push the updates aggs back to the frontend via websockets.

BrickTamblan··on Almost every infrastructure decision I endorse or regret
What’s the right way to manage npm installs and deploy it to an AWS ec2 instance from github? Kubernetes? GitOps? EKS? I roll my own solution now with cron and bash because everything seems so bloated.
BrickTamblan··on Snowcraft – Building a Lego Snowfort from giant Lego snow-bricks
T
BrickTamblan··on Vanna.ai: Chat with your SQL database
Anyone know of any sql management server / GUI software that use AI and your db schema (no data) to aid in SQL generation?

I use SQLStudio on a mac, which I love but sadly, no AI