Timescale Newsletter ?? Pushing Postgres Boundaries

Hi friend,?

This issue is packed with insights and announcements designed to keep your developer toolbox sharp. ??? Start by diving into our featured article, where we explain how RAG (retrieval-augmented generation) is more than just vector search. Learn more about Timescale’s advanced tools to power smarter RAG applications and see a text-to-SQL example in action.?

We’re also excited to announce the hypercore release, which will push PostgreSQL’s performance limits for time-series workloads and real-time analytics. Stay tuned for more details as these updates roll out!

Finally, mark your calendars for our webinar on Building AI Applications With PostgreSQL: A Busy Developer's Guide, happening on Thursday, September 19. Whether you're exploring vector databases, building AI-driven apps, or just looking to stay ahead of the curve, this session is packed with valuable takeaways. Don’t miss out!

See you soon! ??

P.S. In case you missed it, the most clicked link in the previous edition was Testing Postgres Ingest: INSERT vs. Batch INSERT vs. COPY. ??

Hot Off the Press

FEATURED POST

RAG Is More Than Just Vector Search

Explore how Timescale's advanced tools surpass embedding searches to power effective RAG applications. Then, see it in action with a text-to-SQL example. Read more

In-Database AI Agents: Teaching Claude to Use Tools With Pgai

Simplify your architecture and reduce latency by building AI agents within your PostgreSQL database using Claude and the pgai extension. Learn more

Understanding Semantic Search

Semantic search is a central concept in natural language AI systems. Learn about all the ways it works and the tools that support it. Read more

Improving Customer Satisfaction in Pizza Shops With RAG: A Pgai Case Study

See how a business analyst uses retrieval-augmented generation and pgai to improve customer satisfaction and operational efficiency in a pizza shop scenario. Learn more

What Is TOAST (and Why It Isn’t Enough for Data Compression in Postgres)

Postgres TOAST is often seen as a data compression mechanism in PostgreSQL, but it falls short of that task. Learn how TOAST really works and why there is a better alternative. Read more

Using Pgvector With Python

Pgvector is a powerful PostgreSQL vector database extension. See how to use it in Python for powerful machine learning-powered applications. Learn more

LISTEN

The Importance of Complementing PLG With SLG

A big shout-out to the WorkOS team for inviting Timescale’s co-founder and CEO, Ajay Kulkarni, to their Crossing the Enterprise Chasm podcast. Ajay and host Michael Grinich, WorkOS’s CEO, discussed the importance of complementing a product-led growth strategy with a sales-led approach, with all that it entails. Listen to the chat here

RELEASES

Introducing Hypercore ??

Stay tuned this week ?? as we announce several optimizations introduced with TimescaleDB 2.16.0. These improvements will push PostgreSQL beyond its limits to help developers more easily manage time-series workloads and real-time analytics. Keep an eye on the Timescale Blog for more info!

Building AI Applications With PostgreSQL: A Busy Developer's Guide

PostgreSQL is catching fire as the default database choice for AI applications. Thanks to its robust relational foundation and ecosystem of extensions like pgvector, pgvectorscale, and pgai, PostgreSQL is all you need to build a state-of-the-art AI application.

But how can you best leverage all that PostgreSQL has to offer for AI applications? What are the best practices to follow, common pitfalls to avoid, and tools that will accelerate your development?

Join us for a live webinar on the state of the union of developing AI applications in 2024 and why PostgreSQL can save you time and headaches now and in the future:

• Topic: Building AI Applications With PostgreSQL: A Busy Developer's Guide
• When: Thursday, 19 September 2024 at 12:00 ET | 9:00 PT | 17:00 CET
• Who: Avthar Sewrathan, PM AI and Vector @ Timescale

In this live session (plus Q+A), you’ll learn:

• Why you should choose PostgreSQL as your vector database
• Types of AI applications you can build with PostgreSQL: search, RAG, agents, text-to-SQL (with live demos)
• Must-know extensions for building AI applications with PostgreSQL: pgvector, pgvectorscale, and pgai

Can't make it live? No sweat—register, and we'll email you the recording afterward. ??

Tips From the Tiger Trenches

Sharing what our community reads, tweets, watches, or listens to!

Have you heard of the pets of PostgreSQL? Well, take this as your weekly reminder to complete the 2024 State of PostgreSQL survey—in case you haven’t yet! ?? ??

Big shout-out to Brandon for sharing his use case! What about you? What are you using pgai for?

Timescale Careers

Team Timescale is growing! If you know someone who'd like to join our team—or learn more about life on Team Timescale ??—we're currently hiring (100 percent remote).?

?? Check out our careers page to view all of our open positions.?

?? Was this newsletter forwarded to you? Opt in to receive our newsletter and get these updates straight to your inbox!