pgweb.git
12 years agoAdd checkbox for "is online" on events
Magnus Hagander [Wed, 30 Jan 2013 13:07:48 +0000 (14:07 +0100)]
Add checkbox for "is online" on events

This gets rid of the annoying requirement to specify things like
"online, United States" for events that are online.

This requires some SQL to run on existing installations:
ALTER TABLE events_event ADD COLUMN isonline boolean NOT NULL DEFAULT 'f';
ALTER TABLE events_event ALTER COLUMN isonline DROP DEFAULT;
ALTER TABLE events_event ALTER COLUMN country_id DROP NOT NULL;

Fixes #166

12 years agoAdd ability to toggle fields in forms
Magnus Hagander [Wed, 30 Jan 2013 13:01:25 +0000 (14:01 +0100)]
Add ability to toggle fields in forms

This uses jQuery to make it possible to enable and disable fields in the
default forms, by specifying an attribute on the form class. The form
class still has to implement proper validators, so it does not rely on
client side validations.

12 years agoAllow doc comment filtering by approval status
Magnus Hagander [Wed, 30 Jan 2013 10:45:31 +0000 (11:45 +0100)]
Allow doc comment filtering by approval status

12 years agoAllow batch approval of doc comments
Magnus Hagander [Wed, 30 Jan 2013 10:45:11 +0000 (11:45 +0100)]
Allow batch approval of doc comments

12 years agoMake filters in admin be sticky, according to:
Magnus Hagander [Wed, 30 Jan 2013 10:41:14 +0000 (11:41 +0100)]
Make filters in admin be sticky, according to:
http://code.djangoproject.com/ticket/3777

12 years agoEncode list search queries with UTF-8
Magnus Hagander [Tue, 15 Jan 2013 07:46:36 +0000 (08:46 +0100)]
Encode list search queries with UTF-8

Should fix exception when searching for non-ascii characters

12 years agoFixed typo in templates/500.html
Jonathan S. Katz [Sat, 12 Jan 2013 18:24:42 +0000 (13:24 -0500)]
Fixed typo in templates/500.html

12 years agoShow a nicer error on timeout of searches
Magnus Hagander [Sat, 12 Jan 2013 18:23:00 +0000 (19:23 +0100)]
Show a nicer error on timeout of searches

12 years agoList id is not used in the template, so remove it
Magnus Hagander [Sat, 12 Jan 2013 18:07:36 +0000 (19:07 +0100)]
List id is not used in the template, so remove it

Since messages are no longer tied directly to lists, it makes no sense to
show which list a message belongs to.

12 years agoSupport redirect when we get a messageid hit in archives search
Magnus Hagander [Sat, 12 Jan 2013 18:03:48 +0000 (19:03 +0100)]
Support redirect when we get a messageid hit in archives search

12 years agoGenerate search hits using new URL scheme
Magnus Hagander [Sat, 12 Jan 2013 17:49:00 +0000 (18:49 +0100)]
Generate search hits using new URL scheme

12 years agoDon't use pylibmc behaviours, not supported in the version used in production
Magnus Hagander [Sat, 12 Jan 2013 17:41:18 +0000 (18:41 +0100)]
Don't use pylibmc behaviours, not supported in the version used in production

12 years agoAttempt to set a 20 second timeout on searches
Magnus Hagander [Sat, 12 Jan 2013 17:11:38 +0000 (18:11 +0100)]
Attempt to set a 20 second timeout on searches

12 years agoReimplement list searching on top of http API
Magnus Hagander [Sat, 12 Jan 2013 16:48:09 +0000 (17:48 +0100)]
Reimplement list searching on top of http API

The new archives has a http api - use that one for searching instead
of directly talking to the database.

With the new API, we always fetch the complete search results (still
capped server-side at 1000 items), and store them locally in memcached
for 10 minutes. That way, paging will only hit the local memcached and
not the remote http api *or* the SQL api.

12 years agoOrganizations with >1 manager is always "new style"
Magnus Hagander [Tue, 8 Jan 2013 09:22:54 +0000 (10:22 +0100)]
Organizations with >1 manager is always "new style"

