A SQL query is an AST, but represented in a compact portable form. It also supports functions, procedures, and parameterization for flexible and safe query construction.
Your code would get incredibly large and complicated if you had to specify any serious SQL query as a raw AST.
LINQ stands for Language-Integrated Query and is incredibly successful at its purpose of providing powerful querying functionality and extensions baked into the C#/.NET language space itself.
This querying framework is what powers translations and compilation into SQL and several other languages (depending on the datastore provider used).
EntityFramework is one of the most advanced ORMs out there and is supremely productive because of LINQ.
The same reasoning in the article applies: it's a lot of added complexity that isn't related to its core use as a general purpose in-process SQL database.
Usually OLAP at these scales is fast enough with SQLite or you can use DuckDB if you need a portable format before graduating to a full on distributed OLAP system.
Sure, but Rsync and Dropbox are very different. There's really no software option that handles that many small files well with the same features (realtime sync, folder moves, binary diffs, file history, etc).
Rsync is great for taking a snapshot and replicating it elsewhere, which is probably a better fit for research projects anyway.
Those are retail rates, big users get much better pricing. Dropbox used S3 for years until finally moving to their own datacenter to be more efficient.
And like others have said, users are charged for storage that many don't use so there's a lot of revenue padding. Same model used by the other clouds for consumer storage like Google Drive.
How is this any different than storing data in S3? Companies have petabytes in the cloud now. If their networking supports their usage then Dropbox is a good solution given all the features it provides.
Dropbox still has the best syncing tech [1][2] which handles complex situations with lots of files and responds instantly. That alone is worth it if you need it.
However the rest of the product is crap. Dropbox had a solid business with a "magic folder that syncs" but has been chasing new features and product lines with little success. Even the enterprise offering was far behind Box.com for years and now has tons of competition.
The issue is in actually using all that knowledge in a single position and creating enough value. Larger organizations have specialized teams that move faster at their function rather than generalized devs.
The way for full-stack devs to profit most is to work at smaller companies and trade that for equity and seniority.
All of the clouds have a service to run containers (GCP Cloud Run, Azure Container Instance, AWS Fargate) but you have to deploy to the different regions separately and use their global load balancers or an external CDN to manage traffic.
Stackpath is an amalgamation of many acquired companies. Their CDN is fine but nothing special. The computing services aren't great. Not very competitive on price and have reliability and latency issues. Their cloud storage is white-labeled Wasabi. I wouldn't recommend them as the first choice for anything.
They originally had (and seem to still have) the same JS runtime at the edge to give you a smart CDN/reverse proxy.
They just updated it from being JS only to being able to run any Docker image. Cloudflare gives you a persistent key/value store and Fly provides a non-persistent Redis cache.
You don’t have to move your entire app but there are plenty of use-cases where you can move more logic to the edge.
That was about a decade ago and he's changed his stance since after talking to people like Neil deGrasse Tyson.
Joe Rogan represents, quite literally, the average Joe going through life and learning as he goes. If we shun people for ever possibly considering something different then we'll never get to actually connect and change their minds. People are lot more open and resilient than you may consider.
This is often said about Richard Feynman and how he could distill incredibly complex questions down into simple thoughtful answers that left you satisfied but more curious. I think we get a capable (but not quite the same) modern version with Neil deGrasse Tyson.
It's definitely something you can learn though, it just takes practice. Take a complex topic and summarize it to yourself in shorter and shorter sentences. Or browse ELI5 (explain like I'm five) on Reddit for some good amateur responses.
Most bread-and-butter sites are just fine as server-side rendered page. Large client-side frameworks reimplementing the browser and server functionality should be rare, when the situation actually calls for it.
If you really need a offline site then a simple service worker is all you need to cache the pages, not a big JS app.
Not really, this kind of thinking is exactly what led to the client-side JS framework mess.
Round trips are just fine. Browsers are smart, servers are fast, and HTML compresses well. The site you're reading right now (HN) requires a reload. Stackoverflow requires a reload. Neither are slow to use.
If your page is really that complicated, then I suggest Vue or Preact which are efficient and designed to progressively enhance pages instead of rebuilding everything in JS.
Isn't that again just focusing on singular points instead of the whole picture? Who is popular now that Milo and Alex are less so? Has that been measured?
It seems highly dubious that all that attention completely disappeared instead of following other channels, which may be even more extreme. I can't find any study of this.
My underlying point is that there is no singular "platform".
Technology is not standing still. Tor isn't necessary. We're seeing the rise of distributed, federated, encrypted, and anonymous networks that take little more than an app install or website link. They are only getting more hardened against these mitigation techniques and the approach of "just shut it down" will soon become an infeasible solution.
That report only says that Reddit banned some subreddits and so mitigated some speech, on reddit.com.
But Reddit is not the entire internet, and that ban perhaps directly fed into 8chan's rise. People do not disappear because a forum went offline, and tools to communicate are only getting better, faster and more resilient.
Your code would get incredibly large and complicated if you had to specify any serious SQL query as a raw AST.