Yes, I managed to get tripped up on the INT/INTEGER primary key distinction as a new sqlite3 user, and the idea of using the SQL standard to replace it would be great.
1,299 karma · joined September 27, 2013
Now, a dedicated JSONB datatype (and indexes!) like Postgres would be awesome, but sqlite3's "poor man's JSON" seems appropriate for many use cases.
Absolutely not.
https://www.schneier.com/blog/archives/2019/02/blockchain_an...
I personally benefited some $2000/year from the Trump tax cuts that I know my children will have to repay some day at punitive rates, but apparently that's what my fellow citizens want. Without a cultural change, founded on a spiritual change, why should we expect our government, finances, or money to change? I love Hayek but I disagree with that quote at the bottom of the site. A "poison pill" is no solution to our problems.
Sorry but there are other ways. Did you know that the Balanced Budget Amendment (proposal) failed by a single vote in 1995?
I'm working on a side project and it's literally a bunch of .py files in a folder. Libraries include fastapi and sqlite3. I cannot think of a reason to use container orchestration over a "single beefy machine" in almost any use case.
I'll go first but in an ironic way. Trump pulled out of the Paris climate accord which, if you peruse the Constitution [1], you might notice Obama entered the U.S. into seemingly illegally, without consent of Congress in the first place [2]. How did that happen? The Kyoto agreement was also never submitted to Congress for ratification [3]. And let me show my cards and say thank God we never ratified these documents, as that would be tantamount to allowing a world government control over our economy. Treaties you see are the supreme law of the land around here [4].
I don't know if you'd consider Trump's action on this particular treaty to be part of the shit he "got away with" but I find it to be a fitting example of something your average Republican president would probably just go along with, knowing it's a toothless treaty that would never be ratified. But Trump, for political or whatever reasons, felt like reversing Obama's policy in the same way he implemented it. And Congress having no part in the whole affair.
In fact the vast majority of what Trump did was in the form of executive order, most of which had very little impact on state's or individual rights.
So yeah what are these things that Trump did that Congress was either remiss or enabling him to do? If it's stuff related to the border, immigration policy, foreign policy, or the like, that's mostly outside Congress's purview, except the aforementioned treaty power.
Just trying to figure out what's the ethically sketchy stuff that should have been checked by Congress or perhaps the courts. That way we can narrow down a set of principles that could possibly apply to Biden (assuming he's elected).
[1] https://www.law.cornell.edu/constitution-conan/article-2/sec...
[2] https://www.washingtonpost.com/news/volokh-conspiracy/wp/201...
[3] https://en.wikipedia.org/wiki/Kyoto_Protocol#Non-ratificatio...
[4] https://constitution.congress.gov/browse/article-6/clause-2/
http://www.critical-theory.com/watch-zizek-explain-why-the-s...
https://www.cdc.gov/mmwr/volumes/69/wr/mm6945a5.htm
It looks like just contact tracing here, not genome sequencing.
The patient in question is A2 and the study does not say whether they ever tested positive or had symptoms.
Because of day traders and HFT, it's hard to say how long your average investor holds a stock, but it's fair to say that some hold it for a long time and others "speculate" most of the time. The speculators probably have a greater impact on the movement of a stock, but over time it must move in line with the performance of the company.
The price of a stock is thought to be a "risk adjusted present value" of the underlying company. Even if you could be 100% sure a company would make X dollars per year in perpetuity, the price would not be infinite. Instead each year of earnings is "discounted" by risk, inflation rate, the cost of borrowing money, the value of competing investments, and other factors.
If it was assumed by investors that Zoom would make lots of money for the next 5 years, and then make very little money, and this news meant they would only make lots of money for the next 3 years, then that will have an impact of 2 years worth of discounted earnings immediately.
(of course it's not like Zoom pays or is planning to pay a dividends but there's still an underlying value, for instance they could be purchased by a larger company that does pay dividends.)
[1] https://www.reuters.com/article/us-health-coronavirus-short-...