Missing code branch when detecting if an event was migrated - it worked
as long as the org had a single new manager, but if it had more than
one it fell through to the same codepath.

This should fix a number of events showing as migrated even though they
were obviously much newer than that.

12 years agoImprove size of book cover.
Dave Page [Wed, 2 Jan 2013 16:33:58 +0000 (16:33 +0000)]
Improve size of book cover.

12 years agoCorrect alt text
Dave Page [Wed, 2 Jan 2013 16:16:12 +0000 (16:16 +0000)]
Correct alt text

12 years agoAdd PostgreSQL Server Programming book
Dave Page [Wed, 2 Jan 2013 16:14:24 +0000 (16:14 +0000)]
Add PostgreSQL Server Programming book

12 years agoAdd new book "PostgreSQL: Up and Running"
Magnus Hagander [Tue, 1 Jan 2013 17:38:02 +0000 (18:38 +0100)]
Add new book "PostgreSQL: Up and Running"

12 years agoFix broken markup
Magnus Hagander [Sat, 29 Dec 2012 11:33:32 +0000 (12:33 +0100)]
Fix broken markup

12 years agoFix link to professional services
Magnus Hagander [Wed, 26 Dec 2012 18:40:59 +0000 (19:40 +0100)]
Fix link to professional services

Noted by Peter Rowell

12 years agoFix typo in URLs
Magnus Hagander [Tue, 18 Dec 2012 19:58:31 +0000 (20:58 +0100)]
Fix typo in URLs

12 years agoAdd apt.postgresql.org to debian and ubuntu download instructions
Magnus Hagander [Sat, 15 Dec 2012 17:47:20 +0000 (18:47 +0100)]
Add apt.postgresql.org to debian and ubuntu download instructions

12 years agoUpdate privacy policy to list what happens when you post to the mailinglists
Magnus Hagander [Mon, 10 Dec 2012 17:26:12 +0000 (18:26 +0100)]
Update privacy policy to list what happens when you post to the mailinglists

The archives policy was already on the wiki, but for completeness list it here
as well.

12 years agoUpdate PDF sizes.
Dave Page [Thu, 6 Dec 2012 18:52:59 +0000 (18:52 +0000)]
Update PDF sizes.

12 years agoFix URL to latest release notes.
Dave Page [Thu, 6 Dec 2012 18:44:01 +0000 (18:44 +0000)]
Fix URL to latest release notes.

12 years agoAdd ability to approve events by batch
Magnus Hagander [Thu, 6 Dec 2012 18:40:47 +0000 (19:40 +0100)]
Add ability to approve events by batch

12 years agoSupport UTF8 encoded URLs in community authentication
Magnus Hagander [Thu, 6 Dec 2012 18:14:38 +0000 (19:14 +0100)]
Support UTF8 encoded URLs in community authentication

Commit 8b3726b7d866d614c842ca90593187e726a6cf3e fixed this for all
login fields except the URL redirect field (such as the users name).
But the wiki in particular uses UTF8 in the URLs, so we need to deal
with them in the URL as well.

12 years agoUpdate releases
Dave Page [Thu, 6 Dec 2012 14:07:16 +0000 (14:07 +0000)]
Update releases

12 years agoShow purge type in list of recent varnish purges
Magnus Hagander [Fri, 30 Nov 2012 07:23:54 +0000 (16:23 +0900)]
Show purge type in list of recent varnish purges

12 years agoClarify that ^ is added to all varnish purge expressions automatically
Magnus Hagander [Fri, 30 Nov 2012 07:11:13 +0000 (16:11 +0900)]
Clarify that ^ is added to all varnish purge expressions automatically

12 years agoAdd sponsor logos for Google and Garden Grove
Dave Page [Tue, 27 Nov 2012 07:50:49 +0000 (13:20 +0530)]
Add sponsor logos for Google and Garden Grove

12 years agoMake the mailinglist subscription form csrf exempt, so it works again
Magnus Hagander [Sun, 11 Nov 2012 15:12:09 +0000 (16:12 +0100)]
Make the mailinglist subscription form csrf exempt, so it works again

