Database design that survives growth
A database that works with a thousand rows can fall over at a million. uahub keeps every active Danish company, and what we learned there shapes our client designs: PostgreSQL accepts at most 32,767 parameters per query, so batch sizes are calculated from row width; some register IDs overflow 32-bit integers; historical values such as ownership shares need a validity period, or the sums come out at 200 %. On soge.dk, browsing 12.6 million vehicle records stayed fast only after we removed a costly sort and validated filters before they reached MariaDB. We pick PostgreSQL or MySQL/MariaDB, version every change with Alembic migrations and add a search index where people type.
ETL pipelines into a database for reporting
Here ETL means a scheduled job that collects data from a source, cleans it and loads it into a database built for reporting and analysis. danadresse.dk is our clearest case: it keeps about 3.96 million Danish addresses in sync with the official address data and rebuilds its search index every night. A rewrite took that rebuild from about 7.7 hours to around 12 minutes, and each night the job compares the count in the database with the count in the index. uahub loads a daily delta from the CVR register the same way. We build pipelines that can be rerun safely, log what they changed and stop on a surprise rather than load half a file.
BI dashboards and KPI views
A dashboard is only as good as the counting under it. We build KPI views on your own database: bookings, revenue, no-shows, traffic split into people and bots, search performance. Our booking platform bkg.dk has occupancy and source reports built this way. The full page explains the approach and the price.
Learn more →Web scraping and data collection
When the data you need sits on public websites, we collect it on a schedule: an official API or feed first, plain HTTP next, a real browser only where a page demands it. We keep request rates low, check the legal side first and watch every source for silent breakage. Prices start at 2,000 DKK.
Learn more →Predictive analytics, honestly scoped
Forecasts need history, and many small businesses have one or two seasons of clean data at best. So we start with baselines and change detection before any model. On our own servers we compare the last two hours of load with each machine's median for the past day; tested on real data from 12 servers, that rule would have flagged a traffic surge four hours before our fixed thresholds did. We compare like with like, the same hour on the same type of day, because comparing a Saturday with a Friday once gave us a false alarm. If your data can carry a forecast, we build one and show its error on past periods; if it cannot, we say so.
Document workflows: imports, exports and PDFs
Documents must also go out, not only come in: exports your accountant can open, PDFs for print, imports that accept what Danish banks and Excel actually produce. In JaRyk, our payment-reminder product, the CSV import had to understand amounts like 1.234,50 kr., dates like 1.10.2026 and Windows-1252 files saved from Excel, and the bank-statement import reads exports from Danske Bank, Nordea, Jyske Bank and Lunar. For a Danish construction company we turned a long work chat with photos into a searchable web archive and print-ready PDFs of 199 and 33 pages. We build the template, the validation and the routing, so files open correctly the first time.
Reporting automation
A report nobody has to remember to make. Every morning our own system writes a KPI file per website with Google Search Console data for more than 30 of our sites and payment figures from Stripe, and a digest reaches Telegram before the working day starts. bkg.dk can send a salon owner a daily evening report with bookings and revenue, formatted as 4.350,00 kr. in Danish and DKK 4,350.00 in English. JaKonto exports invoices, VAT and profit and loss as CSV files with the byte-order mark Danish Excel expects. We agree with you what goes in, when it is sent and to whom; nothing goes to your customers without your approval.