Drizzle Studio breaking with PGlite + PGVector

Getting a message Error: could not access file "$libdir/vector": No such file or directory I am able to generate and run migrations using drizzle-ORM and insert, query data correctly. It just fails when i try to load studio, i wanted to see the data etc. Any help is greatly appreciated, i also made an issue on github ๐Ÿ™
https://github.com/drizzle-team/drizzle-kit-mirror/issues/584
GitHub
Drizzle studio doesn't seem to work with PGlite + PGvector ยท Issue ...
bug-report.zip PGlite works fine as i can store and retrieve vectors. With drizzle-ORM i can generate and run migrations too. But when i go to open drizzle studio i get this error. Any help is grea...
No description
1 Reply
Samarjit
Samarjitโ€ข3mo ago
did you find a solution for configuring plugin pgvector with pglite for drizzle-studio ? what I observed if I start with drizzle schema I get this error type "vector" does not exist. If I start with forcefully create the type vector await pglite.exec('create extension if not exists vector;'); Then when drizzle-studio opens up, it lists the tables but error pops up could not access file "$libdir/vector": No such file or directory. If I point to proper postgresql database server with pgvector installed then none of these errors come up in drizzle-studio.

Did you find this page helpful?