How One Team Geocoded 14.4 Million French Businesses Using a Free Government API

·1 views

A development team needed GPS coordinates for over 14.3 million French business establishments listed in the SIRENE registry to enable location-based searches. Since the official monthly GeoSirene dataset from INSEE leaves newly registered businesses without coordinates, the team built a two-layer pipeline combining monthly bulk imports with daily incremental updates. They used France's free Base Adresse Nationale (BAN) API, which accepts bulk CSV requests without an API key and is optimised for French addresses, processing data in chunks of 8,000 rows with a one-second pause between requests. Results with a confidence score below 0.4 are discarded, as a missing coordinate is considered less harmful than an inaccurate one for radius-based queries. The solution runs daily alongside a live application without requiring database locks or paid third-party geocoding services.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Five Lightweight Self-Hosted Error Trackers That Can Replace Sentry

Developers relying on Sentry's free hosted tier risk exhausting their event quota during the very incidents when error visibility matters most. Self-hosting the official Sentry distribution solves quota limits but requires over 20 services, at least 3 GB of RAM, and infrastructure complexity disproportionate to small projects. A DEV Community article identifies five leaner alternatives — GlitchTip, Errbit, Signoz, Highlight.io, and one more — that can run as a single Docker container or a compact Compose stack. The shortlist was filtered by strict criteria: under 1 GB RAM at idle, no Kafka or ClickHouse dependencies, and functional source map support. The piece argues that most developers only need readable stack traces, release tagging, and basic alerting — features that do not require the large-scale architecture Sentry built for processing billions of SaaS events monthly.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Builds Zero-Dependency JavaScript Date Picker, Shares Key Lessons

A front-end developer has released RollDate, an open-source JavaScript date picker library built without any framework dependencies such as React, Vue, or jQuery. The library supports single, range, and multi-date selection, an optional time picker, dark theme, localization, and TypeScript, all configurable through a minimal API. The developer found that edge cases around features like keyboard navigation, disabled dates, and leap years proved far more challenging than rendering the calendar itself. Equally significant was the documentation effort, which included building an interactive playground that auto-generates configuration code as users adjust options. The project is available on GitHub and npm, and the developer is actively seeking community feedback to guide future improvements including better accessibility and additional themes.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Claude Opus 5 vs ChatGPT 5.6 Sol: Benchmark Wins Mean Little Without Infrastructure Fit

Anthropic's Claude Opus 5 and OpenAI's ChatGPT 5.6 Sol have emerged as direct competitors in the large language model space, with Opus 5 scoring 43% on the Frontier Bench and 30% on the ARC AGI 3 benchmark. Opus 5 achieves these results partly through dynamic test-time compute, which routes complex queries through internal reasoning loops before delivering a response. However, this architecture introduces variable latency that can complicate enterprise deployments relying on predictable API response times. ChatGPT 5.6 Sol, by contrast, is optimized for high-throughput inference, potentially offering more stable performance for production systems at the cost of marginally lower benchmark scores. Analysts argue that enterprise buyers should evaluate total cost of ownership — factoring in engineering overhead, latency penalties, and fallback complexity — rather than benchmark rankings alone.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

GoodBarber explains how no-code platforms abstract away StoreKit and Play Billing complexity

GoodBarber, a no-code app builder operating since 2011, has published a technical explainer detailing how its platform allows creators to offer in-app subscriptions without directly coding StoreKit on iOS or Google Play Billing on Android. The company argues that building in-app subscriptions from scratch is one of mobile development's hardest challenges, requiring two separate APIs, server-side receipt validation, and a long-running state machine to handle renewals, refunds, and cancellations. GoodBarber's platform abstracts this complexity into a single back-office toggle for native iOS and Android content apps. The feature is designed exclusively for digital content such as articles, videos, and podcasts, as Apple and Google store rules prohibit using in-app purchase rails for physical goods or real-world services. The post also highlights the key trade-off: using the in-app rail means accepting the standard store commission cut, which the company describes as a significant but unavoidable cost for reaching mobile-first audiences at the paywall moment.

0 comments Read more at DEV Community