Hacker News new | past | comments | ask | show | jobs | submit | yas_hmaheshwari's comments login

Wow! Thank you for sharing this. I am bookmarking this article for future use! ( Truth be told, I did not fully understand everything but hopefully future me would )

Reminds of that article about Postgres for everything: https://github.com/Olshansk/postgres_for_everything


Author here, thank you for the kind words :-)

I haven't yet written a "formal launch post" of the CatBench Postgres/pgvector app that I used for examples in the current article, but all the source code and install instructions are already available here:

https://github.com/tanelpoder/catbench


I finally wrote the "CatBench Vector Search Playground" formal launch post and posted it using "Show HN" here too:

https://news.ycombinator.com/item?id=42837246


Haha, true

Finally, an interface that matches our enterprise COBOL codebase, perfect for Y2K-compliant enterprises of 1999 :-)


Out of curiosity: Why not mysql? I am also surprised that no one has even mentioned mysql in any of the comments so far -- so looks like the verdict is very clear on that one

PS: I am also a fan of Postgres, and we are using that for our startup. But I don't know the answer if someone asks me, why not Mysql. Hence asking


To my knowledge, both Postgres and MySQL has their own strengths and weaknesses. Example: mvcc implementation, data replication, connection pooling and difficulty of upgrades were the major weaknesses of Postgres which are much improved over time. Similarly mysql query optimizer is consider lesser developed than that of Postgres's.

Overall I think Postgres adoption and integrations and thus community is much more wider than MySQL which gives it major advantage over MySQL. Also looking at the number of database-as-a-service companies of Postgres vs those of MySQL we can immediately acknowledges that Postgres is much widely adopted.


A few other things I would add:

- MySQL performs a bit better when reading by primary key

- Postgres performs a bit better when doing random inserts/updates.

- MySQL you don't need to worry about vacuums

- The MySQL query optimizer is nice because you can give it hints when it misbehaves. This can be a godsend during certain production incidents.

- Last I checked MySQL still has a nicer scaling story than postgres, but I'm not sure what the latest here is.

- Connection pooling is still heavily in MySQLs favor i.e. you don't need the PG bouncer for lots for scenarios.


There was an article from Uber on why they shifted from Postgres to Mysql: https://www.uber.com/en-IN/blog/postgres-to-mysql-migration/

I don't know how much of that article points are still valid.

The other part in favor of mysql (in my opinion) are that there are lots of companies that use mysql in production - so the access patterns, and its quirks are very well defined Companies like Square, YouTube, Meta, Pinterest, now Uber all use mysql. From blind, Stripe was also thinking of moving all its fleet from Mongo to mysql

Perception wise, it looks like companies needing internet scale data are using mysql


I think this might come down to… Oracle.

Obviously there are alternatives like MariaDB but Postgres is a quality long standing open source solution.


A tangential question: For someone looking to start using React Native (targeting both Android and iOS), is Flutter a viable alternative in 2024 ?


I am also intrigued by this question: What was different for guys like Ramanujan, and how were they able to tap in to this hidden reservoir of knowledge. And how can we replicate it

One guy able to tap into this knowledge in dreams is an indication that it is possible. Now, how do we make this the default for everyone is the question I wonder about

The way we found one variant of wheat in Mexico that was resistant to bacteria, and replicate that to the whole world -- can we do something like that for humans ( even I don't like the sound of it, but I hope you get the feeling )


> The way we found one variant of wheat in Mexico that was resistant to bacteria, and replicate that to the whole world

Great analogy.

Borlaug's famous Mexican dwarves.


> > ... found one variant of wheat in Mexico ...

According to the Wikipedia page of Norman Borlaug, he _developed_ that variety of wheat.


> how were they able to tap in to this hidden reservoir of knowledge.

My guess would be by filling the reservoir first. After filling it, then you can stir it and extract new knowledge. In other words: you get better at math by studying, reading, and thinking a lot about math. I don't think there has been a brilliant mathematician who has not immersed himself in math at first.


We all already do solve problems in our dreams. Even if you haven't awoken with a Eureka, surely you've occasionally found that something that was difficult to solve yesterday is obvious with a pair of fresh eyes.


how do we make this the default for everyone is the question I wonder about

You delete stupid prejudices from society, then it allows itself to do that. One group of people forcibly practicing it for idiotic reasons now plagued the whole field with its label, amplified by religious ideas. The irony is, it’s that same limitation that disallows to address itself and continues to propagate.


This book is definitely worth the read. Or maybe worth 10 reads. Its really that awesome!


Can you elaborate this comment? Haven't used Perl in the last 12 years, so I fit the persona of "living under a rock"


Perl 6 took like 15 years to be released, and was met with fairly lukewarm reception, sometimes very negative. It ended up being renamed because it was so different from Perl 5, so it’s now called Raku. It was a flop.


Got it! Thank you for the explanation

Read this line on Wiki: "In Perl 6, we decided it would be better to fix the language than fix the user - Larry wall"

Looks like a very good philosophical statement. Maybe there's a lesson here for other programming language

( The other Perl slogan: "Easy things should be easy and hard things should be possible" is also really good )


> It [Raku] was a flop.

From what I read, it's a living, breathing language with innovative features, core developers, regular releases and a healthy community of users. What more do you want?


[ I have used express in my last company, and I am asking this as a user who had used it and found it to be really pleasant to use ]

I am really confused by this. Is it really that stable ? For any software that was released this back, I would have thought its abandoned. Are there no features that the community had demanded in this time


Stable doesn’t mean “no room for growth.” It means, “you can count on it to work (for the features it supports) and keep working the way it does.” Absolutely the worst part of the JavaScript ecosystem is the churn.


But what churn? I started using Webpack, Express, TypeScript and React around 2013/2014. I still use the exact same stack. The only difference is that my config files are simpler now. React switched to functions/hooks but class components still work; all of my code from the beginning runs just fine and the professional projects I worked on continue to be developed.

I switched from classic .NET Framework because they deprecated WinForms and WPF was not usable and they churned the entire damn platform and replaced it with alpha-quality software. How many UI frameworks, and how much other churn happened in the past 11 years there? Way too much, everybody is so fed up that the past decade of my career consisted of rewriting desktop apps to this stack.

NPM makes it quite easy to publish anything and for others to start using it. Just don't, stick with the proven solutions. There's - adjusted for user base - the same or worse amount of churn on Pypi and Nuget. If you wouldn't choose a random library nobody uses in the C# land, don't do it in the Node land. At least the Node libs continue to grow, while the Nuget stuff continues to die.


There are a few features that were missing but it wasn't so bad. The most significant (added in v5) is proper async handler support.


On the business side, I am with you and I don't use Threads at all (or know anyone in my circle who does)

This talk is from a technical perspective - and whatever your thoughts on Threads are, it is a great technical feat to launch something of that scale in 5 months!

Can't think of any company that comes close to Meta in the speed of shipping features and products, and Threads app is the best example


I am with you.

I am personally feeling bad that he died. Can't remember any time in recent history when a person with whom I have no personal connecting died, and it is impacting me so much


Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: