<div dir="ltr">Hi<div><br></div><div>Hello</div><div><br></div><div>After hours of fixing error in heroku and my ubuntu .<div>Finally got to run the so far app .</div><div><br></div><div><br></div><div><br></div><div>Here all the ports are listed:</div><div><a href="http://sleepy-wave-33400.herokuapp.com/port/">sleepy-wave-33400.herokuapp.com/port/</a><br></div><div><br></div><div><div>When you'll open the page..probable the ports would not be there because i cleared the DB.</div><div><br></div><div>To add the ports info into DB..we need to open this url:</div><div><a href="http://sleepy-wave-33400.herokuapp.com/port/parser">sleepy-wave-33400.herokuapp.com/port/parser</a></div></div><div><br></div><div>Parsing is done using the portindex.json i have.</div><div>For simplicity i have only 6 portfile data in it.</div><div><br></div><div>Once you open <a href="http://sleepy-wave-33400.herokuapp.com/port/">sleepy-wave-33400.herokuapp.com/port/</a></div><div>you can click on individual port to get further informant about that port.</div><div>infact u can access this information using :</div><div><br></div><div><a href="http://sleepy-wave-33400.herokuapp.com/port/whatever_is_the_port_name">sleepy-wave-33400.herokuapp.com/port/whatever_is_the_port_name</a></div><div><a href="http://sleepy-wave-33400.herokuapp.com/port/whatever_is_the_port_id">sleepy-wave-33400.herokuapp.com/port/whatever_is_the_port_id</a><br></div><div><br></div><div><br></div><div>Thanks </div><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 30 April 2018 at 02:14, Mojca Miklavec <span dir="ltr"><<a href="mailto:mojca@macports.org" target="_blank">mojca@macports.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 29 April 2018 at 19:34, Vishnu wrote:<br>
> Hey<br>
<span class="">><br>
> I wanted to work on finalising the database. What all final columns in each<br>
> table.<br>
<br>
</span>This is a creative process that should in the first place be carefully<br>
crafted by you - of course with sufficient input and feedback from our<br>
side.<br>
<br>
> Take your final suggestions.<br>
<br>
I'm pretty sure that things will change during the course of the<br>
summer once you figure out that there might be additional<br>
requirements, that you might need additional fields to achieve what<br>
you wanted etc. Django usually lets you transition from one schema to<br>
a slightly different one in a relatively painless way.<br>
<br>
But there's one thing that we should probably discuss together with<br>
other members, and that is, to what extent to support:<br>
- historic information about ports (as versions, dependencies,<br>
maintainers etc. change, ports become obsolete, ...)<br>
- the fact that different OS versions might support different ports or<br>
different versions of ports<br>
<br>
Vishnu, I would like to suggest to put your Excel schematic to some<br>
easy-to-read-and-edit document in that github repository. This could<br>
be some Markdown table, or anything else. You can search a bit for<br>
programs that let you easily create ERD (Entity Relation Diagram)<br>
diagrams. This document will then serve at least three purposes:<br>
- brainstorming with us about the most reasonable schematic, improvements etc.<br>
- enormously help you when you start coding you app<br>
- as a documentation that will allow anyone else to understand and<br>
improve the program later on without reading the code<br>
<span class=""><br>
> <a href="https://www.macports.org/ports.php?by=platform&substr=linux" rel="noreferrer" target="_blank">https://www.macports.org/<wbr>ports.php?by=platform&substr=<wbr>linux</a><br>
> How does this work?<br>
> where is the database?<br>
> how are queries relayed?<br>
> where is the actual code for this?<br>
<br>
</span>There is a PostgreSQL database on the server run by Clemens and Rainer<br>
in Germany (most likely the same server where you app would eventually<br>
run).<br>
<br>
I would be grateful if someone from the infrastructure team could<br>
correct me here in case I'm giving you wrong pointers, but I suspect<br>
that the database gets populated with this script:<br>
<a href="https://github.com/macports/macports-infrastructure/blob/master/jobs/PortIndex2PGSQL.tcl" rel="noreferrer" target="_blank">https://github.com/macports/<wbr>macports-infrastructure/blob/<wbr>master/jobs/PortIndex2PGSQL.<wbr>tcl</a><br>
by converting data from PortIndex to SQL and filling the database with it.<br>
<br>
I suspect the rendering is done with<br>
<a href="https://github.com/macports/macports-www/blob/master/ports.php" rel="noreferrer" target="_blank">https://github.com/macports/<wbr>macports-www/blob/master/<wbr>ports.php</a><br>
<br>
You may optionally take a glimpse at various repositories at<br>
<a href="https://github.com/macports/" rel="noreferrer" target="_blank">https://github.com/macports/</a><br>
(ignore user repositories), quickly look at what is there and ask if<br>
there's something more that you would like to know.<br>
<br>
This can give you some ideas, but I assume you would populate the<br>
database in pretty much the same way as you did during your coding<br>
challenge, and according to the database design developed during<br>
proposal writing and during community bonding period.<br>
<span class=""><br>
> Also for my project what database should i use.<br>
> i recall postgre sql.or something else?<br>
<br>
</span>Yes, PostgreSQL is probably the best OpenSource relational database<br>
(or at least it was some years ago), my preference would be to use<br>
that one. SQLite is too limited. MySQL (derivatives?) would be<br>
acceptable, but PG sounds better. Commercial databases are out of<br>
question.<br>
<span class=""><br>
> So should i start creating tickets?<br>
> like ..at least putting putting up my basic milestones.<br>
<br>
</span>Yes, I would like to see the tickets with milestones once we have the<br>
repository. Things like "transfer project proposal to documentation"<br>
with a milestone bonding period could also be stuff that ends up<br>
there.<br>
<span class=""><br>
> Also you said :<br>
> (c.3) Plan the API to get the data from the database in JSON format<br>
> (so that someone else could write an independent app with the same<br>
> display functionality).<br>
> More in a separate email, I guess.<br>
><br>
> I'll do this once i finish my database.<br>
<br>
</span>OK.<br>
<br>
Things that need to be planned are:<br>
- database schematic (the one from proposal was quite ok already, but<br>
we need to refine to what extent to support historic entries etc.)<br>
- the list of different sites (first the list of all sites with<br>
approximate URLs, then add what content you want to end up on each one<br>
of them)<br>
- ideally the API (probably not that much different from the list of sites)<br>
- potentially refine / go into some more details about different<br>
building blocks use to collect the data for the database<br>
<br>
I'll try to explain a bit more about the API ...<br>
<br>
Let's just put everything to a (set of) document(s) in the repository.<br>
It could be a markdown or asciidoc or whatever other document that's<br>
easy to edit and can easily be viewed in your repository. As I said, I<br>
feel that this would be the easiest way to collect more feedback,<br>
collect all ideas at a single place, as a reference while you will be<br>
developing and as a documentation and reference that would be useful<br>
to other developers after the GSOC is over.<br>
<span class=""><br>
> I tried to understand a bit about heroku.It'll work when needed.Not an issue<br>
> i guess.<br>
<br>
</span>I'm not even sure that heroku is the best choice since I have no<br>
experience with the service. It's just nice to have some temporary<br>
flexible way to show progress (as a functional website rather than<br>
just pure code) and get feedback from others while developing stuff.<br>
<span class="HOEnZb"><font color="#888888"><br>
Mojca<br>
</font></span></blockquote></div><br></div>