12 years agoCSRF verification failure now returns HTTP 403 Forbidden, not 200 OK
Marti Raudsepp [Wed, 7 Nov 2012 21:20:09 +0000 (23:20 +0200)]
CSRF verification failure now returns HTTP 403 Forbidden, not 200 OK

12 years agoFix small bug in api_varnish_purge error path
Marti Raudsepp [Wed, 7 Nov 2012 21:14:21 +0000 (23:14 +0200)]
Fix small bug in api_varnish_purge error path

HttpServerError is a function that returns HttpResponse, not an
exception.

12 years agoUpdate @ssl_required decorator to play nice with other decorators
Marti Raudsepp [Wed, 7 Nov 2012 21:11:21 +0000 (23:11 +0200)]
Update @ssl_required decorator to play nice with other decorators

The decorator now retains all attributes of the original view and adds a
new 'view.ssl_required = True' attribute.

12 years agoFix CSRF verification in /admin/mergeorg/ and /admin/purge/
Marti Raudsepp [Wed, 7 Nov 2012 20:01:33 +0000 (22:01 +0200)]
Fix CSRF verification in /admin/mergeorg/ and /admin/purge/

All templates using {% csrf_token %} need to be rendered with a
RequestContext.

This reverts most of commit 58a08f25901079c309d0713223e12c223b413d2c

Also permit POST requests to /search/ -- these aren't relevant to the
site itself, but this used to be allowed before.

12 years agoAdd specific view for handling CSRF failures
Magnus Hagander [Wed, 7 Nov 2012 19:57:22 +0000 (20:57 +0100)]
Add specific view for handling CSRF failures

This generates the error in a bit nicer way inside our framework,
instead of throwing the default django error.

12 years agoRemove extra closing tag
Magnus Hagander [Wed, 7 Nov 2012 19:57:06 +0000 (20:57 +0100)]
Remove extra closing tag

12 years agoMake links to unsupported versions be rel=nofollow
Magnus Hagander [Wed, 7 Nov 2012 19:29:42 +0000 (20:29 +0100)]
Make links to unsupported versions be rel=nofollow

This should hopefully decrease their scoring a bit in external
search engines.

12 years agoRemove csrf from more views that were broken
Magnus Hagander [Wed, 7 Nov 2012 17:43:45 +0000 (18:43 +0100)]
Remove csrf from more views that were broken

12 years agoExclude CSRF token and check for the bug submission form
Magnus Hagander [Wed, 7 Nov 2012 17:34:47 +0000 (18:34 +0100)]
Exclude CSRF token and check for the bug submission form

12 years agoMore complete version of the move of the password views
Magnus Hagander [Mon, 5 Nov 2012 18:39:01 +0000 (19:39 +0100)]
More complete version of the move of the password views

The previous one missed a number of parameters which caused it to throw
exceptions when used.

12 years agoMake all steps of password reset run over SSL
Magnus Hagander [Mon, 5 Nov 2012 18:19:13 +0000 (19:19 +0100)]
Make all steps of password reset run over SSL

This requires the creation of views with @require_ssl set that calls
into the core django views. Otherwise, when deployed in production,
the middleware will catch these requests and direct them out of SSL.

This has always been a problem, but it broke probably when we turned on
CSRF protection, since the cookie required is no longer passed through.

12 years agoEnable CSRF protection by default
Magnus Hagander [Mon, 5 Nov 2012 13:10:39 +0000 (14:10 +0100)]
Enable CSRF protection by default

Most of these forms look pretty benign, but the user profile form, which
includes an SSH key field, certainly needs to be protected.

The survey form is unprotected because it's served over insecure HTTP
and the Varnish proxy strips cookies, which is required by the builtin
CSRF protection.

Marti Raudsepp

12 years agoTry not to crash the ftp browser when there is a directory named README
Magnus Hagander [Mon, 29 Oct 2012 20:53:05 +0000 (21:53 +0100)]
Try not to crash the ftp browser when there is a directory named README

13 years agoAdd (protected) API to queue varnish purge requests
Magnus Hagander [Wed, 3 Oct 2012 12:19:28 +0000 (14:19 +0200)]
Add (protected) API to queue varnish purge requests

