Build me a system to search through a PostgreSQL database
- Status: Closed
- Prize: £200
- Entries Received: 2
- Winner: dev681999
Contest Brief
I need a web interface for a dataset comprising 10M+ rows, which will allow me to search through the data quickly from the browser.
This should be written in .NET or Go (I will provide the dataset as CSV), and dockerized (I want to run docker-compose up and have the system work). I'm happy for just the DB to run in a container for dev exposing it's port on localhost, often quicker that way. But ultimately will be deployed with a single compose comprising the two (db/app).
Query results should be cached and the cached results should be shared between users of the UI. This cache implementation must be threadsafe.
The site frontend should be built using Quasar https://quasar.dev/. TypeScript must be used.
Search should be done on:
- name
- website
- country
- industry
- size
I'll leave it to you to figure out how clever to get with the search.
This dataset is large so I have provided a subset of the data to work with (100k rows of it).
Subject to the winner giving a satisfactory effort there will be more work to do on this system.
Please send a PDF with a link to the completed code on github/gitlab etc.
Recommended Skills
Employer Feedback
“It was odd to run a contest for software system, but Devakanta delivered. He clearly has a good Go ability and a starter boilerplate which allows for quickly scaffolding and building a system. Definitely would recommend.”
revittconsulting, United Kingdom.
Top entries from this contest
-
dev681999 India
-
gabrielsantos19 Brazil
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!