LangChain.Utilities.Postgres 0.17.1-dev.7

This is a prerelease version of LangChain.Utilities.Postgres.
There is a newer prerelease version of this package available.
See the version list below for details.
dotnet add package LangChain.Utilities.Postgres --version 0.17.1-dev.7                
NuGet\Install-Package LangChain.Utilities.Postgres -Version 0.17.1-dev.7                
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.7" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add LangChain.Utilities.Postgres --version 0.17.1-dev.7                
#r "nuget: LangChain.Utilities.Postgres, 0.17.1-dev.7"                
#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.
// Install LangChain.Utilities.Postgres as a Cake Addin
#addin nuget:?package=LangChain.Utilities.Postgres&version=0.17.1-dev.7&prerelease

// Install LangChain.Utilities.Postgres as a Cake Tool
#tool nuget:?package=LangChain.Utilities.Postgres&version=0.17.1-dev.7&prerelease                

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