[OSM-dev] GSoC 17 : Refactor the DB schema for better usability on access patterns

Tom Hughes tom at compton.nu
Mon Mar 6 10:49:45 UTC 2017

Please note that there is considerable overlap between that project and 
some of the others, and I suspect the others have wider support.

In particular there is Paul's "Make the website use the API" project 
which clearly overlaps with it.

I think before time is spent on that project there needs to be a good 
consensus from the community that it is the correct approach or there is 
a risk of wasting effort on something that will never be used.

That project would also appear to require C++ skills (unless it is 
proposing to dump cgimap completely) which are not currently mentioned.


On 06/03/17 10:31, Darafei "Komяpa" Praliaskouski wrote:
> Hello Pulkit,
> I'm Darafei, I proposed the project and ready to mentor it.
> First page to look at for this project
> is https://wiki.openstreetmap.org/wiki/Database - it describes the
> current state, used software, schema and links to relevant spots in
> software.
> I've done a small proof of concept
> implementation https://github.com/Komzpa/fastmap. It's not properly
> tested and not in any way integrated with any of API web services,
> although shows a lot better performance even without major schema
> refactoring.
> You can start with setting it up and playing in Postgres console, and
> try adapting test cases for /map call from cgimap onto it:
> https://github.com/zerebubuth/openstreetmap-cgimap/tree/master/test
> This will give you the most impression of what the project is about in
> shortest time.
> Don't hesitate to write to me directly, https://t.me/komzpa for
> Telegram, or @komzpa on OSM Slack https://osmus-slack.herokuapp.com/.
> вс, 5 мар. 2017 г. в 22:38, Pulkit Bhatia <pulkit4tech at gmail.com
> <mailto:pulkit4tech at gmail.com>>:
>     Hello, I am Pulkit Bhatia, final year student pursuing B.Tech.
>     Computer Science at Guru Gobind Singh Indraprastha University, Delhi.
>     I am well versed with programming in Java, Ruby/RoR and also
>     successfully implemented my GSoC 2016 project
>     <https://github.com/celluloid/GSoC/blob/master/reports/2016-reel_features.md> with Celluloid
>     <https://github.com/celluloid>.
>     I was going through idea list and I am really interested to work on
>     project *Refactoring the DB schema for better usability on access patterns.*
>     Since I am new to community, it would be really helpful if I can
>     connect with possible mentors for this project and also please
>     guide/point me from where to start (issues/any reference/task).
>     Thanks and Regards,
>     Pulkit Bhatia
>     github - github.com/pulkit4tech <https://github.com/pulkit4tech>
>     linkedin - linkedin.com/in/pulkit4tech
>     <https://www.linkedin.com/in/pulkit4tech/>
>     irc nickname - pulkit4tech
>     <https://www.linkedin.com/pub/pulkit-bhatia/98/ba4/25a><https://www.linkedin.com/pub/pulkit-bhatia/98/ba4/25a>
>     _______________________________________________
>     dev mailing list
>     dev at openstreetmap.org <mailto:dev at openstreetmap.org>
>     https://lists.openstreetmap.org/listinfo/dev
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/dev

Tom Hughes (tom at compton.nu)

More information about the dev mailing list