skysight-inc/HackerNews huggingface dataset:
This reputation can't be good and coming from someone like him is quite damning.

Google's rep for short lived projects and it's ecosystem. Are they even wanting to shake this perception or maybe it's a none issue for them?
That only fixes trivial selects. But you still have issues with e.g. GROUP BY, especially since the dependency is circular:

- barring extensions you can only select grouping expressions or aggregates

- but instead of repeating grouping expressions you can refer to a select expression (by index, some databases also allow the alias)

The "spec" order of evaluation for queries is WITH, FROM, WHERE, GROUP BY, HAVING, SELECT, DISTINCT, merge, ORDER BY, LIMIT. Although databases might decide to move SELECT after ORDER BY and LIMIT if they can, in order to avoid unnecessary evaluations.
You are missing the point, there's a reason why they don't name the database or link to it. It's a general behaviour that comes up with many new data stores or tools where you can query data. You could replace the images and examples with a different database that does something similar and the point would still stand.
Tech's Reckoning
It's more complicated, but oversimplifying each nuclear reaction produces gamma rays with a different energy, so you can use that energy to identify the source. (It's like the color of light.)

Also, I think most of those detectors are directional.
I think these two concepts could be reconciled by having selection be combined with moving. So 3w could select three words but also move the cursor to the end of selection, ready to process another normal mode command. The highlighting would need to be scaled back a little (perhaps a dark gray background), as you don't want your entire screen to light up when moving but I think it's doable.
There are a few apps that do this but Rectangle is the best IMO. It is also customizable via the terminal.
I tell new developers that SQL is one of those few things in our field you get to keep forever.

That JavaScript framework that takes a year to understand will no longer be used in 7 years. SQL is going to be here forever and learning it is useful your whole career.

Other common entries on this list of forever tools: regular expressions, emacs, bash/shell scripting, excel, probably more I’m forgetting.

Devs always push back on the suggestion to learn something like excel (actually learning it, not just clicking around), but when they first start they really underestimate how often it’s the tool the business speaks and feels comfortable giving feedback on technical questions in.
Excellent debrief and thanks to Systen76 for showing how it’s done. The SSR thing may be a JS ecosystem but I feel that’s a weird cop out at the end of an otherwise great AAR. We’ve been rendering results on the server for decades with caching. Can someone provide some insight on the difference here as I feel this is a knowledge gap on my part.
thanks, i hate it
I've sent my passport image to them to get my account verified.(When the second time I register Hetzner)

