Update #47: Week of Apr 13 – Apr 19 (32 changes)

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

Improvements

—Revert "Add changelog entry for profit-share look-through and EE identity data"
—Add changelog entry for profit-share look-through and EE identity data
—Add person profit-share look-through and EE counterpart identity
—Add migration for person wealth ranking and relationship person_id FK
—Add hyphen-tolerant match clause to company search queries
—Add missing FULLTEXT index migration for person search
—Refine person pages, improve importers, and strip internal refs from changelog
—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 — emerald-400, sky-400, amber-400
—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
—Comment out dividend estimate section on person page
—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

—Biome lint: stable keys, interface types, top-level regex
—Person page breadcrumbs — hide numeric ID, show formatted name
—Wealth ranking to compute ownership from shares/capital

Update #46: Week of Apr 6 – Apr 12 (1 changes)

April 12, 2026•Kristaps Krūze

Improvements

—Add person entity resolution with people table sync and person_id FK

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

April 4, 2026•Artūrs Krūze

Improvements

—Add country switcher to company map page
—Optimize nightly import pipeline: bulk UPDATEs, staggered schedule, CSV skip
—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
—Populate company_equity_capital for LT and EE, add registeredCapital fallback
—Add timeout/retry to all country downloaders, surface failures in Slack
—Add timeout and retry logic to LT CSV download
—Rework eval to output copy-pasteable Claude Code prompt for top issue
—Strip null byte padding from LT CSV downloads that caused csv-parse OOM

Bug Fixes

—MySQL memory leak from accumulated prepared statements in batchUpdate
—Standalone scripts hanging after completion due to open connection pool
—OOM during LV financial import by chunking snapshot lookup query
—Person graph to show hierarchical company relationships instead of flat
—BatchUpdate duplicate key error on amended filings
—Eval schedule and Slack message truncation
—Eval Slack message fitting within character limit while keeping prompt copyable
—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
—YoY magnitude anomaly false positives on startup-year de minimis revenue
—Eval Slack webhook payload to include message field for workflow trigger
—LT risk import placeholder limit by chunking company ID lookups
—Ambiguous column 'status' in search cache rebuild ON DUPLICATE KEY UPDATE

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

March 29, 2026•Artūrs Krūze

Improvements

—Enable error and console capturing in Better Stack frontend tracking
—Add Better Stack frontend tracking snippet
—Add Better Stack error tracking via Sentry SDK
—Add search cache rebuild, incremental ES sync, checkpointing; remove SQLite
—Optimize ES sync with keyset pagination and country scoping
—Ensure nightly refresh backfills city/region/postal_code
—Add city, region, and postal code extraction for EE and LT companies
—Add 7-day retention cleanup for FI snapshots and EE extracted files
—Add detailed error logging to ES bulk sync
—Split nightly refresh into per-country jobs, move excise to weekly
—Overhaul relationship graph: ownership %, edge merging, smoother layout
—Use INSERT IGNORE for all relationship importers, make position NOT NULL
—Optimize nightly refresh: multi-row INSERT, parallel imports, SQL analytics
—Remove GitHub Actions deploy workflow — no longer using autodeploy
—Split LV scale fix into chunks of 10 columns per UPDATE
—Delete 37 dead SQLite services + 19 obsolete scripts (-13.5K lines)
—Rewrite eval-data-quality.ts for MySQL
—Remove all SQLite from active pipeline — fully MySQL now

Bug Fixes

