## File management: what open and free software do you use to manage a large collection of photos?

What is the best software to manage photos? I know this is a question that has been asked in the past, but I want to add two restrictions:

• Open format. If in 50 years someone wants to see the photos I took, I want them to be able to extract the metadata from my photo, regardless of whether the software I used to label the photos exists or not.
• Free. I can not imagine paying a monthly fee to Adobe for the rest of my life. The day I stop paying, I lose the metadata.
• It works in Windows.

I really like to use Lightroom 5, but I'm worried that Adobe in a few years will tell us that we can not use it anymore (https://www.vice.com/en_us/article/a3xk3p/adobe-tells-users-they-can-get -demand-to-use-old-versions-of-photoshop).

Over the years, I have taken more than 30,000 photos and would like to be able to label them all with the confidence that the labels will not be lost due to a software license.

## Cheap or expensive brushes / Art suppliers

Cheap or expensive brushes / Art suppliers

1. ## Cheap or expensive brushes / Art suppliers

In quality and price, the best watercolor brushes can vary from those in a sealed package of perhaps five, hanging at the end of the aisle of your national chain hobby shop to those that have a real stamp of approval as "By command, Her Majesty the Queen." (Famously, Queen Victoria ordered Winsor & Newton what would be her 7 favorite size in the series 7 of the red saber rounds Kolinsky). The first option could serve, for a short time, to clean a child's boots in his wardrobe. The latter could be framed with pride on the wall of your studio. In between, you will find a wide selection of more than just repairable brushes, of recognized fine brands. Some of these brands are: Winsor & Newton Series 7, Isabey, Rafael, Arches, Escoda, Pro Arte and others. The smaller lines, but still quite useful, include: Winsor & Newton Series 666, Princeton and Grumbacher. I recommend buying a good brand. Avoid the various gangue packages; they will perform so poorly in practice and in durability that they will feel very discouraged. I have some of each mentioned brand and I enjoy every brush. And yes, I bought cheappo brushes in the past … and I had to throw them away.

#### Publication permissions

• Your could not post attachments

.

## postgresql – How to consult the results of a large postgres database?

SELECT COUNT (DISTINCT column_name) FROM table_name;

The part of the PostgreSQL code that implements "COUNT (DISTINCT …)" is quite old and has not done much performance work recently. You can not take advantage of parallel processing or hash tables, for example. I could rewrite with a subquery to possibly take advantage of some newer techniques:

``````select count (*) of
(select a column name other than table name where column name is not null) as foo
``````

But still, this is not such a trivial task as it seems to think it is. It is a difficult task and can take a long time when large amounts of data are ingested.

I am concerned that if the use joins the operations in these tables, this waiting time will increase significantly and be more painful.

Do not invent things to worry about. The performance of a `ACCOUNT (DIFFERENT ...)` It tells you very little about the performance of a JOIN. Write the query you want and then worry about optimizing that query, not another query that has little to do with what you want.

It may make sense to simplify a query to see how long your components can last. But `ACCOUNT (DIFFERENT ...)` it is unlikely to be such a simplifying component part.

## Kernel failure to save / get large files

I have been experiencing accidents in Mathematica 11.0.1 on a machine at work. I've tracked the problem until when Mathematica is using `Save[fileName]` or `Obtain[fileName]`, but sometimes the blockage occurs a few minutes after loading a file. The files I'm using are quite large (350-650MB), which contain variables saved from before. The locks seem to happen randomly, that is, sometimes the file loads correctly and the script ends, but sometimes it hangs and everything stays the same. I checked the records and every time there was a blockage, I was the only one in the machine that executed math or anything else.

What is strange is that on my laptop (Mathematica v.12) I have not encountered any problems, and neither has my official (the same version of Mathematica as the server).

Is there any option that could have been modified on the server that could explain those problems? I do not have root access on the server.

## Large packages! Double disk space and bandwidth: \$ 10 / year -50% discount on unlimited domains with recurring discount | Proxies123.com

WebHostGlobe.com specializes in providing first class web hosting services to clients around the world. We ensure that customers receive a high quality of service and customer satisfaction is maintained. We use the best infrastructure and latest hardware servers in its class to meet the needs and accommodation requirements of our customers. Our engineers have the relevant technical experience to solve problems and solve them quickly to ensure the stability of the network. In short, we strive to help our clients succeed.

All our hosting plans are loaded with the following features:
– Last Control Panel of cPanel
– Money back guarantee
– 99.9% availability guarantee
– Softaculous Auto Installer with more than 100 applications
– Server level protection
– Unlimited subdomains
– Unlimited MySQL databases
– Unlimited email accounts
– Unlimited FTP accounts
– …and many more!

Accommodation plans
Bronze

Disk space: 5GB (usual: 1GB)
Bandwidth: 50GB (usual: 10GB)
Host 1 website
Unlimited subdomains
Unlimited MySQL databases
Unlimited email accounts
Unlimited FTP accounts
Free cPanel control panel
Free Softaculous One-Click Installer
Free configuration and activation
99.9% availability guarantee
Cloud enabled hosting
Money back guarantee
Price: \$ 10 / year with the coupon code "WJ10"
Order now

Silver
Disk space: 10GB (usual: 2GB)
Bandwidth: 100GB (usual: 20GB)
Unlimited subdomains
Unlimited MySQL databases
Unlimited email accounts
Unlimited FTP accounts
Free cPanel control panel
Free Softaculous One-Click Installer
Free configuration and activation
99.9% availability guarantee
Cloud enabled hosting
Money back guarantee
Price: \$ 15 / year with coupon code "WJ15"
Order now

