skysight-inc/HackerNews huggingface dataset:
As TIOBE uses averaged, relative search engine hits for "[programming language name] programming" as its source, it's a significantly lagging indicator, since it counts all pages on the internet equally, regardless of their age. I'm also unsure of the precision of the search "C programming". I suspect that it's catching "C++" in some search engines.

Stack Overflow's annual survey puts JavaScript, SQL, and Python at the top, with C at 12th [0]. RedMonk's Top 20 puts JavaScript, Python, and Java at the top, with C in 10th [1]. ITJobsWatch puts JavaScript, SQL, and C# at top, with C at 9th [2]. Dice puts SQL, Java, and Python as its top 3, with C not even ranking in their top 12 [3]. All of those put JavaScript, Java, and Python in the top 5.

[0] https://insights.stackoverflow.com/survey/2021#most-popular-...

[1] https://redmonk.com/kfitzpatrick/2021/03/02/redmonk-top-20-l...

[2] https://www.itjobswatch.co.uk/default.aspx?ql=&ll=&id=900&p=...

[3] https://insights.dice.com/2021/01/05/top-12-programming-lang...
He said better than SQL.
Are we really against preventing serious crimes against public figures? Is that what freedom and privacy is about?

I mean I get the possibility of slippery slope, and I get what protonmail is saying about their service, but come on. This is a death threat on a public figure and his family. Nobody should be protected to do that. Categorical imperative y'all?
Eventually is a long time. SQLite is committed to supporting its file format out to 2050 and it's the recommended format for data archival by the Library of Congress. I suspect SQL will still be going strong long after my final exit().

Thing is, it's pretty neat in many respects (simple enough to do simple things easily, surprisingly flexible), and I say that as someone who really likes graph databases.
Low Space and HAMMER2 Snapshots
Like Kusto?

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/c...

https://docs.microsoft.com/en-us/azure/data-explorer/
The robotic bricklayers are in the factories. They do construct prefab elements that then get hauled to the building site to be quickly assembled.

Usually it's done with wood but there are also factories that build prefab houses with bricks.

https://www.youtube.com/watch?v=QJIDjdFTVW8
Rust’s traits come to mind. If it quacks like an Iterable it’s an Interable
Also relevant

https://www.cartoonbrew.com/artist-rights/ed-catmull-on-wage...
Of course the robots will take all the manual labor over. However, the machines will take IT jobs much faster. Most likely one or two decades sooner.
Regardless of his experience in software development, if his opinion is informed by the type systems of C, C++ and Java, then it must be considered the opinion of a novice when it comes to type systems.
> 99% of their SQL databases probably don't require transactions and ACID behaviour

99% of applications do not require multi-statement transactions or rollbacks, but basic ACID is hard to live without (at least the 'D' and 'C' parts).

You probably don't need a massively parallel transaction system, perhaps you just need to isolate writers out but the fact is that most of what you need comes for "free" with a standard SQL database + failovers.

It's not that no one was fired for picking it, but that people can be hired to fix it when it doesn't quite work as well as it should.
> 99% of their SQL databases probably don't require transactions and ACID behavior.

Until they do. Developer mind share for the data storage aspect of their applications is much simplified due to ACID.

Just look at the documentation of NoSQL databases. A lot of code is for integrity checks and verification.
Working on a new SQL client https://arctype.com based on this very thesis! SQL tooling is rough tho. My first intro was pgadmin and MySQL workbench which I feel serves to turn a lot of beginners off. If you have to get Python 3 packaging right to even start writing queries.. it’s just a very tough journey.

My other gripe is about ‘intermediate SQL’ - CTEs, window functions, stored procedures. Intentional practice was needed for me to be able to use those! Unlike Python where you pretty much become a functional programmer without realizing it over time.
C# has "dynamic" type. All calls on it are late-bound.
Kusto, https://docs.microsoft.com/en-us/azure/data-explorer/
Maybe create foreign keys and indexes in your Rails migrations
For Databases, it takes me a concious effort to not go to at least 3rd NF.

