Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Read a remote text file
Post: Read a remote text file
Hi All, I have a scenario where i need to read a TEXT file(log.txt) in a remote server(Server 1) and write the read data to a database of another server(Server 2). I'm using the below code ,But do n...
 Sandy7771989 General Coding Help 1 7,020 Jul-17-2019, 07:16 AM
    Thread: Making a generalised CSV COPY script in Python
Post: Making a generalised CSV COPY script in Python
Hi All, I'm using the below Python script to COPY a CSV file to one of my PostgreSQL database table.The script below is working fine,But i'm thinking of making this script a generalised one,So i need...
 Sandy7771989 General Coding Help 3 2,438 Jul-04-2019, 08:18 AM
    Thread: Using executemany to import the data
Post: RE: Using executemany to import the data
Can anyone please help me or suggest any solution for this?
 Sandy7771989 General Coding Help 1 2,699 Jun-11-2019, 07:45 AM
    Thread: Using executemany to import the data
Post: Using executemany to import the data
Hi All, I'm using the below code to port the data from MySQL to postgreSQL database and it is working fine, but it's rather slow though( more than 3 minutes is taking for porting some 500 rows, so i ...
 Sandy7771989 General Coding Help 1 2,699 Jun-07-2019, 09:57 AM
    Thread: Speedup the porting process
Post: Speedup the porting process
Hi All, I'm trying to port data from MySQL DB to PostgreSQL DB using the below script,The script is running fine ,but it is slow for higher record count(>10000),Is there an efficient way to speedup...
 Sandy7771989 General Coding Help 2 2,162 May-14-2019, 01:46 PM
    Thread: Error while fetching data from PostgreSQL tuple indices must be integers or slices, n
Post: Error while fetching data from PostgreSQL tuple in...
Hi All, I'm getting the below error while i'm calling my function,Does anyone have any suggestions on how to deal with it? I want to insert the selected data into the destination table with the insert...
 Sandy7771989 General Coding Help 6 6,000 May-10-2019, 01:55 PM
    Thread: Error while fetching data from PostgreSQL tuple indices must be integers or slices, n
Post: RE: Port Data from MySQL Database to postgreSQL us...
Hi I have re-edited my PY script,Can you please tell me how can i deal with DATA TYPE matching and any how if this can be improved? Please suggest. import psycopg2 import os import time import MySQL...
 Sandy7771989 General Coding Help 6 6,000 May-09-2019, 02:55 PM
    Thread: Error while fetching data from PostgreSQL tuple indices must be integers or slices, n
Post: Port table from MySQL database to PostgreSQL
Hi All, I have a requirement to create a staging table in our data ware house which is running on Postgres and import data from our Magento website which is using MySQL database using Python. I have ...
 Sandy7771989 General Coding Help 6 6,000 May-09-2019, 11:07 AM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020