1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 29-Mar-2024 13:23 GMT
View Project
View this project in detail (Note: you will be redirected to external marketplace)
Project title: Website with large database rapid search and update via api call
Posted by: External project from PeoplePerHour
Started: 17-Sep-2020 09:39 GMT
Description: Expected duration: 1 - 6 months
This project is a total redesign of a website selling custom number plates. The site has a very simple structure and the key functionality is a master search of approx 40 million records within a database. The database will be updated based on a regular api call from the DVLA personalised registrations.

Functionality
1. Master Search – the focus of the homepage (and indeed the entire website) will be a simple search box inviting users to enter a combination of characters to search all databases. Results should be returned in an extremely quick time (Similar to DVLA personalised registrations homepage).

2. Current Style Search – the homepage will also include a series of drop down menus providing an alternative method of searching for suitable ‘Current numbers’.

3. Prefix Style Search – again the homepage will provide a series of drop down menus providing an alternative method of searching for suitable ‘Prefix numbers’.

4. Buying – On the Search Results page, each result will be displayed with a price and a Buy Now button. Whenever a visitor clicks the “Buy Now” button, they will be directed to a new page requesting a range of information including:
• Name
• Address
• Tel no
• Email
• Year of Car
• Reg of Car new plate is going onto
• Google Captcha – to prevent any spam orders
After entering the above information, the buyer will be transferred to PayPal to pay a deposit of £120. This will receive email notification of their purchase including details of the total cost, deposit and remaining balance.

5. Admin Panel – This will display all orders including details of the buyer, total cost and amount outstanding. In addition, it will facilitate database maintenance, enabling aspects of the API call.

6. There are approx. 400 pre-owned numbers and a similar number of NI numbers. These pages should return these results is alphabetical order. Users should have the ability to sort by cost also.

7. Pagination – all results pages should have include a standard pagination script. The user should have the ability to increase the number of results shown per page.

Notes/ added functionality:
A. The website should be based on an existing platform or framework to ensure that it is kept continually up-to-date. This platform could include a CMS to enable content to be updated and provide a secure admin panel. *Note: We would be interested to see if the WordPress platform can be used as this would be preferred by the client. However the overarching objective is the fast retrieval of results from the database.

B. The website should be responsive – so that it displayed optimally on mobile devices.

C. The DVLA database contains a single table with c. 40 million+ records. There are approximately 400 pre-owned numbers and a similar number of NI numbers which will require a separate table.

D. The DVLA table (current and prefix numbers) will be updated using their API service (see separate guidance). This should be an automated process with an API call every 60 mins. Appropriate error handling should be included.

E. The Pre-Owned and NI numbers table will be updated as numbers are purchased and the administrator will be able to manually add/edit through the admin panel.

F. All areas of the website will be secured with a SSL certificate.

G. We propose obtaining a VPS to host the website.


Website Proposal – Please provide the following information:
• An itemised cost breakdown to deliver the project;
• Approximate length of time to undertake the project;
• Your cost schedule (i.e. % of deposit etc...); and
• Any questions/recommendations on the above specification – or any Terms & Conditions you have.
• Your approach/ methodology including the proposed framework/ database schema/ design of the API call etc including a project plan.

If there are aspects of the site that have a disproportionate impact on the project cost these should be highlighted within the proposal as the client has a limited (4 figure) budget - excludes VPS/SSL etc.
Project ID: 3068473
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Scanned PDF typed into Spreadsheet
Category: Copy Typing, Data Entry, Data Processing, Excel, Transcription
Budget: $10 - $30 CAD
29-Mar-2024
11:04 GMT
Detailed Kitchen 3D Model Design
Category: 3D Animation, 3D Design, 3D Modelling, 3D Rendering, 3ds Max
Budget: £174 - £175 GBP
29-Mar-2024
11:03 GMT
Urgent: Cartoon-Style Comic Artist Needed
Category: Arts & Crafts, Caricature & Cartoons, Concept Design, Illustration
Budget: €2 - €6 EUR
29-Mar-2024
11:02 GMT
CSS Repair on WordPress Layout
Category: CSS, HTML, PHP, Web Design, WordPress
Budget: £10 - £20 GBP
29-Mar-2024
11:02 GMT
Product Details Web Data Scraping
Category: Data Mining, Excel, Python, Web Scraping
Budget: ₹750 - ₹1250 INR
29-Mar-2024
11:00 GMT
Event Bartender Needed for 50 Guests
Category: Copy Typing, Customer Support, Data Entry, Virtual Assistant, Web Search
Budget: $30 - $250 SGD
29-Mar-2024
11:00 GMT
Virtual Assistant for Document Transcription
Category: Copy Typing, Data Entry, Excel, Transcription, Virtual Assistant
Budget: $15 - $25 USD
29-Mar-2024
11:00 GMT
Advanced Excel Tabulation
Category: Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic
Budget: €30 - €250 EUR
29-Mar-2024
11:00 GMT
Dokończenie strony - PHP/ CodeIgniter 3
Category: Codeigniter, CSS, MySQL, PHP, Web Design
Budget: $1000 - $5000 USD
29-Mar-2024
10:58 GMT
customization a wordpress payment gateway plugin
Category: CSS, HTML, PHP, Web Design, WordPress
Budget: $30 - $250 USD
29-Mar-2024
10:57 GMT
Pet Tracker: Bluetooth-Based Subscription App
Category: Android, IPad, IPhone, Mobile App Development, Objective C
Budget: $30 - $250 AUD
29-Mar-2024
10:57 GMT
Survey Form Validation JavaScript Script
Category: CSS, HTML, JavaScript, JQuery / Prototype, PHP
Budget: €250 - €750 EUR
29-Mar-2024
10:55 GMT
Opensearch Implementation For Detailed PDF Mining
Category: Elasticsearch, Generative AI, JavaScript, PHP
Budget: $10 - $30 USD
29-Mar-2024
10:55 GMT
I need two customised audio backdrops samples 29-Mar-2024
10:41 GMT
Player statistics website 29-Mar-2024
10:41 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Long URL:
www.1001freelanceprojects.com
Mobile version:
m.1001fp.com
Copyright © 2005-2022 1001 Freelance Projects