Except for addresses/names/telephone numbers, I have been burned by ANY assumption I made. Those, I tend to just store as something like char(255) nowadays by default, unless business requirements force me to split it up, but even then, after voicing my concerns.

Edit: reading up on the addresses falsehoods again, 255 may not be enough.

https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-...

https://github.com/google/libphonenumber/blob/master/FALSEHO...

https://www.mjt.me.uk/posts/falsehoods-programmers-believe-a...
My favorite US airport for food outlets is Austin. Nothing beats getting Salt Lick before your flight!
You can patronize me all you want, it does not rectify the fact that you are out of touch with modern database technologies and prefer what you know works.
To me, ORM code is better than raw SQL.

But, a lot many applications can be developed without really knowing the depths of SQL with help of the ORM itself.
This is one of the first comments i have seen that accurately describes a third category beyond pro-vaccine and "anti vax".

I consider myself to be in this category, as in i know the vaccine helps but am at the same time against it being mandated. This is in part due to the rush to get the vaccines out the door.

Reading a study that some vaccinated got infected changes nothing, when we also know it's a lot harder to get infected when you have taken the vaccine and that your chance of being hospitalized is also a lot smaller.

To see that the governor of New York has been asked to step down is not making me sad, as he wants to mandate vaccines. If you don't then you are practically not part of society, which is the wrong way of approaching things.
Any legal business will cooperate with authorities. You should always assume that to be true by default.

Don't want the authorities to know what you're doing? Use illegal services if you can find them or better yet, do everything yourself.
Today you are not allowed to want to kill somebody. Tomorrow you are not allowed to be of Jewish decent.

How can we prevent the second Holocaust?
> I really think we are steering ourselves into some weird evolution by deciding to go go so reclusive. People need to gather and understand each other not go into remote silos surrounded only by family and super close friends.

It's important to remember that relationships at work are artificial, meaning that they just exist because that's how our society is organized at the moment. In other ages, we would have mostly interacted with our family and friends, taking care of our kids and kids from other families/friends from our village or community.

I think that the way we live at the moment (working at the office) is not natural at all. We spend the whole day with people we barely know, and that the relationship is built on top of a working agreement. It can easily happen that you are surrounded by lots of people, and still be/feel lonely.
Without js there's a bunch of spam at the top of this page.

> Within minutes using our server sets up Cash Advance Locations

Is that SEO or did you get owned?
I had a crazy case where after adding indexes to things, queries suddenly become much much slower. I had to look over the plan and realized that removing these indexes made queries fast again. Turns out you can't just take for granted that an index will speed things up and its something you actually have to test and record before/after results.

I'm still slightly at a loss as to what the issue was but the best I can find is that if you index something with lots of duplicate values, you make the query slower as it has to scan the index and then scan the long list of results.
From https://www.justice.gov/usao-md/press-release/file/1416926/d...:

> Pursuant to legal process, agents discovered that
naturtheateralhena@protonmail.com was linked, for verification purposes, to the creator of the
similar Instagram username “Naturtheater Alhena.” Additionally, the Instagram account was
created on May 14, 2020, from an Internet Protocol (“IP”) address that was associated since April
17, 2014, to a property rented by CONNALLY from April 16, 2020, through June 1, 2020, which
includes the date when the “Naturtheater Alhena” Instagram account was created

It seems the linkage to IG is what provides more info about the accused.

Also that ProtonMail account is used to send emails to a mail.com account (which is unencrypted, and that account seems to be owned by the accused too).

Edit: Typo
Great article.
Unfortunately medicine continues to attract endless applicants. Universities have worked out that people will eat broken glass and pay for the privelege if they think it will raise their status.
React-Based Open Source Frameworks and Tools
It is indeed very helpful, actually my first class in CS colleague was SQL in oracle. I think that's one of the class that is most valuable to me without my realising it. Until now I still remember most of the language because I used it every day, it has similar syntax and understanding even when I convert to Mysql or Postgres.

