Update #62: Week of Oct 19 – Oct 25 (7 changes)

October 25, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Keep the page cache and build cache from filling the shared disk
—Skip production refresh jobs when the shared disk is nearly full
—Keep contact message sections on complete lines

Bug Fixes

—Bound the ISR disk cache under Next 16.4's route-cache directory
—Request the XML media type accepted by PRH
—Apply Finnish filing budget after resolving official dates
—Restore official Latvian feeds and pace Finnish financial imports

Update #61: Week of Sep 28 – Oct 4 (1 changes)

October 4, 2026•Artūrs Krūze

Improvements

—Company and person pages are cached in memory only, not rewritten to disk

Update #60: Week of Sep 21 – Sep 27 (4 changes)

September 23, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Stop the nightly data-quality check from slowing the site for hours
—Forbid bulk extraction of the database in the terms of use
—Read the birth year from partial YYYY-MM birth dates too
—Show only the birth year for people instead of the full date of birth

Update #59: Week of Sep 14 – Sep 20 (1 changes)

September 16, 2026•Kristaps Krūze

Improvements

—Hide the Real Estate search tab until the index is populated

Update #58: Week of Aug 24 – Aug 30 (1 changes)

August 29, 2026•datreal-deploy

Improvements

—Move to /srv/projects/datreal.com and dedicated datreal-deploy user with forced-command key

Update #57: Week of Jul 13 – Jul 19 (3 changes)

July 15, 2026•Artūrs Krūze

Improvements

—Lazy ISR eviction: skip walks while under cap, 10-min scan cadence
—ISR admission circuit breaker + DB pool headroom + mysql2 trace off
—Render PDFs in a killable bun child process

Update #56: Week of Jul 6 – Jul 12 (16 changes)

July 11, 2026•Artūrs Krūze

Improvements

—Bound graph API caching: 1h edge TTL instead of Cloudflare's 12h default
—Homescreen icons: white background with padded logo
—Favicon: new hexagon mark with rounded corners and cut-in chevron
—Remove FI registered-notices (KREK) import step
—Favicon: shift chevron to right-center, thick rounded line
—Favicon: thinner chevron, point shifted right
—Favicon: slimmer chevron with longer arms
—New favicon: green hexagon with white chevron
—Add co-tenant uptime watchdog (eloking, book.wake-up.lv)
—Harden deploys + monitoring: watchdog auto-heal, through-nginx verification, deeper health checks
—LV VAT import: dedupe registration periods
—VAT numbers: stop presenting deregistered numbers as active (all countries)

Bug Fixes

—Remaining relationship-graph defects across countries
—Mobile search not focusing the input (keyboard) on open
—Relationship graph resolving to a stranger who shares the masked code
—OFAC download hang (Bun.write on redirected response) + TED per-country isolation

Update #55: Week of Jun 29 – Jul 5 (68 changes)

July 5, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—RotatingCountry: memoize order
—Company page: consolidate warnings into one severity-tiered block
—Person page: professional sanctions warning with listing details + official source links
—RotatingCountry: animate slot width so the following text slides
—RotatingCountry: GPU-composite the animation (fix lag)
—RotatingCountry: smoother fade + vertical slide animation
—Homepage hero: widen description/search so it's always 3 lines
—Homepage hero: dynamic country width + reserved paragraph height
—Homepage hero: fix {country} in meta description + rotating-word gap
—RotatingCountry: reserve widest word width to stop layout shift
—Homepage hero: rotate the country inline inside the description
—Homepage hero + localized rotating country, SEO titles, UI work
—RotatingCountry: localize the country word per display language
—RotatingCountry: add alwaysRotate for body-copy use (breadth line)
—Homepage title: keyword-rich, language-aware (was a brand slogan)
—Cron: rebuild sitemaps nightly (they were frozen since the last manual run)
—Person/company not-found: noindex to de-index dead URLs
—Sync-people: preserve person id across re-keys (stop URL churn)
—Sitemap: list only populated person id-ranges
—Sitemap: add person profile pages
—Sitemap index: emit accurate per-child lastmod (drop always-today)
—LV self-employed (MUN register): company pages for physical persons
—Sanctions screening: add US OFAC SDN feed, fix overclaiming copy
—SE flushes: drop stale temp tables before CREATE (crash-loop hardening)
—Runbook: FI XBRL re-parse complete (45.2k statements, 27.1k with data)
—Contact suggestions: persist, verify, and auto-apply safe ones
—Live search in the search box: top 3 matches at 3+ characters
—Geo redirect: send Finnish visitors to /en/fi
—Runbook: drop manual sync-people (nightly Phase 2.5 covers it), add FI timing note
—Registry hygiene: align source-registry with what importers actually write
—5.3: wire orphaned datasets or mark them explicitly skipped
—LV: farm land
—SE: merger + ackord events from the Bolagsverket bulk
—LT: VKC named officers importer
—FI: persist the bulk-file fields we always downloaded but dropped
—SE: postal codes, secondary SNI activities (Ng2-5), bifirma trade names
—EE: real officer appointment dates + kmkr_nr VAT numbers
—LV: read the columns that actually exist in insolvency + liquidation CSVs
—SE: map balance total + material costs
—LT: map BSLT00393 tangible fixed assets
—FI XBRL parser: handle default-namespace filings + mixed expense signs
—FI: self-heal the XBRL date index
—Nightly: partial download failures degrade instead of killing the country
—EE: extract labour costs, employees, non-current lines from annual-report elements
—Marriage importer: fix pager stride skipping ~60% of records
—FI: parse XBRL via the real dimension model
—Marriage register: import LV laulāto mantisko attiecību announcements, show on person profiles
—Add extraction-gap fix plan from 5-country source audit
—SE: extract 8 more concepts from iXBRL
—SE: extract officers from annual-report signatures (as-of dated)
—SE: import Bolagsverket business descriptions (verksamhetsbeskrivning)
—Remove /top leaderboard pages
—Footer: link the top-companies leaderboard pages
—Monitoring: rebuild health-check + disk monitor for Docker, wire to cron
—Refresh wrappers: alert on failure, add lv-excise flock, gate success spam
—Refresh: fix eval ~2h post-work hang + add timeout backstops
—Refresh: resilience + make silent/degraded failures visible
—Add net salary, country-wide top pages, and quarterly VID tax data
—Country-generality: single source for country list + registry/tax links
—Security: rate-limit expensive endpoints, fix IP key, cap container memory
—Sanctions: replace OpenSanctions with the official EU FSF list
—Company page: surface FI Vero tax-reported income (separate from financials)
—LT financials: make flush non-destructive (COALESCE), fix 304-with-missing-file
—LT downloads: stream to disk (fix 2 GiB ArrayBuffer truncation)
—LT financials: fix line-code mapping so values actually land
—FI financials: ingest Vero tax-reported income (covers the ~95% with no XBRL)
—LV financials: stop NULL source_type duplication (42M→~600k rows)

Bug Fixes

—Duplicate <main> landmark on company/search/industry pages

Update #54: Week of Jun 22 – Jun 28 (15 changes)

June 26, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Valuation: disclose enterprise value (rescues the leveraged "€0 equity" case)
—Update @sentry/nextjs 10.60 → 10.61
—Valuation pages: make them indexable (crawlable, sitemap, ISR, structured data)
—Company summary card: add "View valuation" CTA
—SE financials: one-shot seed wrapper + don't checkpoint empty imports
—Changelog: biome formatting for gap-fill patch
—Changelog: auto-fill gaps before late curated entries
—Use real Swedish companies as homepage search examples
—More complete and reliable company data updates across all countries

Bug Fixes

—SE refresh: tolerate corrupt arsredovisningar bundles
—SE financials: drop `--` from inner unzip (breaks on Alpine BusyBox)
—SE financials: parse ALL iXBRL docs per filing, not just the first
—SE financials: parse UPPERCASE iXBRL context ids (PERIOD0/BALANS0)
—Build: mapbox-gl 3.25 GeoJSONFeature.properties type break in map-container
—Public procurement awards: complete history, correct values, currency and dates

Update #53: Week of Jun 15 – Jun 21 (6 changes)

June 21, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—TED procurement: company-page section + i18n + weekly cron
—TED public-procurement awards
—SE insolvency/liquidation events from existing bulk (reuse existing tables)
—Add Sweden (SE) support end-to-end
—Deploy: clear hash-prefixed container leftovers in remove_container
—Add personal-code search for people (LV birth-date prefix, EE isikukood)

Update #52: Week of Jun 1 – Jun 7 (7 changes)

June 5, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Skip-test the cleaned changelog message so user-facing commits with internal riders publish
—Regenerate changelog at image build time so the public changelog advances
—Add industry salary leaderboards + salary position cards
—Document the zero-downtime deploy process + prod warnings for agents
—Move blue-green candidate to :3015 (:3006 is the co-tenant book-wake-up stack)
—Make deploys zero-downtime (blue-green) so a transient swap can't 502 the site
—Add Feature Request widget

Update #51: Week of May 25 – May 31 (11 changes)

May 27, 2026•Artūrs Krūze

Improvements

