Re: Presentation tools used ?

[Tom Browder]

On Mon, Oct 23, 2023 at 09:46 Bruce Momjian  wrote:

You might want to watch this video I created, and maybe the bonus one too:
>
> https://momjian.us/main/presentations/general.html#presenting


Excellent! Thanks.

-Tom

>

>

Re: Migrating MySQL DB to PostgreSQL DB.

[Tom Browder]

On Sun, Jul 30, 2023 at 19:36 Kaushal Shriyan 
wrote:

Thanks Ron for the suggestion. Much appreciated. Are there any PostgreSQL
> GUI applications for MacOS, Windows and Linux similar to MySQL Workbench (
> https://www.mysql.com/products/workbench/) ?
>

Check out Dbeaver (dbeaver.com).

-Tom

Re: Support for dates before 4713 BC

[Tom Browder]

This is a bit off topic, but Raku, the sister language of Perl, has a
built-in Date object that should be able to handle the situation. I wonder
if there is a possibility of someday having an interface with Raku as with
Perl.

Note Raku has an excellent module to use PostgreSQL.

Blessings.

-Tom

Re: The tragedy of SQL

[Tom Browder]

On Fri, Sep 17, 2021 at 06:49 Raymond Brinzer  wrote:
On Tue, Sep 14, 2021 at 9:06 AM Merlin Moncure  wrote:
> > I've long thought that there is more algebraic type syntax sitting
> > underneath SQL yearning to get out.
...
> Now, if this sort of thing suits the way you think, I say, "Great!"
> I'm glad you have a language which suits you.  For me, it's too rigid;
> it assumes too much about what I might want to say.  I wouldn't
> program in a language like this, or use a shell like this.  I don't
> want to write database queries like this.  I do, because it's how I
> get to talk to the awesome toy in the background, but it always
> chafes.

This thread strikes home because I've long used my favorite language,
Raku (and Perl before that) as a powerful glue language to generate
code in several languages I was forced to use and maintain during my
working years including FORTRAN, C, C++, PostScript, and SQL. I still
generate a lot of PostScript, but Raku has made it *much* easier.

Most recently I've used Raku modules for both ORM and procedural
interfaces to PostgreSQL, but with Raku's powerful grammar capability
a dedicated user can write his own language interface if he wishes.
In addition, Raku has a native C and C++ interface to ease using
PostgreSQL compiled code when necessary.

Best regards,

-Tom

P.S. See  as a starting place for Raku.

Re: Even more OT: Ditto machines [was: bottom / top posting]

[Tom Browder]

On Thu, Jun 10, 2021 at 15:52 Dean Gibson (DB Administrator) <
postgre...@mailpen.com> wrote:

> On 2021-06-10 13:21, Peter J. Holzer wrote:
>
> On 2021-06-09 14:41:47 -0700, Dean Gibson (DB Administrator) wrote:
>
> ... when paper memos were the norm ...
>
> ... before photocopiers were invented...
>
> Tom mentioned "old-timers."  Remember "Ditto" machines?  Remember the
> odor?  They were in common use when I was in high school (1960).
>

Indeed I "ditto" remember them! And the smell was the prize for running an
errand for the teacher to pick up copies from the Mimeograph room.

-Tom

Re: bottom / top posting

[Tom Browder]

On Wed, Jun 9, 2021 at 17:05 Tom Lane  wrote:

> "Dean Gibson (DB Administrator)"  writes:
> > Top-posting has been the predominantly common practice in the business &
> > government world for decades, & it is easy to adapt to.


But it sure adds to the digital clutter!

The reason why the old-timers around here are sticky about this is that
> we believe we are writing for the mailing list archives.  Gmail-style


I agree wholeheartedly, Tom.

>
I realize that a lot of posters to these lists can't be bothered to
> save a few seconds of my time.  That's fine; I tend to stop reading
> their messages right away.


Ditto.

Best regards,

-Tom Browder

Re: Binary downloads and upgrading the host OS

[Tom Browder]

On Sat, Apr 25, 2020 at 17:07 Magnus Hagander  wrote:
...

> Also don't forget that on an upgrade from Debian 9 to 10, you most likely
> need to reindex your string indexes, see
> https://wiki.postgresql.org/wiki/Locale_data_changes
> .
>

Thanks, Magnus!

-Tom

Re: Binary downloads and upgrading the host OS

[Tom Browder]

On Sat, Apr 25, 2020 at 10:24 AM Adrian Klaver
 wrote:
> On 4/25/20 8:04 AM, Tom Browder wrote:
> > I am using the PostgreSQL binary downloads for Debian from your apt
> > repositories.
...
> Looks good to me. I'm assuming you are leaving the Postgres version the
> same though. Is that correct?

Yes, I already use the latest stable via the apt setup (12 I think).

> Also, if it is not already planned, to be on the safe side throw in a
> backup of some sort just before shutting down the server.

Yes indeed!

Thanks, Adrian.

-Tom

Binary downloads and upgrading the host OS

[Tom Browder]

I am using the PostgreSQL binary downloads for Debian from your apt
repositories.

I am about to upgrade from Debian 9 to Debian 10 and would like
comments for my plan:

1. I will follow Debian's instructions for upgrading from 9 to 10.

2. Before I start the actual upgrade, I will:

+ ensure all is up-to-date for my PostgreSQL as well as the rest of my system
+ temporarily comment out the PostgreSQL links in /etc/apt.
+ stop the pgsql server and prevent auto-restart upon reboot

3. After the successful upgrade I assume I will:

+ update the apt sources for PostgreSQL with the new name (buster)
+ update as usual
+ restart the pgsql server and resume auto-start upon reboot

Thanks for your help.

Blessings,

-Tom