Without realising it is one of the most important fundamentals that is nailed in your head, suddenly you just understand when you look at raw SQL from your ORM to debug, what went wrong etc.
@oftenwrong could you please email hn@ycombinator.com? I want to send you a repost invite.
You might find https://trino.io/ interesting. It allows you to bolt on a MPP SQL execution engine on top of any data source including pre-built connectors for Druid and Kafka.

It's all ANSI SQL and the best part is you can combine data from heterogenous sources. e.g. You can join data between a topic in Kafka and a table in Druid or even between Kafka, S3 and your RDBMS.

Disclaimer: I'm a maintainer of the project.
Anyone that does work on the client that should stay on the server, sending wasted data across the wire has already lost it.

To this day I keep writing stored procedures, no need to multiline strings.

And for the rest just use either myBatis or jOOP, run away from Hibernate.
It's actually a hcaptcha: https://i.imgur.com/JcStn1t.png

Also parent post about "requiring a phone number" or "giving them another email" is incorrect, you can choose to supply one if you want.

Not everyone on the internet has a requirement on being anonymous, so it makes perfect sense.

On a side note, you can fill out a captcha and remain anonymous, also they also have a v3 .onion unlike a lot of providers: https://protonmailrmez3lotccipshtkleegetolb73fuirgj7r4o4vfu7...
Looking for Some Dev Friends
And how many FAANG companies are using a graph database?
Clearly many are also happy to take a 50% cut, not work at all and live at the taxpayer expense.

UBI here we come!
Yet statically typed biological systems are yet to be ever seen to evolve into existence :)
https://www.kenrockwell.com/apple/lightning-adapter-audio-qu...

