HNHacker News
TopNewBestAskShowJobs

spprashant

639 karma · joined December 26, 2021

submissionscomments
spprashant··on gh-116167: Allow disabling the GIL
As someone in a similar boat, just pick Golang. People often dislike the basic syntax, explicit error checking and the lack of algebraic data types. I did. Rust just seems like it offers so much more and you fear missing out on something really cool.

But once you get over it, you realize Golang has a good type system, concurrency model, package manager that's not pip, fast compile times, and static binaries. For most cases it will also offer great performance.

It has everything you need to build APIs, CLI tools, web servers, microservices - pieces which will form the building blocks of your software infrastructure. I have heard numerous stories of people being productive in Go in a few days, sometimes even hours.

If Python is 0 quality of life and Rust is a 100, Golang gets you all they way up to 80-90. That last bit is something you might never need.

Rust is a great language and something I hope to be in proficient someday, but I ll save it for where I actually need that last microsecond of performance.

spprashant··on gh-116167: Allow disabling the GIL
I have no idea if this is verifiably true in a broad sense, but I work at the university and this is definitely the case. PhD students are predominantly using Python to develop models across domains - transportation, finance, social sciences etc. They then transition to industry, continuing to use Python for prototyping.
spprashant··on Almost every infrastructure decision I endorse or regret
I am 10s developer/systems engineer and my eyes kept getting wider with each new technology on the list. I don't know if its overkill or just the state of things right now.

There is no way one person can thoroughly understand so many complex pieces of technology. I have worked for 10 years more or less at this point, and I would only call myself confident on 5 technical products, maybe 10 if I being generous to myself.

spprashant··on Ask HN: Why don't browsers just build a non-JS interpreter?
I thought about it briefly before about this issue I posted. If you target Chromium, Firefox, Safari you hit close to 95% of the web traffic. It is one of the "pros" of a oligopoly in the browser space. I would reckon most websites would be okay with this reach. Just a guess.
spprashant··on Pg_rman: Backup/Restore Tool for PostgreSQL
Having used pgBackRest in production, I find it to be painful to setup and manage.

If you have a centralized backup repo, you have to install pgbackrest both on DB server and the backup repository.

The package version has to be exactly the same minor version between the DB and the repo, else backup fails. If you install a new DB, and the PG common repo no longer has the old version (and no one kept a copy of the rpm locally), you then have to update backrest on all the existing servers.

spprashant··on Strong static typing, a hill I'm willing to die on
Asking because I am curious to learn, how does a language being functional matter here?

As I understand it Python is also strongly typed, while JavaScript is not.

spprashant··on Choose Postgres queue technology
SQLAlchemy is an extra abstraction blocking your path here. While you probably should still use an ORM for your regular relation queries, you are not gaining anything significant by trying to use SQLAlchemy for implementing a queue backend. You can write raw SQL with psycopg2 (which is already a dependency in your project thanks to SQLAlchemy), and wrap these raw queue management SQL in a nice little Python module which you can later reuse for other applications as well.
spprashant··on The Reddit blackout has left Google barren and full of holes
I remember receiving an invitation to some Quora program to post questions for the website, in exchange for monetary compensation. Never took them up on it.

But this seems like the kind of thing, that will lead to low quality content on any platform.

spprashant··on Big Tech Resumed Hiring Foreign Workers Just Weeks After Layoffs
Everyone wants a open market, till it's hits the job market.

H1B workers come from countries where the wages are about a fourth of the average wage here. Of course they would settle for lesser salaries. Most privileged American software developers would rather gatekeep than level up their skills.

spprashant··on What Wikipedia Did
If you had any doubts about Musk's principles, he laid it bare here for everyone to see.

When given a choice between misinformation and no information, he chose misinformation. Can anyone really argue from a ethical standpoint that it was the best decision?

spprashant··on NBCUniversal’s Linda Yaccarino Is in Talks to Become Twitter CEO
This sounds like the end of Twitter's tech culture.

I don't think we will be seeing a stack rewrite as Musk claimed a while ago.

spprashant··on Ask HN: It's 2023, how do you choose between MySQL and Postgres?
Am I missing something here? Postgres does allow you to choose character collation when creating a database, as well as when creating new columns.
spprashant··on Faster CPython at PyCon, part one
The way I read it, Python code as it is, won't see a huge bump it's like 10x or something.

You have to use special syntax and refactoring to get the 1000x speed ups. The secret sauce is essential a whole new language within the language which likely helps skip the GIL issues.

spprashant··on YouTube tests blocking videos unless you disable ad blockers
Ad blocker awareness is still pretty low among non-tech folks. Google will presumably wait for some critical mass of users blocking ads before if pushes this.

Wonder what the economics of this is for Google? Would they rather have everyone pay $12 a month and nix ads altogether?

I suspect they still would want most people watching ads, considering how central their ads business is to their business model.

spprashant··on Google Pixel Fold
That's an ambitious price point. Who are they targeting with this?
spprashant··on ‘Everything is gone’: entire Indian villages burned in ethnic violence
Blanket blaming the media for everything does not help either. I almost never trust western media to understand the nuances of Indian politics. Everytime I visit home, I realize the Indian television media is always effusive in praise of the Modi government. The one exception might have been NDTV, but they had a management shakeup last year, so I am not aware of where their ideologies line up. Print media seems to be left leaning in general - Hindu, Indian Express etc. So trusting media at this point is a foolish exercise.

