Vadim_samokhin
Re:
on Tuesday March 10, 2026 @04:31AM (#47320504)
Just in case, there is a btree_gin extension which can be used in queries combining gin-indexable column and btree-indexable column. It doesn’t solve top-K ordering problem though.
Pulmonic Ingressive
Ambiguous Loss
Loneliness Epidemy in South Korea
Re:Smurf: Beyond the Test Pyramid
on Sunday October 20, 2024 @12:04AM (#41892775)
I think test pyramid is a great idea, in theory. In practice, having lots of unit tests with mocked dependencies doesn’t make me sure that everything works as it should. Thus, I use real database in my unit tests. There, I test serialization errors, authentication problems, network issues, etc. All the real problems which can occur in real life. Leaving these scenarios for integration tests layer will turn a test pyramid to a test diamond.
And what was the rationale behind mocking a database in the first place, speed? Disable synchronous wal writes, or run your postgres instance in ram. Your test suite execution speed will skyrocket.
Re:reftrack-plugin – plugin for GCC that tracks references to allocate...
on Saturday October 19, 2024 @03:31AM (#41886266)
Whoa, the first step towards a garbage collector? :)
Zonkeys, and other zebra-based hybrids
Re:The Plan-Execute Pattern
on Wednesday June 26, 2024 @03:43PM (#40803812)
I think postgres really excelled at this pattern. As well as other databases implementing a query planner.
The Blank Sheet Method: From Passive Reading to Active Learning
Re:How to Get the Most Out of Postgres Memory Settings
on Wednesday June 12, 2024 @02:38PM (#40661388)
> And yes, absolutely _never_ make it your primary key.
If I dont have lots of range queries, why not then? Only because of bloating (I think fragmentation is a more precise term here)?
Algorithms Interviews: Theory vs. Practice
Meringue Philosophy
Aristotle – How to live a good life
Redis 7 Internals, with source code examination
Interscandinavian Language
Kevin Kelly's 101 additional advice for living
Product Management Theatre
Fairy Ring
Re:Stopping at 90%
on Wednesday August 02, 2023 @02:45PM (#36975171)
I think scruple meant not just putting a github nickname, but specific links to repos. That’s what I do - but people still don’t give a shit.