New answers tagged python
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 ...
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 ...
Top 50 recent answers are included
Related Tags
python × 258postgresql × 88
mysql × 67
sql-server × 36
mongodb × 23
sqlite × 17
sqlalchemy × 15
sql-server-2017 × 11
database-design × 9
odbc × 8
mariadb × 7
ubuntu × 6
django × 6
oracle × 5
insert × 5
json × 5
aws × 5
performance × 4
backup × 4
stored-procedures × 4
trigger × 4
security × 4
migration × 4
locking × 4
db2 × 4