Python Forum

Full Version: file sharing across devices question
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
...ok, so basically i made a reminder GUI application (using TkInter mainly) and i save the date in a CSV file. The client wants to be able to install this software on various devices. I have beent searching and DuckDuckGoing for a while now and I cant find anything so I thought i could ask here.. Is there a way to share the file and update all file changes across all of the devices at all times?
Please refer me to frameworks, modules, packages, and IF possible links to documentations/videos/bootcamps.. whatever.... thanks for your time Wink
i don't know if my English is poor,
or do you want to chain updates between devices?

why not create 1 "master" file on the server,
then other slave updates from it?
If everyone shares the same event calendar, a database would be a good choice. Allowing access for multiple users while maintaining data integrity is built-in.
A online database eg Turso great free offer of 500 Databases, 9GB storage.
Eg convert the csv file to sqlite.
import pandas as pd
import sqlite3

conn = sqlite3.connect('reminders.db')
df = pd.read_csv('reminders.csv')
df.to_sql('reminders', conn, if_exists='append', index=False)
Test.
import sqlite3

conn = sqlite3.connect('reminders.db')
cursor = conn.cursor()
cursor.execute('SELECT * FROM reminders')
rows = cursor.fetchall()
for row in rows:
    print(row)
Output:
(1, 'Buy groceries', '2024-08-01') (2, 'Meeting with John', '2024-08-02') (3, 'Doctor appointment', '2024-08-03')
Or it look like can just upload csv file Turso,and they do stuff over.
Then look at Turso Quickstart (Python)