Q1 2025
- Print
- DarkLight
Q1 2025
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback!
Round up of all releases and updates from January to March 2025 (Q1).
Stats
New source added:
Water Hardness - This dataset details the level of reported water hardness for all UK postcodes
Platform Update
New features on DoordaHost
- More intuitive database structure. New schema structure now lists all snapshots under snapshot and Ledger data under ledger.
- Materialised views/ Current views are essentially query wrappers which means the whole query is executed every time the query runs making it quite slow. This update introduces materialised views which stores the view query data, reducing query time from minutes to seconds.
- “Real-time” Updates to data. Current tables in snapshot and ledger on host are updated once every month. With the new structure, this is now updated when the underlying source updates, rather than a fixed date each month.
- Ledger Structure. The structure has changed from json for all columns to separate columns to make it easier to ingest, the logic remains the same.