skysight-inc/HackerNews huggingface dataset:
You're right, there are several verticals of competition for us. Here are some quick notes:

1. Traditional retailers like IKEA and Wayfair: We don't think they'll be fully pivoting to a rentals because it's a very different business model and requires lots of financing/credit setup. These retailers are motivated to get rid of their inventory as soon as possible (warehouse space!) whereas we look at furniture as assets, so we're happy to take yours back, refurbish it, and put in in a new place.

2. Furniture rental startups like Feather and Fernish already have a rental system in place, but but personalized interior design is a different game altogether, especially when you consider our proprietary rending technology which generates photorealistic renders with relatively little human effort. We think our technology will set us apart.

3. Online interior design services like Modsy and Havenly only focus on human-driven interior design. They might want to upsell you a furniture package, but they don't have the necessary rental and logistics setup to have a full offering as we do. This is only competition for us if people want interior designers but want to buy all furniture outright (say for $20k) and our goal is a more affordable offering.

4. Depending on where you live, fully-furnished or serviced apartments are (much) more expensive than renting an apartment, so we think our value proposition is also the "rent to own" part where each of your monthly payments go towards ownership. We also have optional addon services like electricians and biweekly cleaning, so I think we'll more directly compete with the serviced apartments space, except that it's still your apartment and you can own the furniture if you like.

Thanks for your feedback and making me think about this!
There's a jsfiddle link to semi-interactive demo at the end of the article: https://jsfiddle.net/4urdtahx/

My eyes cannot sweep-read the result at all, and I also can't fully disambiguate enough characters in each word for the words to just "pop", even with effort.
It's only 75% of gross for new releases, and I ky for the first few weeks. Older movies that have much more profitable revenue shares might be one way to do so, if you can draw the people in. That might be hard to do for a 20 Plex, but there's a lot of perfectly serviceable smaller Thayers which can be repurposed in part or whole (most likely in part, as some theater chains have been doing for a long time already).
> That has been talked about ad nauseam for the past 10 years.

Imperialism goes way more back than 10 years. It probably has been nauseating for some for at least a century.

> Maybe it's time to remember that non-wealthy countries have more culpability for their own conditions than anyone dares to mention?

Sounds like you've made the exact calculus to rank order culpability. I'm very interested to hear how we all can objectively arrive at this conclusion.

Alternatively, you could tell us a state that haven't been at the receiving end of a war, coup, resource exploitation, economic warfare etc. and still managed to screw up their quest for self-determination.
>I just happened to use ProtonVPN for this example, so I should be protected very well, right? How come they claim I am unprotected?
That

I am surprised of that considering that photo shows ip from contabo (cheap vps/dedicated servers german provider). I run a wireguard server of a vps server. Seems like a surprise because of Protonvpn choices.
What a humourus coincidence that it was in Australia the upside-down walking beetle was found.
PayPal also works well when the merchant doesn’t directly accept Amex
I hope for a miracle: GNU Taler officially endorsed by the EU and implemented by the big banks.
Any more info? ;)
Comparing SQL to those other languages doesn't really make sense. Their purpose is different. For what SQL does, the syntax makes a lot of sense because it is a completely different paradigm. I think it's dismissive to refer to SQL as merely a 70s experiment. It is used so widely today still
The focus on the implementation in Rust in the blog post is a bit odd. That's largely inconsequential for the customers of the product.
You're so vain
You probably think this song is about you
Maybe it wasn't your intention, but your comment is the most scathing critique I've ever read of cmake.

Boilerplate code and "compiler checks" are strongly negative anti-patterns. Maybe the worst in programming. That cmake makes it easy to do these awful things just shows how evil it is!

People: write simple, portable code!
Implement relational data model and programming based on hash-map (NoSQL)

https://github.com/linpengcheng/PurefunctionPipelineDataflow...
> maybe they are asking a bit much from SQL

