[Tutor] Best approach to sort data based on several
criteria
Bob Gailer
bgailer@alum.rpi.edu
Mon Jul 21 11:58:02 2003
--=======538489=======
Content-Type: multipart/alternative; x-avg-checked=avg-ok-62E017AB; boundary="=====================_16454500==.ALT"
--=====================_16454500==.ALT
Content-Type: text/plain; x-avg-checked=avg-ok-62E017AB; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 8bit
At 11:44 AM 7/21/2003 -0300, Jorge Godoy wrote:
>I have a huge amount of data
>[snip]
>I need to show this data (some columns each time) sorted out
>accordingly to some columns (e.g. columns zero, one, five and six,
>each on a different view and in one of these views, I need to sort
>based on multiple keys).
Consider using the sqlite database. Unlike most other RDBMS, sqlite is
loaded as part of your python session, so is very fast.
http://www.sqlite.org for the database.
http://pysqlite.sourceforge.net/ for the Python wrapper.
Bob Gailer
bgailer@alum.rpi.edu
303 442 2625
--=====================_16454500==.ALT
Content-Type: text/html; x-avg-checked=avg-ok-62E017AB; charset=us-ascii
Content-Transfer-Encoding: 8bit
<html>
<body>
At 11:44 AM 7/21/2003 -0300, Jorge Godoy wrote:<br>
<blockquote type=cite class=cite cite>I have a huge amount of data <br>
[snip]<br>
I need to show this data (some columns each time) sorted out<br>
accordingly to some columns (e.g. columns zero, one, five and six,<br>
each on a different view and in one of these views, I need to sort<br>
based on multiple keys).</blockquote><br>
Consider using the sqlite database. Unlike most other RDBMS, sqlite is
loaded as part of your python session, so is very fast.<br>
<font size=2 color="#008000"><a href="http://www.sqlite.org/" eudora="autourl">http://www.sqlite.org</a></font>
for the database.<br>
<font size=2 color="#008000"><a href="http://pysqlite.sourceforge.net/" eudora="autourl">http://pysqlite.sourceforge.net</a><a href="http://pysqlite.sourceforge.net/" eudora="autourl">/</a></font> for the Python wrapper.<br>
<x-sigsep><p></x-sigsep>
Bob Gailer<br>
bgailer@alum.rpi.edu<br>
303 442 2625<br>
</body>
</html>
--=====================_16454500==.ALT--
--=======538489=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-62E017AB
Content-Disposition: inline
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.500 / Virus Database: 298 - Release Date: 7/10/2003
--=======538489=======--