about archives contact posts tags

my hackergotchi

Since you're already here and don't want to pass by, welcome to my webpage!

One may wonder what Pimentola is. Well, according to Kalevala, it is a very cold location somewhere in the far North. The word means something like a "region of darkness". That's why it is dark over there. You can check an article on Pohjola to learn a bit more.

Hope you're not afraid of cold and darkness.

RSS Atom
0036: Debian log, 2020-05

Here is my monthly log covering what I have been doing for Debian in May 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Synchronized po files

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 69 spam reports.

Posted Mon Jun 1 12:41:37 2020 Tags:
0034: Debian log, 2020-04

Here is my monthly log covering what I have been doing for Debian in April 2020.

Debian website

Added new files

Translated new pages into Russian

Debian packages

Uploaded packages

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 0 spam reports.

Posted Sat May 2 00:00:18 2020 Tags:
0034: Debian log, 2020-03

Here is my monthly log covering what I have been doing for Debian in March 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 138 spam reports.

Posted Wed Apr 1 10:17:13 2020 Tags:
0033: Debian log, 2020-02

Here is my monthly log covering what I have been doing for Debian in February 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Localization

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 166 spam reports.

Posted Sun Mar 1 12:26:32 2020 Tags:
0032: UDD to the rescue

In #debian:matrix.org one person just performed stretch->buster upgrade and asked about a way to get a list of newly added packages, that is a list of packages in buster but not in stretch. Another person proposed to run a VM with stretch to get a list of packages in stretch, then run a VM with buster to get a list of packages in buster, then do diff between them. This advise is pretty ingenious, but I doubt that it's good way to do such a simple task. Well, there is UDD, so UDD to the rescue!

There's a public UDD mirror which allows anyone to query UDD using PostgreSQL command-line or GUI clients. So, the mentioned task can be easily solved as follows.

  1. Install your PostgreSQL client of choice, say:

    sudo apt install postgresql-client

  2. Connect to the public mirror with the following command:

    psql -U udd-mirror -h udd-mirror.debian.net -p 5432 udd

  3. Run the following PostgreSQL query:

SELECT package FROM packages WHERE release='buster' AND architecture='amd64'
EXCEPT
SELECT package FROM packages WHERE release='stretch' AND architecture='amd64' ORDER BY package;

This SQL query gives a list of packages in buster but not in stretch for amd64 architecture sorted by package name.

That's it! Pretty easy, huh? UDD is a wonderful source of data about Debian and I really like it.

More information about UDD:

Debian wikipage on UDD

Index of UDD database

Posted Sun Feb 9 14:39:34 2020 Tags:
0031: Debian log, 2020-01

Here is my monthly log covering what I have been doing for Debian in January 2020.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Syncronized po files

Debian packages

Uploaded packages

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 256 spam reports.

Posted Sat Feb 1 11:04:41 2020 Tags:
0030: Debian log, 2019-12

Here is my monthly log covering what I have been doing for Debian in December 2019.

Debian website

Added new files

Translated new pages into Russian

Syncronized po files

Debian packages

Uploaded packages

Uploaded packages to the NEW queue

Debian Mailing Lists, Listarchive Review

Reviewed 104 spam reports.

Posted Wed Jan 1 11:21:44 2020 Tags:
0029: Debian log, 2019-11

Here is my monthly log covering what I have been doing for Debian in November 2019.

Debian website

Added new files

Translated new pages into Russian

Debian packages

Uploaded packages

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 70 spam reports.

Posted Sun Dec 1 12:28:45 2019 Tags:
0028: Debian log, 2019-10

Here is my monthly log covering what I have been doing for Debian in October 2019.

Debian website

Added new files

Translated new pages into Russian

Debian packages

Uploaded packages

Debian Mailing Lists, Listarchive Review

Reviewed 64 spam reports.

Posted Sat Nov 2 21:42:19 2019 Tags:
0027: Debian log, 2019-09

Here is my monthly log covering what I have been doing for Debian in September 2019.

Debian website

Added new files

Translated new pages into Russian

Synchronized translated pages with the original ones

Debian packages

Uploaded packages

Bugs

Debian Mailing Lists, Listarchive Review

Reviewed 38 spam reports.

Posted Sat Nov 2 21:31:29 2019 Tags:

This page is powerly powered by powerful ikiwiki.