Python

SQLServerCentral Article

Vector DB implementation using FAISS

  • Article

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 […]

You rated this post out of 5. Change rating

2025-01-17

2,230 reads

External Article

Screen Scraping with Python and BeautifulSoup Code Examples

  • Article

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

SQLServerCentral Article

Modifying MySQL data from within Python

  • Article

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

314 reads

External Article

Modifying MySQL data from within Python

  • Article

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-02

Blogs

Copilot Outside of SSMS Seems to Work

By

I read Brent’s first look at SSMS and Copilot in there. He didn’t have...

A New Word: Falesia

By

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to...

SQL Server Logins vs. Users: Why You Really Need to Know the Difference

By

The Two-Layer Model Explained “We added them to the database, but they still can’t...

Read the latest Blogs

Forums

What tool or tools do people like for monitoring SQL servers?

By tschgc

I have a few tools at my disposal but none of them seems like...

average duration increasing inline with exec counts

By simon_s

As the title says , I've got a handful of stored procs where the...

A Basic Data API Builder ADD

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Basic Data API Builder...

Visit the forum

Question of the Day

A Basic Data API Builder ADD

What parameters are required for the dab add command in the Data API Builder?

See possible answers