Question : So I have this database (Size 3.1Gb total), but this is due to one specific table I’ve got, […]
Tag: python
SQL Server hashbytes seed
Question : I’m trying to compare hashes generated by SQL Server HASHBYTES() with hashes generated with python’s hash() (or hashlib) […]
Using Python to insert JSON into PostgreSQL [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. This question does not appear to belong […]
How to filter splitting a column value?
Question : I´m a newbie in the SQL world and I code with just the simple insert, select, delete and […]
Looking for simple contains method when searching text in postgresql
Question : Im new to the PostgreSQL world so I do apologize in advance for not knowing if there is […]
Connecting client application to MariaDB Galera cluster
Question : I currently have a REST API written in Flask that connects to a MariaDB server. I’m thinking about […]
Run lo_export as client through psycopg2
Question : Python 2.7 psycopg2 When I run: cur.execute(“SELECT lo_export(123456, ‘/tmp/test.jpg’)”) Produces error – need to be superuser to do […]
psycopg2 connection already closed
Question : In one of our environments we execute quite heavy query from python script using psycopg2. It takes more […]
UPDATE incredibly slow on small PostgreSQL query – EXPLAIN ANALYZE causes it to hang
Question : I’m trying to debug a very slow UPDATE query in one of my tables. The table name is […]
error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified when import excel data to sql server
Question : I work on SQL server 2017 I need to import data from excel 2016 to sql server 2017 […]