But this article is thought provoking to say the least. It follows the courtroom logic of holding the defendant SQL on trial for as much as possible. And SQL is guilty of a lot of crimes.

I do hope GraphQL and similar query languages become more prevalent and standardized, as it seems SQL could really use some stiffer competition.
Bringing Async Capabilities to Django ORM
> Why did SQL have to add it to the language spec?

Most likely because there isn't cargo for SQL, everyone has to make do with a default install offers, and most big boys databases offer FFI to Java, .NET and C.

> This works for data modelling (although it's still clunky because you must try joins against each of the tables at every use site rather than just ask the value which table it refers to)

Only if one never learned what views are for, and the various flavours they come in.

> By far the most common case for joins is following foreign keys. SQL has no special syntax for this:

select foo.id, quux."value"
from foo
inner join bar on foo.bar_id = bar.id
inner join quux on bar.quux_id = quux.id

Really, how much time was spent learning SQL before complaining?
You can exfiltrate the data via an http request or websocket and have your server submit the pageview hit directly to GA's servers. For me, this makes GA unique visitors numbers about 89% of Cloudflare's.

For this specific application, it's a game (digdig.io), so these 11% might likely be browsers that didn't fully connect to the game, or bots that don't fully support the apis I'm using.
You haven't provided any evidence for that.
I don't get what makes it so hard to understand that avoiding content like that and keeping a positive mindset will always be the better option for your life, independent of what will actually happen.
I agree with your last point to an extent. There's something about "inexpressiveness" that can actually be good, in that it requires you to simplify your data model. However, I imagine as it gets more complex, SQL becomes completely unwieldable. You basically have to use a NoSQL db as the author points out.
> They were hired by Nokia for example and it was scary to watch, most of those Ivans had nothing to with Finland, they were swarthy Cossacks with no language skills. And now Finland has 30 000 Russian minority, who consider themselves Russians with their own schools and churches and shit.

This is a complete non-sequitur. You generally expect any neighboring countries to have ethnic minorities, especially in bordering territories, such as the Murmansk/St Petersburg regions and Finland.

Are you implying that somehow this community of Russian people in Finland exists exclusively because they somehow "scammed" their way into the country by pretending to know a language?

I find it fairly hard to believe that Nokia would hire "swarthy Cossacks with no language skills" and frankly your tone is pretty offensive towards what seems to be benign immigration.
Zygalski Sheets
“a language that is adopted as a common language between speakers whose native languages are different.”

What do you think it means?
Fontstruct is great > https://fontstruct.com/
The point is that the standards that you are using is incapable of inferring presence of emotion in animals. Its merely human exceptionalism disguised as reasoning.

I have as much observational evidence that you have emotions as much for a dolphin, monkey or a dog for instance. The external manifestations are in the same ball park. Same for physiological probes like FMRI.

When same class of external observation leads to different class of conclusions that's theology and blind faith, not science.

'Science' has been in this 'human exceptionalism' tar pit before in other fields of science -- astronomy for example.
Yeah, however it is kind of strange to single out SQL, when we have examples like a very famous kernel that can only make use of specific compiler, or Web APIs that are only implemented by a specific browser.
Do they do this when you put food in the tank? Funny you mention it because I just noticed my snails doing this the other day… it sounds weird but I have engineers come to my house just to see it because they don’t believe it
SQL is a pretty warty implementation of relational databases (with non-composability being its primary sin IMO), but we're stuck with it at this point. A new querying DSL that fixes all of SQL's flaws is only half the story, getting enough programmers on the planet to buy into it is another half. To do that you'd need this new piece of software to at least be as fast and as battle tested as existing SQL databases. Even the new generation of massively-scalable relational databases stick with some form of SQL instead of inventing a new DSL because of the sheer momentum behind this sorry syntax.
Against the fundamental notions of product types, records, unions and intersections, binary relations?

Idiots, idiots everywhere.
The 7 Best Online Music Lessons
If you read a bunch of books and then create a similar book, that isn't transformative; transformative is like, you read a bunch of books and then create a machine translation service. The point of transformative is like "isn't going to conflict with the market or compete in any way with the original thing".
> a quantum computer, which Susskind says takes only 100 qubits to outperform any Turing Machine constructable ever

It's very important to understand that this only applies for a limited set of algorithms. QCs are not universal accelerators. In particular, if picking out this deterministic patterns from the apparent chaos were an NP problem, the QC would be just as slow as any other computing machine that we know so far.

You're also misunderstanding how chaotic systems work. With a chaotic system, even if you know the precise time evolution rules, you're not going to be able to predict the outcome at time T, because a tiny difference in the initial conditions, or a tiny interference from the outside world, will mean vastly different outcomes.

In fact, QCs would be particularly BAD at predicting the outcome of a chaotic system, because QCs can only give answers up to some error bound, unlike classical computers which can perform exact calculations. But the error introduced by the QC itself is probably going to compound the imprecision in the initial measurements of your chaotic system.

One final note that is important to state: the problem with predicting chaotic systems is not physical or computational, it is mathematical. You can have even simple systems whose solution can vary orders of magnitude more than a variance in the parameters. Solving such a system is easy and fast, but the solution is physically meaningless: a 0.01% error in the measurements can mean that you solution is off by a factor of 100.
> By far the most common case for joins is following foreign keys. SQL has no special syntax for this

You can use NATURAL JOIN

select * from foo natural join bar

Works as long as the keys are named the same. However, a lot of people have a habit of naming keys differently in the two tables.
Yes, that's the case if you use it for unauthenticated users or public API calls.

For that reason I do not support idempotent retries for public API calls.

For the authenitcated users, you cache/store the idempotency keys scoped by the currently authenticated user, i.e:

{user_id, idempotency_key}

You can add more parts to thie key for better security, i.e.:

{user_id, api_call_name, idempotency_key}

or even

{user_id, api_call_name, input_args_hash, idempotency_key}

etc.
There is also SingleFile as a browser extension: https://github.com/gildas-lormeau/SingleFile
No, I will write a SQL function for the subquery and call it from the main query.
> History is for the meaningful

I respectfully take exception to this, only because I realized for far too long that I felt under the thumb of this idea. If I do a thing, will it have meaning to enough people?

I mean, this is fine in the long-term when historians record history, but I could care less what the rest of the 7 billion people might think when I decide. for example, if I want to take up a course in the language of my grandparents, then neither the opinions of my grandparents, parents or whether it is useful should stop me. It might not be economically feasible (except in the country of its origin) but talking only about what is "meaningful" can pretty much also exclude most creative human effort, even if that effort only impresses upon a few individuals.

This is not an argument for "diversity", which is a non-goal for most people. Instead, this is simply not being locked down to the whims of a zeitgeist every time you ask whether something you find interesting, which can have some educational value, is actually a meaningful thing to pursue.
Clear browser cookies.
Are bots not unique visitors?
What are the ethical considerations you have with faang which does not apply to startup (which often aim to become faang) ?
I share the author's point of view, which led me to start a new relational programming language that compiles to SQL. It's a way to build on existing databases, like postgres or mysql, with all of their advantages, but improve on many of SQL's limitations.

If that sounds interesting, you can find it here: https://github.com/erezsh/Preql
I bet his toilet flushes the other way too!!
They’re more barefaced where I used to live: if near the end of the month they’d beg for cash because they said they have bills to pay and don’t have time for the card payment to arrive in their account.
But that's what they do. Oracle is a law firm that happens to employ a few programmers.
For example, using greek instead of latin letters is completely unnecessary. Just to point out completely meaningless overhead.

Using in-group context-sensitive symbols is by definition exclusive. Using descriptive well thought out names is inclusive.

Math as a language seems very needlessly compressed. Imagine a world where programmers invented a new symbol for every function and you would have to look up what they mean, but when you look up what they mean, you would have to look up 10 other symbols. Most of those symbols refer back to symbols where you came from in the first place. It's a detriment for learning. Simple as that.

Not everybody wants to be a mathematician. Some people just want to get work done and read through a bunch of research papers.
Well if he is insisting in doing the SQL version of writing everything inside a lambda without modularizing the code, then yeah that is bound to happen.
I've used both gbdfed[1] and Fontforge[2] to edit fonts[3][4]...

[1]: https://github.com/andrewshadura/gbdfed

[2]: https://fontforge.org/

[3]: https://github.com/kori/lavender-font

[4]: https://github.com/kori/metis-font
The UK also has credit scores, although they’re not the sole factor in acceptance for credit. Experian, Equifax and Transunion all have their own individual scoring systems with different scales - I’m not aware of a standard like Fico here.

As for shutting down accounts affecting scores - most scores factor in credit utilisation %. Maxing out a credit card can indicate that a borrower is having problems making repayments, so keeping utilisation under around 30% is helpful for a good score. Closing old accounts reduces access to credit, so the utilisation % increases.
Good fiction is not usually judged for how true it depicts a real living person.

Heck, even actual Biography (non fiction) isn't even judged that way.

Cat Person succeeds because it captures a deeper truth. And boy does that story touch a nerve - a mirror that is hard to look at because of its truth.
What advantages do you think

SELECT a, b, c FROM d

has over even a trivial modernisation like, say,

table(d) |> select(a, b, c)

?
I've been around quite a bit of SQL, and views are great. But they're not exactly as easy as assigning to a variable. If I followed your logic per compressibility I'd have to be creating views - permanent global objects - for almost every query I write. Do you create views every time you need to write some ad-hoc SQL?
There are cheats that read the RAM via DMA device, so there is no need to use video signal. They also modify mouse movements via RPI kit that injects between the mouse and PC.
I've been thinking about this problem a lot, CRUDs, GraphQL,ORMs, Models etc. Mostly in the "CRUD-Like" environment. I have been thinking about a "client side SQL impl".

In most CRUD's we currently have on the backend layers and layers of software with ORMS, frameworks etc, and it all boils down to "Writing/Generating the correct(good-enough) SQL"

We now have added stuff like GraphQL, which if you squint hard enough (ok very hard) can be seen as being a SQL alternative(Language to get the actual data).

Maybe SQL + "GraphQL-Like" Layers should "evolve" into ONE common "data scripting language" ?

Maybe we have something like "ClientSide-SQL" - which can be a subset of ServerSide-SQL ?

We need the "TypeScript" of "data-querying" which can be run on the server,client, moon and my device, where one can also only define any "Types" ONCE.

Anywhoo - I think there is still a lot to be done, researched and discovered in this section of CS :)
SQL was not made for programmers alone. It has been invented also for not so technical people so that verboseness and overhead is part of the deal.