For every one BJP comment regarding safe-guarding minority rights, there are 5 which call for open discrimination. Even the video you shared, seems sympathetic at first glance, but Mohan Bhagwat has always prefaced comments with a subtle hint of "know your place in the hierarchy, and you will be fine". [1] I have never known Muslims to claim they were in any form superior. They are poorest minority in India. So that comment makes no sense.

So I only have to fall back on what I know from the people I am close to. All my Muslim friends feel less safe than they were 10 years ago. No one's come into their home and thrown them out, but they have to tip-toe around small things like eating beef, wearing the burqa, and offering prayers.

I suppose we have to ask ourselves, is it worth making people unsafe for practicing their faith in the name of politics?

We might fundamentally disagree on that point, and that is fine. In which case that is hand dealt for this country, and things will fall where they have to.

I appreciate your civility and I agree neither one of us is going to walk away from this thread having changed our minds.

[1]. https://www.outlookindia.com/national/is-the-rss-chief-mohan...

spprashant··on IPyflow: Reactive Python Notebooks in Jupyter(Lab)
Now I wonder why this isn't an option in plain Jupyter. Inconsistent cell states and having to re-execute all cells after a single line change slows me down a lot.

Like I get why this doesn't need to be default, but this seems crucial enough to warrant being included in the base package.

spprashant··on ‘Everything is gone’: entire Indian villages burned in ethnic violence
Okay please go ahead and tell me this isn't true.

https://www.ndtv.com/india-news/tolerant-muslims-can-be-coun...

This is an Union minister speaking at an RSS event.

This is neither the first nor the most vicious attack on India's biggest minority that I have heard of. This kind of rhetoric just seems commonplace today.

Full disclosure: I am an Indian too, living abroad now, but voted for the Modi government in 2014.

spprashant··on ‘Everything is gone’: entire Indian villages burned in ethnic violence
People in India have become tone-deaf to communal violence now.

It's become so frequent and obvious, that the ruling majority considers it as the cost of doing business.

We will destroy a portion of the population in the race to put India on the global map.

spprashant··on The part of Postgres we hate the most: Multi-version concurrency control
It's a problem, but not an AI problem. It has a clear cause and obvious mitigation strategies.
spprashant··on The part of Postgres we hate the most: Multi-version concurrency control
This post has a valid point. But the last line makes it clear why they care so much about it.

Yeah, table bloat and transaction ID wraparounds are terrible, but easily avoidable if you follow a few simple guidelines. Typically in my experience, best way to avoid these issues are to set sensible vacuum settings and track long running queries.

I do hate the some of the defaults in the Postgres configuration are too conservative for most workloads.

spprashant··on UK Blocks Microsoft’s $69B Activision Deal
As far as devil's advocate argument goes I suppose its valid.

But I wouldn't think this changes the opinion on any antitrust violation concerns.

If a company has problems, especially cultural issues, it should fix them or die.

spprashant··on How Postgres Triggers Can Simplify Your Back End Development
> You should consider the fact that complexity will still be there, but it will be abstracted away inside the database.

You have got to be kidding me.

spprashant··on How Postgres Triggers Can Simplify Your Back End Development
Triggers and stored procedures should only handle logic which you do not expect to change. They are notoriously hard to test and debug.

They are coupled tightly with database schema design. Making changes to them needs careful consideration and a extensive testbed environment which cannot be mocked with a fraction of the data.

spprashant··on Show HN: I made a SQL game to help people learn / challenge their skills
There is a minor issue on Chapter 16.

The comment in the Answer section, uses the value "Recovered" but the value of interest is "Returned". This is correct in the actual story description, but wrong in the Answer comment.

Took me a few tries to figure it out.

spprashant··on Substack CEO Chris Best Doesn’t Realize He’s Just Become the Nazi Bar
What is free speech, what should be protected, and what is hate speech - I don't see a way forward to address these, as long as the first amendment is interpreted in its current form.

US Americans love quoting the first amendment to validate any and all arguments. Even political contributions are considered exercising of first amendment rights, making it impossible to regulate them.

How do we even expect growth driven social media tech bros to actually come up with a solution for this?

spprashant··on The roots of Japan's Indian curry
Curry loosely translates to gravy. Without a more specific term describing the type of curry it's a little pointless.

Ever go to an Italian restaurant and say "I ll have the pasta"?

spprashant··on Employees are feeding sensitive data to ChatGPT, raising security fears
Those are pre-configured firewall rules. These firewalls can go deep packet inspection and block traffic.

It's a fairly standard practice. I wouldn't associate it with overreaching surveillance.

spprashant··on OpenAI CEO Sam Altman on Lex Fridman Podcast [video]
Can you (or someone) expand more on what he means by this?
spprashant··on March 20 ChatGPT outage: Here’s what happened
For some reason I liked reading about Rust (or any other technology) a lot more that the AI.

Part of it is that, the average engineer could understand and grok what those articles were talking about, and I could appreciate, relate, and if applicable criticize it.

The AI news just seems to swing between hype and doomsday prophecies, and little discussion about the technical aspects of it.

Obviously OpenAI choosing to keep it closed source makes any in-depth discussion close to impossible, but also some of this is so beyond the capabilities of an average engineer with a laptop. It can be frustrating.

← PreviousPage 7 of 8Next →