301 lines
11 KiB
HTML
301 lines
11 KiB
HTML
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<!DOCTYPE html>
|
|||
|
|
|
|||
|
|
<html lang="en">
|
|||
|
|
<head>
|
|||
|
|
<meta charset="utf-8">
|
|||
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|||
|
|
<meta name="description" content="">
|
|||
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|||
|
|
|
|||
|
|
<title>FOSSY 2025 | Presentation: RAGtime with Postgres: AI Power with pgvector and Retrieval-Augmented Generation</title>
|
|||
|
|
|
|||
|
|
<meta property="og:type" content="website" />
|
|||
|
|
|
|||
|
|
<link rel="icon" href="../../../static/build/img/favicon.ico" />
|
|||
|
|
|
|||
|
|
<!-- Cards -->
|
|||
|
|
<meta property="og:title" content="FOSSY 2025 | Presentation: RAGtime with Postgres: AI Power with pgvector and Retrieval-Augmented Generation">
|
|||
|
|
<meta property="og:description" content="" />
|
|||
|
|
<meta property="og:url" content="https://2025.fossy.us/schedule/presentation/295/">
|
|||
|
|
<meta name="twitter:site" content="@conservancy">
|
|||
|
|
<meta name="twitter:image:alt" content="FOSSY 2025 | Presentation: RAGtime with Postgres: AI Power with pgvector and Retrieval-Augmented Generation" />
|
|||
|
|
<meta name="twitter:card" content="summary">
|
|||
|
|
<meta name="twitter:image" content="https://2025.fossy.us/static/build/img/conservancy_logo_tall_mono.png" />
|
|||
|
|
<meta property="og:image" content="https://2025.fossy.us/static/build/img/conservancy_logo_tall_mono.png" />
|
|||
|
|
<meta property="og:image:width" content="400" />
|
|||
|
|
<meta property="og:image:height" content="400" />
|
|||
|
|
|
|||
|
|
|
|||
|
|
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
|
|||
|
|
<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/hack-font@3.3.0/build/web/hack.css'>
|
|||
|
|
<link rel="stylesheet" href="https://unpkg.com/tachyons@4.12.0/css/tachyons.min.css">
|
|||
|
|
<link href="../../../static/build/scss/app.css" rel="stylesheet" type="text/css" />
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<script type="text/javascript">
|
|||
|
|
var CONF_TZ = "US/Pacific";
|
|||
|
|
</script>
|
|||
|
|
</head>
|
|||
|
|
<body class="">
|
|||
|
|
|
|||
|
|
<header class="bg-washed-yellow pa2"><div class="container"><strong>Archived:</strong> This is an archive from the 2025 conference. See <a href="https://fossy.us/">fossy.us</a> for the latest event.</div></header><header class="clearfix d-print-none">
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<nav class="navbar navbar-expand-lg navbar-dark" style="background: rgb(19,119,82); background: linear-gradient(124deg, rgba(19,119,82,1) 0%, rgba(19,106,119,1) 100%); margin-bottom: 1rem">
|
|||
|
|
<div class="container">
|
|||
|
|
<h2 class="sans-serif f2 f1-ns b lh-solid tracked-tight mv0 mr3">
|
|||
|
|
<a class="washed-yellow hover-washed-yellow" href="../../../index.html" style="text-decoration: none">
|
|||
|
|
FOSSY 2025
|
|||
|
|
</a>
|
|||
|
|
</h2>
|
|||
|
|
|
|||
|
|
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarText" aria-controls="navbarText" aria-expanded="false" aria-label="Toggle navigation">
|
|||
|
|
<span class="navbar-toggler-icon"></span>
|
|||
|
|
</button>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<div class="collapse navbar-collapse" id="navbarText">
|
|||
|
|
<ul class="navbar-nav mr-auto">
|
|||
|
|
|
|||
|
|
<li class="nav-item dropdown">
|
|||
|
|
|
|||
|
|
<a class="nav-link dropdown-toggle" href="index.html#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
|
|||
|
|
About
|
|||
|
|
</a>
|
|||
|
|
<div class="dropdown-menu">
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../about/index.html">About FOSSY</a>
|
|||
|
|
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
</li>
|
|||
|
|
|
|||
|
|
<li class="nav-item dropdown">
|
|||
|
|
|
|||
|
|
<a class="nav-link dropdown-toggle" href="index.html#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
|
|||
|
|
Attend
|
|||
|
|
</a>
|
|||
|
|
<div class="dropdown-menu">
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../attend/tickets/index.html">Tickets</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../travel/index.html">Travel and Lodging</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../attend/volunteer.html">Volunteer</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../attend/code-of-conduct.html">Code of Conduct</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../attend/health-and-safety/index.html">Health and Safety</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../attend/terms-and-conditions/index.html">Terms and Conditions</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="https://sfconservancy.org/privacy-policy/">Privacy policy</a>
|
|||
|
|
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
</li>
|
|||
|
|
|
|||
|
|
<li class="nav-item dropdown">
|
|||
|
|
|
|||
|
|
<a class="nav-link dropdown-toggle" href="index.html#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
|
|||
|
|
Program
|
|||
|
|
</a>
|
|||
|
|
<div class="dropdown-menu">
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../index.html">Schedule</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../pages/tracks/index.html">Tracks</a>
|
|||
|
|
|
|||
|
|
<a class="dropdown-item " href="../../../call-for-proposals/index.html">Proposals</a>
|
|||
|
|
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
</li>
|
|||
|
|
|
|||
|
|
<li class="nav-item ">
|
|||
|
|
|
|||
|
|
<a class="nav-link" href="../../../sponsorship/index.html">
|
|||
|
|
Sponsorship
|
|||
|
|
</a>
|
|||
|
|
|
|||
|
|
</li>
|
|||
|
|
|
|||
|
|
</ul>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
</nav>
|
|||
|
|
|
|||
|
|
</header>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<main role="main" class="container">
|
|||
|
|
<div class="row">
|
|||
|
|
<div class="col page-header">
|
|||
|
|
<h1 class="page-title">RAGtime with Postgres: AI Power with pgvector and Retrieval-Augmented Generation</h1>
|
|||
|
|
<p class="lead">
|
|||
|
|
|
|||
|
|
327 | <span class="presentation-time" data-starttime="2025-08-01T17:30:00" data-endtime="2025-08-01T18:15:00">Fri 01 Aug 5:30 p.m.–6:15 p.m.</span>
|
|||
|
|
|
|||
|
|
</p>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<div class="row">
|
|||
|
|
<div class="col-md-12">
|
|||
|
|
|
|||
|
|
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<div class="row presentation-details">
|
|||
|
|
<div class="col-md-3">
|
|||
|
|
<h2 class="mt-4">Presented by</h4>
|
|||
|
|
<ul class="list-unstyled">
|
|||
|
|
|
|||
|
|
<li class="mb-4 pb-2">
|
|||
|
|
|
|||
|
|
<img src="https://secure.gravatar.com/avatar/f803e0ee8b2c5e637a52f8e1130796aa?s=120&d=mp" alt="Jimmy Angelakos" class="rounded-circle img-fluid">
|
|||
|
|
<p>
|
|||
|
|
<strong><a href="../../../speaker/profile/458/index.html">Jimmy Angelakos</a></strong><br />
|
|||
|
|
|
|||
|
|
<i class="bi-mastodon"></i> <a href="https://fosstodon.org/@vyruss">@vyruss@fosstodon.org</a>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<i class="bi-globe2"></i> <a href="https://vyruss.org/computing">https://vyruss.org/computing</a>
|
|||
|
|
|
|||
|
|
</p>
|
|||
|
|
<div class="bio"><p>Jimmy Angelakos is a Systems and Database Architect and recognized PostgreSQL expert who has worked with, and contributed to, Open-Source tools for 25+ years. He is passionate about participating in the community, a Contributor to the PostgreSQL project, and an active member of PostgreSQL Europe and US. Jimmy is a regular speaker at conferences and events, sharing his insights with the community. Author of PostgreSQL Mistakes and How to Avoid Them, co-author of PostgreSQL 16 Administration Cookbook.</p>
|
|||
|
|
<p>Mastodon: <a href="https://fosstodon.org/@vyruss">https://fosstodon.org/@vyruss</a>
|
|||
|
|
Bluesky: https://bsky.app/profile/<a href="http://vyruss.org">vyruss.org</a></p></div>
|
|||
|
|
</p>
|
|||
|
|
</li>
|
|||
|
|
|
|||
|
|
</ul>
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
<div class="col-md-9 presentation-abstract">
|
|||
|
|
<h2 class="mt-4">Abstract</h4>
|
|||
|
|
|
|||
|
|
<div class="abstract pb-4"><p><p>Retrieval-Augmented Generation (RAG) is a powerful paradigm in application development with AI. In this talk, we'll demonstrate how to leverage PostgreSQL with pgvector to combine the strengths of vector similarity search with Large Language Models (LLMs).</p>
|
|||
|
|
<p>As the speaker is a Postgres nerd (not an AI expert), we'll explain in simple terms how to dip your toes into AI while leveraging our favorite database -- from the perspective of a database person learning to work with these new tools.</p>
|
|||
|
|
<p>We'll walk through: </p>
|
|||
|
|
<ul>
|
|||
|
|
<li>How to use pgvector to store and search vector embeddings (and what those are)</li>
|
|||
|
|
<li>How to connect these capabilities with AI LLMs to build intelligent applications. </li>
|
|||
|
|
<li>Some practical tips for implementation, including configuration, indexing strategies, and scaling considerations</li>
|
|||
|
|
<li>How to reduce dependency on expensive external AI services by using open-source models while maintaining control over costs and infrastructure</li>
|
|||
|
|
</ul>
|
|||
|
|
<p>To demonstrate these concepts in action, we'll look at a real-world example of building a developer assistance system that helps teams understand their codebase.</p></p></div>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<h2 class="mt-4">Videos</h4>
|
|||
|
|
|
|||
|
|
<iframe width="560" height="315" src="https://www.youtube.com/embed/_ZSLJDYMOgM" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
|
|||
|
|
|
|||
|
|
|
|||
|
|
<p style="margin-top: 1rem">Available sources:</p>
|
|||
|
|
<ul>
|
|||
|
|
|
|||
|
|
<li><a href="https://youtu.be/_ZSLJDYMOgM" rel="nofollow">https://youtu.be/_ZSLJDYMOgM</a></li>
|
|||
|
|
|
|||
|
|
</ul>
|
|||
|
|
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
<script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></script>
|
|||
|
|
<script src="../../../static/build/js/app.js" type="text/javascript"></script>
|
|||
|
|
<script src="../../../static/build/js/jquery.formset.js"></script>
|
|||
|
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
|
|||
|
|
<script src="../../../static/build/bootstrap/js/bootstrap.bundle.min.js"></script>
|
|||
|
|
|
|||
|
|
<!--no-analytics-->
|
|||
|
|
|
|||
|
|
|
|||
|
|
<script src="../../../static/build/js/luxon.min.js"></script>
|
|||
|
|
<script src="../../../static/build/js/schedule.js" type="text/javascript"></script>
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
</main>
|
|||
|
|
|
|||
|
|
<footer class="footer mt-4 d-print-none">
|
|||
|
|
<div class="container py-4">
|
|||
|
|
<!-- <div class="row">
|
|||
|
|
<div class="col-md-12 pb-12 text-center" style="margin-top: 0px;margin-bottom: 0px;border-bottom-style: solid;border-bottom-width: 0px;padding-bottom: 20px;">Wifi: FOSSY <i>(see Registration for older wifi)</i><br/>PIN: outreachy1000</div>
|
|||
|
|
</div> -->
|
|||
|
|
<div class="row">
|
|||
|
|
<div class="col-md-4 pb-4">
|
|||
|
|
<strong>FOSSY 2025</strong> <br>
|
|||
|
|
July 31st – August 3rd 2025 <br>
|
|||
|
|
Portland, OR<br>
|
|||
|
|
Timezone: PDT - UTC-7 <br>
|
|||
|
|
<a href="mailto:conference@sfconservancy.org" alt="Email"><i class="bi-envelope-fill"></i></a>
|
|||
|
|
<a href="https://x.com/conservancy" alt="Twitter"><i class="bi-twitter-x"></i></a>
|
|||
|
|
<a href="https://social.sfconservancy.org/conservancy" alt="Mastodon"><i class="bi-mastodon"></i></a>
|
|||
|
|
<a href="https://www.facebook.com/SoftwareFreedomConservancy/" alt="Facebook"><i class="bi-facebook"></i></a>
|
|||
|
|
<a href="https://www.youtube.com/@softwarefreedomconservancy8558/videos" alt="YouTube"><i class="bi-youtube"></i></a>
|
|||
|
|
</div>
|
|||
|
|
<div class="col-md-4 pb-4 text-center">
|
|||
|
|
<p class="text-secondary">Brought to you by</p>
|
|||
|
|
<a href="https://sfconservancy.org"><img src="../../../static/build/img/conservancy_logo.svg" alt="Software Freedom Conservancy logo" class="footer-image"></a>
|
|||
|
|
</div>
|
|||
|
|
<div class="col-md-4 pb-4 text-right">
|
|||
|
|
<small>
|
|||
|
|
<a href="index.html#">Back to top</a><br>
|
|||
|
|
© 2025 <a href="https://sfconservancy.org/">Software Freedom Conservancy</a><br>
|
|||
|
|
<a href="../../../credits/index.html">Credits</a>
|
|||
|
|
</small>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
</footer>
|
|||
|
|
|
|||
|
|
</body>
|
|||
|
|
</html>
|