>When Ray and I were designing Sequel in 1974, we thought that the predominant use of the language would be for ad-hoc queries by planners and other professionals whose domain of expertise was not primarily data- base management. We wanted the language to be simple enough that ordinary people could ‘‘walk up and use it’’ with a minimum of training.

https://ieeexplore.ieee.org/document/6359709
Interesting. Would be great if we could see some stats on this
> Cryptocurrencies just remove those risks instead of externalizing them.

Cryptocurrencies unilaterally move the risk to the spender and I don't see how that is same as removing risk. A financial transaction is always risky for all the participating parties, there is a chain of liability. You can't make the risk disappear, someone has to bear it and/or underwrite it. Which is why you have all these payment processors that charge x% transaction fees for merchants in exchange for taking on that risk.

A larger point here is disputes will always arise in a business transaction. Which is why we have arbiters who hear both sides of a story and settle the matters. You can't say "Payment reversal is an open invitation to criminals to steal from sellers." and make payers unilaterally liable for every payment they make. That is a recipe for killing a market.

In your friend's case PayPal acted as an arbiter and given that the seller had no proof of sale PayPal made a judgement call to side with the payer. The harsh reality is your friend should have been more careful or said only-cash-accepted.
I don't know what kind of places you have worked in, but I have rarely bumped into disrespectful jerks as coworkers in my jobs. If you work with many jerks, maybe there is an opportunity to improve the recruitment process there.
They should use NATURAL JOIN if auto-selection of the join keys is that important. I wouldn't recommend relying on that type of automagic behavior because it is very brittle; adding a column to a table might accidentally break existing queries.
This can help: https://www.darwin.so/features/bots
No I just hate mssql
The most obvious takeaway here is how she was wronged by Roupernian, but maybe a just-as-interesting takeaway is that the real Charles was a three-dimensional person with some good traits, and not just an avatar of all semi-neckbeardy creepy men.

