Greeting: Can someone give me a brief outline of sorting data in databases? I have five databases with numeric values for each item. To be more precise, they are sorted by date and if necessary, by time. Currently, I am using Ubuntu 9.04 in the language of Linux and Python is my choice of programming language.

The way I use to do it in another programming language (Liberty Basic in Windows) was:

1. Count number of data entry in database.

2. Dimension or create an array to equal the maximum number of entry.

3. Copy data entry from database into array.

4. Use the SORT command on array, ascending or descending sequence.

5. Copy sorted data from array into database.

From what I know of Python so far, is it possible to sort the database as it or do I have to copy data into either a list, tuple or dictionary and sort there and then, after sorting copy sorted entry back into the database.

An outline of what needed to be done will be fine so I can study and learn the proper way of doing this in Python. FWIW, I just finished Alan's tutorial on list, tuple and dictionary. Whew!!! Quite comprehensive.

Again, TIA,

Ken

Thanks, gentleman.

Ken


_______________________________________________
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor

Reply via email to