https://www.audioreviews.org/apple-audio-adapter-review/
Ultimately an economy has to meet the fundamental physical needs of human beings (at least until we're all Singularitied into Hive Mind Cryostatsis Upload Tanks or equivalent). That's food, clothing, shelter, and the rest of it --- the base of Maslow's Pyramid.

More money can solve some distributional probems, but ultimately not the problem of insufficient production or supply.

The classic "toy economy" example of this is "The Economic Organisation of a P.O.W. Camp", which looks at the use of cigarette-based currency within a World War II prisoner of war camp.

https://www.jstor.org/stable/2550133

It's not a perfect analogue of a true economy (goods were largely supplied to the camp through the German authorities and Red Cross shipments, there was little actual production or labour). But what was illustrated were both price fluctuations as the currency (cigarettes) increased and decreased in prevalence, subject to an innate destructive demand (habitual smokers). And when the actual supply of goods (food and other items) dried up late in the war, no amount of currency could in fact make the camp economy function.
The battery is probably the least sensitive part to noise. In fact, the battery may be able to filter/absorb a lot of noise, as long as it's charging, because it's a strong current sink and it has low impedance. (You may still have ground loop problems and other resistive voltage dividers that let the interference get to other places.)

The circuits in the phone may be damaged by excessive spikes. Especially if the spikes happen to be of a frequency that the internal filters / regulators in the phone aren't good at rejecting -- some regulators may only reject 20 dB of noise in certain bands, and > 80 dB in others.
Tensorflow.js Became a Performance Bottleneck for My Web App
Haha, it's been a long time since I've found a Centurion lounge relaxing.

Lounge access is only good when it's not full of people who just pay for a credit card. I'm quite fond of the Cathay, Swiss, and Lufthansa first class lounges. Centurions have gone completely down-hill since the Platinum got popular.
There's reasons for one wide table.

The traditional SQL database uses row based data structures.

When you shift to columnar data formats for the table, parquet or any columnar DB, the normalization rules which were developed for row based become extremely different.

The brave new world now is in-memory DBs.

All those 1970s rules, which make sense for row based tables stored on disk, don't apply to data in RAM.

At all.

So it's going to get very interesting.
“As of June 30, 2022 Sprint’s LTE network will be retired”
A book called The Culture Map goes into this. You basically have low confrontational and high confrontational cultures.

I found that understanding the differences helped a lot when I started work in an extremely culturally diverse company.

https://erinmeyer.com/books/the-culture-map/

https://www.peterfisk.com/vault-entry/xl-culture-map-erin-me...
A long time ago, in an Internet far, far away ....
On the contrary, the point of type classes/traits is to provide a type-based alternative to simple overloading.
"...No matter how abominable your condition may be, try not to blame anything or anybody: history, the state, superiors, race, parents, the phase of the moon, childhood, toilet training, etc… The moment that you place blame somewhere, you undermine your resolve to change anything; it could be argued even that that blame-thirsty finger oscillates as wildly as it does because the resolve was never great enough in the first place.

After all, a victim status is not without its sweetness. It commands compassion, confers distinction, and whole nations and continents bask in the murk of mental discounts advertised as the victim’s conscience — but try to resist it. However abundant and irrefutable is the evidence that you are on the losing side, negate it as long as you have your wits about you, as long as your lips can utter “No…”

On the whole, try to respect life not only for its amenities but for its hardships, too. They are a part of the game, and what’s good about a hardship is that it is not a deception."

This resonates with me-- it's something I have always held as a core belief. I made an appointment to be where I am today-- good or bad. The moment I blame my situation on someone or something I cede control of the situation.
What feature of rust traits make them "dynamic" as opposed to the traditional notion of typed interfaces? The latter had been part of static languages for quite a while.
Typeclasses/traits are not duck typing. A type statically needs to implement an abstract data type (with its methods and invariants). This is more of a categorization/composition effort.
>The problems were to do with handling problems like printer jams, out of paper etc which require, in essence, a partial resend and was tricky. Print spoolers on all platforms managed some of this complexity.

The only system I'm aware of that managed that was AFP on IBM mainframes. Certainly the Windows print spooler doesn't. It assumes the printer handles a paper jam and just waits until it is ready to accept more data.
SQL is constantly getting new features. The newest is SQL:2016. So while it's old, there is a lot of newer things too.
I just keep getting faster at SQL. It's fun. I used CROSS LATERAL JOIN last night to find the nearest regions to points. Super fast and easy: https://carto.com/blog/lateral-joins/. Right on the data. SQL does change over time, as Postgres adds features, but especially when you use MADlib, Postgis, and other extensions. I mean ... https://postgis.net/docs/reference.html. And everything I learned when I started is still relevant. It's my go-to crunch tool for data processing.
You're getting downvoted most probably because your comment provides no arguments why. Why would I be better off with Gremlin or Cypher?
Does it really matter that it's a public figure, would you come to a different conclusion if they only threatened to murder a "normal person"?
I have had amazing luck with Prisma.io on the oracle side
The suggestion here is that unit-tests make type-systems less needed.

One could also make the opposite and not contradictory point that type-systems make unit-tests less needed.

They both help
Freedom to contaminate?
I used to love ORM, I used it everywhere. Writing another language in the language I am coding is wrong. ORM simplifies my programs.

No, ORM does not simplify coding! It's a big complex adapter which does not fit many cases.

RDBM itself is complex enough, let's put another complex abstraction above it so we can forget about the tables and columns and joins and foreign keys. Complexity added upon another complexity does not make a polished interface.

If you want to use ORM, you have to learn both SQL and ORM with some depth at least. When problems occur, you have to debug both.

20 years in, I am still learning about RDBM. I still hate to compose SQL in code, but there is no better way.

Databases are used in every situation. Want to store data? Database. Want to communicate between processes? Database. Want to store logs? Database. There are different solutions for different scenarios, but as long as the DB chugs along, why? Sometimes it's sickening.

So 20 years in, the ROI of learning SQL is great. Please don't avoid learning about RDBM by using an ORM. Just learn it.

Actually, I'm not without ORM now a days. Light-weight ORM like Dapper serves well, it does not abstract out the concepts of RDBM, but make things easier.
As far as I can tell[1], any miner that does NOT verify the identities of the source and destination of a bitcoin transaction, and these happen to involve illegal transactions, are guilty of money laundering under Swedish (and probably most countries') law.

In that law, anyone who actively assists in the transference of valuable tokens need to ensure that they're not assisting in the transfer of value that originates from crime.

And since a miner has explicit choice of what transactions to include in the block, this means that they cannot hide behind a "common carrier"-like[2] exception.

[1] Nope, don't even pretend to be a lawyer in secret, and I may have missed some subtleties.
[2] This is basically what protects the inter-bank transfer services, the banks themselves are on the hook for preventing money laundering transactions to get that far. But since anyone can place a transaction into the pool, this is not applicable.
It's also worth mentioning that Posteo doesn't allow a user to use their own domain though.
Over 90% of the projects I have been involved in have required ACID. In fact I can't think of any that used a database and did not require ACID so I think your 99% should be inverted: 99% of all databases require ACID. This is evident from how even MonogoDB is ACID now with their new storage engine.
Well, we need to give good ol' evolution a bit of slack here, considering that it's not intelligently designed ;)
Regen Keto – Does It Work?
Regen Keto is correct now sawed as critical disturbance that supports weight decline targets and sheds eating less terrible sustenance disappointment. The condition holds the mix of tropical plants that trigger the joint effort of Ketosis and speed up the metabolic speed of the body. Other than that, Regen Keto is perhaps the best equation that raises the energy and strength level of the body. The solidification of BHB Ketones triggers fat usage instead of energy and brings back the fit mass shape.

Official Website:- https://scamlegit.com/regen-keto-review/

https://groups.google.com/g/regen-keto-reviews/c/RiTsIQJlcSA

https://www.protocols.io/workspaces/regen-keto2/about
In most cases, death threats are done by someone who the victim already knows and the detectives surely have many other trails to follow than snooping on private communications?
Yes, sure I wasn’t trying to compare FAANG to Blizzard in that regard. However, there might be other aspects of working for FAANG that might be a nogo for some (e.g. privacy and/or ethical reasons), despite being state-of-art in other regards. But yes, that’s a different story.
I think the middle ground is something like https://wudl.co.uk/ where your house is essentially put together from smaller modular pieces. This allows pre-construction and the efficiencies in "mass production" while allowing semi-customisation.
Amazon’s drone delivery team ‘collapsing,’ losing over 100 workers
I use ProtonMail so that Google or other marketers can't scan my emails.

If you think any of your correspondence on the clear web is protected from US authorities you've been sleeping under a rock the past decade or so
As someone who’s mostly clueless about BGP but have a fair grasp of all the other layers mentioned, I’d love to see posts like this going more in depth on it for folks like myself.
This article is an ad for an online course.
This has never been a secret or am I missing something ? https://protonmail.com/law-enforcement

Protonmail's claim is that their emails are end to end encrypted and that they won't sell your data to advertisers nor answer random government requests. They have always told they are going to collaborate in cases of serious crimes.
Or Idea Ultimate which contains Datagrip's functionality and the other languages they made IDEs for, except CLion (C/++, Rust debugger) and Rider (C/F#). Android Studio can connect to the Apps SQLite db. There is a plugin for Vim to connect to DBs, Written by Tim Pope.

Just a content user.

(edit) Links for the curious:

https://github.com/tpope/vim-dadbod

There are a UI and completions for it too:

https://github.com/kristijanhusak/vim-dadbod-ui

https://github.com/kristijanhusak/vim-dadbod-completion
My employer is going to the other way from snowflake -> druid to reduce high response latencies/ improve freshness.

I am assuming your use cases can tolerate increased latency?
Because it eliminates the complexity of joins: both the mind-complexity and the algorithmic complexity.
Refusing to reduce things to dualisms and binaries is a pretty well understood path to tolerance.
Requirement logic and interaction with customer to shape it is the domain of the Business Analyst (or similar position). I can imagine that BAs in our company, equipped with a slightly better version of the Copilot, could prepare a lot of code. BAs in our company have limited knowledge of coding. Yet I'm quite certain that they are capable of selecting the right implementation proposed by the Copilot, in most cases. Without resorting to developer's help, they would just click to prepare are routine. Like automated checkouts in the supermarkets, they don't make the checkout jobs disappear completely, but they're substantially reducing the need for them.
EdgeQL looks promising https://www.edgedb.com/docs/edgeql/overview
Good work. Is having text fields same as adding annotations?