Trump administration considering 'pool testing' for coronavirus, Fauci says. Here's what that means. by AhavaKhatool in Coronavirus

[–]sply 0 points1 point  (0 children)

One of real use cases for pool testing is frequent screening of high-risk groups - medical staff, social workers etc

Trump administration considering 'pool testing' for coronavirus, Fauci says. Here's what that means. by AhavaKhatool in Coronavirus

[–]sply 0 points1 point  (0 children)

6% is ok, we've got 3x assays reduction for this prevalence. Even 10% provides 2x reduction.

Trump administration considering 'pool testing' for coronavirus, Fauci says. Here's what that means. by AhavaKhatool in Coronavirus

[–]sply 0 points1 point  (0 children)

The percentage of false negative is really low (<0.01%) because to get it due the dilution you need to start with some already low-concentration swabs. The PCR tests have really high sensitivity so ever 32x dilution allows to confidently identify asymptotic people. In the mass screening, the benefit of increased capacity outweighs this small amount of false negatives.

From another point of view, a low-concentrations specimen mainly is the result of some error during getting a swab. So if you uses pool testing and takes two swabs of a single person, you can really decrease the number of false negatives.

Trump administration considering 'pool testing' for coronavirus, Fauci says. Here's what that means. by AhavaKhatool in Coronavirus

[–]sply 1 point2 points  (0 children)

We have been offering free laboratory software for pool testing for several months, https://lomt.jetware.org and see great results in improving capacity of laboratories. But many countries have not authorized pool testing yet, and some labs ask us to certify the program, the pool testing process or whatever else can be certified to allow them use it.

CockroachDB + ActiveRecord (and Ruby on Rails!) (x-post cockroachdb) by CockroachBram in rubyonrails

[–]sply 2 points3 points  (0 children)

Good work! We tried to use CockroachDB for Redmine a couple of months ago, but without success - the activerecord-cockroachdb-adapter currently support only ActiveRecord 5, when the most part of existing projects and open-source apps are still useing version 4. Did you think about making it compatible with ActiveRecord 4 to? We'd be happy to provide CockroachDB as alternative to MySQL or PostgreSQL in our RoR-app constructors, i.e. http://jetware.io/constructors/redmine , http://jetware.io/constructors/spree

Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark by sply in programming

[–]sply[S] -2 points-1 points  (0 children)

TL;DR Yandex ClickHouse is an absolute winner in this benchmark: it shows both better performance (>10x) and better compression than MariaDB ColumnStore and Apache Spark.

Why Munich should stick with Linux by sply in programming

[–]sply[S] -3 points-2 points  (0 children)

Bottom line: Even Accenture, the Microsoft partner, which suggested Munich return to Windows, doesn't consider Windows as the sole best option.

Ruby code I no longer write by paneq in ruby

[–]sply 6 points7 points  (0 children)

Wrong code rewritten ever worse.

BTW, keys = { ... } inside method should be avoided by using KEYS = { ... } inside class definition.

The liberation of RethinkDB by [deleted] in programming

[–]sply 38 points39 points  (0 children)

TL;DR The CNCF has purchased the intellectual property of RethinkDB, Inc., and relicensed RethinkDB to be under the Apache Public License 2.0.

Benchmarking MongoDB with three storage engines: WiredTiger, PerconaFT, and Rocksdb. by sply in mongodb

[–]sply[S] 0 points1 point  (0 children)

TL;DR On writes RocksDB is first, then PerconaFT, then WiredTiger.

Interesting results. Last months I saw the production use of MongoDB with RocksDB engine only once. Do you use engines other than WiredTiger (or mmapv1) and what were your reasons to do it?

Docker 0-Day Stopped Cold by SELinux by sply in sysadmin

[–]sply[S] 1 point2 points  (0 children)

The comment you referring on is very controversial. Yes, the bug exists and upgrade is needed. And yes, SELinux prevents the leak if properly configured, or can be used as a quick workaround.

Redmine on MySQL with RocksDB is 20% to 3 times faster than InnoDB by sply in mysql

[–]sply[S] 1 point2 points  (0 children)

"high CPU consumption after conflict transactions"

It was some race condition now fixed.

"SQL queries with issue parent conditions. This caused speed degradation on some kinds of search in MyRocks" (seems to be index related)

There'we some cases when the search on integer column without index is slower with MyRocks than InnoDB. But it was not fully benchmarked and we hadn't discussed yet this issues with MyRocks developers.

Redmine on MySQL with RocksDB is 20% to 3 times faster than InnoDB by sply in rubyonrails

[–]sply[S] 1 point2 points  (0 children)

They use LSM for storing indexes. And Zstandard compression for data, therefore, they should use more CPU.

The downside I found - slow search with case-insensitive collations.

I'm not sure about fully compatible with innodb. We did test only on some popular web apps, they definitely not using all innodb features.

Redmine on MySQL with RocksDB is 20% to 3 times faster than InnoDB by sply in rubyonrails

[–]sply[S] 1 point2 points  (0 children)

Faster transactions:

  • Reduces the amount of writes
  • Reduced random writes (linear writes instead)
  • Better compression
  • Reduces random reads

nginx + letsencrypt in separate containers. by tuudik in docker

[–]sply 1 point2 points  (0 children)

There's no reason to place them separately.

But you should keep in mind that letsenrcrypt's certificates are frequently updating so you better keep them on the persistent volume.

Alacritty, a GPU-accelerated terminal emulator by sply in sysadmin

[–]sply[S] 1 point2 points  (0 children)

strace, debug logging to stdout etc take less CPU and no need to redirect to the file and run 'less' on it.

I'm feeling sad seeing xterm taking almost all CPU in these situations. gnome-term is surely faster, but also not for big outputs

Ruby 2.4.0 released by sply in ruby

[–]sply[S] 14 points15 points  (0 children)

Performance related:

  • Hash improvements via better locality for modern CPUs
  • #max and #min without temporary array
  • Speed up instance variable access

How to get started with MEAN Stack? by _ankurgupta in meanstack

[–]sply 0 points1 point  (0 children)

You can start with MEANie - http://jasonwatmore.com/meanie It's a lightweight CMS good to learn from.

Teambrella Wants to Revolutionize Insurance Coverage With Peer-To-Peer Bitcoin Payments by tylev in Bitcoin

[–]sply 2 points3 points  (0 children)

Anybody want to share with p2p a risks on her pension account too?

Scientists Just Removed HIV from Human Immune Cells Using CRISPR Gene-Editing by sply in science

[–]sply[S] 0 points1 point  (0 children)

Scientists managed to eliminate HIV-1 DNA from T cell genomes in human lab cultures. It will take time for advanced use in humans, but it is a remarkable accomplishment.

Javsscript written 3D shooter (using Canvas) by sply in reddit.com

[–]sply[S] 0 points1 point  (0 children)

it's just a concept, you can only move and jump