added

August 22, 2024 (v0.2.14..15)

Highlights

  • Enhanced Performance: Optimized data loading with StoreBase.load_column() improvements.
  • Flexible Data Handling: Support for lists, dictionaries, and other non-numpy datatypes in import_pandas.
  • Precise Video Frame Extraction: Control frame extraction with FrameIterator by specifying the exact number of frames.
  • Improved Visualizations: New UDF draw_bounding_boxes() for easier visualization of object detection results.
  • Streamlined Codebase: Migrated to a Pixeltable-compatible pgserver fork, improved SQL handling of arithmetic expressions, and refactored for better code organization and type checking.
  • Enhanced Usability: All column types are now stored by default, making it easier to persist your data.

New Features

  • import_json() and import_rows(): Convenient functions for importing JSON data and inserting rows directly into tables.
  • Timestamp Functions Library: Expanded library with more functions for working with timestamps.
  • Aggregate make_list(): Create lists from grouped data.

Improvements

  • Method Call Syntax: Simplified syntax for calling library functions.
  • Notebook Experience: Improved user-friendliness with better error messages and tab completion.
  • Testing: Enhanced test coverage and automation for more reliable code.

Bug Fixes and Other Changes

  • Database Update: New DB version to accommodate internal changes for better compatibility.
  • Type Handling: Removed support for Python datetime.date until a proper DateType is added.
  • CSV Import: Nullable types are now used as defaults for better data handling during CSV import.

Let us know what you think! Your feedback is invaluable to us as we continue to build and improve Pixeltable.