PWV Portfolio Feed

playing around with a new camera! i bought a Ricoh GR 3

still no idea how to use it best, but it's nice to have something i can fit in my pocket

This is amazing! A valuable solution without a presentation layer at the same level is not good these days.

this is super cool! is unnoq a company?

Vectors + Metal is an insane combo. We made vector storage and search into MySQL meaning PlanetScale is the first RDBMS to allow vector search as part of a full SQL query. You can pre and post filter while doing vector lookups reducing 3-4 queries into 1

We just released 3 new extensions to supercharge your content and data workflows 🧵

Get started today by enabling vector support on your database branch in the PlanetScale dashboard.

Only the tree and a small, fixed number of relevant partitions need to be in memory when building and querying the index, allowing efficient operation with vector data up to 6x bigger than available memory.

SPANN is a hybrid index design that combines the best aspects of partition-based and tree-based indexes. In SPANN, vectors are assigned to small partitions, which are stored in hidden InnoDB tables.

One of the biggest differentiators of PlanetScale vector support is the ability to use indexes larger than RAM.  We are the first to incorporate an index based on SPANN (Space-Partitioned Approximate Nearest Neighbors) into an RDBMS.

Writes and queries work like a normal RDBMS. Store your vector data in a column in your existing database, build an index with an ALTER or CREATE VECTOR INDEX statement, or write SELECT statements with JOIN and WHERE clauses like any other data.

very good

Another day, another concurrency issue.

Had a lovely time chatting with Paul about when to use existing sync engines vs when to roll your own.

Would love your feedback on the episode!