Strukt is a cloud service that allows users to quickly and easily process and analyze any tabular data. With Strukt, users can pull data from files, folders, URLs, the clipboard, Git repositories, Postgres, MySQL, Redis, and more. Supported file types include CSV, TSV, XLSX, JSON, web logs, and SQLite. Results can be viewed as a table, line or bar chart, text (plain or HTML), or a map. Strukt supports real data types, such as strings, numbers, booleans, dates, locations, colors, blobs, and nulls, and updates in real time as users edit the pipeline steps.
v1.8
Bugs fixed:
• Fixed crash: geographic locations at 0 degrees could crash, depending on your display settings.
• Fixed crash: right-clicking on an empty area of the Folders preferences tab and choosing any menu item would crash.
• Fixed crash: "Detect Data In Text" would crash if it found address or transit data in your text.
• Fix a bug where grouping by a field with Nulls would fail to group them. (Null in Strukt is essentially a singleton, not a strange non-value like in SQL. We're not constrained to equal-typed tuples, so we can just omit a value when it's missing.)
• Fix an issue with database optimization which could cause an insignificant edit to cause a (pointless but harmless) re-run.
Performance improved:
• For "Read File", use a newer API (DispatchIO, versus NSInputStream) for reading data. It's much faster than the old way.
• When an unknown file is dropped on Strukt and we need to figure out if it's a SQLite database, load less of it (only 1KB, versus 4KB). We use libmagic for this, and it checks way less than 1KB, so this should make no practical difference.
• Minor improvements to performance for sorting and grouping operations.
User interface tweaks:
• When an unknown URL scheme is entered, list all the recognized schemes in the error message.