We want an API for this so they end up in the queue with all the other
requests, and get delivered to all our frontends without needing each node
to know about which frontends exist.

13 years agoAdd support for varnish purging based on expressions
Magnus Hagander [Wed, 3 Oct 2012 10:45:06 +0000 (12:45 +0200)]
Add support for varnish purging based on expressions

Previously we would only purge based on URLs, but some of the upcoming
new work requires arbitrary expression purging.

NOTE! Require the creation of the new SQL procecure in the database,
either from varnish.sql or varnish_local.sql depending on if it's prod
or dev.

13 years agoFix the What's New link.
Jonathan Katz [Tue, 25 Sep 2012 12:25:50 +0000 (13:25 +0100)]
Fix the What's New link.

13 years agoRemove HTML from news archive clips
Magnus Hagander [Mon, 24 Sep 2012 10:55:29 +0000 (12:55 +0200)]
Remove HTML from news archive clips

Would render really badly when we happened to get a header or numbered
list tag or somthing like that. Keep the clips to simple text instead,
while of course keeping the HTML in the main page.

13 years agoWhen loading the current version of docs, also purge /current/
Magnus Hagander [Mon, 24 Sep 2012 10:38:49 +0000 (12:38 +0200)]
When loading the current version of docs, also purge /current/

13 years agoUpdate shoutbox for new releases
Magnus Hagander [Mon, 24 Sep 2012 10:35:44 +0000 (12:35 +0200)]
Update shoutbox for new releases

13 years agoSet shorter cache on the sponsor page, so they rotate faster
Magnus Hagander [Wed, 19 Sep 2012 16:11:02 +0000 (11:11 -0500)]
Set shorter cache on the sponsor page, so they rotate faster

13 years agoRandomize order of sponsors, instead of using alphabetical order
Magnus Hagander [Wed, 19 Sep 2012 16:06:12 +0000 (11:06 -0500)]
Randomize order of sponsors, instead of using alphabetical order

Obviously just random within each group, with the groups still being
sorted the same way as before.

13 years agourgs - if you commit something ending in ".jpg" better make sure it is actually one...
Stefan Kaltenbrunner [Mon, 17 Sep 2012 18:07:03 +0000 (20:07 +0200)]
urgs - if you commit something ending in ".jpg" better make sure it is actually one...

13 years agoconova changed its CI more than 3 years ago - update the logo to reflect that
Stefan Kaltenbrunner [Mon, 17 Sep 2012 18:02:11 +0000 (20:02 +0200)]
conova changed its CI more than 3 years ago - update the logo to reflect that

13 years agoUpdate the hub.org logo, and add Rackspace.
Dave Page [Mon, 17 Sep 2012 13:07:48 +0000 (08:07 -0500)]
Update the hub.org logo, and add Rackspace.

13 years agoRemove sponsorship level descriptions.
Dave Page [Mon, 17 Sep 2012 12:59:42 +0000 (07:59 -0500)]
Remove sponsorship level descriptions.

13 years agoMore sponsor logo updates.
Dave Page [Sat, 15 Sep 2012 16:16:48 +0000 (12:16 -0400)]
More sponsor logo updates.

13 years agoFix logo width.
Dave Page [Sat, 15 Sep 2012 16:06:46 +0000 (12:06 -0400)]
Fix logo width.

13 years agoShrink the PGX logo to a slightly more usable size.
Dave Page [Sat, 15 Sep 2012 15:57:40 +0000 (11:57 -0400)]
Shrink the PGX logo to a slightly more usable size.

13 years agoMore sponsor logos.
Dave Page [Sat, 15 Sep 2012 15:56:24 +0000 (11:56 -0400)]
More sponsor logos.

13 years agoAdd PGX logo
Dave Page [Sat, 15 Sep 2012 15:47:08 +0000 (11:47 -0400)]
Add PGX logo

13 years agoUpdate SRA logo
Dave Page [Sat, 15 Sep 2012 15:44:55 +0000 (11:44 -0400)]
Update SRA logo

13 years agoUpdate EDB logo
Dave Page [Sat, 15 Sep 2012 15:43:10 +0000 (11:43 -0400)]
Update EDB logo

