HN user

avremel

29 karma

https://www.avikaminetzky.dev/

Posts7
Comments37
View on HN

Endeca was killed by Oracle.

I recently completed an Endeca to Algolia migration. I spent quite a bit of time auditing the Endeca implementation, from the XML files to the Windows desktop application. It was pretty good for its era.

The big difference is that duplicate index entries can still occur in B-tree indexes. GIN indexes have to integrate new entries into the posting list every time, which makes data modifications less efficient (this is mitigated by the pending list). In contrast, PostgreSQL deduplicates B-tree entries only when it would otherwise have to split the index page. So it has to do the extra work only occasionally, and only when it would have to do extra work anyway. This extra work is balanced by the reduced need for page splits and the resulting smaller index size.

https://www.cybertec-postgresql.com/en/b-tree-index-deduplic...

Django 3.1 6 years ago

I would be very hesitant to turn an ORM into a "smart" SQL generator. Depending on the type/distribution of data, there are sometimes very different paths to optimizing a query. The ORM as a "stupid" SQL generator (straightforward mapper) is a great way to allow for the flexibility to control how a query is generated.

The DB engine might be the place for those sort of improvements.

1) I doubt the NYC merchandise itself is the advantage, rather it is the concentration of Hasidic entrepreneurs which provides invaluable networks.

2) The need to support a growing family from a young age with no formal education, propels many to try their hand at business.

Exactly.

I suspect that the popularity of these types of articles is that it resonates deeply with highly motivated, self directed learners.

Same goes for articles targeting productivity geeks, and anything self-help related