Tag Archives: pyqt

Northwind Database Client Server Project

Here is a project I wrote last semester for a client/server systems class. Basically the professor assigned us a table from the Northwind Database. Our first assignment was to take that table, export it to a text file, then create a program to parse that text file and create a random access binary file. We were then to create a GUI that will read, write, and modify records from that binary file. I decided to write my project assignments in Python since that is my programming language of choice.

We spent half the semester working on this part of the project instead of learning anything related to client/server systems. Creating the GUI was extremely easy using Qt3 Designer and pyuic, so most of my work went into the reading and writing of the binary file.

Finally about 3/4 of the way though the semester we were assigned to modify our program to read, write, and modify the binary file over the network. The server contained the binary file, and the client connected to the server to get information from the binary file. This part of the program was actually fun to implement.

Our very last assignment was to merge our client and server with another students. I partnered with Eric Gaumer since he was also working in python. The following code is the result of our work. We took my GUI added the features his client needed and then added his server code to mine.

Simply start the server, then when you start the client enter the ip address where the server is located.

Code:

http://www.mattweber.org/files/nwdb.tar.gz

Note: PyQT and PyKDE are required to run this code.

Back to my Roots

Well a few days ago I went back to my roots and installed Debian on my main desktop. I had been using Kubuntu for the past 3 months or so and really enjoyed it, however it had a few annoyances that finally got to me. Konqueror crashing fairly often is one of them. I expectred this to be fixed quickly, however it was not. Another major problem I had was with packages. Quite a few packages have messed up dependencies and/or are completely broken. Eric3 and PyKDE being the ones I remember the most. Since I am into Python programming right now, I found this extremely annoying and unacceptable. Kubuntu was great, however I think it is too new and has a lot of work to do before Breezy is released.

I am currently running Debian Etch, but I plan on upgrading to Debian Sid pretty soon. I read that there is a lot of new packages being worked into Sid right now that may cause some breakage, so I need to look into this more before upgrading.