Editing involving several backup drives: how to assemble a project with minimal clip duplication?

This question might be a little complex, but here’s the situation:

We are a small team and we shoot almost every day, we do correspondence-type shooting. We are backing up our footage to external encrypted drives, there are three now. When I edit, I pull the folders that I want in the edit from the backup drive onto my Editing SSD drive. Because we shoot in MXF and MTS, I usually then transcode everything to ProRes. After that, I delete the original MXFs and MTS’ to conserve space.

With this, I end up with duplicated clips on my editing drive. When I edit in Final Cut Pro X, I choose several clips from these folders to be in the final edit from inside the FCPX, and after I render, there are unused, but linked files left behind. I have no way to automatically delete what was not used, and I don’t want to delete the folders with transcoded footage if I were to revise the project at a later date.

Is there any way to delete files not used in the timeline? How do I conserve on space? Is there anything in my workflow that could be optimized?

MySQL: Merge Same Database on Several Location into Single Location

I have a registration form, which is exactly the same for several locations. Each of them has a REG column, which is unique for each inserted row. Basically, each data input has a different REG number for it, which is auto incremented.

The location’s form references a location’s table which has the same structure for each individual location.

However, we have one central database which pulls all the data from several locations. This central database has the job of manipulating and populate ing all the location’s databases.

Let’s say, I have 3 locations, A, B and C. All those locations are using same database structure to save the data of each individual location.

What I need help on here, is how must I change or configure the database table or column so I can “restore” each individual database from the different location’s into one single database on the central location. If the structure is same, then the previous data will be replaced by the new one when restore/add to the database in the central location.

I have a column called CODE which stored specific hard code for each location, it is just a simple character either A, B or C based on where the location of the database is saved.

So, at the specific time, from 3 different locations, the form table will be backed up and sent to the central database. And there, it will be restored or added to the database to populate all from those 3 locations.

Any idea and little help, please? Thanks in advance.

Here the database layout I would like to be done.
Layout
And the engine is InnoDB.

How do I print a large single page in several small pages?

My use case is an A3 pdf landscape sheet that I needed printed in two A4 portraits. I am using desktop ubuntu 16.04.

What I have tried
What I have managed to do is use a command-line program that helps:
Split/Tile A3 (landscape) pdf to A4 (portrait)
or
how to print a single image in the 4 corners of the paper?

Also I have found Printing a poster (over several sheets of paper) but the solution uses a GUI version of the above command line options but does not seem to work with PDF or SVG.

Another option would be the print to file option mentioned in this answer. But even though I request it to print A4 size it just prints a new PDF which is A3 size.

What I would like is to have the option in the print dialogue.

I have a feeling that if I use the right settings it should work. But for example, the following settings on Page Setup and on Page Handling:
Print Page Setup Settings
Print Page Handling Settings

When I click preview I see the full A3 sheet in one landscape page I still press print in the hope that it will do what I want but:

It prints only the top right corner in landscape which I do not understand the logic.

Following the comment: If the box labelled “select page size using document page size” under the Page Handling tab is un-ticked then I get half the job done: It will print only the left hand side in an A4 portrait which is what I want. But I will still be missing the right hand side.

Use cases: Printing posters A2, A1 and A0 size when you don’t have access to a plotter or to check for typos, printing engineering drawings when you don’t have access to A3 printer or simply ran out of A3 paper and printing large images into parts