—LT financial stream backpressure — use event API instead of for-await
—LT financial import OOM by streaming+flushing to DB periodically
—Better Stack snippet to use raw script tag for reliable execution
—FI XBRL non-fatal error handling and LT import OOM
—LT refresh OOM by splitting financial import into two phases
—LV missing postal codes and numeric city/region values
—3 importer bugs that broke all country refreshes
—Postal code display: use string type to preserve format, add country-aware prefix
—PM2 env: load .env file in ecosystem config directly
—ES search: dampen revenue boost, add hyphen-insensitive matching
—Person graph: use company_relationships instead of broken person_company_roles
—LV name ordering: show firstname first for all person types
—Person search: diacritics, word order, company matching, and UI
—Multi-row INSERT parser: handle NOW() and nested parentheses
—Duplicate shareholders/beneficial owners in company_relationships
—Graph: resolve numeric IDs and prioritize regcodes for graph buttons
—Analytics precompute: reduce batch size and deduplicate rankings
—Search cache column names: last_year_revenue not last_revenue
—LV scale script: use prepare().runAsync() instead of exec() for parameterized queries
—Malformed packet in LV scale fix script — process one row at a time
—LV financial scale (×1000) and improve ES search ranking
—Graph service: add sanctions, insolvency, person lookup, edge dedup

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

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

Improvements

—Sync analytics to MySQL in both nightly and weekly refresh
—Add analytics table sync + fix NACE code normalization
—Update dependencies: Next.js 16.2.1, Sentry 10.45, Tailwind 4.2.2
—Update README and onboarding for MySQL setup
—Add safe SQL migration for schema changes on prod
—Improve schema quality and add pre-commit checks
—Replace Convex + SQLite with MySQL via Drizzle ORM
—Restore company person birth dates across ownership and management
—Update app and data tooling
—Preserve ES-fallback financial reports when Convex returns empty
—Add Elasticsearch fallback for LT/EE companies missing from Convex

Bug Fixes

—Duplicate relationships: add unique constraint + dedup migration
—Critical issues in overnight import pipeline
—Elasticsearch search ranking with multiplicative scoring
—Status mapping and remove risky ES script sort
—ES sync: use Drizzle column refs instead of raw SQL aliases
—Search/browse sorting: active first, NULLs last
—SQLITE_BUSY: kill timed-out import subprocess and increase LV timeout

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

March 15, 2026•Artūrs Krūze

Improvements

—Reduce Convex bandwidth by limiting financial reports to 5 on company page
—Add health check endpoint for BetterStack monitoring
—Reduce Convex bandwidth: Elasticsearch backend, monthly sitemaps, query caching
—Add data quality eval system and fix BNAGP nonprofit revenue bug
—Increase active company bonus to 500 to outweigh revenue cap
—Improve search ranking: active boost, hyphen-insensitive matching, exact token bonus
—Search and data architecture
—Add optional country filter to public company details API
—Add keyboard navigation for search results
—Company details copy
—Convex cost and data refresh
—Footer status changelog
—MCP server for Claude

Bug Fixes

—Remaining LT/EE 404s: add by_regcode index and thread countryCode everywhere
—404 on LT/EE company pages by passing countryCode to Convex query
—Negative score error in search by clamping revenue to 0
—Replace mcp-handler with direct SDK transport for production compatibility
—Add error handling to all Convex fetchQuery/fetchAction calls to prevent Server Errors
—Browse results sorted by naceCode instead of revenue when NACE filter active
—Filter values being cleared when changing country/status/NACE

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

March 8, 2026•Artūrs Krūze

New Features

—Resumable per-table Convex import with auto-detect deployment
—Migrate to Convex backend with delta-based data pipeline

Improvements

—Add AGENTS.md with Cursor Cloud specific instructions

Bug Fixes

—Remove sha256 SQL function dependency in change tracking
—Sort search results by status and revenue across all search paths
—Use Convex _id for list keys and improve ownership/relations UI
—Return beneficial owner details (birthDate, nationality) and improve graph node identity
—Always rebuild company_search index after data imports
—Use 'bun x' instead of 'bunx' for PATH compatibility on prod
—Resolve TypeScript build errors in service type mismatches
—Resolve TypeScript build errors in Convex dataImport generic insert calls
—Resolve TypeScript build error in generic table query helper
—Export uses live financial data instead of stale company_search cache
—Prevent cross-contamination in financial data + limit exports to 5K

Update #40: Week of Feb 23 – Mar 1 (2 changes)

March 1, 2026•Artūrs Krūze

Improvements

—Track bun.lock - stop playing dependency roulette

Bug Fixes

—Gitignore bun.lock and data/commits.json to prevent deploy conflicts

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 #47: Week of Apr 13 – Apr 19 (32 changes)

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

Improvements

—Revert "Add changelog entry for profit-share look-through and EE identity data"
—Add changelog entry for profit-share look-through and EE identity data
—Add person profit-share look-through and EE counterpart identity
—Add migration for person wealth ranking and relationship person_id FK
—Add hyphen-tolerant match clause to company search queries
—Add missing FULLTEXT index migration for person search
—Refine person pages, improve importers, and strip internal refs from changelog
—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 — emerald-400, sky-400, amber-400
—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
—Comment out dividend estimate section on person page
—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

—Biome lint: stable keys, interface types, top-level regex
—Person page breadcrumbs — hide numeric ID, show formatted name
—Wealth ranking to compute ownership from shares/capital

Update #46: Week of Apr 6 – Apr 12 (1 changes)

April 12, 2026•Kristaps Krūze

Improvements

—Add person entity resolution with people table sync and person_id FK

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

April 4, 2026•Artūrs Krūze

Improvements

—Add country switcher to company map page
—Optimize nightly import pipeline: bulk UPDATEs, staggered schedule, CSV skip
—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
—Populate company_equity_capital for LT and EE, add registeredCapital fallback
—Add timeout/retry to all country downloaders, surface failures in Slack
—Add timeout and retry logic to LT CSV download
—Rework eval to output copy-pasteable Claude Code prompt for top issue
—Strip null byte padding from LT CSV downloads that caused csv-parse OOM

Bug Fixes

—MySQL memory leak from accumulated prepared statements in batchUpdate
—Standalone scripts hanging after completion due to open connection pool
—OOM during LV financial import by chunking snapshot lookup query
—Person graph to show hierarchical company relationships instead of flat
—BatchUpdate duplicate key error on amended filings
—Eval schedule and Slack message truncation
—Eval Slack message fitting within character limit while keeping prompt copyable
—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
—YoY magnitude anomaly false positives on startup-year de minimis revenue
—Eval Slack webhook payload to include message field for workflow trigger
—LT risk import placeholder limit by chunking company ID lookups
—Ambiguous column 'status' in search cache rebuild ON DUPLICATE KEY UPDATE

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

March 29, 2026•Artūrs Krūze

Improvements

—Enable error and console capturing in Better Stack frontend tracking
—Add Better Stack frontend tracking snippet
—Add Better Stack error tracking via Sentry SDK
—Add search cache rebuild, incremental ES sync, checkpointing; remove SQLite
—Optimize ES sync with keyset pagination and country scoping
—Ensure nightly refresh backfills city/region/postal_code
—Add city, region, and postal code extraction for EE and LT companies
—Add 7-day retention cleanup for FI snapshots and EE extracted files
—Add detailed error logging to ES bulk sync
—Split nightly refresh into per-country jobs, move excise to weekly
—Overhaul relationship graph: ownership %, edge merging, smoother layout
—Use INSERT IGNORE for all relationship importers, make position NOT NULL
—Optimize nightly refresh: multi-row INSERT, parallel imports, SQL analytics
—Remove GitHub Actions deploy workflow — no longer using autodeploy
—Split LV scale fix into chunks of 10 columns per UPDATE
—Delete 37 dead SQLite services + 19 obsolete scripts (-13.5K lines)
—Rewrite eval-data-quality.ts for MySQL
—Remove all SQLite from active pipeline — fully MySQL now

Bug Fixes

