Jonathan Levin

The example of the 'sum of product truck' might not be useful to end users. The usual requirements for these sorts of aggregation usually come with 'drilling down' to the...

Technically speaking, you have two 'business specific' ways of going about this: 1) You have an intermediate summary table that aggregates data by product/day/location 2) In the product table, you...

Need to break this down to a few tasks: - Get the metadata of the database tables - Convert the metadata to CREATE TABLE commands - Have command to disable...

There are two types of database backups: physical and logical. Physical is backing up the actual blocks or files and Logical is SQL statements. You should normally do both. The...

There is another tool I just ran into that seems to do this. https://www.gnu.org/software/datamash/examples/#example_grouping