Question: Consider the possible attributes of an environment among several modalities (observability,…

Consider the possible attributes of an environment among several modalities (observability, determinism, discreteness, etc.). For each, consider the possible options (e.g., deterministic vs. stochastic, or continuous vs. discrete) and compare them. Would one prove harder to design an intelligent agent for than the other? Why?

(For example, designing an agent for a partially observable environment is naturally more difficult than for a fully observable environment because we cannot be certain of the state and must use additional overhead to maintain some sort of belief state.)

(Help with Artificial Intelligence homework. A straight up answer would be preferable.)

Create several subcategories without using the GUI in craft

I have to create the following categories hierachicall : One book has between 1 and 150 chapters.
I have to do this for several books. Dealing with chapters is painful using the GUI. Is there any way to achieve this directly using json, queries ?

Category “Book 1” is consisted of 100 chapters subcategory

  • Book 1 -> Chap 1
  • Book 1 -> Chap 2
  • Book 1 -> Chap 100

Category “Book 1” is consisted of 10 chapters subcategory

  • Book 2 -> Chap 1
  • Book 2 -> Chap 2
  • Book 1 -> Chap 10

Design a class to have several attributes or one attribute as dictionary with many keys, Python3 [on hold]

I have class for calculating temperature of an object at different positions, based on ambient temperature.

class BodyA:
    def __init__(self, ambient_temperature)
        self.amb_t = ambient_temperature
        self.pos1_t = self.amb_t + 1
        self.pos2_t = self.amb_t * 2
        self.pos3_t = self.pos1_t + self.pos2_t - 5


class BodyB:
    def __init__(self, ambient_temperature)
        self.amb_t = ambient_temperature
        self.pos_t = dict()
        self.pos_t['pos1'] = self.amb_t + 1
        self.pos_t['pos2'] = self.amb_t * 2
        self.pos_t['pos3'] = self.pos_t['pos1'] + self.pos_t['pos2'] - 5

In practical case, there are up-to 10 positions, and I want to build child-class from it. And some child-classes do not have certain positions. For example, pos2 can be missing in some child.

Could you please let me know, which design is better in terms of OOP and efficiency. Thanks.

Design a class to have several attributes or one attribute as dictionary with many keys, Python3

I have class for calculating temperature of an object at different positions, based on ambient temperature.

class BodyA:
    def __init__(self, ambient_temperature)
        self.amb_t = ambient_temperature
        self.pos1_t = self.amb_t + 1
        self.pos2_t = self.amb_t * 2
        self.pos3_t = self.pos1_t + self.pos2_t - 5


class BodyB:
    def __init__(self, ambient_temperature)
        self.amb_t = ambient_temperature
        self.pos_t = dict()
        self.pos_t['pos1'] = self.amb_t + 1
        self.pos_t['pos2'] = self.amb_t * 2
        self.pos_t['pos3'] = self.pos_t['pos1'] + self.pos_t['pos2'] - 5

In practical case, there are up-to 10 positions, and I want to build child-class from it. And some child-classes do not have certain positions. For example, pos2 can be missing in some child.

Could you please let me know, which design is better in terms of OOP and efficiency. Thanks.

Change Tracking across several Tables

I’m looking into providing DB level change tracking within my system. I need to be able to track changes at an entity level, rather than just individual tables.

Right now, we have triggers on each of the tables of interest, that write the tables PK into a Change_Event table. We can then query that table, and boil it down to the PK that represents the entity as a whole. We can then retrieve the data for that entity and perform the relevant actions upon it.

As an example, consider the following (simplified) example:

CREATE TABLE Employee
(
    Id INT IDENTITY PRIMARY KEY,
    Name VARCHAR(250) NOT NULL,
    Telephone VARCHAR(15) NOT Null
);

CREATE Table Visit
(
    Id INT IDENTITY PRIMARY KEY,
    VisitDate DATETIME2 Not NULL,
    [Address] VARCHAR(500) NOT NULL,
    VisitorId INT NOT NULL,
    CONSTRAINT FK_Visit_VisitorId FOREIGN KEY (VisitorId) REFERENCES Employee (Id)
);

INSERT into Employee (Name, Telephone)
VALUES ('John Doe', '123456789'),
('Jane Smith', '999555333');

INSERT INTO Visit (VisitDate, Address, VisitorId)
VALUES (SYSDATETIME(), '123 Fake St', 1),
(GETDATE() + 5, '99 Test Av', 2);

In this example, the Visit Entity is considered to be the following xml:

SELECT Id,
       CAST((
           SELECT Id,
                  VisitDate,
                  Address,
                  (
                      SELECT E.Id,
                             E.Name,
                             E.Telephone
                      FROM Employee E
                      WHERE E.Id = V.VisitorId
                      FOR XML RAW ('Visitor'), TYPE, ELEMENTS
                  )
                  Visitor
           FROM Visit V
           WHERE V.Id = Visit.Id
           FOR XML RAW ('Visit'), ELEMENTS
       ) AS XML) AS Data
FROM Visit

I need to be able to know, when one of those entities has changed. If I were to change the telephone number of the Employee, I need to be able to see that that has changed the Visit entity so that I can reprocess it.


Right now, my change table records the Employee Id. I then run a query that gives me all the visits with that employee as the VisitorId. That sounds fine when you are only looking at two tables, but when you factor in several tables (and potentially several levels of abstraction between them) the performance can get pretty slow.

I’ve looked into Change Data Capture, but that still seems to be capturing at a table level. Equally, I could add Modified date columns to all tables, and combine all the modifieds from the view to produce a single, max modified value – but considering I need to filter on that field, I can’t imagine performance would be that great either.

Is there a recommended method of dealing with this within SQL Server? As an added consideration – whilst the Instance is SQL 2008, the DB is still in 2000 compatibility mode.

UPDATE

I’ve been looking into Change Tracking, which works pretty well at a table level. Unfortunately it doesn’t work too well with the select above.

I even tried creating a schemabound view based on that select, and enabling change tracking on the view, but this appears to be an option that can’t apply to views.

I can make it work by using something like the below:

WITH ChangedVisits AS
(
    SELECT DISTINCT OV.Id
    FROM dbo.Visit OV
        INNER JOIN Employee E ON OV.VisitorId = E.Id
        LEFT JOIN CHANGETABLE(CHANGES Visit, @LastSyncVersion) AS VCT ON OV.Id = VCT.Id
        LEFT JOIN CHANGETABLE(CHANGES Employee, @LastSyncVersion) AS ECT ON OV.VisitorId = ECT.Id
    WHERE VCT.Id IS NOT NULL
        OR ECT.Id IS NOT NULL
)
SELECT Id,
       CAST(
       (
           SELECT V.Id as [@Id],
                  V.VisitDate,
                  Address,
                  (
                      SELECT E.Id,
                             E.Name,
                             E.Telephone
                      FROM dbo.Employee E
                      WHERE E.Id = V.VisitorId
                      FOR XML PATH(''), TYPE, ELEMENTS
                  )
                  Visitor
           FROM dbo.Visit V
           WHERE V.Id = CV.Id
           FOR XML PATH ('Visit'), ELEMENTS
       )
       AS XML) AS Data
FROM ChangedVisits CV

But the drawback of that is the need to join on each of the tables and an associated CHANGETABLE object in order to work out if something has changed.