(My first attempt on registration got my account closed even I've provided by passport.(maybe it's because I've used VPN for registration as it's website is too slow to open in China(might caused by china GFW)
In a previous life I worked for Nokia...
HouseWatch: Open-source tool for monitoring and managing ClickHouse clusters
- water is heavy

- pumped water gets used and flows to the oceans, far away

- we have pumped a lot of water (look up how much some places have subsided due to groundwater depletion).

- the earth's rotation is something we've worked out how to measure very, very precisely

It sounds completely plausible to me.
The same logic could be applicable to pretty much any other spam filtering mechanism.
unfortunately and increasingly harder to find

They aren't hard to find. The reality is that the people who want to say 'whatever they want' are usually just looking to spout endless conspiracy theories, vaccine denial, pro putin propaganda, election denial and lots of other nonsense misinformation with no evidence behind it.

The problem is that these people don't just want a place to say it, they want to find a large audience to broadcast to normal people trying to have normal discussions. Normal people don't want them around, people running sites don't want them around and talking to each other isn't what they want.

Finding a place to say what you want is easy, finding a place where you can foul up normal message boards and everyone just lets you do it is the challenge.
I'm curious, what would be some examples where conservatives warned that some "lack of principles" would lead to a "breakdown of society," and were actually correct? Certainly not same sex marriage, abortion, or any thing that conservatives have fought against during my lifetime.

It sounds, to me, a lot like the "degenerate" label that the Nazis loved to throw around.
I donno about other databases but it doesn’t add complexity to PostgreSQL. And you can convert json array to text array.
Nope. And the loudest anti-cop people don’t care, either.
I agree with you and think this backwards model leads to developers having a poor mental model of what they are doing.

Step 1: build the dataset you want (FROM and JOIN) with all columns.

Step 2: filter out the rows you don't want (WHERE).

Step 3: choose which columns/values you want (SELECT).

Maybe it's just me but this model makes so much more sense to me! I'm sure not every developer has the same way of thinking, but it sure does seem more logical to me.
I had one image added in 2013 in this service. No idea what this is exactly but the mail was indeed confusing.
Such a shame that many cannot eat a lot of those plants because of their vitamin K content.
I just looked it up and it seems you are right. But I find it strange that "2%-10%" is considered rare, that's certainly more than I expected.

1. https://www.brown.edu/campus-life/health/services/promotion/...
Discovery will probably be the only Star Trek show that I never finish watching. So far season 1 of Strange New Worlds has been pretty good. (And each season of Picard was way better than the previous.)
> further increase the complexity of the queries

Small price to pay for improving RDBMS throughput and eking out more from limited hardware. There is no shortage of use cases where this just makes sense. Doing all of that work in a single SQL query also makes sure there's less buffer cache thrashing.
Check VDO device mapper module.
Only if you trust your dentist (or your proctologist, depending on which cheek you were referring to).
Test Undecanoate used weekly is flat.
People who can afford the loss buy insurance because it is simpler peace of mind to do so, not because it is the law.
> Also you should fill your database with houses - use AI or some sort of random data generator to generate them and just make sure there's a small but clear note on the listing saying this is AI data. It's not ideal but it is better than an empty database. Give people something to look at.

Don't do this, please never do this.
Whaaaat did not expect to see my hometown on HN today
Hang in there Montgomster, congratulations on your SaaS!
Lovely, right on the subject of all those wannabe replacements.
> It's called bribery or corruption and is common in third-world countries. "You actually want me to do the job I'm already paid for? Give me cash."

While true, it is just veiled and normalized in 1st World nations and perhaps more pernicious due to severity; at least it's honest in the so called 3rd World as you mentioned which ironically makes it more tolerable to me.

I don't like it, but I'm also beyond the hope we can undo this until an immense reduction in population makes housing, and the maintenance that supports it, a post-scarcity commodity which I fear will likely never completely happen.
IRC is for chat. NNTP it's the protocol which is the antecesor for Reddit and web fora.

Usenet (https://www.eternal-september.org) with Pan/SLRN as the clients has a much better pace, and the talks on tech circles are top quality, such as comp.unix.misc or comp.unix.programmer or comp.lang.c.
No need to update or answer inmediately, you'll get much better answers to complex issues by waiting a few hours.

Then there's FIDO and DOVEnet, which you can access thru Telnet (BBS'), SSH, web and Usenet. Most of it are old folks and ancient tech, but you have better talks on modern news (and some niche Unix talks) as they post long and elaborated arguments.

Using a Usenet client againt FIDO/Dovenet thru cvs.syncro.net:113 it's like using any other Usenet client as the hierarchies are closeish and as a plus you get threaded discussions for free.
Update: U+237C ⍼ &Angzarr;
[I'd like to know more about alpine problems]

Sure, and we're planning to share another post later on the whole procedure of our migration from AMD64 to ARM64, and in that post we'll include more details about Clickhouse's problem if we can definitively establish that the problem was caused by alpine.
(After this incident I personally have bias against alpine images too

Comparing alpine and non-alpine images on DockerHub:

https://hub.docker.com/layers/clickhouse/clickhouse-server/2...

https://hub.docker.com/layers/clickhouse/clickhouse-server/2...

There is just ~66MB(255MB vs 321MB) of size difference, my personal advice after this to to avoid alpine images in production as much as possible :P
The ecosystem of tools and learning resources around SQL is so large that I think generally any FancyQL is a liability. It would need to bring a 10x improvement over SQL and that is hard to believe.

However, I’d have said the same about JS a few years ago, and now we have TypeScript. Perhaps a language that is a strict superset of SQL and that compiles to SQL might be something worth trying.
> I noticed this hyper obsession with productivity in our industry

Maybe we are part of very different parts of that industry because I see very little obsession with productivity.
Because of credit reporting agencies subsequently telling lies about you and affecting your ability to obtain credit in the future.

But you already knew the answer.
I just had another cluster of deleted comments reappear, this time all that had been posted in r/Unexpected, which leads me to suspect this is happening on a per-subreddit occurance, perhaps as a side effect of some other subreddit-specific shenanigans that reddit is doing.
This matches my experience as a buyer as well. It won’t get you 100% of the buyers, but it will get you way over 50% and likely over 75%.

If I was working with an agent, I’m sure they’d discourage me from that listing, but as a seller in a reasonable market, I’m willing to give up a few possible buyers to save 5-6% on a 7-figure transaction. (I’ve also seen FSBOs that offer X% to buyer agents.)

I will say that agents did do some work to make the transaction complete on both of my house purchases. Negotiations after the inspection can be tense and a good agent can help both sides get to the closing table.
Good thing the license allows personal use rather restricting only to personal use.

People don't understand that in these constellations the project is commercially released first and then the open source license allows things that have not been covered by the commercial license. This is the opposite of restriction.
Especially the last point makes me realize that many frustrations with SQL are transferred frustrations with the suits (from the 70s or not) that we're all working for, and the company culture they've created
DuckDB has some really nice syntax updates that I hope get added to the ISO spec, like GROUP BY ALL and GROUP BY aliases.

I like their approach of adding thoughtful quality of life improvements instead of coming up with a new language.

https://duckdb.org/2022/05/04/friendlier-sql.html
I’ve had a first-of-class linuxian excellent developer but junior, tell me that we need Kafka because our SQL requests took 3 seconds.

It should be a single INSERT, but through an ORM that multiplies it. The only upside of Kafka is not having the ORM…
Most of the pricing inefficiency comes from information asymmetry. It might have made sense a 100 years ago when information traveled slowly. But in today's world, it travels fast. But still there is asymmetry due to purposeful obfuscation and complex packaging.
> I’m not sure how to prove anything, but I’ll note that Python 3.0 was released in 2008. If Python 2 wasn’t already extremely popular and well-established at that point, I doubt we’d have seen the brutal 10+ish year migration from it.

This is about the “scripting niche” I was talking about: in 2008 every Linux distro included Python and lots of build scripts were written in Python 2, but Python for the back-end was really rare back then.
Show HN: Small European Country – the smallest project I published in a decade
Back when I was employed as an office peon for a summer myself and a few interns were tasked with alphabetizing about a thousand file folders.

Fresh from my algorithms course, I organized a parallel meat space merge sort. And it went pretty quickly.

Everyone started with very small random stacks to order, and then merging the pre sorted stacks was relatively quick mindless work.
Probably end up with English powered by LLMs
Chrome on Android does not support extensions at all. It's still the biggest mobile browser. Sure, it will make a lot of technical people mad, but a lot more won't care.
You can’t mix/max a summed group? The sum would be in the same group level as min max…
Not random, but permutations of easily confusable characters (0OQ, 1l).
(phonetically) related: weboob

https://pypi.org/project/weboob/
It is an extension for Chrome, but google delisted it (along with other reddit content deleters). It still exists on the edge extension store though:

https://microsoftedge.microsoft.com/addons/detail/nuke-reddi...
What are your other methods of playing besides keyboard and mouse?

The newest monkey Island is steam Deck verified and also works with gamepad on your tv computer etc :)

I think new x-com games are steam deck playable. And original xcom game is eminently playable on any old laptop :)
> This is no longer true in database that have JSON support

Doing that means losing foreign-key referential integrity...
> Hi, Am I the only engineer that is looking to build a recurring revenue stream from building out tech solutions for real business problems?

this is literally an entire multi billion dollar industry called software as a service.
Rumor is brandall10 is old enough to remember the clusterf*k situation of Dracula in real time (https://bit.ly/3JlCppX). And other dramatic turns when paired against acting heavyweights like in the Devil's Advocate.

Acting is a craft. Criticism is healthy. As an actor he lacks dramatic range. This is hardly a controversial opinion, to put it lightly. He had some turns that showed promise (The Gift, some smaller films in his early career), but ultimately, that's not his forte. He is a star behind some iconic roles that best suit his talents. And is by all accounts a lovely human being. It's fine to celebrate that and call it what it is.

Finally, brandall10 likewise thinks kubancyk is a swell guy and encourages him to not take criticism of someone he's a fan of personally, even if they are an FBI agent that knows kung fu.
P:T is available on android as a beamdog port.

It plays very nicely for that format.
3AC Bankruptcy Auction Nets $11M in What Might Be Final Hurrah for NFTs
The green button was originally “zoom” which, to Apple, meant “adjust this window to its content, or revert to the previous size.” Some apps implemented zoom as maximize, but that was not The Apple Way®.

Their full-screen-window-gets-its-own-desktop-space was added later.
I'm generally on the side of OP, but this is reasonable.
>"We estimate we can sell up to 80% of the visual field before inducing seizures!"

It's Blipverts all over again
I was skeptical at first, but the babes are even undead? Truly this must be the RPG of a generation
Even if Kissinger had done nothing of note since the 80s, he would still be an irredeemable psychopath.
I often wish they make this game a TV show or even a series of movies, because the scenario, beyond the fact it's amazingly good, has potential for a lot of new arcs, thanks to the very concept of the game.

Characters scream for a bigger screen, with colorful personalities and back stories, plus they got a design made to scale to awesomeness.

And with the world building, you got a solid base plus endless possibilities.

I enjoyed the game very much, but let's face it, it's too old for most new gamers to appreciate.
imo, firefox is considered by G to be "controlled opposition".
How does bcachefs deal with laptops just dying due to lack of power and then fsck and recover on boot?
> that JavaScript framework that takes a year to understand will no longer be used in 7 years.

Surely there is a lot more nuance for having a nicer database query language than comparing it to JS frontend practices.

SQL is something that'll stick for a long time, but I support attempts from people that don't want to let SQL be the endgame.

Of course don't go around deploying highly experimental shiny things on production! :P
You can turn the selection and forced snap of other windows off, and I do.
I remind you all that GemRB runs BG 1/2 and Planescape Torment under GNU/Linux, OSX, Windows, Mac, Android... with ease.
> What's stopping a shop advertising a car at 10% below MSRP and slapping on a dealer showroom MSRP?

Nothing. That's exactly what happens, especially once you get sent into the Finance Office.
But one doesn’t write arbitrary queries. It is very easy to end up frequently wanting to write the kinds of analytic queries described in the GP rather than the kinds of things which SQL expressed better (which you fail to describe).

People pay a lot of money for kdb so clearly they see some value in it despite the lack of sql.
This was posted here a while ago and related

https://www.inputmag.com/features/tropetrainer-thomas-buchle...
Correct me if I’m wrong, but I don’t think RedPanda is a database. I see it as a streaming data solution, which the novelty factor can be discussed as well, since it’s basically Kafka.
The moment this happens a big fraction of internet users will switch to an alternative browser
Compressed air has worked well for me.
This entire comment is unnecessary. Nothing that they said is incorrect. Whether you, personally, consider it "resentment" or not is completely irrelevant.
> if you are on this forum, you can mostly likely afford one

...what?
We have very poor understanding of Stonehenge, only build 5000 years ago.

Throughout history many advanced civilisations have been wiped out for one reason or the other, with only anedectotal stories left.

It is not unlikely the context around nuclear waste storage on the surface is lost within generations.
I recall seeing at least one article where an alternative, synthetic serum was seemingly rejected from approval by seemingly cronyist interplay between corpo-regulatory regimists. I should look it up again because it's been years, but there really should be bigger attempts at synthetic alternatives smh
Thank you for your thorough explanation on your experience. While I appreciate your sharing I come from a different perspective in that you were the customer and I was the service provider. I recently wrote a column that explains my role and a major consideration as to why I have undertaken this project.[1] Please check it out from an insiders perspective. It is always helpful. A mentor once told me "First seek to understand, then be understood."[1]https://dearmonty.com/selling-and-buying-a-home-today-is-eas...
Then a few sections later

> Babes: Think babes. Then think more babes.

Slightly different times :)
I corrected my example (the inner group was meant to be by more columns)
I recently discovered that btrfs can also be mounted under windows.
Question about the "Yields of Australian Commonwealth government bonds as of 21 January 2000" graph in Chapter 2 (page 13 of the A4 version):

The y-axis (Yield in percent) values don't seem to match the data points. For example, the point for Feb '01 is labelled '7%' but the point is just above the 6% mark and well below the 6.5%. What am I not understanding?
> Of course I promptly removed it when finished.

Why? Which issues was it causing if you have the visual bell option in your terminal?
No it's not. Half of reddit is back like nothing happened.

And the rest will follow.

Like every outrage on the internet, it's a tantrum, not a protest.

Because a real protest costs a lot to the people protesting, and you quickly see through virtual signaling once the bill comes due.
> Usually start with "select * from table limit 10", look at the columns and data available, and then start refining.

An experienced person won't do that. For any moderately complex SQL query, before writing it I already have in mind the several jointures I'll need, since I usually know the tables and FK I'm working with. It's like following the edges of a graph, all in my head. But I don't know all the fields of these tables, so I rarely write their names from memory. So I have to write "SELECT 1 FROM …" and then go back to that "1" once my FROM is complete. That's not the end of the world, but it does smell.
On the Usability of Number Pads
They didn't mention if the attackers got photos too. If not this time, next time.

I believe the "identification by digital photograph" that is being rolled out at US airports (no longer need to show ID at some security checkpoints) is based on photographs shared by state-level driver's license/id card.

Increased roll-out of facial recognition technology probably increases the value of stealing headshots associated with other identity information.

I believe federal "RealID" requires states to maintain a database of digital photographs from identification documents. I think almost all states do that now.
Also, use of the word "babes" screams mid nineties.
Both human and Asian? That’s real representation.
We live that way because we have no choice, and the majority of people here are still comfortable enough to not even realize that we're constantly getting screwed over in nearly every way.
I use tiles ( https://www.sempliva.com/tiles/ ). I don't know the difference, but apparently when i setup my computer i found that solution.
quadsort/fluxsort/crumsort author here.

For me there's a strong visual component, perhaps most obvious for my work on array rotation algorithms.

https://github.com/scandum/rotate

There's also the ability to notice strange/curious/discordant things, and either connect the dots through trying semi-random things, as well as sudden insights which seem to be partially subconscious.

One of my (many) theories is that I have the ability to use long-term memory in a quasi-similar manner to short-term memory for problem solving. My IQ is in the 120-130 range, I suffer from hypervigilance, so it's generally on the lower end due to lack of sleep.

I'd say there's a strong creative aspect. If I could redo life I might try my hand at music.
I think this looks nice and clean, and works well on my iPhone. Thank you for opening up your source code.

One note: I randomly receive “Internal Server Error” messages and it would be nice if my last prompt was stored when this happens. If I enter a message and receive an error, my last input is lost. I noticed this works the same on chat.openai.com as well. Just a suggestion.
I was keen on migrating to ARM, but there seems to be no benefits from doing so on GCP; I'm open to be wrong here.

From what I understand they're using Ampere Altra, which have single thread performance similar to Skylake; but the cost is equivelant or worse than the x86 e2 series.

e2-standard-4: USD 97.84/mo

t2a-standard-4: USD 112.42/mo

(sustained use discounts apply to neither).

EDIT: I see you're in Denmark and are operations focused. I am too operations focused and just across the bridge in Malmö, maybe we could hang out.