268 Commits

Author SHA1 Message Date
313929bece Fix silly typo 2021-02-22 12:21:29 +01:00
521edfa167 Add a css that explicitly imports rqeuired docs css files
Being able to point to this one css instead of individually at each one
will make it easier in the future to make changes to the stylesheets
without breaking things like the docs build.
2021-02-22 11:32:48 +01:00
2a22df2c5d Retire search for "community sites"
This hasn't worked for a few years (since 900946df) and nobody has
complained. Getting rid of it allows similifying a few things on the
search server side as well.
2021-02-22 11:13:25 +01:00
9564ab4d95 Soften bold on various definition list entries on docs
The new changes had made certain pages, e.g. the index, much
more bold.
2021-02-08 12:19:33 -05:00
3a3185d203 Fix bolding of text on website
Borrowing from 5112187fa[1] in the pgeu-system codebase,
this returns the ability to bold text within pgweb by ensuring
the Open Sans heavier fonts are loaded.

To accomplish this, this patch includes a few more changes:

- Normalize the heavier weights under 400, 600, 800.
- Ensure any font-weight settings using Open Sans match the
standards listed above.
- An adjutsment on the event archive page to ensure the font
weights are not too bold.

[1] https://git.postgresql.org/gitweb/?p=pgeu-system.git;a=commit;h=5112187fac45e0bcadb34e61c6e3e0ac398a5df3
2021-02-07 17:15:21 -05:00
230c8e84d0 Add "Mastering PostgreSQL 13 - Fourth Edition" 2021-01-14 14:23:41 -05:00
9b053e9e9b Do not set fixed width for thread selector dropdown box
There were cases that the fixed width for this box would cause the
thread selector to explode outside of the email header table in the
thread viewer. We should keep the select dropdown itself to the width
of the overall list of email addresses in the chain.
2021-01-08 14:04:50 -05:00
a0583746c4 Add EOT format of fa fonts
Based on the number of 404's for this on the website, clearly it's
something that browsers want, and it was probably just missed in the
original import.
2021-01-06 16:51:03 +01:00
ec7bf6e8ef Fix multi-paragraph statements in documentation callouts
Multi-paragraph statements in the warning/caution/note/tip boxes
were being smushed together due to the removal of paragraph
margins. It is still essential to remove the paragraph margin
on the final paragraph, which is accounted for in this change.

Reported by: Peter Geoghegan <pg@bowt.ie>
2020-12-17 16:51:24 -05:00
14ebde63fd Updates logo files and display
This adds the black outline logo of Slonik to the repository
and provides some updates to the existing logo files that are
hosted on pgweb.
2020-12-08 17:13:32 -05:00
24a48d2037 Update layout of documentation navigation pages
* Move links to current manuals to /docs/, decommission /docs/manuals/
* Add link to /docs/current/ with a large button
* Add links to /docs/devel/ at the bottom of the version table
* Remove translated manuals from left nav menu, since they are in the
  right one
* Remove redundant wording around "comprehensive manual"
* Clean up some incorrect template tags

Discussion: https://www.postgresql.org/message-id/CABUevEymaWDL4JywHxBDBATUUPPrAf4_tGwin4CtGFdQ5tx5Hg@mail.gmail.com
2020-11-24 17:19:36 +01:00
f9abdbfd77 Create instruction page for markdown fields
Instead of directly linking to the spec, include some basic info and a
list of our limitations.
2020-11-12 18:53:16 +01:00
03b2f142c4 Remove imported showdown
No longer used with the new markdown processing.
2020-11-12 18:52:07 +01:00
ea9becd746 Re-do markdown handling for better user experience and security
* Get rid of the django_markwhat dependency, and implement our own
  classes to get more control. In passing also remove django-markdown,
  because we never used that.
* Instead of trying to clean markdown with regexps, use the bleach
  library (NEW DEPENDENCY) with special whitelisting of allowed tags
  based off standard markdown. This means that one can input links or
  formatting in HTML if one prefers, as long as it renders to the same
  subset of tags that markdown allows.
* Replace javascript based client side preview with an actual call to a
  preview URL that renders the exact result using the same function,
  since the use of showdown on the client was increasingly starting to
  differ from the server, and since that cannot be kept secure the same
  way. Rewrite the client side javascript to work better with the now
  longer interval between updates of the preview.

Long in planning, but never got around to it.

Suggestion to use bleach for escaping from David Fetter.
2020-11-12 18:52:04 +01:00
89386d5134 Update EDB logo. 2020-11-05 09:20:21 +00:00
24ca44cec7 Add "Learn PostgreSQL" to books 2020-10-19 10:56:01 -04:00
669d2f733c Add support for fieldsets to forms
This makes it possible to define a fieldset which has a legend and a
description, to split up a large form into multiple visual components.
2020-10-07 18:53:45 +02:00
2182b62913 Improve display of news tags
* Add a fa icon for tags to the buttons that are clicked for news tags,
  to make it more clear what they are.
