The Challenge
The core challenge was building a search system fast enough to query 60 million records in milliseconds while keeping the data synchronised with DVLA's constantly changing inventory. The solution uses a carefully indexed SQLite database with optimised query patterns that return results in under 50ms.
Overview
Number 1 Registrations is a comprehensive private number plate search engine that indexes over 60 million DVLA registrations. Built from the ground up with a custom SQLite database architecture, it enables real-time availability checking against the DVLA's fixed price registrations API. The platform handles everything from plate search and filtering through to customer communication via integrated Gmail API automation.
Key Features
- Real-time DVLA API integration for plate availability
- 60M+ registrations indexed in optimised SQLite database
- Automated customer communication via Gmail API
- Advanced search with pattern matching and price filtering
- Supplier plate monitoring with automated stock updates
- Weekly DVLA snapshot imports processing millions of records