Of course, it's pretty clear the story wants to serve as some kind of stylized and boiled-down version of some of the disturbing stuff that women experience dating. But this kind of prompts you to stop and think about the real people on the other side, as well.
Voxels/SpriteStacking/3dModelling is more of the how, they can all produce great looking 2d renderings.

I imagine the difference is more based around how the creator wants to create. If you are a 2d artist then jumping into 3d modelling can be a step learning curve, but voxel or sprite stacking are generally more forgiving.
As an accountant and developer I can tell you that many accounting tasks are very similar to coding. I have spent years having to prepare management accounts in an open office and it is exhausting trying to maintain the focus required. And yes people interrupt you just like any other day because their roles require timely responses.

I have an office now and it helps a bit, but normally I hide at home and turn off email and put Teams into dnd for these tasks
Adding more disks to it. The thing is that disks used in RAIDs tend to be of the same model and even batch and thus suspicious to the same vulnerabilities. Home users typically don't really have neither the need of the capacity/speed nor the budget to allow enough disks in the RAID to allow two disks failing at the same time. As disks get larger and larger, it's really unlikely to have no defects for all disks during the expected life span of the RAID. If one disk in the array shows signs of failure, the others probably going to have the exact the save issue soon. Given the size of the disks, it can take days to rebuild the array after replacing a single failed disk. Making it worse, rebuilding itself also put more pressure on the remaining disks that might be imminent to fail and can really lead to a cascading failure of multiple disks, in which case, total loss of data is unavoidable.

