We're happy to share our latest releases from June. This post goes into detail on v0.6.6. For v0.6.1 through v0.6.5, see the May/June roundup.
Install with:
And a quick celebration before the release notes: our YouTube channel just crossed 20,000 subscribers. That is a big one for us. Thank you if you helped get us there. If you have not subscribed yet, please do. We share build walkthroughs and release demos there.
The full change list for v0.6.6 is in the Pixeltable changelog and the GitHub compare view.
Import SQL rows into a Pixeltable table#
Facts often live in Postgres. Bytes live in S3. Someone wants a model to use both. The awkward part is getting the SQL rows into the same place as the media without a hand-written sync script.
import_sql() loads a SQLAlchemy table or query into a Pixeltable table. It creates the table by default, or appends to a compatible one. The import infers the schema. A schema override can treat an image URL as an image column when the inferred type is wrong. Computed columns can then run on the image while the other source fields stay on the row.
Sources: SQL import/export cookbook · #1324
If you need labels out to analytics afterward, export_iceberg() already shipped earlier (#1301). See the Iceberg export guide and the analytics export cookbook.
Compute without persisting#
Sometimes you want the filled-in row without keeping it. A dry run. A "try it" endpoint. A review step before anyone hits insert. Table.compute() takes the same input shape as insert(), runs the computed columns, and returns the results. Nothing is written to the table.
Want that over HTTP? FastAPIRouter.add_compute_route() is the same idea as add_insert_route(), except no row is stored.
Sources: Compute without persisting · #1366
We retired data sharing#
We retired data sharing in this release. That includes pxt.publish(), pxt.replicate(), and the related push and pull APIs. If you want an early preview of what we are building to supersede it, reach out to the team.
Sources: #1414
What's next?#
Follow us on LinkedIn for the July highlights, including class-based table schemas, Meta's SAM 3 for prompted segmentation, and cleaner column APIs for agents.