* Show a badge with the tag on each item when browsing the list.
* Change the buttons to be badges when viewing an individual item, and
  move them to the top of the page instead of the bottom for consistency
  with the listing.

In passing, add some spacing between the header and the text when
viewing a news item, because it looks a lot better.
2020-09-26 15:45:14 +02:00
b593b590de Add NetBSD OS to list of downloadable packages
This also includes a change in the descruption of the BSD
family of packages to use the term "operating system", which
is the preferred language for describing the different BSD
options.

Author: Daniel Gustafsson <daniel@yesql.se>
2020-09-23 11:10:38 -04:00
b0e7f5ce76 Add rel="noopener" to all _blank target urls 2020-09-23 16:20:48 +02:00
230b672d34 Update jquery dependency to 3.4.1 2020-09-12 14:19:34 +02:00
2217408d0d Upgrade bootstrap and popper dependencies
Up to bootstrap 4.4.1 containing a lot of fixes.

While at it, put the version in the filenames, so we don't have to
cache-bust them every time we modify something unrelated, since they do
have well defined versions.
2020-09-12 14:18:39 +02:00
ddc11b5002 Remove unused dependency on jquery.matchHeight 2020-09-12 12:48:58 +02:00
4d00e96399 Remove CSS files from the previous generation of the site 2020-09-12 12:48:45 +02:00
ee3f6ab8f4 Remove unused parts of bootstrap 2020-09-12 12:48:45 +02:00
c40cc5e223 Remove unused javascript
This is from the old version of the website, and hasn't been used for
quite some time.
2020-09-12 12:48:45 +02:00
087be8458b Remove dependency on unversioned jquery-ui
We apparently had some old /admin/ code that used an old version of
jquery-ui, but AFAICT we don't have that anymore. So remove teh loading
of them and also the files, so we have just one version of jquery
around.
2020-09-12 12:48:45 +02:00
e4453cdda9 Add support for sending out news as HTML email
When a news article is approved, it gets delivered as an email to the
pgsql-announce mailinglist. It will render the markdown of the news
article into a HTML part of the email, and include the markdown raw as
the text part (for those unable or unwilling to read html mail).

For each organisation, a mail template can be specified. Initially only
two templates are supported, one "default" and one "pgproject" which is
for official project news. The intention is *not* to provide generic
templates, but we may want to extend this to certain related projects in
the future *maybe* (such as regional NPOs).

These templates are stored in templates/news/mail/*.html, and for each
template *all* images found in templates/news/mail/img.<template>/ will
be attached to the email. "Conditional image inclusion" currently not
supported.

To do CSS inlining on top of the markdown output, module pynliner is now
required (available in the python3-pynliner package on Debian).

A testing script is added as news_send_email.py in order to easier test
out templates. This is *not* intended for production sending, so it will
for example send unmoderated news. By sending, it adds it to the
outgoing mailqueue in the system, so unless the cronjob is set up to
send, nothing will happen until that is run manually.

Support is included for tagged delivery using pglister, by directly
mapping NewsTags to pglister tags.

While at it, update the moderation preview forms to preview news items
using the HTML template for the email (while leaving other types of
items previewing without a particular stylesheet).
2020-09-10 14:52:41 +02:00
5ffe6c389c Re-work moderation of submitted items
This includes a number of new features:

* Move some moderation functionality into shared places, so we don't
  keep re-inventing the wheel.
* Implement three-state moderation, where the submitter can edit their
  item and then explicitly say "i'm done, please moderate this now".
  This is currently only implemented for News, but done in a reusable
  way.
* Move moderation workflow to it's own set of URLs instead of
  overloading it on the general admin interface. Admin interface remains
  for editing things, but these are now separated out into separate
  things.
* Do proper stylesheet clearing for moderation of markdown fields, using
  a dynamic sandboxed iframe, so it's not ruined by the /admin/ css.
* Move moderation email notification into dedicated moderation code,
  thereby simplifying the admin subclassing we did which was in some
  places quite fragile.
* Reset date of news postings to the date of their approval, when
  approved. This avoids some annoying ordering issues.
2020-09-10 14:52:41 +02:00
b2ffced2b0 Update more links to be https instead of http 2020-08-31 11:56:47 +02:00
3fedfc190a Add "PostgreSQL: The First Experience" book
Author: Pavel Luzanov <p.luzanov@postgrespro.ru>
2020-08-21 13:46:24 -04:00
d10199ae96 Add "Fundamentos para el trabajo con PostgreSQL" to Books 2020-08-03 12:51:11 -04:00
6464c68d6a Clean up javascript indentation
Remove tabs from indentation, which was in about half the files, and
make everything 4-space indentation, which is what most of the rest
used.
2020-07-12 14:09:25 +02:00
af78101784 Remove tabs from CSS indentation
We seem to still have sometimes 2 and sometimes 4 character indentation,
but for now at least get rid of the tabs.
2020-07-12 14:08:01 +02:00
6b61af92f7 Move all the non-Yum event handler setup into one shared script, per discussion. 2020-07-09 12:03:28 +01:00
b0c19acf47 Download pages overhaul:
- Don't use inline event handlers
- Simplify some of the wording
- Replace the package download list with nice buttons

Design by me & Jonathan, code by me, review by Jonathan and others.
2020-07-07 16:52:25 +01:00
0f4ae761e3 Remove the source mapping URL for popper.min.js to prevent cluttering dev tools with warnings that it can't be found. 2020-07-07 11:09:45 +01:00
fee3746ea0 Make described checkboxes a lot more clear
Instead of a weirdly located "hover over the checkbox to get a
description" message, put the actual description underneath the
checkboxes. This removes the need for javascript for it, and make the
description a lot more readily available.

This applies only to news tags for now, since that's the only use of
described checkboxes, but hopefully it will make those more clear to
people submitting.

In passing, fix how help_text for multi-checkbox field is shown -- it
was previously shown almost as part of the field name itself, making it
very hard to make out. Now make it look like all other form field help
texts.
2020-07-04 14:54:06 +02:00
36277b95a7 Use Google Tag Manager for integration with Google Analytics and honour DNT.
Per discussion and review on pgsql-www.
2020-07-02 15:03:19 +01:00
1dc0f560a9 Overhaul the Redhat, Ubuntu and Debian installation instructions.
* Merge all commands into a single text area for ease of copy/paste.
* Add a Copy Script button to each text area to copy the script (without comments and blanks) to the clipboard.
* Centralise the copy/paste code so it can be used elsewhere.
* Always install the database server.

Based on reviews/discussion with Magnus, Jonathan, Daniel and Sehrope.
2020-06-10 14:08:04 +01:00
93716f2a81 Update doc styles for catalog tables
As part of the ongoing effort to make the documentation
both easier to read visually and more friendly for the
PDF building, there have been improvements to the layout
of the reference tables.

This set of changes focuses on the catalog tables that
detail the information in the different PostgreSQL catalogs.
There is also a small adjustment for the function tables, as
one of the CSS classes was renamed in the SGML source.

Author: Tom Lane <tgl@sss.pgh.pa.us>
2020-05-13 22:23:46 -04:00
1c37e1be47 Add documentation styles for updated function & operator tables
The new documentation contains a new look & feel for how functions
and operator information are displayed, but this requires some
adjustments to the stylesheet.

This also removes from of the "!important" tags that are used
in top-level parts of the code, as we do not want those to cascade
down to lower layers of the stylesheets.
2020-04-30 00:09:25 -04:00
417bb6e561 Set indenting and alignment on new function listing tables
This helps to ensure readability of the new function table listings
while working around some of the generated code from DocBook

Authors: Tom Lane <tgl@sss.pgh.pa.us> and myself
2020-04-18 14:48:18 -04:00
e50eb48ec5 Add HTML attribute selectors for table cell alignment
As the align/valign attributets are deprecated in HTML 5 and as our
documentation generation scripts still spit these out, these selectors
will ensure compatibility, and also fix present alignment issues.
2020-04-14 18:08:27 -04:00
0153e79283 Respect valign="middle" property in table headers
As part of ongoing changes to the structure of tables in the
documentation[1], the HTML property valign is being set to middle
in the table headers, but was not being respected in the pgweb CSS
rules.

This adjusts the table headers to respect the valign property, which
in testing works with both the latest documentation as well as previous
versions (and given most, if not all, table headers to date are not
multi-lined).

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e894c61836e4b967f7ec65358fdaed2ba86ed238
2020-04-14 16:43:06 -04:00
5d7cf9833f Remove dependency on django-selectable 2020-03-31 22:55:13 +02:00
6aee9f8a11 Add "PostgreSQL for DBA: PostgreSQL 12" to books list 2020-03-01 09:37:21 -05:00
ad6f2ea2dd Update RedHat download page for RHEL8 dnf module disable
This is required to make the community rpm package work on RHEL 8 and
newer, so we should include it in the instructions...
2019-12-10 20:55:00 +01:00
ee07007329 Add 32x32 and 48x48 favicons 2019-11-08 13:19:12 +01:00
538ffd7dcf Update the membership of the Code of Conduct Committee.
Includes biographical information of the committee members.
2019-10-17 12:20:43 +02:00