—LT financial stream backpressure — use event API instead of for-await
—LT financial import OOM by streaming+flushing to DB periodically
—Better Stack snippet to use raw script tag for reliable execution
—FI XBRL non-fatal error handling and LT import OOM
—LT refresh OOM by splitting financial import into two phases
—LV missing postal codes and numeric city/region values
—3 importer bugs that broke all country refreshes
—Postal code display: use string type to preserve format, add country-aware prefix
—PM2 env: load .env file in ecosystem config directly
—ES search: dampen revenue boost, add hyphen-insensitive matching
—Person graph: use company_relationships instead of broken person_company_roles
—LV name ordering: show firstname first for all person types
—Person search: diacritics, word order, company matching, and UI
—Multi-row INSERT parser: handle NOW() and nested parentheses
—Duplicate shareholders/beneficial owners in company_relationships
—Graph: resolve numeric IDs and prioritize regcodes for graph buttons
—Analytics precompute: reduce batch size and deduplicate rankings
—Search cache column names: last_year_revenue not last_revenue
—LV scale script: use prepare().runAsync() instead of exec() for parameterized queries
—Malformed packet in LV scale fix script — process one row at a time
—LV financial scale (×1000) and improve ES search ranking
—Graph service: add sanctions, insolvency, person lookup, edge dedup

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

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

Improvements

—Sync analytics to MySQL in both nightly and weekly refresh
—Add analytics table sync + fix NACE code normalization
—Update dependencies: Next.js 16.2.1, Sentry 10.45, Tailwind 4.2.2
—Update README and onboarding for MySQL setup
—Add safe SQL migration for schema changes on prod
—Improve schema quality and add pre-commit checks
—Replace Convex + SQLite with MySQL via Drizzle ORM
—Restore company person birth dates across ownership and management
—Update app and data tooling
—Preserve ES-fallback financial reports when Convex returns empty
—Add Elasticsearch fallback for LT/EE companies missing from Convex

Bug Fixes

—Duplicate relationships: add unique constraint + dedup migration
—Critical issues in overnight import pipeline
—Elasticsearch search ranking with multiplicative scoring
—Status mapping and remove risky ES script sort
—ES sync: use Drizzle column refs instead of raw SQL aliases
—Search/browse sorting: active first, NULLs last
—SQLITE_BUSY: kill timed-out import subprocess and increase LV timeout

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

March 15, 2026•Artūrs Krūze

Improvements

—Reduce Convex bandwidth by limiting financial reports to 5 on company page
—Add health check endpoint for BetterStack monitoring
—Reduce Convex bandwidth: Elasticsearch backend, monthly sitemaps, query caching
—Add data quality eval system and fix BNAGP nonprofit revenue bug
—Increase active company bonus to 500 to outweigh revenue cap
—Improve search ranking: active boost, hyphen-insensitive matching, exact token bonus
—Search and data architecture
—Add optional country filter to public company details API
—Add keyboard navigation for search results
—Company details copy
—Convex cost and data refresh
—Footer status changelog
—MCP server for Claude

Bug Fixes

—Remaining LT/EE 404s: add by_regcode index and thread countryCode everywhere
—404 on LT/EE company pages by passing countryCode to Convex query
—Negative score error in search by clamping revenue to 0
—Replace mcp-handler with direct SDK transport for production compatibility
—Add error handling to all Convex fetchQuery/fetchAction calls to prevent Server Errors
—Browse results sorted by naceCode instead of revenue when NACE filter active
—Filter values being cleared when changing country/status/NACE

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

March 8, 2026•Artūrs Krūze

New Features

—Resumable per-table Convex import with auto-detect deployment
—Migrate to Convex backend with delta-based data pipeline

Improvements

—Add AGENTS.md with Cursor Cloud specific instructions

Bug Fixes

—Remove sha256 SQL function dependency in change tracking
—Sort search results by status and revenue across all search paths
—Use Convex _id for list keys and improve ownership/relations UI
—Return beneficial owner details (birthDate, nationality) and improve graph node identity
—Always rebuild company_search index after data imports
—Use 'bun x' instead of 'bunx' for PATH compatibility on prod
—Resolve TypeScript build errors in service type mismatches
—Resolve TypeScript build errors in Convex dataImport generic insert calls
—Resolve TypeScript build error in generic table query helper
—Export uses live financial data instead of stale company_search cache
—Prevent cross-contamination in financial data + limit exports to 5K

Update #40: Week of Feb 23 – Mar 1 (2 changes)

March 1, 2026•Artūrs Krūze

Improvements

—Track bun.lock - stop playing dependency roulette

Bug Fixes

—Gitignore bun.lock and data/commits.json to prevent deploy conflicts

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