It dominates или о доминировании

Submitted by Serguei_Tarassov on

Цитата.

Les Etats-Unis... sont la seule et unique hyperpuissance. Elle est prédominante dans tous les domaines : économique, technologique, militaire, monétaire, linguistique, culturel. Cette situation est sans précédent
Hubert Védrine, Ministre des Affaires étrangères de la République Française, 2000 (1)

Failure to download extra data files with ttf-mscorefonts-installer on Ubuntu 16.04

Submitted by Serguei_Tarassov on

An annoying problem due to invalid download links in the package. The Debian package was fixed already.

Solution for Ubuntu.

1. Download ttf-mscorefonts-installer_3.6_all.deb package from Debian site into your Downloads folder

Types of joins in SQL (cheatsheet for beginners)

Submitted by Serguei_Tarassov on

This article is used in my book "Programming with databases".

Better to see once than to hear a hundred times. This small article explains what are the different kinds of joins in SQL.

At the first time you should take into account that SQL is a declarative 4th generation language. So the best way to use it (especially for beginners) is to write the query and let SQL optimizer do its job. That means thinking in set-oriented terms and avoiding sub-queries.

Let's take two example tables: Companies and Contacts.

Delphi Starter doesn't support command line

Submitted by Serguei_Tarassov on

Delphi feature matrix has two important points:

  • Delphi 32-bit native code optimizing compiler (dcc32) for Windows, including high performance x86
    Assembler
  • Delphi toolchains for Windows

Regardless indicated options dcc32 doesn't work in Delphi Berlin Starter with the error message "This version of the product does not support command line compiling".

Pages

Subscribe to Mechanics of software RSS