Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

New answers tagged

0 votes

Issue with idle connections/open transactions from Python to SQL Server

The driver used for the database connection should have connection settings that govern transaction behavior. The pyodbc driver for python, for example, has the “autocommit” setting. With autocommit ...
user avatar
  • 1,158
0 votes

Advice for applying locks in my data processing pipeline

Instead of a boolean attribute that shows if a row is being processed, add a timestamp with time zone attribute that you set to current_timestamp when you start processing a row. When looking for rows ...
user avatar
  • 32.4k

Top 50 recent answers are included