On Mon, 23 Jun 2014, Chuck Hast wrote: > Yes, I want to store each row in a db or a flat file, but I fear the > FF may get messy,
Chuck, Flat files are a no-no! I suggest that you first design your database and normalize the tables. If this is new to you, write off the list and I'll help. > ... then once I have it somewhere for posterity, > I will start to process it. Generally we look at it in the following > form, > Rejects by mould number > Reject type by mould number > Rejects last hour > Rejects last X hours > Rejects last shift > Rejects last 24 hours > Other time periods > Also we look at a breakdown of reject types on those time periods. > At this point I am just trying to get the data stream into a db or a > file, once there I can start playing with how to graph it, There are all SQL SELECT queries. My recommendation is to write a simple application using the wxPython GUI, psycopg2 to get the data from the machines and store them in the appropriate postgres tables. Then you can work on writing the queries and get reports using numbers before thinking about graphs. First, though, properly design the database tables; some thought up front will save hours or grief later. Rich _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
