FAQ
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

Search Discussions

  • Krzysztof Stachlewski at Aug 17, 2006 at 9:48 am
    "Alina Ghergu" <alina.ghergu at gmail.com> wrote in message
    news:1155807053.375687.15930 at i3g2000cwc.googlegroups.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
  • Alina Ghergu at Aug 17, 2006 at 10:21 am

    Krzysztof Stachlewski wrote:
    "Alina Ghergu" <alina.ghergu at gmail.com> wrote in message
    news:1155807053.375687.15930 at i3g2000cwc.googlegroups.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
  • Alina Ghergu at Sep 6, 2006 at 10:41 am
    I solved the problem by using a more recent version of MySQLdb,
    compatible with MySQL 5.0.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppython-list @
categoriespython
postedAug 17, '06 at 9:30a
activeSep 6, '06 at 10:41a
posts4
users2
websitepython.org

People

Translate

site design / logo © 2023 Grokbase