LangChain.Utilities.Postgres 0.17.1-dev.51

This is a prerelease version of LangChain.Utilities.Postgres.
dotnet add package LangChain.Utilities.Postgres --version 0.17.1-dev.51
                    
NuGet\Install-Package LangChain.Utilities.Postgres -Version 0.17.1-dev.51
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="LangChain.Utilities.Postgres" Version="0.17.1-dev.51" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="LangChain.Utilities.Postgres" Version="0.17.1-dev.51" />
                    
Directory.Packages.props
<PackageReference Include="LangChain.Utilities.Postgres" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add LangChain.Utilities.Postgres --version 0.17.1-dev.51
                    
#r "nuget: LangChain.Utilities.Postgres, 0.17.1-dev.51"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#addin nuget:?package=LangChain.Utilities.Postgres&version=0.17.1-dev.51&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=LangChain.Utilities.Postgres&version=0.17.1-dev.51&prerelease
                    
Install as a Cake Tool

šŸ¦œļøšŸ”— LangChain .NET

Nuget package dotnet License: MIT Discord

All Contributors

⚔ Building applications with LLMs through composability ⚔
C# implementation of LangChain. We try to be as close to the original as possible in terms of abstractions, but are open to new entities.

While the SemanticKernel is good and we will use it wherever possible, we believe that it has many limitations and based on Microsoft technologies. We proceed from the position of the maximum choice of available options and are open to using third-party libraries within individual implementations.

I want to note:

  • I’m unlikely to be able to make serious progress alone, so my goal is to unite the efforts of C# developers to create a C# version of LangChain and control the quality of the final project
  • I try to accept any Pull Request within 24 hours (of course, it depends, but I will try)
  • I'm also looking for developers to join the core team. I will sponsor them whenever possible and also share any money received.
  • I also respond quite quickly on Discord for any questions related to the project

Usage

You can use our wiki to get started: https://tryagi.github.io/LangChain/
If the wiki contains unupdated code, you can always take a look at the tests for this
Also see examples for example usage or tests.

// Price to run from zero(create embeddings and request to LLM): 0,015$
// Price to re-run if database is exists: 0,0004$
// Dependencies: LangChain, LangChain.Databases.Sqlite, LangChain.DocumentLoaders.Pdf

// Initialize models
var provider = new OpenAiProvider(
    Environment.GetEnvironmentVariable("OPENAI_API_KEY") ??
    throw new InconclusiveException("OPENAI_API_KEY is not set"));
var llm = new OpenAiLatestFastChatModel(provider);
var embeddingModel = new TextEmbeddingV3SmallModel(provider);

// Create vector database from Harry Potter book pdf
using var vectorDatabase = new SqLiteVectorDatabase(dataSource: "vectors.db");
var vectorCollection = await vectorDatabase.AddDocumentsFromAsync<PdfPigPdfLoader>(
    embeddingModel, // Used to convert text to embeddings
    dimensions: 1536, // Should be 1536 for TextEmbeddingV3SmallModel
    dataSource: DataSource.FromUrl("https://canonburyprimaryschool.co.uk/wp-content/uploads/2016/01/Joanne-K.-Rowling-Harry-Potter-Book-1-Harry-Potter-and-the-Philosophers-Stone-EnglishOnlineClub.com_.pdf"),
    collectionName: "harrypotter", // Can be omitted, use if you want to have multiple collections
    textSplitter: null); // Default is CharacterTextSplitter(ChunkSize = 4000, ChunkOverlap = 200)

// Now we have two ways: use the async methods or use the chains
// 1. Async methods

// Find similar documents for the question
const string question = "Who was drinking a unicorn blood?";
var similarDocuments = await vectorCollection.GetSimilarDocuments(embeddingModel, question, amount: 5);

// Use similar documents and LLM to answer the question
var answer = await llm.GenerateAsync(
    $"""
     Use the following pieces of context to answer the question at the end.
     If the answer is not in context then just say that you don't know, don't try to make up an answer.
     Keep the answer as short as possible.

     {similarDocuments.AsString()}

     Question: {question}
     Helpful Answer:
     """);

Console.WriteLine($"LLM answer: {answer}"); // The cloaked figure.

// 2. Chains
var promptTemplate =
    @"Use the following pieces of context to answer the question at the end. If the answer is not in context then just say that you don't know, don't try to make up an answer. Keep the answer as short as possible. Always quote the context in your answer.
{context}
Question: {text}
Helpful Answer:";

var chain =
    Set("Who was drinking a unicorn blood?")     // set the question (default key is "text")
    | RetrieveSimilarDocuments(vectorCollection, embeddingModel, amount: 5) // take 5 most similar documents
    | CombineDocuments(outputKey: "context")     // combine documents together and put them into context
    | Template(promptTemplate)                   // replace context and question in the prompt with their values
    | LLM(llm.UseConsoleForDebug());             // send the result to the language model
var chainAnswer = await chain.RunAsync("text");  // get chain result

Console.WriteLine("Chain Answer:"+ chainAnswer);       // print the result
        
Console.WriteLine($"LLM usage: {llm.Usage}");    // Print usage and price
Console.WriteLine($"Embedding model usage: {embeddingModel.Usage}");   // Print usage and price
  • LangChainChat - Allows you to run a chat based on a Blazor project using LangChain.Serve and any of the supported local or paid models

🌟 Contributors

langchain.net contributors

Support

Priority place for bugs: https://github.com/tryAGI/LangChain/issues
Priority place for ideas and general questions: https://github.com/tryAGI/LangChain/discussions
Discord: https://discord.gg/Ca2xhfBf3v

It's licensed under the MIT license. We do not plan to change the license in any foreseeable future for this project, but projects based on this within the organization may have different licenses.
Some documentation is based on documentation from dotnet/docs repository under CC BY 4.0 license, where code examples are changed to code examples for using this project.

Acknowledgments

JetBrains logo

This project is supported by JetBrains through the Open Source Support Program.

CodeRabbit logo

This project is supported by CodeRabbit through the Open Source Support Program.

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
0.17.1-dev.51 122 5/20/2025
0.17.1-dev.47 43 5/3/2025
0.17.1-dev.45 126 4/23/2025
0.17.1-dev.44 125 4/22/2025
0.17.1-dev.42 126 4/22/2025
0.17.1-dev.41 129 4/22/2025
0.17.1-dev.40 130 4/22/2025
0.17.1-dev.39 127 4/21/2025
0.17.1-dev.38 134 4/19/2025
0.17.1-dev.37 125 4/19/2025
0.17.1-dev.35 93 4/18/2025
0.17.1-dev.34 110 4/18/2025
0.17.1-dev.33 102 4/18/2025
0.17.1-dev.32 108 4/18/2025
0.17.1-dev.27 123 4/1/2025
0.17.1-dev.26 117 4/1/2025
0.17.1-dev.25 129 4/1/2025
0.17.1-dev.23 82 3/29/2025
0.17.1-dev.20 133 3/23/2025
0.17.1-dev.19 131 3/23/2025
0.17.1-dev.18 126 3/23/2025
0.17.1-dev.17 123 3/23/2025
0.17.1-dev.16 119 3/18/2025
0.17.1-dev.12 51 3/1/2025
0.17.1-dev.11 56 3/1/2025
0.17.1-dev.10 52 3/1/2025
0.17.1-dev.9 48 2/28/2025
0.17.1-dev.7 57 2/26/2025
0.17.1-dev.5 69 2/20/2025
0.17.0 144 1/31/2025
0.16.1-dev.9 66 1/31/2025
0.16.1-dev.5 42 1/15/2025
0.16.1-dev.3 62 1/7/2025
0.16.1-dev.1 69 1/6/2025
0.16.0 126 1/5/2025
0.15.3-dev.31 64 1/5/2025
0.15.3-dev.30 63 1/5/2025
0.15.3-dev.21 66 12/10/2024
0.15.3-dev.20 57 12/10/2024
0.15.3-dev.14 58 11/13/2024
0.15.3-dev.12 72 11/2/2024
0.15.3-dev.8 71 10/11/2024
0.15.2 162 9/19/2024
0.15.1-dev.130 67 9/18/2024
0.15.1-dev.129 69 9/17/2024
0.15.1-dev.126 94 9/14/2024
0.15.1-dev.125 73 9/12/2024
0.15.1-dev.124 59 9/12/2024
0.15.1-dev.123 60 9/12/2024
0.15.1-dev.122 66 9/12/2024
0.15.1-dev.120 72 9/11/2024
0.15.1-dev.118 62 9/10/2024
0.15.1-dev.116 66 9/5/2024
0.15.1-dev.115 59 9/3/2024
0.15.1-dev.112 62 9/1/2024
0.15.1-dev.111 57 9/1/2024
0.15.1-dev.104 88 8/22/2024
0.15.1-dev.100 79 8/21/2024
0.15.1-dev.98 80 8/20/2024
0.15.1-dev.96 83 8/20/2024
0.15.1-dev.95 80 8/20/2024
0.15.1-dev.94 85 8/20/2024
0.15.1-dev.90 86 8/18/2024
0.15.1-dev.89 84 8/16/2024
0.15.1-dev.86 77 8/14/2024
0.15.1-dev.79 46 8/6/2024
0.15.1-dev.78 48 8/6/2024
0.15.1-dev.77 48 8/6/2024
0.15.1-dev.76 62 8/6/2024
0.15.1-dev.69 49 8/4/2024
0.15.1-dev.68 50 8/3/2024
0.15.1-dev.67 47 8/3/2024
0.15.1-dev.65 47 8/3/2024
0.15.1-dev.63 65 8/1/2024
0.15.1-dev.51 62 7/30/2024
0.15.1-dev.46 62 7/27/2024
0.15.1-dev.43 68 7/25/2024
0.15.1-dev.42 66 7/24/2024
0.15.1-dev.41 67 7/24/2024
0.15.1-dev.39 67 7/24/2024
0.15.1-dev.37 62 7/24/2024
0.15.1-dev.35 65 7/22/2024
0.15.1-dev.34 75 7/22/2024
0.15.1-dev.31 69 7/21/2024
0.15.1-dev.12 47 7/11/2024
0.15.1-dev.11 49 7/11/2024
0.15.1-dev.1 69 6/27/2024
0.15.0 122 6/27/2024
0.14.1-dev.79 65 6/26/2024
0.14.1-dev.73 71 6/19/2024
0.14.1-dev.69 63 6/14/2024
0.14.1-dev.66 57 6/11/2024
0.14.1-dev.65 69 6/11/2024
0.14.1-dev.60 65 6/8/2024
0.14.1-dev.57 67 6/6/2024
0.14.1-dev.52 62 6/3/2024
0.14.1-dev.51 65 6/3/2024
0.14.1-dev.49 65 6/1/2024
0.14.1-dev.48 59 6/1/2024
0.14.1-dev.47 77 5/31/2024
0.14.1-dev.43 74 5/23/2024
0.14.1-dev.42 75 5/23/2024
0.14.1-dev.39 71 5/21/2024
0.14.1-dev.35 76 5/19/2024
0.14.1-dev.34 69 5/18/2024
0.14.1-dev.33 63 5/18/2024
0.14.1-dev.31 75 5/17/2024
0.14.1-dev.30 72 5/17/2024
0.14.1-dev.25 63 5/15/2024
0.14.1-dev.24 63 5/15/2024
0.14.1-dev.21 81 5/13/2024
0.14.1-dev.17 64 5/13/2024
0.14.1-dev.14 60 5/12/2024
0.14.1-dev.11 71 5/8/2024
0.14.1-dev.10 66 5/8/2024
0.14.1-dev.8 81 5/5/2024
0.14.1-dev.7 83 5/5/2024
0.14.1-dev.6 82 5/5/2024
0.14.1-dev.5 77 5/5/2024
0.14.1-dev.2 68 5/3/2024
0.14.1-dev.1 65 5/3/2024
0.14.0 116 5/3/2024
0.13.1-dev.184 68 5/3/2024
0.13.1-dev.183 62 5/3/2024
0.13.1-dev.179 51 5/2/2024
0.13.1-dev.178 37 5/2/2024
0.13.1-dev.177 35 5/2/2024
0.13.1-dev.175 34 5/2/2024
0.13.1-dev.171 37 5/2/2024
0.13.1-dev.169 55 5/1/2024
0.13.1-dev.161 68 4/30/2024
0.13.1-dev.157 65 4/29/2024
0.13.1-dev.154 62 4/29/2024
0.13.1-dev.150 63 4/29/2024
0.13.1-dev.145 63 4/29/2024
0.13.1-dev.144 62 4/29/2024
0.13.1-dev.142 60 4/29/2024
0.13.1-dev.141 61 4/29/2024
0.13.1-dev.138 63 4/29/2024
0.13.1-dev.137 61 4/29/2024
0.13.1-dev.136 57 4/29/2024
0.13.1-dev.131 68 4/28/2024
0.13.1-dev.121 63 4/27/2024
0.13.1-dev.119 67 4/27/2024
0.13.1-dev.116 71 4/26/2024
0.13.1-dev.112 73 4/25/2024
0.13.1-dev.110 69 4/25/2024
0.13.1-dev.107 69 4/24/2024
0.13.1-dev.106 59 4/24/2024
0.13.1-dev.103 73 4/23/2024
0.13.1-dev.102 64 4/23/2024
0.13.1-dev.101 71 4/23/2024
0.13.1-dev.99 67 4/22/2024
0.13.1-dev.97 66 4/22/2024
0.13.1-dev.96 69 4/22/2024
0.13.1-dev.95 65 4/21/2024
0.13.1-dev.94 66 4/21/2024
0.13.1-dev.93 73 4/21/2024
0.13.1-dev.92 66 4/20/2024
0.13.1-dev.91 69 4/20/2024
0.13.1-dev.90 66 4/20/2024
0.13.1-dev.87 64 4/20/2024
0.13.1-dev.85 66 4/20/2024
0.13.1-dev.84 69 4/20/2024
0.13.1-dev.83 71 4/20/2024
0.13.1-dev.82 64 4/20/2024
0.13.1-dev.81 64 4/20/2024
0.13.1-dev.80 71 4/20/2024
0.13.1-dev.79 65 4/20/2024
0.13.1-dev.78 68 4/20/2024
0.13.1-dev.77 68 4/20/2024
0.13.1-dev.76 74 4/20/2024
0.13.1-dev.75 72 4/20/2024
0.13.1-dev.74 74 4/20/2024
0.13.1-dev.73 70 4/20/2024
0.13.1-dev.72 67 4/20/2024
0.13.1-dev.71 77 4/20/2024
0.13.1-dev.70 70 4/20/2024
0.13.1-dev.69 70 4/20/2024
0.13.1-dev.68 66 4/20/2024
0.13.1-dev.67 68 4/20/2024
0.13.1-dev.66 74 4/20/2024
0.13.1-dev.65 55 4/20/2024
0.13.1-dev.64 59 4/20/2024
0.13.1-dev.63 76 4/20/2024
0.13.1-dev.62 69 4/20/2024
0.13.1-dev.61 68 4/20/2024
0.13.1-dev.60 64 4/20/2024
0.13.1-dev.59 66 4/20/2024
0.13.1-dev.57 67 4/20/2024
0.13.1-dev.56 70 4/20/2024
0.13.1-dev.55 68 4/20/2024
0.13.1-dev.54 68 4/20/2024
0.13.1-dev.53 70 4/20/2024
0.13.1-dev.52 61 4/19/2024
0.13.1-dev.51 58 4/19/2024
0.13.1-dev.50 66 4/18/2024
0.13.1-dev.49 79 4/15/2024
0.13.1-dev.48 64 4/15/2024
0.13.1-dev.47 72 4/14/2024
0.13.1-dev.45 72 4/13/2024
0.13.1-dev.44 72 4/13/2024
0.13.1-dev.43 69 4/13/2024
0.13.1-dev.41 72 4/13/2024
0.13.1-dev.40 66 4/12/2024
0.13.1-dev.39 64 4/11/2024
0.13.1-dev.38 76 4/10/2024
0.13.1-dev.37 63 4/9/2024
0.13.1-dev.36 66 4/8/2024
0.13.1-dev.35 66 4/7/2024
0.13.1-dev.34 64 4/7/2024
0.13.1-dev.33 76 4/7/2024
0.13.1-dev.32 73 4/6/2024
0.13.1-dev.31 79 4/5/2024
0.13.1-dev.29 62 4/5/2024
0.13.1-dev.28 70 4/5/2024
0.13.1-dev.27 71 4/4/2024
0.13.1-dev.26 70 4/3/2024
0.13.1-dev.25 81 4/3/2024
0.13.1-dev.24 71 4/3/2024
0.13.1-dev.22 67 4/3/2024
0.13.1-dev.21 69 4/3/2024
0.13.1-dev.20 69 4/3/2024
0.13.1-dev.19 69 4/3/2024
0.13.1-dev.18 62 4/3/2024
0.13.1-dev.17 80 4/2/2024
0.13.1-dev.16 74 4/1/2024
0.13.1-dev.15 75 4/1/2024
0.13.1-dev.13 89 3/30/2024
0.13.1-dev.12 86 3/27/2024
0.13.1-dev.11 78 3/24/2024
0.13.1-dev.10 74 3/23/2024
0.13.1-dev.9 75 3/22/2024
0.13.1-dev.7 82 3/18/2024
0.13.1-dev.5 71 3/9/2024
0.13.1-dev.3 74 3/7/2024
0.13.1-dev.2 73 3/7/2024
0.13.1-dev.1 75 3/6/2024
0.13.0 170 3/6/2024
0.12.3-dev.157 73 3/6/2024
0.12.3-dev.156 78 3/6/2024
0.12.3-dev.155 73 3/6/2024
0.12.3-dev.151 61 3/5/2024
0.12.3-dev.150 80 3/4/2024
0.12.3-dev.149 76 3/4/2024
0.12.3-dev.148 75 3/4/2024
0.12.3-dev.147 72 3/3/2024
0.12.3-dev.145 70 3/3/2024
0.12.3-dev.144 71 3/3/2024
0.12.3-dev.143 76 3/3/2024
0.12.3-dev.142 85 3/2/2024
0.12.3-dev.141 71 3/2/2024
0.12.3-dev.140 71 2/29/2024
0.12.3-dev.139 76 2/29/2024
0.12.3-dev.137 81 2/28/2024
0.12.3-dev.134 63 2/28/2024
0.12.3-dev.133 69 2/28/2024
0.12.3-dev.132 79 2/27/2024
0.12.3-dev.131 69 2/26/2024
0.12.3-dev.130 73 2/26/2024
0.12.3-dev.128 68 2/25/2024
0.12.3-dev.127 80 2/25/2024
0.12.3-dev.120 73 2/24/2024
0.12.3-dev.119 74 2/24/2024
0.12.3-dev.118 71 2/23/2024
0.12.3-dev.116 66 2/23/2024
0.12.3-dev.115 71 2/23/2024
0.12.3-dev.114 76 2/19/2024
0.12.3-dev.113 86 2/12/2024
0.12.3-dev.110 76 2/8/2024
0.12.3-dev.108 73 2/7/2024
0.12.3-dev.107 71 2/6/2024
0.12.3-dev.106 76 2/4/2024
0.12.3-dev.103 70 2/1/2024
0.12.3-dev.102 74 1/31/2024
0.12.3-dev.100 71 1/31/2024
0.12.3-dev.99 72 1/28/2024
0.12.3-dev.98 67 1/27/2024
0.12.3-dev.97 70 1/27/2024
0.12.3-dev.95 64 1/26/2024
0.12.3-dev.94 73 1/24/2024
0.12.3-dev.93 73 1/22/2024
0.12.3-dev.92 74 1/21/2024
0.12.3-dev.91 68 1/21/2024
0.12.3-dev.88 74 1/18/2024
0.12.3-dev.87 75 1/18/2024
0.12.3-dev.85 76 1/14/2024
0.12.3-dev.84 76 1/14/2024
0.12.3-dev.83 84 1/10/2024
0.12.3-dev.82 83 1/9/2024
0.12.3-dev.81 83 1/7/2024
0.12.3-dev.80 74 1/6/2024
0.12.3-dev.79 69 1/6/2024
0.12.3-dev.78 74 1/6/2024
0.12.3-dev.77 91 1/6/2024
0.12.3-dev.76 79 1/6/2024
0.12.3-dev.75 80 1/6/2024
0.12.3-dev.74 87 1/6/2024
0.12.3-dev.72 78 1/5/2024
0.12.3-dev.71 79 1/4/2024
0.12.3-dev.69 91 1/1/2024
0.12.3-dev.68 88 12/29/2023
0.12.3-dev.65 92 12/20/2023
0.12.3-dev.64 94 12/8/2023
0.12.3-dev.63 80 12/6/2023
0.12.3-dev.62 87 12/5/2023
0.12.3-dev.61 84 12/5/2023
0.12.3-dev.60 99 12/5/2023
0.12.3-dev.41 80 12/4/2023
0.12.3-dev.40 84 12/1/2023
0.12.3-dev.39 72 11/29/2023