Timescale Newsletter ?? Hello ?? Cohere models!
Hi friend,?
The list of large language models you can use within your PostgreSQL database via pgai keeps on growing! ?? After the Ollama and Anthropic models, it’s now time to welcome Cohere.?
Explore how to build powerful search and RAG systems on PostgreSQL using Cohere's enterprise-grade language models and the pgai extension. ?? We'll show you how to perform hybrid search with Cohere's Embed and Rerank models—it's easier than you think!
Next, dive into some vector database basics to learn more about HNSW—an efficient algorithm for vector searches. Learn how to implement it in PostgreSQL with pgvector, and for those in the cloud, we’ll also compare your vector database options on AWS to help you make the best choice.
Also on the topic of AWS, check out our recommendations on setting up your architecture with AWS & TimescaleDB. We've got four common implementations that can help you find the right fit for your project.
See you soon! ??
P.S. In case you missed it, the most clicked link in the previous edition was Moving Past Legacy Systems: Data Historian vs. Time-Series Database. ??
Hot Off the Press
FEATURED POST
Build Search and RAG Systems on PostgreSQL Using Cohere and Pgai
PostgreSQL developers can now harness the power of Cohere's enterprise-grade language models directly on PostgreSQL data using the pgai PostgreSQL extension. ?? In this tutorial, we perform a hybrid search while leveraging Cohere Embed and Rerank models. Learn more
Vector Database Basics: HNSW
Learn more about hierarchical navigable small world indexes, their pros and cons, and how to use them with PostgreSQL via pgvector. Read more
Vector Database Options for AWS
Vector databases are a key piece of AI infrastructure. In this article, we walk you through and compare some vector database options for AWS. Learn more
Recommendations for Setting Up Your Architecture With AWS amp; TimescaleDB
Learn four common implementations of AWS and TimescaleDB, and find the option that works best for your project, team, or organization. Read more
A Beginner’s Guide to IIoT and Industry 4.0
What is industrial IoT, and why is it one of the fastest-growing industries? Check this explainer of IIoT’s components, benefits, and challenges. Read more
What Is a Time Series and How Is It Used?
Time-series data can highlight valuable information about changes over time. Read this recap on what a time series is and how your organization can collect it and put it to use with examples, tools, and tips. Learn more
POSTGRESQL CLAUSES
Understanding FROM in PostgreSQL (With Examples)
The FROM clause in PostgreSQL is used to specify the table from which to select or delete data. Learn how to use it with practical examples. Read more
LISTEN
Postgres.fm: pgvectorscale
PostgreSQL guru Nikolay Samokhvalov chatted with Timescale’s AI engineers—Mat Arye and John Pruitt—about pgvectorscale, the open-source PostgreSQL extension they helped create to enable high-performance vector search in PostgreSQL. Thanks for having us! Listen here?
Tips From the Tiger Trenches
Sharing what our community reads, tweets, watches, or listens to!
Disk savings, speedier queries, same syntax? In one PostgreSQL extension? ??
Mom, I’m on Fireship’s 100 Seconds! (If you have a horse, it's time to sign them up for Tinder! It all starts with a swipe. ???)
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).?
?? Was this newsletter forwarded to you? Opt in to receive our newsletter and get these updates straight to your inbox!