So even my NAS supports RAID5/6, I still go with single disk volumes so that in event of disk failures I'll only have to replace the failed disks and lose only the data on it in the worse case. In fact, I don't lose much because my data does not have to be in the same volume and the disks are ready fast enough and made my home network the bottleneck.
Mixfix syntax is not that weird. Objective-C is one well known language that uses it, for example.
Here is your function(arg, arg, arg)

CREATE [OR REPLACE] FUNCTION function_name (arg, arg, arg)
RETURN return_type
IS
---
END;

Then

SELECT function_name (arg, arg, arg...) FROM dual;

SELECT columns FROM xpt where xpt.id = function_name (arg, arg, arg...);

IF function_name (arg, arg, arg...) = ... THEN ...
There have been 10 year periods with negative inflation-adjusted annualized return. E.g. for the S&P500 it was -3.4%/year in the 2000's and -1.4%/year in the 1970's [1]. That makes any investments with a guaranteed long term benefit look better.

[1] See table at bottom of http://www.simplestockinvesting.com/SP500-historical-real-to...
It's fine if it's only for hard core mathematicians. Use a disclaimer front and center next time: NOT MEANT FOR MUGGLES.

(Seriously talking: From an educational point of view, lowest common deminator is exactly what you want, as long as you can communicate the entire concept effectively)
Care to back up those claim with evidence? The SQL queries are toy examples. Experienced SQL users don't write SQL like in the article because they know SQL's pitfalls and avoid them. It doesn't mean SQL isn't full of pitfalls and bad decisions (like many very old programming languages still in use).
Similar project (cross platform commandline): https://github.com/wabarc/wayback