summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2012-11-16Optimize mirror status data fetchingDan McGee
Now that we have as many mirror URLs as we do, we can do a better job fetching and aggregating this data. The prior method resulted in a rather unwieldy query being pushed down to the database with a horrendously long GROUP BY clause. Instead of trying to group by everything at once so we can retrieve mirror URL info at the same time, separate the two queries- one for getting URL performance data, one for the qualitative data. The impetus behind fixing this is the PostgreSQL slow query log in production; this currently shows up the most of any queries we run in the system. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-13Move JSON keys view to public/ appDan McGee
This seems like a more appropriate place, and now the visualization is done here anyway so we should move the data backing it. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-13Update rss.pngDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-13Move PGP key visualizations to master keys pageDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-13Mirror details style and JS cleanupDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-13Slight master key template adjustmentDan McGee
This is in anticipation of moving the visualization stuff to this page rather than grouped with unrelated things. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-12Prefetch the available protocols on the mirror overview pageDan McGee
Otherwise we are doing one query per mirror, which at this point is over 100 separate queries. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-12Remove SevenL from sponsors listDan McGee
They've been good to us for several years, but our hardware requirements have changed and we've moved on to using different machines for the purposes this donated machine served. Thanks! Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-12Add a test high-resolution imageDan McGee
Just the simple RSS feed image for now, but want to see how complicated this will get. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-12Add comments to visualize JSDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-12Add get_latest_by to MirrorLog Meta classDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-11Add title to mirror status data pointsDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-11Exclude news.safe_mode on news edit screenrelease_2012-11-11Dan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-11Mirror graph tweaking after usage with real dataDan McGee
* Clamp y-axis minimum to 0. * Don't plot `is_success == false` values. * Ensure URLs are sorted predictably. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-11Re-add nice() calls for mirror status axesDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-11Slight style tweaksDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-11Mirror status graph, now with points AND linesDan McGee
We might have to tweak the interpolation method once we see this with real data, but for now it looks really pretty locally. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-10Enable mirror status graph resizingDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-10Add initial version of mirror status chartDan McGee
Still have some hardcoded stuff to rip out and replace to make this a bit more dynamic on things like sizing, but for now, this is a great start. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-10Allow filtering retrieved mirror statuses by mirror_idDan McGee
When we don't need them all, no need to fetch them all. Let the database do the work for us, hopefully. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-10Add mirror extended status JSON viewDan McGee
When asking for status for a single mirror, we can include logs from the past 24 hours in addition to the normal information we provide. This is slated for usage by a frontend graph still to come, similar to those on the NTP pool website. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-06Remove explicit timezone handling from feedsDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-06Make guid feeds helper a @staticfunctionDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-01Allow editing news.safe_mode flag via admin screenDan McGee
We need to mark the property as editable, but you still don't have access to it through the normal non-admin views and edit screen. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-01Signal attachment cleanupDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-01Update for November ISO releaseDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-11-01download.html: Provide a magnet linkThomas Bächler
Some people prefer these over torrent files, as they're easier to pass than the torrent files themselves. On updates, this only needs the new info hash. The tracker bits are optional, but ensure that the torrent client gets peers more quickly to receive the actual torrent file. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-31Store 'safe_mode' attribute on news modelDan McGee
This lets us identify old news items that need to allow HTML through the markdown parser. For all new news items, we will disallow raw HTML. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-31Disable markdown safe modeDan McGee
Unless we want older news items to look like [HTML_REMOVED]this[HTML_REMOVED] all over the place. I'm tempted to mark old items as non-safe but enforce safe mode for all new news postings. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-29Remove information regarding test ISOsrelease_2012-10-29Thomas Bächler
The test builds are dead and nobody is taking care of them. With our monthly releases, they serve no purpose. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-27Fix news feed content displayDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-27Convert silhouette.png to an 8-bit colormapDan McGee
This cuts the size from 33KB to just 2KB. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-26Remove usages of 'django.contrib.markup'Dan McGee
Switch to the news model being able to spit out the HTML version of the content, and don't use the markup contrib module. This is deprecated as of Django 1.5 so we can move off it now to save trouble down the road when it is fully removed. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-26Cleanup meta model attributesDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-26Extract some common architecture grabbing logicDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-26Enable safe mode for markdown parsingDan McGee
Although we don't allow unauthenticated users to post content, we should still cover our bases here and ensure people can't inject stuff into the production website via an inadvertent XSS. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-26Add .DS_Store to .gitignoreDan McGee
Thanks for your silly files, OS X. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-21Remove 'table' tag specifier from '.arch-bio-entry'Dan McGee
Class-based selectors make sense here, we don't need the table tag too. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-21More navbar styling cleanupDan McGee
Use ID-only rules, etc. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-21Remove dead CSSDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-21css: with ID selectors, no need for tag selectorDan McGee
This simplifies a lot of the CSS and brings it in line with recommendations to use ID-based selectors when possible. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-21Remove charset declaration <meta/> tagDan McGee
This belongs in HTTP headers, not here. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-21Fix navbar logo stylingrelease_2012-10-21Dan McGee
The relative path to the logo PNG image wasn't correct, and too much of the other styles got deleted when removing the IE6 compatibility shim. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-21Update tablesorter JSDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-18Bump requirementsDan McGee
Move to the 1.4.2 Django security release, and update django-countries to 1.4. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-18Clean up create index migrationDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-18Modernize initial main migrationDan McGee
Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-14Remove logo override for IE6Dan McGee
We don't need this anymore. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-14Inline global navbar stylesheetDan McGee
It is silly to have to load an external resource when we can simply cram all of this in the same single stylesheet used for the site. Signed-off-by: Dan McGee <dan@archlinux.org>
2012-10-14Remove print stylesheetDan McGee
This hasn't been updated in ages, and who is printing out pages from the website anyway? Signed-off-by: Dan McGee <dan@archlinux.org>