iav

8 ms·

31.
by iav 4y ago
Generated columns are not supported by older PG versions. For example if you used AWS AuroraDB with Postgres compatibility, they didn’t support generated columns till a few years ago. In my experience using PG FTS, there are often some prep
32.
by iav 4y ago
Used Car prices have increased a lot in the pandemic due to the chip shortage, logistics bottlenecks, and rising demand. So most car loans that predate 2020 are in the money - the car can be sold to fully cover the loan. But cars purchased
33.
by iav 4y ago
For a typical suburban American home, 80% of the cost is labor and 20% is materials. This rule of thumb even applies in small cases - replacing the floor will likely cost you 5x more to have it done for you vs what the materials cost at Hom
34.
by iav 4y ago
Cruise ship arrivals were only 7% of Venice visitors in 2018. They have already been diverted to a nearby industrial port since reopening after the pandemic
35.
by iav 4y ago
As someone who’s used Bloomberg in a professional setting, this is more like 1% of the data for 5% of the cost. This doesn’t even have an Excel plugin or any other API. For people looking for an alternative, I recommend Refinitiv Eikon, wh
36.
by iav 4y ago
This case was about users public profiles. LinkedIn makes users profiles accessible to the Googlebot and other public visitors without the need to login. There was an additional wrinkle in that HiQ actually had a commercial agreement with L
37.
by iav 4y ago
Scraping is legal, but the legal framework requires scraping to abide by three rules: 1. The page is not behind a login. If you have to create an account to access the content, then you have to agree to abide by the terms of service which m
38.
by iav 5y ago
Those other economic activities generally have a regulator standing by, a gambling commission, the FDA, SEC, and FTC. Most of them aren’t anywhere near funded or have necessary powers or maybe susceptible to regulatory capture. But at least
39.
by iav 5y ago
Also legal entity diagrams, picture appendices, and often math formulas with Unicode
40.
by iav 5y ago
I used to do this but switched to iCloud Beta for custom domain this year. It’s $1/month (free with any paid iCloud plan) and integrates with iPhones/Mac, supports push email for iPhone, and is free of Google spying.
41.
by iav 5y ago
That's probably because previous Congressional acts mandated regular sales from the SPR as evidenced here https://www.eia.gov/todayinenergy/detail.php?id=35032 Not to mention the 10M barrels we sold just to pay fo
42.
by iav 5y ago
The US bought 77M barrels of crude oil in March 2020 under a Trump executive order. The purchases were directly from US producers, but WTI was trading around $20-25/barrel in that period. Selling 50M barrels now is going to profit the
43.
by iav 5y ago
price reductions are seasonal in real estate. Peak new listings are around Super Bowl Sunday and Labor Day. There are very few price reductions in that period. The best quality homes at attractive prices sell first. By late October, the tot
44.
by iav 5y ago
Plus 4000 local credit unions.
45.
by iav 5y ago
My SaaS business serves corporate law firms and investment banks that invest in large corporate bankruptcies (think Hertz). When I launched, I first applied for a merchant license from Stripe, and was quickly denied by an automated system,
46.
by iav 5y ago
California and Quebec carbon allowances markets are now linked (trading as CCA), and Washington State is expected to join. I researched that market thoroughly and it’s not perfect but very well structured. It’s mostly carbon allowances, not
47.
by iav 5y ago
While that might be true, that's kind of saying that if I go around breaking windows, I'm helping the economy as people are going to go out and spend money to buy new windows. Our society produces a limited amount of goods and ser
48.
by iav 5y ago
Those are state by state decisions. Many states choose to fund the prisons by taxing phone conversations. None of it is encouraged by the private industry - the prisons have a contest between the main vendors (GTL and Securus) and whoever o
49.
by iav 5y ago
If you factor in the resale value of a 2 year old iPhone and a 2 year old Pixel, I doubt this is true. And one of the biggest reasons for the high depreciation is the loss of software updates...
50.
by iav 5y ago
I moved from ElasticSearch to PG FTS in production, and here are the things I had to give up: 1. PostgreSQL has a cap on column length, and the search index has to be stored in a column. The length of the column is indeterminate - it is sto
51.
by iav 5y ago
He was biking, not driving
52.
by iav 5y ago
Minus all of the data though. That’s why people pay for Ancestry, is because they go in to countries around the world and pay to digitize archives and make them available to subscribers. Usually data like the census is made available on a r
53.
by iav 5y ago
There is a similar publicly traded business - https://www.collectorsuniverse.com/
54.
by iav 6y ago
A few insights I've learned from my meetings with the company: * The magic number is $40. If you send a large box of clothes to them, they will pay you some amount that's very near to $40. That's the amount that stops you fro
55.
by iav 6y ago
Those policies often work through gradual tightening, rather than a sudden change. So it might start with a 7% + CPI cap, then a few years later they'll change it to 5%, then remove the CPI, and so on. Sometimes the cap is allowed to b
56.
by iav 6y ago
The best part of Zoom for deaf people is the automatic captioning. There is one big downside of using generic video chat for signing - it’s usually optimized for clear audio, not clear video. When the connection gets weak, Zoom will drop fr
57.
by iav 6y ago
It’s in thousands - $3.5mm
58.
by iav 6y ago
I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is
59.
by iav 6y ago
My estimate is the death toll from Covid is saving trillions in future benefit obligations for the US overall. From a GAAP perspective, the epidemic might come out a wash. This contrasts with the 1918 pandemic, which mainly killed the young
60.
by iav 6y ago
bankrupt11.com

More ›