13 years agoFirst sponsor updates
Dave Page [Sat, 15 Sep 2012 15:38:19 +0000 (11:38 -0400)]
First sponsor updates

13 years agoRemove pgfoundry reference from frontpage
Magnus Hagander [Thu, 13 Sep 2012 14:09:42 +0000 (16:09 +0200)]
Remove pgfoundry reference from frontpage

We still have references elsehwere, but we don't want to push
"prime location" links there when it's in it's current state.
Per discussion.

13 years agoFix link for ukranian
Magnus Hagander [Mon, 10 Sep 2012 12:26:21 +0000 (14:26 +0200)]
Fix link for ukranian

13 years agoAdd small tool to run w3c validator on local pages before deployment
Magnus Hagander [Mon, 10 Sep 2012 12:02:19 +0000 (14:02 +0200)]
Add small tool to run w3c validator on local pages before deployment

13 years agoRedirect /downloads/ to /download/
Magnus Hagander [Mon, 10 Sep 2012 11:16:18 +0000 (13:16 +0200)]
Redirect /downloads/ to /download/

Seems Berkus managed to push a broken link in the press release...

13 years agoUpdate beta and roadmap pages for 9.3
Magnus Hagander [Mon, 10 Sep 2012 11:05:57 +0000 (13:05 +0200)]
Update beta and roadmap pages for 9.3

13 years agoToo much copy/paste makes for wrong links to PDFs. Oops.
Magnus Hagander [Mon, 10 Sep 2012 10:58:27 +0000 (12:58 +0200)]
Too much copy/paste makes for wrong links to PDFs. Oops.

13 years agoFix broken HTML
Magnus Hagander [Mon, 10 Sep 2012 10:55:27 +0000 (12:55 +0200)]
Fix broken HTML

13 years agoDoc links updates for 9.2
Magnus Hagander [Mon, 10 Sep 2012 10:55:20 +0000 (12:55 +0200)]
Doc links updates for 9.2

13 years agoOops. Title should go in title field...
Magnus Hagander [Mon, 10 Sep 2012 10:26:53 +0000 (12:26 +0200)]
Oops. Title should go in title field...

13 years agoNew shoutbox for 9.2 from Josh Berkus, and updated link to news item
Magnus Hagander [Mon, 10 Sep 2012 10:24:35 +0000 (12:24 +0200)]
New shoutbox for 9.2 from Josh Berkus, and updated link to news item

13 years agoFix broken HTML in misc press files
Magnus Hagander [Mon, 10 Sep 2012 10:10:09 +0000 (12:10 +0200)]
Fix broken HTML in misc press files

13 years agoFix broken links in presskit
Magnus Hagander [Mon, 10 Sep 2012 10:09:58 +0000 (12:09 +0200)]
Fix broken links in presskit

13 years agoRegional contact list update
Magnus Hagander [Mon, 10 Sep 2012 08:49:31 +0000 (10:49 +0200)]
Regional contact list update

13 years agoPresskit and FAQ updates for 9.2
Magnus Hagander [Mon, 10 Sep 2012 08:46:40 +0000 (10:46 +0200)]
Presskit and FAQ updates for 9.2

Josh Berkus and a number of translators/regional contacts

13 years agoOops, documentation should not refer to RPMs that are not for production use
Magnus Hagander [Fri, 7 Sep 2012 07:51:24 +0000 (09:51 +0200)]
Oops, documentation should not refer to RPMs that are not for production use

