rpedela

Elasticsearch, Lucene under the hood, implements an inverted index which is an extremely fast data structure for text search. ES has clustering as a primary feature too and many search features that can significantly improve relevance that you won't find in MySQL and most other databases.

In a double-blind, phase 3 trial only one group has on-going data access: the independent group conducting the study. No one else, including patients, doctors, and the business, has any knowledge of the results until they are "unsealed". That continues to be true throughout the entire trial even if preliminary results are unsealed at different points.

Yeah those logos help with the stability part. Obviously logos alone does not prove stability, but it is one signal.

If your data has an obvious shard key, like customer ID, then I suggest taking a look at Citus. Not exactly multi-master, but a good sharded solution for PG. There is a managed version of Citus on Azure too.

Grass is always greener...

It can be a tough decision, but I have been through it enough times that I don't really care what the options package is. I just want one if everyone else gets one, but otherwise I look at salary and benefits. Because most likely the shares will become worthless, and if not, I most likely won't be around to see the liquidation event. I never exercise unless I know for a fact a liquidation event is coming.

In private companies, you often are unable to sell your shares because it requires board approval. The AMT trap, in oversimplified terms, is being wealthy enough on paper, due to shares, to trigger AMT but unable to sell shares to cover the taxes.

90 days for ISOs is US law. They can be converted to NSOs to get a longer exercise term, but there are different tax implications too. Some companies are offering the conversion now.

Have to agree with others that more funding, alone, won't solve the problem. At my mother's school, any extra funding usually paid for more administration to tell her how to do her job wrong.

One exception would be if your product has really good and obvious search keywords that are being searched at a reasonably high volume. Google ads can work really well in this scenario. Even better if no one else is buying ads for those keywords.

> Unfortunately because web content is automatically positioned/sized in a way that's (mostly) opaque to JavaScript code, this is a pretty hair problem (compared to graphics where you have all the numbers on-hand).

Exactly the same for 3d graphics. The auto-positioning is different but conceptual similar.

Yes B is my recommended approach. Since we are talking about performance, we should really be putting limits on what fast and slow mean. That is because it doesn't really matter if something is fast or slow, what matters is the performance difference between different approaches.

For B on average, performance will in the microsecond range, DOM rendering will be in the millisecond range, and the network is >100ms to seconds range. It is unlikely that B will be equal or slower to brute force rendering everything. Those X microseconds spent figuring out the culling window saves Y milliseconds rendering and saves Z milliseconds to seconds querying the network.

I'm an old 3d graphics programmer. One of performance rules is only render what will be displayed in that frame because rendering is expensive. That is why there are various culling algorithms, some are quite complicated. The reward for implementing all these advanced culling algorithms is very fast frame renders that give you more time to draw special effects, draw more characters, etc in a single frame.

I am a data engineer now and sometimes have to build web interfaces for scrolling large data tables. Just like in the 3d graphics world, the trick to responsiveness is culling. Only download and display the amount of data that the user will see at a given time, plus some overhead so the user never sees gaps when scrolling.

While Rust may have solved the problem in #1, it is unlikely to solve the problem in #2 because you are also fighting the network where Rust is useless. Need culling.

No it should based on the need of the use case, as always. Very few websites, even highly dynamic ones that require React, need to be rendered at 60 fps.

60 fps is rarely needed in web apps.

Yes and it can make certain use cases easier. There are pros and cons to both index-time and query-time stemming, synonyms, etc. I usually use index-time stemming and query-time synonyms.

Shouldn't be slow if shared memory is used.

https://docs.python.org/3/library/multiprocessing.shared_mem...

Clubhouse.io

Jira recently overhauled their UI to make it more similar to Clubhouse, but it still isn't as good. Jira is still slow and buggy. Clubhouse also has seamless integration with Github which makes it feel like I am using GitHub issues when tagging PRs, etc. There is also a BitBucket integration, but haven't used it. To me Clubhouse does something that no other similar tool does: make PMs and engineers happy.

On Android and Chrome, I can't read the page. The graphic takes up half the screen and the text underneath is barely visible.

The PG dev community puts data correctness above all else. It is a good, strong opinion to have for database software but it does slow down feature development. The most requested feature for years was UPSERT but it wasn't implemented until 9.4 because they couldn't figure out how to do it without any gotchas until then.

Sometimes participation is required to pass psychology classes.

The reality is that you need to practice that stuff in order to get through the first interview or two at many companies. It is most likely helping with web development even if it isn't obvious how. Kinda like how lifting weights and jogging helps someone be better at their favorite sport. Think of it as cross-training.

Caffeine is well established to interrupt sleep. Interrupt doesn't necessarily mean a person wakes up either. It can mean 9 hours of less restful sleep than without caffeine. Over the long term, the less restful sleep can lead to other problems.

For that specific example, they needed both. You could craft a custom query to accomplish that every time in the old version, but you really needed to know what you were doing. Now that they changed some defaults in the UI and made search improvements on the back end, I haven't seen that specific problem since.

Pubmed has needed an upgrade for at least 15 years. The fact you could search for the exact article title in the old version and never find it says a lot.

Falcon

https://github.com/falconry/falcon

PG community has put a lot effort into performance the last few years, including JIT compilation in PG12. Is that criticism still true today?

One of the best data tools I have ever used: DBT. The big concept is that everything is a SELECT and handles most DDL and DML under the hood. It also provides the ability to add scripting, such as loops, with Jinja. It is primarily meant for OLAP and ELT, but could be used for some OLTP too.

https://github.com/fishtown-analytics/dbt

There is a causal relation between more energy and more prosperity, not pollution. Pollution is a byproduct of how we have chosen to produce that energy. There is no fundamental reason it has to stay that way.

Turnaround time for supporting the latest version on RDS is faster, and RDS supports more extensions. Then if you need to scale you have Aurora.

I will buy SQL Server specifically, but if you are using MySQL or Postgres then AWS is still the clear winner in my book. RDS is great and Aurora is even better, and serverless...wow. Both Azure's and GCP's managed database offerings don't match up if using MySQL or Postgres.

The primary purpose of everyone wearing masks is so that people who are asymptomatic or pre-symptomatic minimize the spread of their droplets to everyone else. If the mask also protects you from sick people, that is an added benefit but secondary. Only N95 masks worn properly can guarantee protection for the wearer.

That means covering the mouth is most important because even breathing releases droplets. And the nose should be covered too, but only covering the mouth does help.