We've released a new version of the Datagrok platform (0.94.0). This release focuses on the areas of visualization, usability, rich features for the developers, and traditionally on the platform stability.
- Many updates in Scatter plot: a lasso tool, axis sliders, data split by marker shape, custom lines by equations; all summarized in this video
- New Histogram features: splines and bands: video
- New Line Chart features: marker shape selection, whiskers: video
- Using “Relative Values” property in combination with the “Stack” property to analyze the distribution of the stacked values: overview
- Many aspects and issues of the Bar Chart addressed: overview
- Search for category names in filters (useful when there are many categories in the column): more in this video + an overview
- Lists in parameterized database queries: overview + video; also check the video about parameterized queries in general: link
- Database query caching with cron jobs ability: video
- More granular event handling (an example with intercepting conditional color coding settings change: link)
- Creating drag-and-drop objects: overview
- Getting cell colors: overview
- Adding custom machine learning models to Datagrok in R, Python, or from external models deployed in clusters: video, package, help
- PowerPack and Universal Search — commonly used platform enhancements, currently covering Start Page widgets, Power Search (ability to search for anything from the Start Screen), and search templates support: video
- Updates in the Peptides package, learn more in the video
We have also redesigned our approach to interactive Tutorials. We have moved them to a standalone package and made them available through a dedicated app. Check this video to get a grasp. Every tutorial on the platform now is a simple TypeScript code, like here. Now it is possible to equip customers' apps and deployments of Datagrok with tutorials as well!
We've released a new version of the Datagrok platform (0.93.0). It's a large release with many new features and stability improvements, addressing both user experience and flexibility for developers.
Here are some interesting areas in the platform updates:
- Viewers improvements, such as [relative values in Bar Charts] (https://community.datagrok.ai/t/bar-chart-updates/580) or multi-axis Line Chart
- Visual improvements like dragging columns with drop zones and cleaner columns summaries in tooltips
- Functional features, such as filtering multivalue cells
- Improvements in sharing files and folders
- Better programmatic operations, such as more granular event handling for metadata and new customizations in Scatter Plot
- Numerous improvements in database connectors stability and performance
- Additional built-in functions and improved documentation on them
We also worked intensively on our public packages, presenting a few new of them:
- Biosignals – Physionet annotations file viewer, dynamic scripting capabilities for constructing signal processing pipelines: overview, video
- ClinicalCase — working with clinical data in SDTM format: overview, video
- Sequence Translator — oligonucleotide sequences conversion (BioSpring, Axolabs): overview, video
- Oligo Batch Calculator — extinction coefficient, mass, optical density, Nmole, mol. weight: overview, video
- Cheminformatics features: chemical dataset curation, activity cliffs, save as SDF
We've just released a new version of the Datagrok platform (0.91.10). It is a major release with multiple stability and performance improvements, many new features, and new APIs for developers. Here are some of the notable advances:
- Viewers improvements, including trellis plot usability and performance, bar chart with DateTime categorization, conditional color coding
- Custom cell renderers for molecules and other object types as a first-class citizen in viewers' axis, tooltips, tiles and forms
- New viewers, such as Chord and Timelines
- Cheminformatics support for client-side RDKit searches and molecule rendering
- Usability and stability improvements in filtering, projects, layouts, files browsing and sharing
- Numerous developers' enhancements, including TypeScript support and new APIs
- Custom comparer functions
Check release notes for more details, and give the new version a try at https://public.datagrok.ai!
In this release, we've focused on enriching both the experience of the platform end-users and on-platform developers, as well as on connecting these two groups. For instance, custom-built cell renderers, useful for displaying molecules, nucleotide sequences or experiments results, now expand the platform in many places such as tooltips and tile viewers. There are also new viewers, several bar chart features, color coding features, and a few dozen of JS API enhancements and bug fixes.
- Rendering of chemical molecules with RDKit in tooltips, forms, viewers' axis and tile viewer
- Bar Chart: support for DateTime columns categorization, functional improvements
- Conditional color coding for the grid, scatter plot, box plot
- New Timelines Viewer
- JS API improvements: Typescript support, new events and methods
- Better JS editing in the JS fiddle with IntelliSense and
async/await
- Grid: Custom cell renderers, including RDKit molecules, in several contexts: tooltips, tile viewer, form, other viewers' axes
- Bar Chart: categorizes DateTime columns using functions of Year, Month, Quarter, Year - Quarter, etc.
- Bar Chart: add setting for excluding null values category on bar segments
- Heatmap: Improved adaptive rendering of the column names in the heatmap
- JS API: Migrate to Typescript
- JS API: Log API
- JS API: Grid onColumnResized / onRowsResized events
- JS API: dynamic resolution of object handlers
- JS API: Logging: New API for collecting telemetry logging
- JS Fiddle: Added IntelliSense dynamic resolution of object handlers
- JS fiddle: Use async/await inside
- Color coding improvements: categorical color coding with values binning, conditional color coding for the grid, scatter plot, box plot
.tagsand.tempnow support JS-native Map-like iteration and modification- New
ValueMatcher - New Timelines Viewer becomes available
- Trellis Plot: show more granular X and Y axis ticks on line charts
- Selection of data subsets to display on scatter plots
- Filter state is preserved when closing filter panel
- Chem: 10x faster CoordGen-based alignment, flag to hide isotopic labels in RDKit rendering
- Histogram: duplicated Y axis
- User can't login with OpenId if someone shared something to him by email
- Detectors load on each table open
- dapi.log.events returns empty array
- Layout apply doesn't work on renamed columns
- Chem: Column width with structures is not correct when using OCL
filesmethodrenamedoesn't work properly- Saved function annotation doesn't delete old parameters from database
- Settings: apply drops password parameters
- tabControl with ui.wait will concatenate contents of tabs and show loader after second tab click
- Package Properties ignored on repository publish
- Grid: Selection display is drawing incorrect on high res.displays (MacOS)
- Grid: empty cells are colored with conditional color-coding on
- error: NullError: method not found: '_ddt$_name' on null
- Visual Query does not work for all supported providers
- Fixed the bool input debouncing issue
- Heat Map: columns do not resize
- Exception after adding filters on Table View
- Column format changes are not persisted in layouts
- S3 AES: Cant post a file
- Ability to disable routing
- UI boolInput: onChange event executes code twice
- Filters panel opens with an error message
- Newick file viewer
- Improved comments on DataFrameViewer::onFrameAttached(..)
- JS API: pass JsViewer in onContextMenu events
- JS API: Ability to create ViewLayout from ViewState
- JS API: preserve metadata while changing column type (WIP)
- Timelines: Add Reset View item to context menu
- datagrok-tools: add package init function template
- /info/packages route added
- Improved bitset notification logic to respect current level of notifications (aka updateLevel)
- Filters: deletion of rows in grid/df results in incorrect filters
- Grid: Harmonize popup menu (WIP)
- Grid: Custom HTML-based cell renderers: investigate performance issues (WIP)
- "Normalize" action does not work
- Improve error handling mechanism for visualizations
- HeatMap: automatically adjust header font size as column width gets smaller
- Query View: Incorrect display of line numbering
- UX: Flickering of scroll bars fixed
- Added missing react import
- Heat Map: automatically adjust header font size as column width gets smaller
- JS API: onPackageLoaded event
- Ability to discover and choose JS-based grid cell renderers based on a sem type
- Optimization: faster BitSet construction based on logical function and two arguments
- Grid: make the color of selected rows lighter
- Bar Chart: ability to select categories by clicking on the category label
- Bar Chart: tooltips on category labels
- Bar Chart: disable zoom on the X axis
- Filters: split categories containing a list of values by pipes
- Conditional Color Coding: Ranges "20-30" and ">40" are always automatically determined for any numeric columns
Note: this summary accumulates updates after 0.89.27.
Multiple marker shapes https://community.datagrok.ai/t/visualization-related-updates/521/20 JS API making drag-and-droppable objects https://community.datagrok.ai/t/visualization-related-updates/521/15?u=dskatov
- A new "Add New Column"
- Custom ML
- Function View and Sensitivity Analysis https://www.youtube.com/watch?v=2xuxJjpjXi4&t=2507s