aggregate – Should aggregated data include meta data?

I want to create a aggregation job that executes a big db query and flush it into BigQuery.
My question is should I include only the id of the entities (campaign id, advertiser id, user id) or should I include also the meta data (campaign name, advertiser name, user name).

The upside for metadata storing is that I have the whole data in one place.
The downside is that when the metadata been changed (campaign name modified for example) then the whole data should be aggregated again.

Is there a best practice for this kind of situation?

htaccess – What types of files does ExpiresDefault include?

But, what are the file types that ExpiresDefault will work on ?

As you’ve stated, “the rest”. Any responses that are not covered by the mime-types stated in the preceding ExpiresByType directives are covered by the ExpiresDefault directive.

So, from the directives you posted, this will include HTML (text/html), JS (application/javascript), CSS (text/css) and anything else you are serving.

Are php files also included here ?

Well, that depends what mime-type your PHP files are being served with.

Ordinarily, your PHP files probably default to a text/html mime-type since you often serve HTML content from PHP files (by default). In which case, your ExpiresDefault directive will include these responses, since text/html is not covered by the specific ExpiresByType directives.

However, PHP can potentially serve anything. Your PHP file could generate a JPEG image, in which case it should be served with a image/jpeg mime-type (in the Content-Type HTTP response header). In this case, the ExpiresByType image/jpeg ... directive will cover this response and ExpiresDefault will not apply.

Aside:

ExpiresDefault "access plus 2 months"

The plus keyword is entirely optional. It is just syntactic sugar, to make it more readable.

So, include it or not – it is up to you. But, as with everything, it is important to be consistent. Include it OR don’t include it; don’t mix.

ExpiresByType image/jpg "access 1 years"
ExpiresByType image/jpeg "access 1 year"

You don’t need both of these. Your server is (or “should be”) responding with only one or the other mime-type for JPEG images. It “should be” image/jpeg, which is the official mime-type. However, you could have a “buggy” script that thinks otherwise.

Check the Content-Type HTTP response header for the mime-type that is being served. That is the only one you need to target.

seo – Does Google Key Word Planner include data from misspelled words typed in the Chrome browser URL bar?

Stack Exchange Network


Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

media library – Does using the WordPress Import tool still include attachment data if “Download and import file attachments” is not selected?

I’m in a unique situation where I have to import WordPress content into a production server, but I don’t have SSH access to the server files or database. I can’t install plugins on the production server, so I am limited to the built-in WordPress Importer tool.

I don’t have any issues bringing over Posts and Pages, but it’s extremely hit or miss when bringing over the Media Library, of which I have something like ~2000 items.

What I do have, however, is access to the S3 bucket where the production server hosts the Media Library. The production server also automatically rewrites URLs for the media library to point to the S3 bucket.

My question is: If I migrate my Media Library files to my S3 bucket beforehand, then use the WP Exporter tool to export “All content” from my source site and import it into my production site and leaving “Download and import file attachments” unchecked, will my Attachment data (not the files themselves) still be imported into the database?

sharepoint online – Insdie CSOM what does Web.SiteUsers include exactly

I am a bit confused on what does Web.SiteUsers include in CSOM? as per the documentation it includes the users which belong to a site collection, but what does belong mean?

Does it mean users who have permission on the site, even if the permission was not granted directly to the user but through an AD group or through the “Everyone Except external” group?

I need a way to get all the users which can access the site regardless of the way they have been granted access to. Can anyone advice ?

How to include externally hosted images into a gallery

WordPress has a really great native gallery function. The only downside I find is that it requires you to have the images on your domain.

We have a blog for fun, and a very cheap hosting plan. Which is limited in storage, now when we want to increase the storage it comes at a hefty price.

Google photo’s will host our images for free, so I was planning on embedding the images directly from there. However the native Gallery offers no option to include images from an external source, as far as I can tell. I can include them using a single image block, or with tweaking the HTML ofcourse.

Is there a way to include externally hosted images in a gallery, or an easy way to edit the HTML for such a gallery to work with external images?

linux – I have an IP camera that doesn’t include a “from” for a status email and need to add it at the MTA

I’m using postfix on this system, and there are four cameras attached. These cameras when sending email don’t include a “from” address, and they are rejected by gsuite because of that. I’ve seen the rewrite rules etc, but they don’t cover the situation where the from address doesn’t exist. What’s the best way to add a from address based on the source IP address to the email in postfix?

webforms – How do I include composer.libraries.json in root composer.json without using the wikimedia/composer-merge-plugin plugin?

In the recent update to Composer 2.0 the advice is to get rid of the wikimedia/composer-merge-plugin, which was even removed from the dependencies of Drupal core.

There is documentation on how to include custom module’s composer.json in the root composer.json, for example Managing dependencies for a custom project, but I cannot find documentation on how to include composer.libraries.json in the root composer.json.

Can anyone explain how to get the Webform module compatible with Composer 2.0?

How can I create build and deployment automation package which can include PowerApp, MS Flow and SharePoint list?

Stack Exchange Network


Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange