You Probably Don't Need a Vector Database
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
2026-06-19
1,245 reads
Python
Vector DB implementation using FAISS
Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a Python-based approach to implementing an efficient document search system using FAISS (Facebook AI Similarity Search) for Vector DB and sentence embeddings, which can be useful in applications like chatbots, document retrieval, and natural language understanding. In this […]
2025-01-17
4,032 reads
Connecting Streamlit to Upload Data to Snowflake
How to create a connection for StreamLit and Snowflake to upload data for visualization
2024-12-20
2,564 reads
Enhancing SQL Server Searches with Elasticsearch and Python
Learn how to get started with Elasticsearch with data in your SQL Server database.
2024-10-14
2,614 reads
Machine learning K-Means applied to SQL Server data
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
2024-01-08
3,258 reads
SQL Server and Python Tutorial
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
2023-11-06
20,944 reads
Integrating Python with MongoDB
This article gives an overview of MongoDB and outlines steps to integrate python with MongoDB
2023-10-13
862 reads
2023-11-20 (first published: 2023-10-02)
3,032 reads
Screen Scraping with Python and BeautifulSoup Code Examples
BeautifulSoup (sometimes referred to as Beautiful Soup library) is one of several widely used screen scraping packages for a web page. It is highly regarded for its ease of use and power.
Screen scraping enables developers to create solutions that permit comparative analyses from all over the internet, such as web applications that look for the best price on an item from many different online stores.
2023-08-25
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
2023-08-04
354 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers