Changelog

SciGlass Next Database

Roadmap planned

• Add new data from literature after 2019 (we need your contribution!).
• Add new predictive models (we need your contribution!).
• Add commercial glass data from SCHOTT and corresponding search interface.
• Add data upload workflow.
• Add data extraction tool workflow (PDF format).
• Add full-text search function, making it easier to locate information within the detail table, which was previously difficult to search effectively (e.g., non-standardized properties).
• Add ontology-based search for DIN/ISO standards for glass manufacturing/measurement.
• Support for unit conversion when searching the database and for predictions (e.g. GlassNet model).

0.6.1 June 20, 2025

• Performance
  • Improved query performance by 2x-120x, depending on the query.
    You may not notice a significant difference in the website, as it's already fast.
    The main bottleneck is rendering raw data as table in the browser.
  • Because Plotly's ternary plot does not support WebGL, rendering too many points can significantly degrade browser performance. For this reason, we do not display the data when it exceeds the threshold (6000 points). Unless it is supported by Plotly in the future, we will not be able to display very large data in the ternary plot.
• New
  • Add a new option Show single or binary systems in the Property Diagram to allow data points where one or two axes are zero to be included, making compositions along the edges or corners of the diagram visible.
• Improvements
  • Sort the compositions (Component, Mol%, Wt% columns) in the Calculation Result by Wt% value in descending, so the most abundant component by weight appears first.
  • Minor size adjustment for the Property Predictor and Calculation Result.
  • Improved virtual scrolling in the Detail Card (Table view) for smoother performance with large tables.
  • Make the percentage check in the Property Diagram more tolerant, so that it can handle cases where the sum of the components is not exactly 100% (e.g., 99.9999%).
  • Add more description for the Complex mode (pseudo-ternary) option in the Property Diagram.
  • Updated the Complex mode (pseudo-ternary) logic: when multiple components are grouped into one axis (e.g., A = SiO2+Al2O3), the entire group is treated as a whole. As long as the sum of the group is greater than zero, it meets the condition, even if individual components are missing or zero.
  • Automatically switch to exponent notation for values smaller than 1e-6 to avoid displaying them as 0 in plots.
• Bug fixes:
  • Fixed an issue with URL encoding of component names containing + characters (e.g., Na2O+K2O in Collection) in Search for Glasses.
  • Fixed an issue where the composition name is not reset when switching between Mol/Wt% and At% after using the Clear button in the Property Diagram and in Search for Glasses.
• Data correction:
  • Correct typo of the group property Srtess-optic coef. in the original database, which should be Stress-optic coef.. 147 entries are corrected.
  • Corrected incorrect display of some group properties (T_g, M_g, and T_liq). 287 entries are corrected.

0.6.0 May 23, 2025

• Improve user authentication process
  • Brand-new login UI. (already introduced in v0.5.0)
  • Prevent user registration with free email accounts on the registration page to reduce administrative workload.
  • Add an automated role assignment process during the first login for users with email domains from trusted universities, institutes, or companies.
  • Migrate the Keycloak client type from confidential to public and decouple the backend from user authorization. The authorization flow is now handled by Keycloak.
  • Starting with Keycloak 26, user sessions are persistent. Users are no longer logged out after our system updates/maintenance.
• API key usage is changed, please refer to the API introduction for the latest instructions.
• Added two new API endpoints for retrieving multiple spectral data and multiple glass formation data. Thanks for the user feedback.
• Fixed an issue that may occur when switching between Scatter and Histogram plots with axis swapping button clicked.
• Added more information to the Result Card (Visualization view) section.
• Internal
  • Bump frontend/backend packages to latest version.
  • Use Redis to share memory between workers for ratelimit control.

0.5.4 March 4, 2025

• Fixed an issue where the Young's modulus, shear modulus, and microhardness did not display values when the unit was GPa.

0.5.3 February 13, 2025

• Remove unnecessary Legend Groups and Display controls in Result Card (Visualization view). Legend Groups will be reintroduced in Result Card (Visualization view) once new data sources (e.g., commercial glasses) are added, as they are only necessary when multiple data sources exist.

0.5.2 February 10, 2025

• Tiny bug fix.

0.5.1 January 28, 2025

• The Scroll snap control checkbox is now OFF by default. Page will no longer auto-scroll to sections. You can turn it back ON in Settings→Appearance→Scroll snap control if needed.
• The VFT curve fitting equation has been removed from the Result Card (Visualization view) and is now only visible on the Detail Card (Visualization view).
• The x-axis is now reversed by default when plotting Abbe diagram (x: Abbe's number, y: refractive index n_d at 20°C) in the Result Card (Visualization view).
• Fixed an issue with unwanted page zooming on iOS devices.
• Corrected a typo in property names in Calculation Result and Property Predictor.

0.5.0 January 16, 2025

• New
  • Brand-new UI with improved UX and accessibility.
  • History function (session only), which can be used to quickly open previously opened tables from the Detail Card (Table view) section.
  • Sharing search results via URL.
  • Advanced search controls (Filter) for table data.
  • Data visualization using Ternary Plot chart type in Result Card (Visualization view) and Detail Card (Visualization view).
  • Grid/List/Plot view of predictions in Property Predictor.
  • Download raw data as CSV/Excel from Spectral plot from the modebar.
  • Fullscreen mode via the modebar in all plot types.
  • Calculation Result is now in sidebar that can be reopened by clicking on the Calculation Result button.
  • Opening table or calculation result directly from the plot in Property Diagram, Result Card (Visualization view), and Detail Card (Table view).
    • Double-clicking on data point to open calculation result
    • Right-clicking on data point to open a context menu with options of open calculation result and open table.
  • Notification center feature that provides a convenient way for users to view notifications such as system updates, events, and maintenance alerts.
  • Setting center feature to the profile dropdown menu that allows users to configure some settings.
  • Copy Code (Developer mode) feature that provides a convenient way for users with API access to copy the Python code generated from search criteria from web UI.
• Data correction:
  • Correct several hundred typos in the Patent Index and remove 883 entries with incorrect/duplicate data in the original database.
• API changes: Please refer to the latest API endpoint pages.
• Bug fixes:
  • Fix query timeout issues when searching with atomic %.

0.4.2 August 07, 2024

• UI improvements.
• Support for displaying calculation results of glasses by clicking on the GNo (Glass No) in the Detail Card (Table view) and Result Card (Table view).
• Support for request caching on the website for faster response and speed.
• Rename the individual properties of T1~T13 to T1 (logη=1)~T13 (logη=13) for clarity.
• Bug fixes:
  • Fixed a regression bug where the component in Property Predictor won't be updated (internally) after clicking on the cancel button.

0.4.1 August 04, 2024

• Support for displaying all components of glasses even without selecting components in Search for Glasses.
• Data correction:
  • Add missing data for Table ID=44801 {: target="_blank"} when using Search for Glasses, four glasses added.
  • Correct 2360 entries of wrong glass number ranges internally in the original database, which could return incorrect results when searching with Search for Tables.
• Bug fixes:
  • Fixed a regression bug where the search for some components (in Collection) in Search for Glasses gave an error or an empty result.
  • Fixed a regression bug where the page title wouldn't update when opening a table using Table by Number.
  • Fixed the issue of possible duplicate requests that may occur during page navigation or browsing.

0.4.0 July 26, 2024

• New important feature: API Key and API documentation added.

• New feature: Property Diagram.

• Support for searching with atom names:

  • Add a new card Search Options in Search for Tables.
  • Add Atomic % option in Kind of % card in Search for Glasses.

• Support for opening tables that are displayed in Result card in a new tab or a new window.

• Update Property Predictor:

  • Property of logη at X°C (log viscosity at X°C) has incorrect value since v0.3.0, it is now corrected. Thanks to user feedback!
  • Add a fullscreen button next to the close button.

• Update export function:

  • Support for exporting table (result) in CSV format (additional option), default is Excel.
  • Update the position of the table header tooltip to the row above the table header in both Excel and CSV.

• Set default filename when downloading plots as png from:

  • Glass Formation plot: table-{table_id}-glass-formation.png
  • Spectral plot: table-{table_id}-spectra.png
  • Detail Card (Visualization view): table-{table_id}.png

where {table_id} is the Table ID.

• Adopt a uniform rule to display header names with units in the table.
  • Update the superscript style of the units (e.g., change ^-1 to ^-1).
  • Use a comma followed by a space (e.g., change T,°C to T, °C).
• Add a function to copy the Table ID by clicking on it in the Detail Card (Table view) section.
• Add a Notes column in Patent Index.
• Data correction:
  • Correct dozens of entries with missing atoms in the original database.
  • Add missing Atomic% data for atoms of Tc, Re, Np, and Pu in the original database and update the composition of the affected 35 glasses.
  • Update 179 reference titles.
  • Update description text of 22 tables that contain redundant information.
  • Update names in Country column in Patent Index to make it shorter:
    • United States of America to US
    • United Kingdom to UK
    • German Democratic Republic to DDR
    • Korea, South to South Korea
    • OAPI - African Intellectual Pr (should be African Intellectual Property Organization) to OAPI
  • Update name in Properties column in Patent Index, as the comma between the various properties is missing for hundreds of entries.
  • Remove extra , (comma) at the end of Properties column in Result Card, 679 entries updated.
  • Correct the density value of GNo (glass number) = 606816 in Table ID = 11280, which should be 1.90 instead of 1.80 for the heat treatment condition 750°C, ≈2 kbars.
  • Correct the density value of GNo (glass number) = 421754 in Table ID = 34609, which should be 2.422 instead of 4.422.
  • Correct the density and refractive index value of GNo (glass number) = 493171 in Table ID = 42511, and GNo= 610518~610521 in Table ID=44747, where the density and refractive column should be exchanged.
• Bug fixes (list only important fixes):
  • Fixed a bug in plot hover info and legend display when grouping with the glass number for some data types.
  • Fixed a bug where the modal is not closed when the browser navigates back and forth.
  • Enter 0 in the Min fields of the Component card of Search for Glasses to indicate that the component can be absent did not work, now this issue is fixed.
• UI improvements, and page loading time optimization.
• Optimize the search performance slightly by indexing.

0.3.1 June 11, 2024

• Support for opening a specific table via the URL: https://sciglass.uni-jena.de/database?tableid=id, where id( integer) is the Table ID displayed in Result Card.

For example, https://sciglass.uni-jena.de/database?tableid=44923 {: target="_blank"} will open table with Table ID=44923.

!!! note

     Deprecated since v0.4.0, use `table_id` instead of `tableid` due to the new naming convention.

• Support back and forward navigation with the browser's navigation buttons across different opened tables.

0.3.0 June 10, 2024

• New feature: Property Predictor with GlassNet integrated.
• Correct 152 missing glass compositions in the original database, so that they can now be searched via the Search for Glasses function.
• Correct 150 glasses containing Au (gold) as the values of Au were originally missing.
• Make the scrollbar in the sidebar thin (when it overflows) and support the touchscreen to unhide the sidebar for smaller screens (<1024px).

0.2.6 June 02, 2024

• Correct wrong unit of logρ at X°C ** (Electrical resistivity), which should be **Ohm·cm by default, not Ohm·m.

0.2.5 May 29, 2024

• On smaller screens (<1024px), the icon and text of the function in the sidebar will be shown, and the tooltip will be hidden.

0.2.4 May 08, 2024

• Improve the handling of error messages in the frontend.

0.2.3 May 06, 2024

• Due to a bug in the Firefox browser, the scroll-snap effect is disabled when using Firefox.

0.2.2 May 03, 2024

• Improve the readability of the tooltip when hovering over the data points in the plot.
• Make the number of atoms in the chemical formula as subscript (e.g., B2O3 → B₂O₃) when visualizing a table.

0.2.1 April 22, 2024

• Internal: Fixing issues with some component names with special characters (e.g., +, (, )) that need to be escaped.
• Fix missing results for the Collections group in the Component area of searching for glasses.
• Remove some components that actually have no results.
• Fix overflow issue caused by the selected components/property hints.

0.2.0 April 17, 2024

• Add Search for Glasses function:
  • Include components and user-defined min/max concentration values (mol% or wt%) for the search.
  • Exclude components for the search.
  • Include individual standardized properties or group properties for the search.
• Add search composition by analysis filter to both Search for Tables and Search for Glasses.
• Add a toggle button in System to search for glass systems that exactly match the selections.
• Add a radio button in System Type to ignore impurities < 0.5 wt% or to consider them as compositions.
• Add fullscreen function to the Result Card (Visualization view) section when searching for glasses, and Detail Card (Visualization view) section.
• Correct erroneous data in the original database.
• UI improvements.
• Improved query performance in the backend (but the database is not yet optimized for speed).
• Add web API Rate Limit restriction due to limited resources in the beta test phase.

0.1.1 March 01, 2024

• Public access.
• Add tooltip hint when hovering over the table column name (usually symbols).

0.1.0 February 20, 2024

• Initial release for beta testing.