1 hr 18 min

Spinning up on Postgres & AI with Arda Aytekin Path To Citus Con, for developers who love Postgres

    • Technology

Everywhere you look, people are talking about AI. From Copilot to ChatGPT to Postgres’s powerful AI capabilities (think: pgvector), AI is everywhere. In this episode of Path To Citus Con, for developers who love Postgres, Arda Aytekin joined Claire and Pino to chat about spinning up on Postgres and AI. Arda shared his origin story in mechanical engineering and data science before walking us through vector databases, pgvector, and azure_ai. Arda is one of the creators of the azure_ai extension, so the conversation delves into the azure_ai integration between Azure Database for PostgreSQL and Azure AI Services. Also discussed (of course) was—Responsible AI.

Links mentioned in this episode:
pgvector on GitHub: https://github.com/pgvector/pgvectorAndrew Kane: https://github.com/ankaneSimon Willison’s Blog: https://simonwillison.net/Demo of Azure AI & pgvector with Azure Database for PostgreSQL by Claire Giordano: https://youtu.be/em0PKDGzzlQ?si=TrOQHXO5gqIuGsU0Blog: Introducing the azure_ai extension to Azure Database for PostgreSQL by Denzil Ribeiro: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-the-azure-ai-extension-to-azure-database-for/ba-p/3980291Documentation: Azure Database for PostgreSQL - Flexible Server Azure AI Extension: https://learn.microsoft.com/azure/postgresql/flexible-server/generative-ai-azure-overviewBlog: Vectors are the new JSON in PostgreSQL by Jonathan Katz: https://jkatz05.com/post/postgres/vectors-json-postgresql/Responsible AI at Microsoft: https://aka.ms/raiAndreessen's Corollary: Ethical Dilemmas in Software Engineering by Bryan Cantrill: https://www.youtube.com/watch?v=0wtvQZijPzgBlog: Phi-2: The surprising power of small language models by Mojan Javaheripi & Sébastien Bubeck: https://www.microsoft.com/research/blog/phi-2-the-surprising-power-of-small-language-models/pg_vectorize: https://github.com/tembo-io/pg_vectorizeOpenAI API documentation: https://platform.openai.com/docs/introductionMicrosoft Azure AI Fundamentals: Generative AI - Training: https://learn.microsoft.com/training/paths/introduction-generative-ai/ChatGPT Prompt Engineering for Developers: https://www.deeplearning.ai/short-courses/chatgpt-prompt-engineering-for-developers/Andrej Karpathy's keynote @ Microsoft Build 2023: https://www.youtube.com/watch?v=bZQun8Y4L2AStanford University CS231n: Deep Learning for Computer Vision: http://cs231n.stanford.edu/LangChain: https://www.langchain.com/Towards Data Science: https://towardsdatascience.com/Generative AI for Beginners on GitHub: https://github.com/microsoft/generative-ai-for-beginners/Zero-shot learning: https://en.wikipedia.org/wiki/Zero-shot_learningAndrej Karpathy thread on LLMs: https://www.threads.net/@karpathy/post/C3lBSlov1QJ/Podcast: Path to Citus Con Ep01: Working in public on open source with Simon Willison & Marco Slot: https://pathtocituscon.transistor.fm/episodes/working-in-public-on-open-sourceThe Art of PostgreSQL by Dimitri Fontaine, get 15% OFF with CLAIRE15: https://theartofpostgresql.com/Podcast: Path to Citus Con Ep08: Solving every data problem in SQL w/Dimitri Fontaine & Vik Fearing: https://pathtocituscon.transistor.fm/episodes/solving-every-data-problem-in-sql-w-dimitri-fontaine-vik-fearing)Arda Aytekin’s scheduled talk at PGDay Chicago 2024 on April 26: https://postgresql.us/events/pgdaychicago2024/schedule/session/1542-learnings-from-extension-development-in-rust-pgrx/ CFP for POSETTE: An Event for Postgres (free & virtual event) open until April 7th 2024: https://aka.ms/posette-cfp-2024