—Harden deploy app-swap against transient failures + capture diagnostics
—Cluster people by individual_id to stop EE name-collision over-merge
—Schedule OpenSanctions screening in the nightly cron
—Add sanctions-screening FAQ to person profiles
—Serialize deploys with an flock to stop false health-timeout alarms
—Resolve subsidiaries by counterpart_regcode, not the empty FK
—Show EU funding in readable compact form (€13m not €13021k)
—Self-heal app recreate and cap ISR cache to stop deploy 502s
—Dedupe LV/EE detail tables and lock down with unique keys
—Stop LV refresh from duplicating EU funding rows

Bug Fixes

—Correctness, security, and resilience issues from max code review

Update #50: Week of May 18 – May 24 (2 changes)

May 23, 2026•Artūrs Krūze

Improvements

—Make deploy.sh resilient to docker recreate-rotate bug
—Make EE chain survive container deaths and torn-zip extracts

Update #49: Week of May 11 – May 17 (6 changes)

May 15, 2026•Artūrs Krūze

Improvements

—Stop CDN-caching the agent markdown rewrite
—Install py3-ijson in runner image so EE extractors work
—Use match_phrase_prefix on the nospace field
—Make company search space-insensitive and typo-tolerant
—Cap ISR disk cache at 200 GiB via custom CacheHandler
—Add python3 to runner image for EE registry extractors

Update #48: Week of May 4 – May 10 (21 changes)

