Viewing profile — cevian

Hi HN, I built a suite of tools to help ai generate better PostgreSQL code. The most interesting part is an opinionated set of skills to help it design better Postgres schemas. Als…

For the past 10 years at Timescale (now Tiger Data), I've been been watching developers make mistakes in database design: forgetting to index foreign keys, creating case-sensitive …

We've been building text-to-SQL at TigerData and kept hitting the same problem: evaluation tools that tell you your accuracy score but nothing about how to improve it. Getting a 60…

We’ve been exploring what it means to build a database that works for LLMs and agents. These models don’t see application code. They can’t ask teammates. They just generate SQL fro…

(co-author here) We automatically retry on failures in a while. We also log error messages in the worker (self-hosted) and have clear indicators in the cloud UI that something went…

(Post co author) We absolutely agree that chunking is critical for good RAG. What I think you missed in our post is that the vectorizer allows you to configure a chunking strategy …

(post co-author here) It could do either depending on on what the planner decides. In pgvector it usually does post-filtering in practice (filter after vector search). pgvector HNS…

as far as I can tell Chroma can only store chunks, not the original documents. This is from your docs `If the documents are too large to embed using the chosen embedding function, …

haha. We had a good internal debate as to whether this is more like indexes or more like Materialized Views. It's kinda a mixture of the two.

(post co-author here) The DB is the right layer from a interface point of view -- because that's where the data properties should be defined. We also use the DB for bookkeeping wha…

(post co-author here) We agree a lot of stuff still needs to be figured out. Which is why we made vectorizer very configurable. You can configure chunking strategies, formatting (w…

Please note that TimescaleDB also uses columnar storage for its compressed data. Disclosure: I am a TimescaleDB engineer.

Hah! This was actually one of the main algorithmic challenges of adapting DiskANN to PostgreSQL. Yes, I think it's common for these algorithms to assume you know how many results t…

This article doesn't account for the fact that the role of government funding in science is to fund basic science that industry doesn't have the right incentives to fund. Renewable…

Lead engineer here, happy to answer any questions

Timescale [ Worldwide | Fully Remote | Multiple Roles: Eng, Product + more | https://www.timescale.com/ Timescale is continuing to grow rapidly, and we’re hiring for many roles inv…

Just one more note. Timescale is hiring, including for roles working on Promscale. https://www.timescale.com/careers Promscale roles are listed in the "Observability" section.

(NB: Post author and Promscale dev here) Promscale does both data storage and analysis/rollups. It's like Thanos in that you can use it as a remote storage backend. It has the addi…

(NB: post author here) Great question. We support average of averages by storing the intermediate state of the aggregate (for average that's the sum and count) so we could cleanly …

(Timescale engineer here). We believe so and we have customers using us for just that. We haven't created our own product for that yet (as we have for metrics -- Promscale) but it …

That may indeed have been more accurate. But this is a HN comment thread after all, we can't capture all subtleties of a very complex debate. :)

That's fair but I was more replying to the OP that said "but it shouldn't be called an Open Source license". The point is we don't call our license Open Source. Comparisons to Open…

That only makes sense if you agree with the open source foundation definition of restrictive. I don't. I think the ability to freely link to whatever other software is much more im…

And we never call it Open Source! (Timescale engineer here)