Softpedia >Windows >Others >Miscellaneous >Picalo >  Changelog

Picalo Changelog

What's new in Picalo 4.21

Dec 28, 2007
  • Changed delimited text to save with the line separator of the platform (Win or Unix)
  • Removed all use of the python 'csv' module because it took too much memory.
  • Added a new picalo.lib.delimitedtext module to do csv, tsv, and other delimited text formats. It is slower than the built-in, C-based csv module, but it can handle millions of records. I tested it against 50 million records (4 GB file) and it never used much memory.
  • Fixed delimited and fixed reading and writing to handle unicode correctly. Unicode has long been supported by Picalo, but some encodings were fragile. It works robustly now.

New in Picalo 4.12 (Jun 16, 2007)

  • Added the text-based progress bar. Refactored the entire progress bar code to handle both text-based and gui-based dialogs.
  • Fixed the graphic plugin so it didn't need write permissions to the c: drive.
  • Took out the graphing capabilities altogether. No one was using it and Excel is much nicer.
  • Table, Record, and Column iterators use generators now rather than old-style code.
  • Database now uses generators as well (yield-type code).
  • Major change: Tables now have their memory paged in and out of disk in an efficient manner.
  • Picalo should now be able to handle files of any size, even huge ones, as long as you have enough disk space.
  • Removed the Delayed Database cursors, _datasource in Table, and all other separate data sources.
  • Major change: The project is now simply a directory. All Picalo objects in the tree have filenames behind them.
  • Added the new Database.Query object. This is a large new piece of the app.
  • Totally revamped the Project object tree scanning algorithm. It is more efficient and correct now.
  • Added is_changed to TableList and TableArray
  • Fixed an infinite recursion bug when copying table slices
  • Fixed a bug where Picalo won't come back up when it is quit in a minimized state
  • Fixed a bug in Tables where _update_filter_index was spelled wrong.
  • Centralized the cut, copy, and paste operations
  • Recoded how window focusing works between the different windows of the app
  • Updated the view() method in table to accept Query objects
  • New 'number' type! floats are out because they don't do decimal places as expected.
  • Fixed formats for numbers, dates in the TableProperties dialog. Formats are back in business.
  • Converted values sent to Record.__init__ to list if necessary (databases send tuples)
  • Menu now changes when pages are changed, not when windows are focused on.
  • Spaced out the bottom of the toolbar on Windows -- it was too close.
  • Fixed filtering to use the new pagefiles
  • Fixed a small bug in Table.prettyprint() where formatted fields weren't printing correctly.
  • Modified Spreadsheet.py to allow queries to be viewed.
  • Created an "Edit Query" button to allow the user to change the sql of a query.