Gold
Disk space: 15GB (usual: 5GB)
Bandwidth: 150GB (usual: 50GB)
Unlimited subdomains
Unlimited MySQL databases
Unlimited email accounts
Unlimited FTP accounts
Free cPanel control panel
Free Softaculous One-Click Installer
Free configuration and activation
99.9% availability guarantee
Cloud enabled hosting
Money back guarantee
Price: \$ 20 / year with coupon code "WJ20"
Order now

Platinum
Disk space: 20GB (usual: 10GB)
Bandwidth: 200GB (usual: 100GB)
Unlimited subdomains
Unlimited MySQL databases
Unlimited email accounts
Unlimited FTP accounts
Free cPanel control panel
Free Softaculous One-Click Installer
Free configuration and activation
99.9% availability guarantee
Cloud enabled hosting
Money back guarantee
Price: \$ 25 / year with coupon code "WJ25"
Order now

Do you need more details? Visit us now at: http://webhostglobe.com/hosting

## pr.probability: What is the large n limit of a distribution of the following sample statistics:

What is the large n limit of a distribution of the following sample statistic:$$displaystyle frac { sum ^ {n} X_ {i}} {, sqrt {, sum ^ {n} X_ {i} ^ {2} ,} ,}$$ When sampling the Cauchy distribution (0.1)? The Monte Carlo simulation indicates that the convergence to this limit is quite fast and that the resulting PDF (symmetric) has very marked cusps in -1 and +1, but, of course, it does not produce an analytic expression for this PDF. Find them? The following image shows how the positive half of the PDF looks

## Backup: How to export a large WhatsApp chat with media exactly as it appears on my phone?

I want to export a great WhatsApp conversation (346,000 messages) along with the media (photos, videos and voice notes) to my computer exactly as it appears on WhatsApp.

There is a Chrome extension that does exactly what I want when I download the WhatsApp Web conversation as HTML. But, it crashes around 100,000 texts. Is there any other way?

I can not export it directly through WhatsApp because it is limited to 40,000 texts. Also, my phone is not rooted, so extracting SQLite files is not an option.

(The technical answers are highly recommended)

## php – the best way to use a large matrix in the function

If it's just a list of numbers, I'd suggest simply saving them in a text file, with a number on each line.

``````110019
111222
112233
``````

Then, when you need the file, read its contents with PHP and use `exploit()` to convert it into an array:

``````\$ file_path = plugin_dir_path (& # 39; postcodes.txt & # 39 ;, __FILE__); // Or wherever you have placed it.
\$ file_contents = file_get_contents (\$ file_path);
\$ postcodes = preg_split ("/  r  n |  n |  r /", \$ file_contents);

if (in_array (\$ postcode, \$ postcodes)) {

}
``````

That `preg_split ()` The method for dividing text based on new lines is taken from here.

## convergence – Test using the law of large numbers

Leave $$X_ {1}$$,$$X_ {2}$$, … be independent random variables satisfactory $$E (X_ {n} ^ {4}) for some finite $$B> 0$$ Y $$E (| X_ {i} |)$$ $$rightarrow$$ $$mu$$.

a) Show that $$Y_ {n}$$ = $$X_ {n}$$$$E (X_ {n})$$ they are independent and $$E (Y_ {n}) = 0$$, $$E (Y_ {n} ^ 2) < sqrt (B)$$, $$E (Y_ {n} ^ 4) <16B$$.

b) Show that for $$bar Y_ {n} = (Y_ {1} + … + Y_ {n}) / n$$,
$$E ( bar Y_ {n} ^ 4) = frac {1} {n ^ 4} sum_ {i = 1} ^ {n} E (Y_ {i} ^ 4) + frac {6} { n ^ 4} sum_ {i neq j} E[Y_{i}^2 Y_{j}^2] leq frac {16B} {n ^ 3} + frac {6B} {n ^ 2}$$

c) show that $$sum_ {n = 1} ^ { infty} P ( bar Y_ {n}> epsilon) < infty$$ and conclude $$bar Y_ {n} rightarrow 0$$ almost sure

d) Show that $$( mu_ {1} + … + mu_ {n}) / n rightarrow mu$$ and finish the test $$bar X_ {n} rightarrow mu$$
almost surely

I can handle the question a) to try $$E (Y_ {n}) = 0$$ but I have no idea of ​​the rest of the problem. I think c) and d) may have something to do with the law of large numbers, but they do not know how to proceed. Can anyone give any detailed suggestions about the rest of a), b), c) and d)?

Thank you!

## postgresql – Postgres accelerates the creation of indexes for large tables

I have a large Postgres table with more than 2 billion entries (1.5TB) and mostly not null, with var columns. To speed up the insertions, I released the indexes before doing a massive load. However, it is now taking forever to create the b-tree indexes. For one of the races I cut, I had spent more than 12 hours creating the indexes.

Example of table and indexes that I am trying to make:

``````                                Column | Type | Modifiers
----------------------- + -------------------------- --- + -----------
name | character that varies | not null
id | character that varies |
lifecycle_id | character that varies |
dt | character that varies |
address | character that varies |
...

Indexes:
"name_idx" PRIMARY KEY, btree (name)

"id_idx" btree (rec_id)

"lifecycle_id_idx" btree (lifecycle_id)
``````

The current table has 18 columns. I have configured the maintenance_work_mem to 15GB. This is running on Postgres 9.6.11 on RDS. The instance class is db.m4.4xlarge.

Since there are three indexes, it would be difficult to classify the data before inserting them. Would it be faster to simply insert the data without discarding the indexes? Any other suggestions to accelerate the creation of the index?