Thread: PostgreSQL reference coffee mug
Hello, Nearly 20 years ago, I ordered some 50 vi-reference coffee mugs like this one here (not exactly the same, but to give you an idea): https://www.getdigital.eu/vi-reference-mug.html for our vi-lovers in-house and the admins of our customers. I'd like to do the same now with a reference mug for PostgreSQL, for example with the most important Meta-commands, sys tables, etc. I have nearby a copy shop which would produce it based on a JPEG file. Before designing our own, I wanted to ask here if such a beast exists already or, if not, maybe even a Reference Card in PDF or JPEG to use it as a starting point. Thanks in advance for any hints. matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub
po 26. 7. 2021 v 8:56 odesílatel Matthias Apitz <guru@unixarea.de> napsal:
Hello,
Nearly 20 years ago, I ordered some 50 vi-reference coffee mugs like this
one here (not exactly the same, but to give you an idea):
https://www.getdigital.eu/vi-reference-mug.html
for our vi-lovers in-house and the admins of our customers.
I'd like to do the same now with a reference mug for PostgreSQL, for
example with the most important Meta-commands, sys tables, etc.
I have nearby a copy shop which would produce it based on a JPEG file.
Before designing our own, I wanted to ask here if such a beast exists
already or, if not, maybe even a Reference Card in PDF or JPEG to use it as a
starting point.
Thanks in advance for any hints.
I have this in czech language - maybe google translator https://translate.google.com/ helps
Regards
Pavel
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
On Jul 26, 2021, at 1:06 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Thanks in advance for any hints.I have this in czech language - maybe google translator https://translate.google.com/ helpsRegardsPavel
I could definitely use a mug large enough to hold all that.
po 26. 7. 2021 v 13:44 odesílatel Rob Sargent <robjsargent@gmail.com> napsal:
On Jul 26, 2021, at 1:06 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:Thanks in advance for any hints.I have this in czech language - maybe google translator https://translate.google.com/ helpsRegardsPavelI could definitely use a mug large enough to hold all that. \
:-)
El día lunes, julio 26, 2021 a las 09:05:39a. m. +0200, Pavel Stehule escribió: > po 26. 7. 2021 v 8:56 odesílatel Matthias Apitz <guru@unixarea.de> napsal: > > > > > Hello, > > > > Nearly 20 years ago, I ordered some 50 vi-reference coffee mugs like this > > one here (not exactly the same, but to give you an idea): > > > > https://www.getdigital.eu/vi-reference-mug.html > > > > for our vi-lovers in-house and the admins of our customers. > > > > I'd like to do the same now with a reference mug for PostgreSQL, for > > example with the most important Meta-commands, sys tables, etc. > > I have nearby a copy shop which would produce it based on a JPEG file. > > > > Before designing our own, I wanted to ask here if such a beast exists > > already or, if not, maybe even a Reference Card in PDF or JPEG to use it > > as a > > starting point. > > > > Thanks in advance for any hints. > > > > I have this in czech language - maybe google translator > https://translate.google.com/ helps > > https://postgres.cz/files/tahak_postgresql-13.pdf > Thank you, Pavel. This is ofc to much for a coffee mug. For using it as a Reference Card in paper form, it's a pity that it is not written in English. I'm working on my own for the mug and will publish the PDF and libreoffice ODT version here. The max size of the image for the mug is 7.5cm high x 16cm around the body of the coffee mug. A question to PostgreSQL.org: Are we allowed to use the PostgreSQL logo on such produced mugs without selling them, just as a gift. And can we put our own logo together with the one of PostgreSQL on the same coffee mug. To whom our Legal Dept. would have to ask this officially? Or is it just free and allowed? Thanks matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub Tear it down! Defund the Humboldt Forum! https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html
> On 27 Jul 2021, at 20:32, Matthias Apitz <guru@unixarea.de> wrote: > A question to PostgreSQL.org: Are we allowed to use the PostgreSQL logo > on such produced mugs without selling them, just as a gift. > And can we put our own logo together with the one of PostgreSQL on the > same coffee mug. > > To whom our Legal Dept. would have to ask this officially? Or is it just > free and allowed? Use of the PostgreSQL logo falls under the project Trademark Policy, which you can find here: https://www.postgresql.org/about/policies/trademarks/ There is a point of contact listed there as well in case there are more detailed questions. -- Daniel Gustafsson https://vmware.com/
El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias Apitz escribió:
> Thank you, Pavel. This is ofc to much for a coffee mug. For using it as
> a Reference Card in paper form, it's a pity that it is not written in English.
>
> I'm working on my own for the mug and will publish the PDF and
> libreoffice ODT version here. The max size of the image for the mug is
> 7.5cm high x 16cm around the body of the coffee mug.
>
Attached is a first version as PDF. Bugs/comments are welcome. Thanks.
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html
Attachment
Hello Matthias, Am 28.07.2021 um 15:40 schrieb Matthias Apitz: > El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias Apitz escribió: > >> Thank you, Pavel. This is ofc to much for a coffee mug. For using it as >> a Reference Card in paper form, it's a pity that it is not written in English. >> >> I'm working on my own for the mug and will publish the PDF and >> libreoffice ODT version here. The max size of the image for the mug is >> 7.5cm high x 16cm around the body of the coffee mug. >> only typos: \o file snnds -> sends \passwor -> password createdb ... dbna -> dbname > Attached is a first version as PDF. Bugs/comments are welcome. Thanks. > > matthias regards Georg
On 7/28/21 8:01 AM, Georg H. wrote: > Hello Matthias, > > Am 28.07.2021 um 15:40 schrieb Matthias Apitz: >> El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias >> Apitz escribió: >> >>> Thank you, Pavel. This is ofc to much for a coffee mug. For using it as >>> a Reference Card in paper form, it's a pity that it is not written in >>> English. >>> >>> I'm working on my own for the mug and will publish the PDF and >>> libreoffice ODT version here. The max size of the image for the mug is >>> 7.5cm high x 16cm around the body of the coffee mug. >>> > only typos: > > \o file snnds -> sends > > \passwor -> password > > createdb ... dbna -> dbname To add to above: \set \s allone -> alone > > >> Attached is a first version as PDF. Bugs/comments are welcome. Thanks. >> >> matthias > > regards > > Georg > > > -- Adrian Klaver adrian.klaver@aklaver.com
On 2021-Jul-28, Adrian Klaver wrote: > On 7/28/21 8:01 AM, Georg H. wrote: > To add to above: > > \set \s allone -> alone Actually that's wrong, because \s prints history not variables. This needs to read \set alone ... I'm *not* going to get into this, because I know I'm capable of spending days on it. I would definitely look into using different font sizes and colors and make it much denser, for one thing. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
Thanks to all hints about typos and bug. Attached is a corrected version
as PDF.
El día miércoles, julio 28, 2021 a las 11:38:22a. m. -0400, Alvaro Herrera escribió:
>
> I'm *not* going to get into this, because I know I'm capable of spending
> days on it. I would definitely look into using different font sizes and
> colors and make it much denser, for one thing.
I'm attaching as well the source for libreoffice calc, so you are free
to make a nicer version. Do not forget the final size in PDF as
7.5cm x 16cm.
Thanks
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html
Attachment
El día miércoles, julio 28, 2021 a las 06:58:08p. m. +0200, Matthias Apitz escribió:
> > I'm *not* going to get into this, because I know I'm capable of spending
> > days on it. I would definitely look into using different font sizes and
> > colors and make it much denser, for one thing.
>
> I'm attaching as well the source for libreoffice calc, so you are free
> to make a nicer version. Do not forget the final size in PDF as
> 7.5cm x 16cm.
I printed the PDF on paper, cut it to the size of 7.5cm x 16cm and
wrapped it around the mugs I have here. 16cm is not correct. My mugs have
more or less 7-8cm as diameter which gives around:
$ bc -l
>>> 7.5 * pi(2)
23.550
I will go tomorrow to the copy shop and ask/measure it there...
Which means also, we have more space for more information.
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html
Matthias Apitz said on Wed, 28 Jul 2021 15:40:22 +0200 >El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias >Apitz escribió: > >> Thank you, Pavel. This is ofc to much for a coffee mug. For using it >> as a Reference Card in paper form, it's a pity that it is not >> written in English. >> >> I'm working on my own for the mug and will publish the PDF and >> libreoffice ODT version here. The max size of the image for the mug >> is 7.5cm high x 16cm around the body of the coffee mug. >> > >Attached is a first version as PDF. Bugs/comments are welcome. Thanks. > > matthias Very, very nice! I'll be using this quite a bit. Does there exist anywhere a Reference Card for PostgreSQL SQL commands? My impression is that every database has its own slightly different version of SQL that it responds to. Thanks, SteveT Steve Litt Spring 2021 featured book: Troubleshooting Techniques of the Successful Technologist http://www.troubleshooters.com/techniques
El día miércoles, julio 28, 2021 a las 07:30:24p. m. +0200, Matthias Apitz escribió:
> I printed the PDF on paper, cut it to the size of 7.5cm x 16cm and
> wrapped it around the mugs I have here. 16cm is not correct. My mugs have
> more or less 7-8cm as diameter which gives around:
>
> $ bc -l
> >>> 7.5 * pi(2)
> 23.550
>
> I will go tomorrow to the copy shop and ask/measure it there...
> Which means also, we have more space for more information.
Resulted, that the size can be 20.12cm X 7.5cm. Attached is an updated
version as PDF. Hints/bugs are welcome.
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html
Attachment
On 29/07/21, Matthias Apitz (guru@unixarea.de) wrote:
> El día miércoles, julio 28, 2021 a las 07:30:24p. m. +0200, Matthias Apitz escribió:
> Resulted, that the size can be 20.12cm X 7.5cm. Attached is an updated
> version as PDF. Hints/bugs are welcome.
I personally find that, after \l (list databases), connecting to a different
one with \c is pretty useful.
\? : to list help subjects
\? options
\? variables
\h
\watch [SEC] : is helpful, for example for keeping an eye on connections via pg_stat_activity
\e | \ef | \ev : is incredibly helpful if you are working on a query, function or view which you immediately want to
loadinto the database via the query buffer (setting the EDITOR env will help). Best done in production, of course.
\set ON_ERROR_STOP on : to abort on first error
\timing on : very helpful to see how fast or slowly your function or query runs
Perhaps some example pg_stat_activity calls might be worth list, eg:
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
# https://gist.github.com/rgreenjr/3637525
Rory
The prototype is ready.
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html
Attachment
I suggest a series: one per chapter! > On Aug 6, 2021, at 12:09 PM, Matthias Apitz <guru@unixarea.de> wrote: > > > The prototype is ready. > > matthias > > -- > Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 > Public GnuPG key: http://www.unixarea.de/key.pub > Tear it down! Defund the Humboldt Forum! > https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html > <postgreSQL-coffee-mug.jpg>
On 8/6/21 11:09 AM, Matthias Apitz wrote: > > The prototype is ready. +1 > > matthias > -- Adrian Klaver adrian.klaver@aklaver.com
Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz: > The prototype is ready. Nice. Now the elephant needs to fade into the background. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert escribió:
> Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:
>
> > The prototype is ready.
>
> Nice. Now the elephant needs to fade into the background.
It is already in the background (done with libreoffice calc). See the
attached PDF. Only the black lines of the Elephant logo are a problem.
Don't know how to solve this.
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html
Attachment
On Sat, 7 Aug 2021 20:44:41 +0200 Matthias Apitz <guru@unixarea.de> wrote: > El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert > escribió: > > > Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz: > > > > > The prototype is ready. > > > > Nice. Now the elephant needs to fade into the background. > > It is already in the background (done with libreoffice calc). See the > attached PDF. Only the black lines of the Elephant logo are a problem. > Don't know how to solve this. Agree with Matthias here, the elephant needs to fade, not just be in the background. reading black on dark-ish-blue background is quite uncomfortable. Or maybe make it small, below the last line? Regards,