May 10, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Add Hetzner deployment infrastructure
—Add PDF engine, expand search filters, csc_last_year_roe, dep bumps
—Ignore generated data/sitemaps/ in git
—Move locale-aware layout out of root to enable edge caching
—Use pm2 reload in deploy.sh to avoid manifest race after build
—Pre-build sitemaps to disk with incremental, throttled refresh
—Expose compliance, officers, and taxPayments on public company API
—Throttle AI bots and disallow /search in per-bot robots blocks
—Add public API endpoint for recent company tax payments
—Force /vs/* hero side-by-side via min-w-0 + clamp width, larger gaps
—Always show /vs/* hero video side-by-side, bump sizes
—Apply biome formatter pass to vs hero video changes
—Add auto-scroll videos to /vs/* hero + lower side-by-side breakpoint
—Dismiss cookie banners before capturing /vs/* hero screenshots
—Convert /vs/* hero screenshots to WebP + lazy-load
—Add competitor homepage screenshots in /vs/* hero (right side, lg+ only)
—LT/EE/FI translation quality pass on /vs/* pages
—Apply biome formatter pass to /vs/* pages
—Roll out 10 new /vs/<competitor> comparison pages plus 5-locale support across all 12
—Add /api-solutions hub + category pages with matrix-rain hero, /vs/* comparison pages, OAuth-protected-resource and shareholders endpoints, and a sticky-on-scroll transparent header for hero pages.

Bug Fixes

—OpenSearch deep-pagination crash loop in sitemap and search

Update #47: Week of Apr 20 – Apr 26 (3 changes)

April 25, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Drop unstable_cache for high-cardinality keys to stop fetch-cache inode growth
—Add deploy.sh + ignore importer state to keep prod git clean
—Add business-partners block on person pages + housekeeping

Update #46: Week of Apr 13 – Apr 19 (33 changes)

April 19, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Rebuild NACE industry picker + fix biome config + ignore auto-commits
—Update commits.json and auto-entries.json
—Harden changelog filter against internal / data-quality leakage
—Swap blanket data/ ignore for narrow rules
—Add sanctions, commercial pledges, registry rulings, search improvements
—Add EE data importers: contacts, pledges, liquidations, revenue splits
—GEO/SEO improvements: structured data, robots.txt, FAQ, i18n updates
—Add person profit-share look-through and EE counterpart identity
—Add hyphen-tolerant match clause to company search queries
—Add FAQ schema and visible FAQ section to person pages
—Restyle role mix with individual bars per role
—Add dynamic OG image for person pages
—Improve person page SEO metadata
—Link officer/shareholder/owner names to person pages on company profiles
—Remove uppercase headers
—Remove filler description text from person hero header
—Restyle stats as single card with divide-x columns
—Lighten sidebar colors
—Improve semantic HTML and structured data on person page
—Add i18n translations for role labels across all locales
—Translate position labels and use consistent badge styling
—Increase vertical gap in company details grid
—Move financials into details grid alongside reg nr and dates
—Restructure company rows with proper grid layout
—Match person timeline to company timeline pattern
—Restyle person page to use CollapsibleSection + InfoRow patterns
—Add business owner wealth ranking to person profile
—Redesign person page with dark sidebar, role mix, and dividend estimate
—Link person search results to person profile pages
—Add person profile page with company roles, financials, and timeline

Bug Fixes

—LV masked-ID birth year landing in the future
—Person page breadcrumbs
—Wealth ranking to compute ownership from shares/capital

Update #45: Week of Mar 30 – Apr 5 (8 changes)

April 3, 2026•Artūrs Krūze

Improvements

—Add country switcher to company map page
—Make company map work for LV, LT, and EE instead of Latvia only
—Improve cold search query performance
—Display legal forms as "Translated name (Local name)" with Estonian support

Bug Fixes

—Person graph to show hierarchical company relationships instead of flat
—Recently viewed companies using wrong country URL when navigating across regions
—Double LT- prefix on Lithuanian postal codes
—Comparison basket using wrong country when navigating across regions

Update #44: Week of Mar 23 – Mar 29 (1 changes)

March 26, 2026•Artūrs Krūze

Improvements

—Add city, region, and postal code extraction for EE and LT companies

Update #43: Week of Mar 16 – Mar 22 (3 changes)

March 22, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Restore company person birth dates across ownership and management
—Update app and data tooling

Bug Fixes

—Search/browse sorting: active first, NULLs last

Update #42: Week of Mar 9 – Mar 15 (6 changes)

March 13, 2026•Artūrs Krūze

Improvements

—Search and data architecture
—Add optional country filter to public company details API
—Add keyboard navigation for search results
—Company details copy
—Footer status changelog

Bug Fixes

—Filter values being cleared when changing country/status/NACE

Update #41: Week of Mar 2 – Mar 8 (1 changes)

March 8, 2026•Artūrs Krūze

Bug Fixes

—Sort search results by status and revenue across all search paths

Update #40: Company Valuation Reports

June 25, 2026•6 commits•Kristaps Krūze, Artūrs Krūze

New Features

—New company valuation report — an estimated company value with a low-to-high range, computed entirely from publicly filed financial statements
—Four valuation methods shown side by side: capitalised earnings (EV/EBITDA), revenue multiple, net asset value, and a discounted cash flow
—Solvency assessment with the Altman Z-score (safe / grey / distress) alongside a full set of financial ratios
—Industry comparison against the sector median for revenue and profit, plus a market-share view ranking the company against same-industry peers
—Download the full valuation as a polished PDF report
—Available in all six languages — English, Latvian, Estonian, Lithuanian, Finnish, and Swedish

Improvements

—Open a company's valuation as a slide-out panel from its page, or visit the standalone valuation page directly via its own shareable link
—Every number is calculated from filed figures — the plain-language summary is the only AI-written part, never the valuation itself

Update #39: Data Expansion & Accuracy Fixes

February 26, 2026•2 commits•Kristaps Krūze

New Features

—Lithuanian company pages now show management structure — CEO, board members, and councils with gender breakdowns
—Full address data for all Lithuanian companies
—Over 312,000 historically deregistered Lithuanian companies added to the database
—Estonian company pages now show tax revenue, employee counts, and tax debt details
—Finnish company data coverage expanded with additional financial details

Improvements

—Lithuanian company pages now display richer legal form and address details
—Faster and more reliable data updates across all countries
—More reliable automatic data updates with better error handling

Bug Fixes

—Fixed incorrect revenue and employee numbers appearing on some company pages and in data exports
—Fixed zero-value financial data being incorrectly replaced with data from other periods
—Fixed data export sometimes showing mismatched figures compared to company detail pages

Update #38: Favorites, Comparison & Country Flags

February 24, 2026•4 commits•Artūrs Krūze, Kristaps Krūze

New Features

—New Favorites system — save companies from any company page and access them from the header star icon dropdown
—New Comparison Basket — add up to 5 companies for side-by-side comparison via the header bar chart icon
—New Company Comparison page with side-by-side financial metrics, ratio analysis, YoY changes, and sparkline revenue/profit trends
—Country flags displayed next to company names in Favorites dropdown, Comparison Basket, and Comparison page headers

Improvements

—Favorites and Comparison dropdowns widened for better readability of long company names
—Polished empty state design for both dropdowns with larger icons and spacious layout
—Export success/error/rate-limit messages now fully localized in all 5 languages

Bug Fixes

—Fixed hardcoded English strings in export status messages that were never translated
—Fixed missing useCallback dependency for translation function in ExportButton

Update #37: Data Export & Advanced Search Filters

February 23, 20260•Kristaps Krūze

New Features

—New data export — download filtered company data as XLSX or CSV with per-country sheets, filter summary, and year-over-year revenue comparison (2022–2024)
—Owners column in exports showing shareholders and beneficial owners for LV and EE companies, with aggregate participant counts for LT
—Redesigned compact search filters panel with all filters visible without scrolling
—New Financial Year filter to find companies with recent financial reports
—New Revenue Year selector to choose which year's revenue to filter on
—Active filter pills showing all applied filters with one-click removal
—Live company count updates as filters change

Bug Fixes

—Fixed export using stale filter state instead of current input values
—Fixed filter dialog closing mid-export before the download completes

Update #36: Company Page SEO & Dependency Updates

February 12, 2026•1 commits•Kristaps Krūze

Improvements

—Company page meta descriptions are now translated into all 5 languages instead of being hardcoded in English
—OpenGraph descriptions now use locale-aware translations for better social sharing in local languages
—Meta descriptions now include company name, registration number, legal form, and address for richer search snippets
—Updated 9 dependencies to latest versions including puppeteer, drizzle-kit, and type definitions

Bug Fixes

—Fixed salary comparison bar displaying literal 'common.company' instead of the actual company name

Update #35: Sick Leave Calculator & Translation System

February 3, 2026•10 commits•Kristaps Krūze

New Features

—New Sick Leave Pay Calculator with accurate 2026 formulas for Latvia, Estonia, Lithuania, and Finland
—Visual comparison showing income loss between healthy and sick days
—Daily breakdown table showing who pays (employer vs state) for each day of leave
—Automated translation verification after deployments

Improvements

—All calculator pages now show country name in SEO titles (e.g., 'Sick Leave Calculator 2026 - Latvia')
—All 5 calculators now share standardized UI components (ResultCard, ToggleButtonGroup, Disclaimer)
—Topic clusters now link all calculators together for better navigation

Bug Fixes

—Fixed missing translation key 'salary.grossSalaryLabel' that was showing as raw text on salary calculator

Update #34: Calculator UX Improvements

February 2, 2026•3 commits•Kristaps Krūze

Improvements

—Calculator labels now use consistent first-person form across all calculators (salary, unemployment, dividend, maternity) in all 5 languages
—Updated jsdom to v28.0.0 with improved CSS selector engine and better spec conformance

Update #33: Maternity & Parental Benefit Calculator

February 1, 2026•6 commits•Kristaps Krūze

New Features

—New Maternity & Parental Benefit Calculator with accurate 2026 formulas for Latvia, Estonia, Lithuania, and Finland
—Monthly payment breakdown showing each benefit phase over the entire leave period
—Country-specific options: Latvia extended leave and parental duration choices, Lithuania 1-year vs 2-year comparison
—Helpful tooltips explaining maternity vs parental benefit differences

Update #32: Server Stability Improvements

January 31, 2026•7 commits•Artūrs Krūze

Bug Fixes

—Fixed nightly data updates failing to complete correctly
—Stuck update jobs are now automatically detected and recovered

Update #31: Dividend Calculator & Unemployment Updates

January 29, 2026•33 commits•Artūrs Krūze, Kristaps Krūze

New Features

—New dividend tax calculator for Latvia, Estonia, Lithuania, and Finland
—Latvia: Toggle between standard (20% CIT) and alternative (15% CIT + 6% PIT) regimes
—Finland: Support for listed vs unlisted companies with progressive capital gains tax
—Card-style result display with expandable tax breakdown details
—Region-specific info text now displays correct unemployment benefit details for each country when switching tabs

Improvements

—Comprehensive FAQs explaining each country's dividend tax rules
—Added dividend calculator to sitemap and calculators index page
—Topic cluster links between salary, unemployment, and dividend calculators
—Updated unemployment calculator with accurate 2026 laws for all 4 countries (Latvia, Estonia, Lithuania, Finland)
—Estonia: New 60%/40% two-phase benefit rates with experience-based duration (180/210/300 days) and min/max caps
—Latvia: Phase-based reduction (100%→75%→50%→45%) with €224.40 minimum benefit
—Lithuania: Updated minimum wage (€1,153), new min/max benefit caps (€350-€1,405.45)
—Finland: Updated deduction rate to 3.83%, tiered reduction at 80%/75%
—Added 'What changed in 2026?' FAQ question for each country explaining the key 2026 reforms
—All FAQ answers now include specific percentages, amounts, and calculations for accuracy

Bug Fixes

—Fixed Latvia standard regime calculation (was 25% effective, now correct 20% on gross)
—Fixed Latvia alternative regime to apply 6% PIT on dividend after CIT deduction
—Removed abolished Estonia defense tax from calculation and all content
—Fixed conflicting info text and FAQs that still referenced old Estonia defense tax
—Fixed contradicting text where FAQs showed outdated percentages (50-60%) inconsistent with info text (60%/40%)
—Fixed Latvia FAQ that incorrectly stated 4/6/9 months duration instead of 8 months
—Fixed Estonia FAQ that vaguely said '50-60%' instead of the correct 60% then 40% rates

Update #30: Changelog Overhaul, Code Cleanup & Design Consistency

January 28, 2026•13 commits•Kristaps Krūze, Artūrs Krūze

New Features

—Changelog page overhaul with author avatars and GitHub profile links
—Curated human-readable changelog entries replace raw commit messages
—Dynamic commit counts and author extraction from git history
—JSON-LD Blog and BlogPosting schemas for changelog SEO
—Company FAQ now includes founding date and ownership information
—Changelog link added to website footer with translations in 5 languages

Improvements

—Comprehensive UI consistency audit: standardized typography, borders, colors, and spacing across all pages
—Faster initial page render with optimized Hero component
—Redesigned changelog layout with cards, author avatars, and consistent typography

Bug Fixes

—Fixed inconsistent filter button styles - country/status filters now use same pattern as calculator tabs
—Fixed several data processing issues that could cause missing or incorrect company information
—Fixed Latvian data update issues
—Fixed scroll hijacking issue where changelog sidebar navigation affected main page scroll

Update #29: Calculator Redesign & Search Filters

January 27, 2026•17 commits•Artūrs Krūze, Kristaps Krūze

New Features

—Enhanced salary calculator with improved UI, accessibility, and SEO
—Search filters now serialize to URL parameters for shareable, bookmarkable searches
—NACE code filter detection from URL params with visual badge count
—K/M/B notation support in financial filter inputs (e.g. '5M' = 5,000,000)

Improvements

—Updated filter presets with practical ranges: Revenue 1M-100M, Profit 100k-10M, Employees 50-1000
—Auto-select 'all' when all 4 countries are selected in multi-country filter
—Consistent card styling across all company page sections

Bug Fixes

—Fixed missing taxBookInfo translations in all 5 language locales
—Fixed database optimization not running during scheduled updates
—Resolved all code quality warnings across the codebase
—Fixed table name references and removed unused ts-expect-error directives
—Fixed clear input to only clear text field, not close the modal

Update #28: Internationalization, Search & Performance

January 26, 2026•4 commits•Kristaps Krūze

New Features

—Search filters now support NACE code search with autocomplete
—Multi-country selection in search filters for cross-border company discovery
—Live formatting preview as you type in financial filter inputs
—New calculators index page for all 5 supported languages
—Complete translations implemented and message files split by domain for easier maintenance

Improvements

—Updated fast search page with country-agnostic shortcuts and dynamic locale URLs
—Search now queries all regions by default instead of just URL region
—Faster mobile search animations with smaller page size

Bug Fixes

—Fixed calculator translations and footer region detection
—Fixed translation key resolution for server-rendered components
—Removed hardcoded Latvian text from expandable table rows
—Synced all i18n keys across locales and added Finnish (FI) country support
—Fixed company page styling inconsistencies
—Added missing translation keys for ROE label and view full analysis
—Fixed analytics computation not running after data updates
—Fixed scheduled data update configuration

Update #27: Database Optimization & Setup Simplification

January 25, 2026•9 commits•Kristaps Krūze

New Features

—Improved database performance through better maintenance routines

Bug Fixes

—Fixed some Estonian industry codes appearing without proper English labels

Update #26: Finland Integration & Analytics

January 24, 2026•26 commits•Kristaps Krūze

New Features

—Full Finland (FI) data integration with 2026 tax rates
—Industry code search is now 10-100x faster
—Industry percentile rankings show how companies compare within their sector
—Company risk assessment badges based on financial indicators

Bug Fixes

—Various setup and configuration fixes for smoother operation
—Updated year references to 2026

Update #25: SEO 2026 & Industry Pages

January 23, 2026•9 commits•Kristaps Krūze

New Features

—SEO 2026 updates: freshness signals, AI snippet optimization, enhanced schema markup
—Industry pages with comprehensive sector data
—Disclaimer page now covers Estonian and Lithuanian data

Bug Fixes

—Fixed stray ] causing syntax error in global-breadcrumbs
—Removed lighthouse report files from repo

Update #24: Multi-Region Support & Search

January 22, 2026•2 commits•Kristaps Krūze

New Features

—Added Finnish (FI) region support with full company data
—Improved Estonian company data quality and coverage

Improvements

—Unified region handling across the entire platform for consistent UX
—Better URL routing for multi-region company pages
—Updated framer-motion and mapbox-gl dependencies

Bug Fixes

—Fixed translation errors in calculator and common components
—Improved translation consistency checks

Update #23: SEO Schema Implementation

January 20, 2026•2 commits•Artūrs Krūze

New Features

—FAQ schema markup (FAQPage) for company pages to appear in rich search results
—Enhanced Organization schema with detailed company metadata
—BreadcrumbList schema for proper navigation structure in search results

Improvements

—Improved structured data across company and industry pages
—Better meta descriptions generated from company data

Update #22: Company Page Redesign

January 19, 2026•3 commits•Artūrs Krūze

New Features

—New company page hero section displaying key financial metrics at a glance
—Tabbed navigation for easier access to company sections (Overview, Financials, People, etc.)

Improvements

—Consistent card styling across all company page sections
—Mobile-responsive company sidebar that collapses on small screens
—Improved loading states with skeleton placeholders

Update #21: Fast Search & Interactive Maps

January 18, 2026•9 commits•Artūrs Krūze

New Features

—Lithuanian (LT) support added to fast search for instant company lookup
—Public API endpoint for address autofill functionality
—Interactive municipality map for Latvia with drill-down to local company data

Improvements

—Municipality map UX improvements with pointer cursor and cleaner detail views

Bug Fixes

—Fixed net_income column reference for profit calculations in company search
—Various search UI improvements for better usability

Update #20: Latvia Map & Analytics Integration

January 17, 2026•14 commits•Artūrs Krūze

New Features

—Interactive Latvia company map with municipality-level detail pages
—Dynamic Open Graph (OG) images generated for company link previews on social media
—Google Analytics GA4 integration with enhanced e-commerce and user behavior tracking

Improvements

—Added comprehensive README with local setup and map data instructions

Bug Fixes

—Fixed analytics tracking configuration

Update #19: Lithuanian Data Integration

January 16, 2026•6 commits•Artūrs Krūze

New Features

—Full Lithuanian company data now available
—Real VAT numbers for Lithuanian companies
—Lithuanian data updates automatically with nightly refreshes

Improvements

—Improved handling of large Lithuanian financial datasets

Update #18: Security Patch

January 8, 2026•1 commits•Artūrs Krūze

Bug Fixes

—Critical security vulnerability patched in authentication flow

Update #17: SEO Maintenance

December 23, 2025•1 commits•Artūrs Krūze

Bug Fixes

—Fixed sitemap generation to include all company pages correctly

Update #16: Server Reliability

December 9, 2025•2 commits•Artūrs Krūze

Improvements

—Configured server auto-restart for improved uptime

Update #15: API & Fast Search Launch

December 2, 2025•4 commits•Artūrs Krūze

New Features

—Fast search functionality with instant typeahead results
—Public API documentation page for developers

Bug Fixes

—API security hardening with rate limiting and input validation

Update #14: Stability Improvements

December 1, 2025•11 commits•Artūrs Krūze

Bug Fixes

—Multiple bug fixes for improved application stability
—Code cleanup and lint error resolution

Update #13: SEO Improvements

November 30, 2025•11 commits•Artūrs Krūze

Improvements

—Enhanced SEO meta tags for better search engine visibility
—Improved page titles and descriptions

Bug Fixes

—Multiple stability and rendering fixes

Update #12: Brand Transition

November 26, 2025•1 commits•Artūrs Krūze

Improvements

—Rebranded from DocScan to DatReal across all platform touchpoints
—Updated logos, favicons, and meta information

Update #11: Performance & Search Fixes

November 25, 2025•7 commits•Artūrs Krūze

Improvements

—Performance optimizations across search and company pages

Bug Fixes

—Fixed person search functionality returning incorrect results

Update #10: AI Chat & UI Standardization

November 24, 2025•36 commits•Artūrs Krūze, Kristaps Krūze

New Features

—AI chat integration for interactive company insights and Q&A with message history
—Full-featured chat widget with expand/collapse, thumbs up/down feedback, source citations, and image support

Improvements

—Standardized card padding and header styles across all UI components
—Replaced ad-hoc green colors with consistent brand color palette
—Updated chat input with gradient border on hover
—Removed bottom border from 'Vairāk' (More) button
—UI improvements: flat risk badge icons, fixed tooltips, comparison column tooltip
—Improved data processing performance

Bug Fixes

—Fixed UI consistency issues after merge conflicts
—Restored complete chat widget features after branch merge

Update #9: Search Improvements & Rich Snippets

November 23, 2025•32 commits•Artūrs Krūze, Kristaps Krūze

New Features

—Rich snippets schema for enhanced search result appearance
—Desktop search improvements with better autocomplete
—Swipe to switch tabs on mobile for better UX
—Company risk flags in search results
—Added official UR (company registry) link to company pages

Improvements

—Improved search performance
—Navigation fixes and CLS (Cumulative Layout Shift) issue resolved
—Mobile search view improvements
—Improved search accuracy for partial matches
—Added browser-specific search engine setup instructions

Bug Fixes

—Fixed GitHub Actions deployment workflow
—Fixed GitHub deploy configuration
—Fixed search open/close state issue
—Fixed error on fast-search page
—Fixed incorrect fast search page behavior

Update #8: Charts, AI & Mobile PWA

November 22, 2025•31 commits•Artūrs Krūze, Kristaps Krūze

New Features

—Financial charts and graphs for visualizing company performance over time
—Google AI mode for enhanced search and analysis capabilities
—Web App Manifest for PWA (Progressive Web App) support

Improvements

—Comprehensive improvements to search UI and analytics tables
—Major improvements to search, graph matching, and database optimization
—Added progress bar for long-running operations
—Performance optimizations across the platform
—Cached search results for faster repeat queries

Bug Fixes

—Fixed mobile navigation and responsive layout issues
—Fixed mobile search functionality
—Fixed lint errors and UI border radius on mobile
—Style fixes for chart components and tooltips

Update #7: DocScan Launch & Disclaimers

November 21, 2025•20 commits•Artūrs Krūze, Kristaps Krūze

New Features

—DocScan branding and identity
—Free API tier announcement
—Legal notices and disclaimers for data usage

Improvements

—Standardized company component styling - removed emojis, assigned unique icons
—Faster search and page load times
—Improved color palette consistency

Bug Fixes

—Fixed line display issues
—Fixed color inconsistencies across components
—Added additional required disclaimers

Update #6: Homepage Redesign & Performance

November 20, 2025•34 commits•Artūrs Krūze, Kristaps Krūze

New Features

—3D globe visualization on homepage with Latvia focus
—7 additional company data categories now available
—Graph visualization for company relationships

Improvements

—Redesigned homepage and footer with modern, professional styling
—Speed improvements and performance optimizations
—Improved data processing reliability
—Faster initial page loads
—Graph visualization with rounded corners, soft shadows, and full-width canvas
—Standardized colors: replaced non-brand greens, unified dividers
—Refined homepage and footer styling

Bug Fixes

—Fixed data update logging issues
—Fixed excise licenses progress indicator
—Fixed build and code quality issues
—Fixed visual inconsistencies and spacing issues
—Fixed SSL configuration
—Fixed linting errors and improved accessibility
—Fixed SEO meta tags

Update #5: Rebrand to Lur.lv

November 19, 2025•12 commits•Kristaps Krūze

New Features

—Expanded company data with excise licenses, VAT status, and more
—Privacy policy and Terms of Service pages
—Distinct icons for ownership sections

Improvements

—Complete UI rebrand to lur.lv with new navigation design
—Navigation tabs with overflow dropdown for cleaner mobile experience
—Enhanced business activities and equity capital display styling
—Simplified README to essential commands only
—Migrated routes from [regNumber] to [...slug] pattern
—Improved FAQ and Related Companies sections with consistent styling
—Removed extra padding wrapper from financial data tabs

Bug Fixes

—Fixed linting warning and cleaned up footer links
—Fixed accessibility issues in ownership sections

Update #4: Codebase Modernization

November 18, 2025•3 commits•Kristaps Krūze

Improvements

—Improved platform architecture for faster feature development
—Database improvements and UI enhancements

Bug Fixes

—Fixed page rendering issues on some company pages

Update #3: Security & Reliability Hardening

November 17, 2025•12 commits•Kristaps Krūze

New Features

—Professional business registry features for familiar user experience

Improvements

—Significant codebase cleanup and optimization

Bug Fixes

—Prevented SQL wildcard injection vulnerability in search endpoints
—Fixed potential DoS vector via unvalidated search parameters
—Fixed EU funding inflation calculation display
—Fixed database configuration issue
—VAT deregistration status now displays correctly in company UI
—Fixed database connection issues and removed debug logging
—Fixed various code quality issues and data display inconsistencies
—Fixed multiple reliability and performance issues

Update #2: Code Review Implementation

November 16, 2025•5 commits•Kristaps Krūze

Improvements

—Centralized formulas and constants, eliminating duplication
—Improved platform reliability and performance
—Improved type safety with properly typed parameters

Bug Fixes

—Fixed search reset not clearing all filters
—Fixed duplicate results in some search queries
—Corrected card CSS classes for consistent styling
—Fixed tax unit display calculations
—Added missing useEffect dependencies throughout codebase
—Fixed source map errors

Update #1: Initial Public Launch

November 15, 2025•8 commits•Kristaps Krūze

New Features

—Major UI/UX improvements for production-ready launch
—Company search with filters for revenue, employees, and industry

Improvements

—Standardized styling across entire codebase for visual consistency
—Centralized constants and cleaned up package dependencies

Bug Fixes

—Fixed person name formatting for proper display of diacritics
—Removed hardcoded NACE utility functions in favor of database lookups

Update #62: Week of Oct 19 – Oct 25 (7 changes)

October 25, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Keep the page cache and build cache from filling the shared disk
—Skip production refresh jobs when the shared disk is nearly full
—Keep contact message sections on complete lines

Bug Fixes

—Bound the ISR disk cache under Next 16.4's route-cache directory
—Request the XML media type accepted by PRH
—Apply Finnish filing budget after resolving official dates
—Restore official Latvian feeds and pace Finnish financial imports

Update #61: Week of Sep 28 – Oct 4 (1 changes)

October 4, 2026•Artūrs Krūze

Improvements

—Company and person pages are cached in memory only, not rewritten to disk

Update #60: Week of Sep 21 – Sep 27 (4 changes)

September 23, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Stop the nightly data-quality check from slowing the site for hours
—Forbid bulk extraction of the database in the terms of use
—Read the birth year from partial YYYY-MM birth dates too
—Show only the birth year for people instead of the full date of birth

Update #59: Week of Sep 14 – Sep 20 (1 changes)

September 16, 2026•Kristaps Krūze

Improvements

—Hide the Real Estate search tab until the index is populated

Update #58: Week of Aug 24 – Aug 30 (1 changes)

August 29, 2026•datreal-deploy

Improvements

—Move to /srv/projects/datreal.com and dedicated datreal-deploy user with forced-command key

Update #57: Week of Jul 13 – Jul 19 (3 changes)

July 15, 2026•Artūrs Krūze

Improvements

—Lazy ISR eviction: skip walks while under cap, 10-min scan cadence
—ISR admission circuit breaker + DB pool headroom + mysql2 trace off
—Render PDFs in a killable bun child process

Update #56: Week of Jul 6 – Jul 12 (16 changes)

July 11, 2026•Artūrs Krūze

Improvements

—Bound graph API caching: 1h edge TTL instead of Cloudflare's 12h default
—Homescreen icons: white background with padded logo
—Favicon: new hexagon mark with rounded corners and cut-in chevron
—Remove FI registered-notices (KREK) import step
—Favicon: shift chevron to right-center, thick rounded line
—Favicon: thinner chevron, point shifted right
—Favicon: slimmer chevron with longer arms
—New favicon: green hexagon with white chevron
—Add co-tenant uptime watchdog (eloking, book.wake-up.lv)
—Harden deploys + monitoring: watchdog auto-heal, through-nginx verification, deeper health checks
—LV VAT import: dedupe registration periods
—VAT numbers: stop presenting deregistered numbers as active (all countries)

Bug Fixes

—Remaining relationship-graph defects across countries
—Mobile search not focusing the input (keyboard) on open
—Relationship graph resolving to a stranger who shares the masked code
—OFAC download hang (Bun.write on redirected response) + TED per-country isolation

Update #55: Week of Jun 29 – Jul 5 (68 changes)

July 5, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—RotatingCountry: memoize order
—Company page: consolidate warnings into one severity-tiered block
—Person page: professional sanctions warning with listing details + official source links
—RotatingCountry: animate slot width so the following text slides
—RotatingCountry: GPU-composite the animation (fix lag)
—RotatingCountry: smoother fade + vertical slide animation
—Homepage hero: widen description/search so it's always 3 lines
—Homepage hero: dynamic country width + reserved paragraph height
—Homepage hero: fix {country} in meta description + rotating-word gap
—RotatingCountry: reserve widest word width to stop layout shift
—Homepage hero: rotate the country inline inside the description
—Homepage hero + localized rotating country, SEO titles, UI work
—RotatingCountry: localize the country word per display language
—RotatingCountry: add alwaysRotate for body-copy use (breadth line)
—Homepage title: keyword-rich, language-aware (was a brand slogan)
—Cron: rebuild sitemaps nightly (they were frozen since the last manual run)
—Person/company not-found: noindex to de-index dead URLs
—Sync-people: preserve person id across re-keys (stop URL churn)
—Sitemap: list only populated person id-ranges
—Sitemap: add person profile pages
—Sitemap index: emit accurate per-child lastmod (drop always-today)
—LV self-employed (MUN register): company pages for physical persons
—Sanctions screening: add US OFAC SDN feed, fix overclaiming copy
—SE flushes: drop stale temp tables before CREATE (crash-loop hardening)
—Runbook: FI XBRL re-parse complete (45.2k statements, 27.1k with data)
—Contact suggestions: persist, verify, and auto-apply safe ones
—Live search in the search box: top 3 matches at 3+ characters
—Geo redirect: send Finnish visitors to /en/fi
—Runbook: drop manual sync-people (nightly Phase 2.5 covers it), add FI timing note
—Registry hygiene: align source-registry with what importers actually write
—5.3: wire orphaned datasets or mark them explicitly skipped
—LV: farm land
—SE: merger + ackord events from the Bolagsverket bulk
—LT: VKC named officers importer
—FI: persist the bulk-file fields we always downloaded but dropped
—SE: postal codes, secondary SNI activities (Ng2-5), bifirma trade names
—EE: real officer appointment dates + kmkr_nr VAT numbers
—LV: read the columns that actually exist in insolvency + liquidation CSVs
—SE: map balance total + material costs
—LT: map BSLT00393 tangible fixed assets
—FI XBRL parser: handle default-namespace filings + mixed expense signs
—FI: self-heal the XBRL date index
—Nightly: partial download failures degrade instead of killing the country
—EE: extract labour costs, employees, non-current lines from annual-report elements
—Marriage importer: fix pager stride skipping ~60% of records
—FI: parse XBRL via the real dimension model
—Marriage register: import LV laulāto mantisko attiecību announcements, show on person profiles
—Add extraction-gap fix plan from 5-country source audit
—SE: extract 8 more concepts from iXBRL
—SE: extract officers from annual-report signatures (as-of dated)
—SE: import Bolagsverket business descriptions (verksamhetsbeskrivning)
—Remove /top leaderboard pages
—Footer: link the top-companies leaderboard pages
—Monitoring: rebuild health-check + disk monitor for Docker, wire to cron
—Refresh wrappers: alert on failure, add lv-excise flock, gate success spam
—Refresh: fix eval ~2h post-work hang + add timeout backstops
—Refresh: resilience + make silent/degraded failures visible
—Add net salary, country-wide top pages, and quarterly VID tax data
—Country-generality: single source for country list + registry/tax links
—Security: rate-limit expensive endpoints, fix IP key, cap container memory
—Sanctions: replace OpenSanctions with the official EU FSF list
—Company page: surface FI Vero tax-reported income (separate from financials)
—LT financials: make flush non-destructive (COALESCE), fix 304-with-missing-file
—LT downloads: stream to disk (fix 2 GiB ArrayBuffer truncation)
—LT financials: fix line-code mapping so values actually land
—FI financials: ingest Vero tax-reported income (covers the ~95% with no XBRL)
—LV financials: stop NULL source_type duplication (42M→~600k rows)

Bug Fixes

—Duplicate <main> landmark on company/search/industry pages

Update #54: Week of Jun 22 – Jun 28 (15 changes)

June 26, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Valuation: disclose enterprise value (rescues the leveraged "€0 equity" case)
—Update @sentry/nextjs 10.60 → 10.61
—Valuation pages: make them indexable (crawlable, sitemap, ISR, structured data)
—Company summary card: add "View valuation" CTA
—SE financials: one-shot seed wrapper + don't checkpoint empty imports
—Changelog: biome formatting for gap-fill patch
—Changelog: auto-fill gaps before late curated entries
—Use real Swedish companies as homepage search examples
—More complete and reliable company data updates across all countries

Bug Fixes

—SE refresh: tolerate corrupt arsredovisningar bundles
—SE financials: drop `--` from inner unzip (breaks on Alpine BusyBox)
—SE financials: parse ALL iXBRL docs per filing, not just the first
—SE financials: parse UPPERCASE iXBRL context ids (PERIOD0/BALANS0)
—Build: mapbox-gl 3.25 GeoJSONFeature.properties type break in map-container
—Public procurement awards: complete history, correct values, currency and dates

Update #53: Week of Jun 15 – Jun 21 (6 changes)

June 21, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—TED procurement: company-page section + i18n + weekly cron
—TED public-procurement awards
—SE insolvency/liquidation events from existing bulk (reuse existing tables)
—Add Sweden (SE) support end-to-end
—Deploy: clear hash-prefixed container leftovers in remove_container
—Add personal-code search for people (LV birth-date prefix, EE isikukood)

Update #52: Week of Jun 1 – Jun 7 (7 changes)

June 5, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Skip-test the cleaned changelog message so user-facing commits with internal riders publish
—Regenerate changelog at image build time so the public changelog advances
—Add industry salary leaderboards + salary position cards
—Document the zero-downtime deploy process + prod warnings for agents
—Move blue-green candidate to :3015 (:3006 is the co-tenant book-wake-up stack)
—Make deploys zero-downtime (blue-green) so a transient swap can't 502 the site
—Add Feature Request widget

Update #51: Week of May 25 – May 31 (11 changes)

May 27, 2026•Artūrs Krūze

Improvements

—Harden deploy app-swap against transient failures + capture diagnostics
—Cluster people by individual_id to stop EE name-collision over-merge
—Schedule OpenSanctions screening in the nightly cron
—Add sanctions-screening FAQ to person profiles
—Serialize deploys with an flock to stop false health-timeout alarms
—Resolve subsidiaries by counterpart_regcode, not the empty FK
—Show EU funding in readable compact form (€13m not €13021k)
—Self-heal app recreate and cap ISR cache to stop deploy 502s
—Dedupe LV/EE detail tables and lock down with unique keys
—Stop LV refresh from duplicating EU funding rows

Bug Fixes

—Correctness, security, and resilience issues from max code review

Update #50: Week of May 18 – May 24 (2 changes)

May 23, 2026•Artūrs Krūze

Improvements

—Make deploy.sh resilient to docker recreate-rotate bug
—Make EE chain survive container deaths and torn-zip extracts

Update #49: Week of May 11 – May 17 (6 changes)

May 15, 2026•Artūrs Krūze

Improvements

—Stop CDN-caching the agent markdown rewrite
—Install py3-ijson in runner image so EE extractors work
—Use match_phrase_prefix on the nospace field
—Make company search space-insensitive and typo-tolerant
—Cap ISR disk cache at 200 GiB via custom CacheHandler
—Add python3 to runner image for EE registry extractors

Update #48: Week of May 4 – May 10 (21 changes)

May 10, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Add Hetzner deployment infrastructure
—Add PDF engine, expand search filters, csc_last_year_roe, dep bumps
—Ignore generated data/sitemaps/ in git
—Move locale-aware layout out of root to enable edge caching
—Use pm2 reload in deploy.sh to avoid manifest race after build
—Pre-build sitemaps to disk with incremental, throttled refresh
—Expose compliance, officers, and taxPayments on public company API
—Throttle AI bots and disallow /search in per-bot robots blocks
—Add public API endpoint for recent company tax payments
—Force /vs/* hero side-by-side via min-w-0 + clamp width, larger gaps
—Always show /vs/* hero video side-by-side, bump sizes
—Apply biome formatter pass to vs hero video changes
—Add auto-scroll videos to /vs/* hero + lower side-by-side breakpoint
—Dismiss cookie banners before capturing /vs/* hero screenshots
—Convert /vs/* hero screenshots to WebP + lazy-load
—Add competitor homepage screenshots in /vs/* hero (right side, lg+ only)
—LT/EE/FI translation quality pass on /vs/* pages
—Apply biome formatter pass to /vs/* pages
—Roll out 10 new /vs/<competitor> comparison pages plus 5-locale support across all 12
—Add /api-solutions hub + category pages with matrix-rain hero, /vs/* comparison pages, OAuth-protected-resource and shareholders endpoints, and a sticky-on-scroll transparent header for hero pages.

Bug Fixes

—OpenSearch deep-pagination crash loop in sitemap and search

Update #47: Week of Apr 20 – Apr 26 (3 changes)

April 25, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Drop unstable_cache for high-cardinality keys to stop fetch-cache inode growth
—Add deploy.sh + ignore importer state to keep prod git clean
—Add business-partners block on person pages + housekeeping

Update #46: Week of Apr 13 – Apr 19 (33 changes)

April 19, 2026•Kristaps Krūze, Artūrs Krūze

Improvements

—Rebuild NACE industry picker + fix biome config + ignore auto-commits
—Update commits.json and auto-entries.json
—Harden changelog filter against internal / data-quality leakage
—Swap blanket data/ ignore for narrow rules
—Add sanctions, commercial pledges, registry rulings, search improvements
—Add EE data importers: contacts, pledges, liquidations, revenue splits
—GEO/SEO improvements: structured data, robots.txt, FAQ, i18n updates
—Add person profit-share look-through and EE counterpart identity
—Add hyphen-tolerant match clause to company search queries
—Add FAQ schema and visible FAQ section to person pages
—Restyle role mix with individual bars per role
—Add dynamic OG image for person pages
—Improve person page SEO metadata
—Link officer/shareholder/owner names to person pages on company profiles
—Remove uppercase headers
—Remove filler description text from person hero header
—Restyle stats as single card with divide-x columns
—Lighten sidebar colors
—Improve semantic HTML and structured data on person page
—Add i18n translations for role labels across all locales
—Translate position labels and use consistent badge styling
—Increase vertical gap in company details grid
—Move financials into details grid alongside reg nr and dates
—Restructure company rows with proper grid layout
—Match person timeline to company timeline pattern
—Restyle person page to use CollapsibleSection + InfoRow patterns
—Add business owner wealth ranking to person profile
—Redesign person page with dark sidebar, role mix, and dividend estimate
—Link person search results to person profile pages
—Add person profile page with company roles, financials, and timeline

Bug Fixes

—LV masked-ID birth year landing in the future
—Person page breadcrumbs
—Wealth ranking to compute ownership from shares/capital

Update #45: Week of Mar 30 – Apr 5 (8 changes)

April 3, 2026•Artūrs Krūze

Improvements

—Add country switcher to company map page
—Make company map work for LV, LT, and EE instead of Latvia only
—Improve cold search query performance
—Display legal forms as "Translated name (Local name)" with Estonian support

Bug Fixes

—Person graph to show hierarchical company relationships instead of flat
—Recently viewed companies using wrong country URL when navigating across regions
—Double LT- prefix on Lithuanian postal codes
—Comparison basket using wrong country when navigating across regions

Update #44: Week of Mar 23 – Mar 29 (1 changes)

March 26, 2026•Artūrs Krūze

Improvements

—Add city, region, and postal code extraction for EE and LT companies

Update #43: Week of Mar 16 – Mar 22 (3 changes)

March 22, 2026•Artūrs Krūze, Kristaps Krūze

Improvements

—Restore company person birth dates across ownership and management
—Update app and data tooling

Bug Fixes

—Search/browse sorting: active first, NULLs last

Update #42: Week of Mar 9 – Mar 15 (6 changes)

March 13, 2026•Artūrs Krūze

Improvements

—Search and data architecture
—Add optional country filter to public company details API
—Add keyboard navigation for search results
—Company details copy
—Footer status changelog

Bug Fixes

—Filter values being cleared when changing country/status/NACE

Update #41: Week of Mar 2 – Mar 8 (1 changes)

March 8, 2026•Artūrs Krūze

Bug Fixes

—Sort search results by status and revenue across all search paths

Update #40: Company Valuation Reports

June 25, 2026•6 commits•Kristaps Krūze, Artūrs Krūze

New Features

—New company valuation report — an estimated company value with a low-to-high range, computed entirely from publicly filed financial statements
—Four valuation methods shown side by side: capitalised earnings (EV/EBITDA), revenue multiple, net asset value, and a discounted cash flow
—Solvency assessment with the Altman Z-score (safe / grey / distress) alongside a full set of financial ratios
—Industry comparison against the sector median for revenue and profit, plus a market-share view ranking the company against same-industry peers
—Download the full valuation as a polished PDF report
—Available in all six languages — English, Latvian, Estonian, Lithuanian, Finnish, and Swedish

Improvements

—Open a company's valuation as a slide-out panel from its page, or visit the standalone valuation page directly via its own shareable link
—Every number is calculated from filed figures — the plain-language summary is the only AI-written part, never the valuation itself

Update #39: Data Expansion & Accuracy Fixes

February 26, 2026•2 commits•Kristaps Krūze

New Features

—Lithuanian company pages now show management structure — CEO, board members, and councils with gender breakdowns
—Full address data for all Lithuanian companies
—Over 312,000 historically deregistered Lithuanian companies added to the database
—Estonian company pages now show tax revenue, employee counts, and tax debt details
—Finnish company data coverage expanded with additional financial details

Improvements

—Lithuanian company pages now display richer legal form and address details
—Faster and more reliable data updates across all countries
—More reliable automatic data updates with better error handling

Bug Fixes

—Fixed incorrect revenue and employee numbers appearing on some company pages and in data exports
—Fixed zero-value financial data being incorrectly replaced with data from other periods
—Fixed data export sometimes showing mismatched figures compared to company detail pages

Update #38: Favorites, Comparison & Country Flags

February 24, 2026•4 commits•Artūrs Krūze, Kristaps Krūze

New Features

—New Favorites system — save companies from any company page and access them from the header star icon dropdown
—New Comparison Basket — add up to 5 companies for side-by-side comparison via the header bar chart icon
—New Company Comparison page with side-by-side financial metrics, ratio analysis, YoY changes, and sparkline revenue/profit trends
—Country flags displayed next to company names in Favorites dropdown, Comparison Basket, and Comparison page headers

Improvements

—Favorites and Comparison dropdowns widened for better readability of long company names
—Polished empty state design for both dropdowns with larger icons and spacious layout
—Export success/error/rate-limit messages now fully localized in all 5 languages

Bug Fixes

—Fixed hardcoded English strings in export status messages that were never translated
—Fixed missing useCallback dependency for translation function in ExportButton

Update #37: Data Export & Advanced Search Filters

February 23, 20260•Kristaps Krūze

New Features

—New data export — download filtered company data as XLSX or CSV with per-country sheets, filter summary, and year-over-year revenue comparison (2022–2024)
—Owners column in exports showing shareholders and beneficial owners for LV and EE companies, with aggregate participant counts for LT
—Redesigned compact search filters panel with all filters visible without scrolling
—New Financial Year filter to find companies with recent financial reports
—New Revenue Year selector to choose which year's revenue to filter on
—Active filter pills showing all applied filters with one-click removal
—Live company count updates as filters change

Bug Fixes

—Fixed export using stale filter state instead of current input values
—Fixed filter dialog closing mid-export before the download completes

Update #36: Company Page SEO & Dependency Updates

February 12, 2026•1 commits•Kristaps Krūze

Improvements

—Company page meta descriptions are now translated into all 5 languages instead of being hardcoded in English
—OpenGraph descriptions now use locale-aware translations for better social sharing in local languages
—Meta descriptions now include company name, registration number, legal form, and address for richer search snippets
—Updated 9 dependencies to latest versions including puppeteer, drizzle-kit, and type definitions

Bug Fixes

—Fixed salary comparison bar displaying literal 'common.company' instead of the actual company name

Update #35: Sick Leave Calculator & Translation System

February 3, 2026•10 commits•Kristaps Krūze

New Features

—New Sick Leave Pay Calculator with accurate 2026 formulas for Latvia, Estonia, Lithuania, and Finland
—Visual comparison showing income loss between healthy and sick days
—Daily breakdown table showing who pays (employer vs state) for each day of leave
—Automated translation verification after deployments

Improvements

—All calculator pages now show country name in SEO titles (e.g., 'Sick Leave Calculator 2026 - Latvia')
—All 5 calculators now share standardized UI components (ResultCard, ToggleButtonGroup, Disclaimer)
—Topic clusters now link all calculators together for better navigation

Bug Fixes

—Fixed missing translation key 'salary.grossSalaryLabel' that was showing as raw text on salary calculator

Update #34: Calculator UX Improvements

February 2, 2026•3 commits•Kristaps Krūze

Improvements

—Calculator labels now use consistent first-person form across all calculators (salary, unemployment, dividend, maternity) in all 5 languages
—Updated jsdom to v28.0.0 with improved CSS selector engine and better spec conformance

Update #33: Maternity & Parental Benefit Calculator

February 1, 2026•6 commits•Kristaps Krūze

New Features

—New Maternity & Parental Benefit Calculator with accurate 2026 formulas for Latvia, Estonia, Lithuania, and Finland
—Monthly payment breakdown showing each benefit phase over the entire leave period
—Country-specific options: Latvia extended leave and parental duration choices, Lithuania 1-year vs 2-year comparison
—Helpful tooltips explaining maternity vs parental benefit differences

Update #32: Server Stability Improvements

January 31, 2026•7 commits•Artūrs Krūze

Bug Fixes

—Fixed nightly data updates failing to complete correctly
—Stuck update jobs are now automatically detected and recovered

Update #31: Dividend Calculator & Unemployment Updates

January 29, 2026•33 commits•Artūrs Krūze, Kristaps Krūze

New Features

—New dividend tax calculator for Latvia, Estonia, Lithuania, and Finland
—Latvia: Toggle between standard (20% CIT) and alternative (15% CIT + 6% PIT) regimes
—Finland: Support for listed vs unlisted companies with progressive capital gains tax
—Card-style result display with expandable tax breakdown details
—Region-specific info text now displays correct unemployment benefit details for each country when switching tabs

Improvements

—Comprehensive FAQs explaining each country's dividend tax rules
—Added dividend calculator to sitemap and calculators index page
—Topic cluster links between salary, unemployment, and dividend calculators
—Updated unemployment calculator with accurate 2026 laws for all 4 countries (Latvia, Estonia, Lithuania, Finland)
—Estonia: New 60%/40% two-phase benefit rates with experience-based duration (180/210/300 days) and min/max caps
—Latvia: Phase-based reduction (100%→75%→50%→45%) with €224.40 minimum benefit
—Lithuania: Updated minimum wage (€1,153), new min/max benefit caps (€350-€1,405.45)
—Finland: Updated deduction rate to 3.83%, tiered reduction at 80%/75%
—Added 'What changed in 2026?' FAQ question for each country explaining the key 2026 reforms
—All FAQ answers now include specific percentages, amounts, and calculations for accuracy

Bug Fixes

—Fixed Latvia standard regime calculation (was 25% effective, now correct 20% on gross)
—Fixed Latvia alternative regime to apply 6% PIT on dividend after CIT deduction
—Removed abolished Estonia defense tax from calculation and all content
—Fixed conflicting info text and FAQs that still referenced old Estonia defense tax
—Fixed contradicting text where FAQs showed outdated percentages (50-60%) inconsistent with info text (60%/40%)
—Fixed Latvia FAQ that incorrectly stated 4/6/9 months duration instead of 8 months
—Fixed Estonia FAQ that vaguely said '50-60%' instead of the correct 60% then 40% rates

Update #30: Changelog Overhaul, Code Cleanup & Design Consistency

January 28, 2026•13 commits•Kristaps Krūze, Artūrs Krūze

New Features

—Changelog page overhaul with author avatars and GitHub profile links
—Curated human-readable changelog entries replace raw commit messages
—Dynamic commit counts and author extraction from git history
—JSON-LD Blog and BlogPosting schemas for changelog SEO
—Company FAQ now includes founding date and ownership information
—Changelog link added to website footer with translations in 5 languages

Improvements

—Comprehensive UI consistency audit: standardized typography, borders, colors, and spacing across all pages
—Faster initial page render with optimized Hero component
—Redesigned changelog layout with cards, author avatars, and consistent typography

Bug Fixes

—Fixed inconsistent filter button styles - country/status filters now use same pattern as calculator tabs
—Fixed several data processing issues that could cause missing or incorrect company information
—Fixed Latvian data update issues
—Fixed scroll hijacking issue where changelog sidebar navigation affected main page scroll

Update #29: Calculator Redesign & Search Filters

January 27, 2026•17 commits•Artūrs Krūze, Kristaps Krūze

New Features

—Enhanced salary calculator with improved UI, accessibility, and SEO
—Search filters now serialize to URL parameters for shareable, bookmarkable searches
—NACE code filter detection from URL params with visual badge count
—K/M/B notation support in financial filter inputs (e.g. '5M' = 5,000,000)

Improvements

—Updated filter presets with practical ranges: Revenue 1M-100M, Profit 100k-10M, Employees 50-1000
—Auto-select 'all' when all 4 countries are selected in multi-country filter
—Consistent card styling across all company page sections

Bug Fixes

—Fixed missing taxBookInfo translations in all 5 language locales
—Fixed database optimization not running during scheduled updates
—Resolved all code quality warnings across the codebase
—Fixed table name references and removed unused ts-expect-error directives
—Fixed clear input to only clear text field, not close the modal

Update #28: Internationalization, Search & Performance

January 26, 2026•4 commits•Kristaps Krūze

New Features

—Search filters now support NACE code search with autocomplete
—Multi-country selection in search filters for cross-border company discovery
—Live formatting preview as you type in financial filter inputs
—New calculators index page for all 5 supported languages
—Complete translations implemented and message files split by domain for easier maintenance

Improvements

—Updated fast search page with country-agnostic shortcuts and dynamic locale URLs
—Search now queries all regions by default instead of just URL region
—Faster mobile search animations with smaller page size

Bug Fixes

—Fixed calculator translations and footer region detection
—Fixed translation key resolution for server-rendered components
—Removed hardcoded Latvian text from expandable table rows
—Synced all i18n keys across locales and added Finnish (FI) country support
—Fixed company page styling inconsistencies
—Added missing translation keys for ROE label and view full analysis
—Fixed analytics computation not running after data updates
—Fixed scheduled data update configuration

Update #27: Database Optimization & Setup Simplification

January 25, 2026•9 commits•Kristaps Krūze

New Features

—Improved database performance through better maintenance routines

Bug Fixes

—Fixed some Estonian industry codes appearing without proper English labels

Update #26: Finland Integration & Analytics

January 24, 2026•26 commits•Kristaps Krūze

New Features

—Full Finland (FI) data integration with 2026 tax rates
—Industry code search is now 10-100x faster
—Industry percentile rankings show how companies compare within their sector
—Company risk assessment badges based on financial indicators

Bug Fixes

—Various setup and configuration fixes for smoother operation
—Updated year references to 2026

Update #25: SEO 2026 & Industry Pages

January 23, 2026•9 commits•Kristaps Krūze

New Features

—SEO 2026 updates: freshness signals, AI snippet optimization, enhanced schema markup
—Industry pages with comprehensive sector data
—Disclaimer page now covers Estonian and Lithuanian data

Bug Fixes

—Fixed stray ] causing syntax error in global-breadcrumbs
—Removed lighthouse report files from repo

Update #24: Multi-Region Support & Search

January 22, 2026•2 commits•Kristaps Krūze

New Features

—Added Finnish (FI) region support with full company data
—Improved Estonian company data quality and coverage

Improvements

—Unified region handling across the entire platform for consistent UX
—Better URL routing for multi-region company pages
—Updated framer-motion and mapbox-gl dependencies

Bug Fixes

—Fixed translation errors in calculator and common components
—Improved translation consistency checks

Update #23: SEO Schema Implementation

January 20, 2026•2 commits•Artūrs Krūze

New Features

—FAQ schema markup (FAQPage) for company pages to appear in rich search results
—Enhanced Organization schema with detailed company metadata
—BreadcrumbList schema for proper navigation structure in search results

Improvements

—Improved structured data across company and industry pages
—Better meta descriptions generated from company data

Update #22: Company Page Redesign

January 19, 2026•3 commits•Artūrs Krūze

New Features

—New company page hero section displaying key financial metrics at a glance
—Tabbed navigation for easier access to company sections (Overview, Financials, People, etc.)

Improvements

—Consistent card styling across all company page sections
—Mobile-responsive company sidebar that collapses on small screens
—Improved loading states with skeleton placeholders

Update #21: Fast Search & Interactive Maps

January 18, 2026•9 commits•Artūrs Krūze

New Features

—Lithuanian (LT) support added to fast search for instant company lookup
—Public API endpoint for address autofill functionality
—Interactive municipality map for Latvia with drill-down to local company data

Improvements

—Municipality map UX improvements with pointer cursor and cleaner detail views

Bug Fixes

—Fixed net_income column reference for profit calculations in company search
—Various search UI improvements for better usability

Update #20: Latvia Map & Analytics Integration

January 17, 2026•14 commits•Artūrs Krūze

New Features

—Interactive Latvia company map with municipality-level detail pages
—Dynamic Open Graph (OG) images generated for company link previews on social media
—Google Analytics GA4 integration with enhanced e-commerce and user behavior tracking

Improvements

—Added comprehensive README with local setup and map data instructions

Bug Fixes

—Fixed analytics tracking configuration

Update #19: Lithuanian Data Integration

January 16, 2026•6 commits•Artūrs Krūze

New Features

—Full Lithuanian company data now available
—Real VAT numbers for Lithuanian companies
—Lithuanian data updates automatically with nightly refreshes

Improvements

—Improved handling of large Lithuanian financial datasets

Update #18: Security Patch

January 8, 2026•1 commits•Artūrs Krūze

Bug Fixes

—Critical security vulnerability patched in authentication flow

Update #17: SEO Maintenance

December 23, 2025•1 commits•Artūrs Krūze

Bug Fixes

—Fixed sitemap generation to include all company pages correctly

Update #16: Server Reliability

December 9, 2025•2 commits•Artūrs Krūze

Improvements

—Configured server auto-restart for improved uptime

Update #15: API & Fast Search Launch

December 2, 2025•4 commits•Artūrs Krūze

New Features

—Fast search functionality with instant typeahead results
—Public API documentation page for developers

Bug Fixes

—API security hardening with rate limiting and input validation

Update #14: Stability Improvements

December 1, 2025•11 commits•Artūrs Krūze

Bug Fixes

—Multiple bug fixes for improved application stability
—Code cleanup and lint error resolution

Update #13: SEO Improvements

November 30, 2025•11 commits•Artūrs Krūze

Improvements

—Enhanced SEO meta tags for better search engine visibility
—Improved page titles and descriptions

Bug Fixes

—Multiple stability and rendering fixes

Update #12: Brand Transition

November 26, 2025•1 commits•Artūrs Krūze

Improvements

—Rebranded from DocScan to DatReal across all platform touchpoints
—Updated logos, favicons, and meta information

Update #11: Performance & Search Fixes

November 25, 2025•7 commits•Artūrs Krūze

Improvements

—Performance optimizations across search and company pages

Bug Fixes

—Fixed person search functionality returning incorrect results

Update #10: AI Chat & UI Standardization

November 24, 2025•36 commits•Artūrs Krūze, Kristaps Krūze

New Features

—AI chat integration for interactive company insights and Q&A with message history
—Full-featured chat widget with expand/collapse, thumbs up/down feedback, source citations, and image support

Improvements

—Standardized card padding and header styles across all UI components
—Replaced ad-hoc green colors with consistent brand color palette
—Updated chat input with gradient border on hover
—Removed bottom border from 'Vairāk' (More) button
—UI improvements: flat risk badge icons, fixed tooltips, comparison column tooltip
—Improved data processing performance

Bug Fixes

—Fixed UI consistency issues after merge conflicts
—Restored complete chat widget features after branch merge

Update #9: Search Improvements & Rich Snippets

November 23, 2025•32 commits•Artūrs Krūze, Kristaps Krūze

New Features

—Rich snippets schema for enhanced search result appearance
—Desktop search improvements with better autocomplete
—Swipe to switch tabs on mobile for better UX
—Company risk flags in search results
—Added official UR (company registry) link to company pages

Improvements

—Improved search performance
—Navigation fixes and CLS (Cumulative Layout Shift) issue resolved
—Mobile search view improvements
—Improved search accuracy for partial matches
—Added browser-specific search engine setup instructions

Bug Fixes

—Fixed GitHub Actions deployment workflow
—Fixed GitHub deploy configuration
—Fixed search open/close state issue
—Fixed error on fast-search page
—Fixed incorrect fast search page behavior

Update #8: Charts, AI & Mobile PWA

November 22, 2025•31 commits•Artūrs Krūze, Kristaps Krūze

New Features

—Financial charts and graphs for visualizing company performance over time
—Google AI mode for enhanced search and analysis capabilities
—Web App Manifest for PWA (Progressive Web App) support

Improvements

—Comprehensive improvements to search UI and analytics tables
—Major improvements to search, graph matching, and database optimization
—Added progress bar for long-running operations
—Performance optimizations across the platform
—Cached search results for faster repeat queries

Bug Fixes

—Fixed mobile navigation and responsive layout issues
—Fixed mobile search functionality
—Fixed lint errors and UI border radius on mobile
—Style fixes for chart components and tooltips

Update #7: DocScan Launch & Disclaimers

November 21, 2025•20 commits•Artūrs Krūze, Kristaps Krūze

New Features

—DocScan branding and identity
—Free API tier announcement
—Legal notices and disclaimers for data usage

Improvements

—Standardized company component styling - removed emojis, assigned unique icons
—Faster search and page load times
—Improved color palette consistency

Bug Fixes

—Fixed line display issues
—Fixed color inconsistencies across components
—Added additional required disclaimers

Update #6: Homepage Redesign & Performance

November 20, 2025•34 commits•Artūrs Krūze, Kristaps Krūze

New Features

—3D globe visualization on homepage with Latvia focus
—7 additional company data categories now available
—Graph visualization for company relationships

Improvements

—Redesigned homepage and footer with modern, professional styling
—Speed improvements and performance optimizations
—Improved data processing reliability
—Faster initial page loads
—Graph visualization with rounded corners, soft shadows, and full-width canvas
—Standardized colors: replaced non-brand greens, unified dividers
—Refined homepage and footer styling

Bug Fixes

—Fixed data update logging issues
—Fixed excise licenses progress indicator
—Fixed build and code quality issues
—Fixed visual inconsistencies and spacing issues
—Fixed SSL configuration
—Fixed linting errors and improved accessibility
—Fixed SEO meta tags

Update #5: Rebrand to Lur.lv

November 19, 2025•12 commits•Kristaps Krūze

New Features

—Expanded company data with excise licenses, VAT status, and more
—Privacy policy and Terms of Service pages
—Distinct icons for ownership sections

Improvements

—Complete UI rebrand to lur.lv with new navigation design
—Navigation tabs with overflow dropdown for cleaner mobile experience
—Enhanced business activities and equity capital display styling
—Simplified README to essential commands only
—Migrated routes from [regNumber] to [...slug] pattern
—Improved FAQ and Related Companies sections with consistent styling
—Removed extra padding wrapper from financial data tabs

Bug Fixes

—Fixed linting warning and cleaned up footer links
—Fixed accessibility issues in ownership sections

Update #4: Codebase Modernization

November 18, 2025•3 commits•Kristaps Krūze

Improvements

—Improved platform architecture for faster feature development
—Database improvements and UI enhancements

Bug Fixes

—Fixed page rendering issues on some company pages

Update #3: Security & Reliability Hardening

November 17, 2025•12 commits•Kristaps Krūze

New Features

—Professional business registry features for familiar user experience

Improvements

—Significant codebase cleanup and optimization

Bug Fixes

—Prevented SQL wildcard injection vulnerability in search endpoints
—Fixed potential DoS vector via unvalidated search parameters
—Fixed EU funding inflation calculation display
—Fixed database configuration issue
—VAT deregistration status now displays correctly in company UI
—Fixed database connection issues and removed debug logging
—Fixed various code quality issues and data display inconsistencies
—Fixed multiple reliability and performance issues

Update #2: Code Review Implementation

November 16, 2025•5 commits•Kristaps Krūze

Improvements

—Centralized formulas and constants, eliminating duplication
—Improved platform reliability and performance
—Improved type safety with properly typed parameters

Bug Fixes

—Fixed search reset not clearing all filters
—Fixed duplicate results in some search queries
—Corrected card CSS classes for consistent styling
—Fixed tax unit display calculations
—Added missing useEffect dependencies throughout codebase
—Fixed source map errors

Update #1: Initial Public Launch

November 15, 2025•8 commits•Kristaps Krūze

New Features

—Major UI/UX improvements for production-ready launch
—Company search with filters for revenue, employees, and industry

Improvements

—Standardized styling across entire codebase for visual consistency
—Centralized constants and cleaned up package dependencies

Bug Fixes

—Fixed person name formatting for proper display of diacritics
—Removed hardcoded NACE utility functions in favor of database lookups