This project will build a new functionality to [login to view URL] backend.
First of all, please review our coding guidelines: [login to view URL]
Milestone 1. Implement CreateAndReloadDb method in PlacesLoader
Use the PostgreSQL connection string in the file
Method should be recreating city table (not recreating db)
Unit tests to verify that columns are created as expected
Milestone 2. Implement IPlacesServices on PlacesService. Method descriptions are in interface definition file. Then start using new service in [login to view URL]
Every method should be fully covered by unit tests
Places service should only go to DB the first time, after that it should cache cities in memory
FindPlacesByPartialMatch for 10 results should return the same list of cities as this call.
FindPlacesByPartialMatch should be using efficient data structure so that search is O(m+n) where m is number of letters in the searched substring and n is number of items to return
FindPlacesInArea should be using efficient data structure, so that we are partitioning cities efficiently and only look at required partitions around the center location
For more details please see[login to view URL]
Each milestone will only be accepted after pull request is reviewed and approved and all unit tests are written.
If interested, please send me a message with the following info:
1. Your bid (time and $) for milestone #1 as per description
2. Your bid (time and $) for milestone #2
3. What column data types will you use in the DB for this data?
4. What data structure will you use to implement FindPlacesByPartialMatch? How much memory will it use.
1. Your bid (time and $) for milestone #1 as per description
50 $ and 2 day
2. Your bid (time and $) for milestone #2
200 $ and 7 day
3. What column data types will you use in the DB for this data?
Geopraphy columns or just numeric float columns.
4. What data structure will you use to implement FindPlacesByPartialMatch? How much memory will it use.
All city data will be cached in memory, and will use linq to query by name. Can not know the exact memory usage before doing it. I will do a memory profiling after the task is done.
$250 USD en 10 días
5,0 (7 comentarios)
4,9
4,9
9 freelancers están ofertando un promedio de $216 USD por este trabajo
Hello
I'm interesting your project very well
I'm a Good C#, PostgreSQL , Geo Data, Math, Algorithm expert.
I m quite well experienced in these jobs.
Let's go ahead with me
I want to service for you continously.
Thanks
Hello,
Hope you are fine. I have read the job description, I am willing to work with you as per your requirements. I have already done similar work and get great feedback.
Please open chat with me so we can discuss more in details. Hope we ll work together.
Looking forward for your response :)
Best Regards,
Waheed Gondal
Hello,
I hope you doing very well!
I have gone through the description and would like to provide a quality solution using 5+ years of professional experience in required skills. (.NET/ASP.NET - MVC, EF, SQL, C#).
Awaiting for your positive response so we can have final talk and start project immediately :)
Hi,
I’m dedicated professional Web and Desktop Programmer & Developer and freelancer only. I have been working with challenge and hope to improve future plan with good network every client. If any client want to get more faster job services with save time I am ready to work.
I can ensure that I’ll complete each instruction within time frame even more faster. I am available everyday to work more than 12 hours. I can ensure that I'll complete each instruction within time limit with daily update on server. I am ready to work and I hope I'll get permit to prove my experience.
Thank you
Dear Project Owner, my updated response:
1. Your bid (time and $) for milestone #1 as per description
Time required - 4 days. Milestone payment - $50
2. Your bid (time and $) for milestone #2
Time required - 7 days. Milestone payment - $99
The time for #1 and #2 considers time required for clarifications etc.
3. What column data types will you use in the DB for this data?
double precision for lat long, varchar(100) for city
4. What data structure will you use to implement FindPlacesByPartialMatch? How much memory will it use.
I would recommend using SortedList or implementing SuffixTree.