Skip To Main Content
Harry Pei on Muck Rack

Harry Pei

As seen in: cnblogs.com, National Bureau of Economic Research
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile
Back to Harry Pei’s profile

Articles by Harry Pei

Replacement and Reputation

|
By Navin Kartik, Elliot Lipnowski, Harry Pei
| National Bureau of Economic Research
We thank Richard Van Weelden for discussions that led to this project, as well as Nageeb Ali, Sandeep Baliga, Nina Bobkova, Alessandro Bonatti, Joyee Deb, Jeffrey Ely, Mehmet Ekmekci, Drew Fudenberg, Rohit Lamba, David Levine, Qingmin Liu, Alessandro Pavan, Carlo Prato, Doron Ravid, Refine.ink, João Ramos, Larry Samuelson, Andrzej Skrzypacz, Bruno Strulovici, Mike Ting, Juuso Välimäki, Alexander Wolitzky, and various audiences for helpful comments.
Open in Who Shared Issue with article?

SqlSugar 接入 PostgreSQL pgvector 完整方案（增删改查 + 强类型相似度查询）

|
By Harry Pei
| cnblogs.com
背景 最近在做向量检索相关的功能，技术栈是 .NET + SqlSugar + PostgreSQL + pgvector。SqlSugar 官方对 pgvector 的支持比较有限，网上能搜到的资料大多只解决了一半问题——要么只讲了插入、要么只讲了查询，而且坑点散在好几个不同的地方，单独看每一篇都跑不通。 折腾了一天之后终于把整套方案打通了，这里完整记录一下，希望能帮后来人少走弯路。 环境准备 PostgreSQL 启用 pgvector 扩展： CREATE EXTENSION IF NOT EXISTS vector; NuGet 安装两个包： dotnet add package Pgvector dotnet add package Pgvector.Npgsql 程序启动时注册 vector 类型映射（必须，否则 Npgsql 不认识 vector 类型）： NpgsqlConnection.GlobalTypeMapper.UseVector(); 核心难点 SqlSugar + pgvector 有两条独立的数据通路，必须分别处理，这是最容易踩坑的地方：...
Open in Who Shared Issue with article?
Show More