Everywhere you look, people are talking about AI. From Copilot to ChatGPT to Postgres’s powerful AI capabilities (think: pgvector), AI is everywhere. In this episode of Path To Citus Con, for developers who love Postgres, Arda Aytekin joined Claire and Pino to chat about spinning up on Postgres and AI. Arda shared his origin story in mechanical engineering and data science before walking us through vector databases, pgvector, and azure_ai. Arda is one of the creators of the azure_ai extension, so the conversation delves into the azure_ai integration between Azure Database for PostgreSQL and Azure AI Services. Also discussed (of course) was—Responsible AI.

Links mentioned in this episode:
pgvector on GitHub: https://github.com/pgvector/pgvectorAndrew Kane: https://github.com/ankaneSimon Willison’s Blog: https://simonwillison.net/Demo of Azure AI & pgvector with Azure Database for PostgreSQL by Claire Giordano: https://youtu.be/em0PKDGzzlQ?si=TrOQHXO5gqIuGsU0Blog: Introducing the azure_ai extension to Azure Database for PostgreSQL by Denzil Ribeiro: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-the-azure-ai-extension-to-azure-database-for/ba-p/3980291Documentation: Azure Database for PostgreSQL - Flexible Server Azure AI Extension: https://learn.microsoft.com/azure/postgresql/flexible-server/generative-ai-azure-overviewBlog: Vectors are the new JSON in PostgreSQL by Jonathan Katz: https://jkatz05.com/post/postgres/vectors-json-postgresql/Responsible AI at Microsoft: https://aka.ms/raiAndreessen's Corollary: Ethical Dilemmas in Software Engineering by Bryan Cantrill: https://www.youtube.com/watch?v=0wtvQZijPzgBlog: Phi-2: The surprising power of small language models by Mojan Javaheripi & Sébastien Bubeck: https://www.microsoft.com/research/blog/phi-2-the-surprising-power-of-small-language-models/pg_vectorize: https://github.com/tembo-io/pg_vectorizeOpenAI API documentation: https://platform.openai.com/docs/introductionMicrosoft Azure AI Fundamentals: Generative AI - Training: https://learn.microsoft.com/training/paths/introduction-generative-ai/ChatGPT Prompt Engineering for Developers: https://www.deeplearning.ai/short-courses/chatgpt-prompt-engineering-for-developers/Andrej Karpathy's keynote @ Microsoft Build 2023: https://www.youtube.com/watch?v=bZQun8Y4L2AStanford University CS231n: Deep Learning for Computer Vision: http://cs231n.stanford.edu/LangChain: https://www.langchain.com/Towards Data Science: https://towardsdatascience.com/Generative AI for Beginners on GitHub: https://github.com/microsoft/generative-ai-for-beginners/Zero-shot learning: https://en.wikipedia.org/wiki/Zero-shot_learningAndrej Karpathy thread on LLMs: https://www.threads.net/@karpathy/post/C3lBSlov1QJ/Podcast: Path to Citus Con Ep01: Working in public on open source with Simon Willison & Marco Slot: https://pathtocituscon.transistor.fm/episodes/working-in-public-on-open-sourceThe Art of PostgreSQL by Dimitri Fontaine, get 15% OFF with CLAIRE15: https://theartofpostgresql.com/Podcast: Path to Citus Con Ep08: Solving every data problem in SQL w/Dimitri Fontaine & Vik Fearing: https://pathtocituscon.transistor.fm/episodes/solving-every-data-problem-in-sql-w-dimitri-fontaine-vik-fearing)Arda Aytekin’s scheduled talk at PGDay Chicago 2024 on April 26: https://postgresql.us/events/pgdaychicago2024/schedule/session/1542-learnings-from-extension-development-in-rust-pgrx/ CFP for POSETTE: An Event for Postgres (free & virtual event) open until April 7th 2024: https://aka.ms/posette-cfp-2024

1 hr 18 min

Top Podcasts In Technology

Acquired
Ben Gilbert and David Rosenthal
No Priors: Artificial Intelligence | Technology | Startups
Conviction | Pod People
All-In with Chamath, Jason, Sacks & Friedberg
All-In Podcast, LLC
Lex Fridman Podcast
Lex Fridman
Hard Fork
The New York Times
TED Radio Hour
NPR