My bad :(

13 years agoFix link
Magnus Hagander [Thu, 6 Sep 2012 16:41:04 +0000 (18:41 +0200)]
Fix link

Bruce Momjian

13 years agoReplace broken link to "Share your story"
Magnus Hagander [Wed, 5 Sep 2012 20:34:28 +0000 (22:34 +0200)]
Replace broken link to "Share your story"

13 years agoAdd back the backend flowchart to the website
Magnus Hagander [Tue, 4 Sep 2012 16:32:04 +0000 (18:32 +0200)]
Add back the backend flowchart to the website

Bruce Momjian, with surprisingly few modifications by me

13 years agoAdd form to search for git commit hashes
Magnus Hagander [Tue, 4 Sep 2012 13:05:57 +0000 (15:05 +0200)]
Add form to search for git commit hashes

13 years agoSmall changes, beta -> rc
Magnus Hagander [Mon, 27 Aug 2012 12:21:13 +0000 (14:21 +0200)]
Small changes, beta -> rc

13 years agoDon't include old ssh keys when new ones exist
Magnus Hagander [Tue, 21 Aug 2012 10:17:21 +0000 (12:17 +0200)]
Don't include old ssh keys when new ones exist

This would cause a UNIQUE violation on the git server...

13 years agoUpdates for new releases out today
Magnus Hagander [Fri, 17 Aug 2012 10:05:36 +0000 (12:05 +0200)]
Updates for new releases out today

Including security updates

13 years agoAdd description for postgres.app to the download page
Magnus Hagander [Wed, 15 Aug 2012 12:11:53 +0000 (14:11 +0200)]
Add description for postgres.app to the download page

Mattt Thompson

13 years agoAd dback links to OpenSCG cross-disto package downloads
Magnus Hagander [Fri, 10 Aug 2012 11:05:00 +0000 (13:05 +0200)]
Ad dback links to OpenSCG cross-disto package downloads

13 years agoMove headers into include files - no need for duplication
Magnus Hagander [Fri, 10 Aug 2012 10:43:18 +0000 (12:43 +0200)]
Move headers into include files - no need for duplication

13 years agoUpdate for 9.2b3
Dave Page [Mon, 6 Aug 2012 12:27:53 +0000 (13:27 +0100)]
Update for 9.2b3

13 years agoAdd the RPM signing key to the pgweb repository
Magnus Hagander [Thu, 12 Jul 2012 10:58:14 +0000 (12:58 +0200)]
Add the RPM signing key to the pgweb repository

This is done so people can get it using https, and verify the extra
trust.

13 years agoInclude listgroup sortkey in the JSON API
Magnus Hagander [Wed, 11 Jul 2012 16:05:28 +0000 (18:05 +0200)]
Include listgroup sortkey in the JSON API

13 years agoMake stackbuilder dependencies into a comma separated textfield
Magnus Hagander [Wed, 11 Jul 2012 09:42:18 +0000 (11:42 +0200)]
Make stackbuilder dependencies into a comma separated textfield

The "true dependencies" usign db relationships were too strict for
reality - multiple entries can have the same textid, and that's what
we need to depend on. Resolving it for platform is handled in the
StackBuilder client.

This update requires the following SQL to be run in the database:
DROP TABLE downloads_stackbuilderapp_dependencies;
ALTER TABLE downloads_stackbuilderapp ADD COLUMN txtdependencies varchar(1000) NOT NULL DEFAULT '';
ALTER TABLE downloads_stackbuilderapp ALTER COLUMN txtdependencies DROP DEFAULT;

Closes #167

13 years agoMake sure new_notification is actually in POST before we try to use it
Magnus Hagander [Fri, 6 Jul 2012 08:06:30 +0000 (10:06 +0200)]
Make sure new_notification is actually in POST before we try to use it

13 years agoPut sourcecode first in the snapshots page
Magnus Hagander [Sun, 1 Jul 2012 12:28:18 +0000 (14:28 +0200)]
Put sourcecode first in the snapshots page

Per comments from Josh Berkus

13 years agoRestructure download sections to be clearer
Magnus Hagander [Sun, 1 Jul 2012 12:25:32 +0000 (14:25 +0200)]
Restructure download sections to be clearer

In particular, split up the linux instructions into different pages
for different distributions, since they are very differnt, and in
general try to include more detail.

There are still some OSes that definitely need more info, but this
is more than we had before...

13 years agoSet verbose name on more organisation fields
Magnus Hagander [Fri, 29 Jun 2012 12:14:43 +0000 (14:14 +0200)]
Set verbose name on more organisation fields

13 years agoOne more spot missed when renaming organisation field
Magnus Hagander [Fri, 29 Jun 2012 12:13:03 +0000 (14:13 +0200)]
One more spot missed when renaming organisation field