473,503 Members | 1,700 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

wxPython GUI update with data from a MySQL database

Hi there,

I'm currently developing a GUI for a network monitor. I have to plot
data taken from a MySQL database. For GUI I use wxPython, for plotting
Matplotlib. The plotting has to be realtime, so
I have to query the database periodically. I don't have enough
experience in programming and I would need some advice about the best
approach in this matter.

I tried to solve it using wx.Timer but from time to time MySQL server
doesn't repond to queries. I use one db connection for all my queries.
I also tried a threads approach but because I don't know how to use
them the result was worse.

Any sugestion will be highly apreciated.

Alina

Aug 17 '06 #1
3 3934
"Alina Ghergu" <al**********@gmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...

Hi,
I have to query the database periodically. I don't have enough
experience in programming and I would need some advice about the best
approach in this matter.

I tried to solve it using wx.Timer but from time to time MySQL server
doesn't repond to queries. I use one db connection for all my queries.
What is the error returned from MySQL when it is not responding to queries?

Stach
Aug 17 '06 #2

Krzysztof Stachlewski wrote:
"Alina Ghergu" <al**********@gmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...

Hi,
I have to query the database periodically. I don't have enough
experience in programming and I would need some advice about the best
approach in this matter.

I tried to solve it using wx.Timer but from time to time MySQL server
doesn't repond to queries. I use one db connection for all my queries.

What is the error returned from MySQL when it is not responding to queries?

Stach
Hi Stach,

The error is "Lost connection to MySQL server during query".

Alina

Aug 17 '06 #3

I solved the problem by using a more recent version of MySQLdb,
compatible with MySQL 5.0.

Sep 6 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
10543
by: Mark | last post by:
A beginner in this area, I have been able to read a record from a MySQL database and populate an HTML form (wow!). Now, my goal is to allow the user to edit the contents of the form and then...
6
3356
by: Paul Eden | last post by:
Hello all. I'm totally stumped. Please de-stump me! I've read my data in from the database, changed it according to what i want to do and now I want to write it back. But it seems I can only...
5
10592
by: Andrew | last post by:
Hi I just started learning wxPython I wanted to know how I could do this in wxPython self.listbox.delete(0, END) for item in self.results: self.listbox.insert(END, item)
2
3886
by: Carlos Eduardo Peralta | last post by:
Hello: Can i update a MySQL database with just copy the files MYI MYD and FRM in the right dir? I know this work. The question is how MySQL manage the user that are usig that database in that...
3
1747
by: Tania | last post by:
Hi. I´ve a problem. I have two diffrent databases. And I want to update database B with database A. But when a column is missing in the B it won´t be insert with the update of A. Whole tables...
2
3790
by: Janto Dreijer | last post by:
I'm writing a Linux filemanager using wxPython. I'd like to embed a bash console inside it. I have found the Logilab pyqonsole (http://www.logilab.org/projects/pyqonsole), but it uses PyQT. Does...
3
2658
by: eholz1 | last post by:
Hello PHP programmers. I had a brilliant idea on one of my pages that selects some data from my mysql database. I first set the page up to display some info and an image, just one item, with a...
4
1915
by: Jimmy | last post by:
Hi, wxPython is cool and easy to use, But I ran into a problem recently when I try to write a GUI. The thing is I want to periodically update the content of StatixText object, so after create...
12
2158
by: bullockbefriending bard | last post by:
I am a complete ignoramus and newbie when it comes to designing and coding networked clients (or servers for that matter). I have a copy of Goerzen (Foundations of Python Network Programming) and...
0
7203
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
1
6993
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5579
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5014
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4675
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3156
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1514
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
737
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
383
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.