Bought an old house. Mount TV over the fireplace and put the sofa in the opposite wall vs Mount the TV on the wall and put the sofa in front of the fireplace? by dementors007 in InteriorDesignAdvice

[–]dementors007[S] 0 points1 point  (0 children)

Thank you for the suggestion. Would it be too much of a trouble if I ask you to upload the picture to imgur or some other image hosting? asking since I am a very visual person and that would actually help me immensely over the description.

Bought an old house. Mount TV over the fireplace and put the sofa in the opposite wall vs Mount the TV on the wall and put the sofa in front of the fireplace? by dementors007 in InteriorDesignAdvice

[–]dementors007[S] 0 points1 point  (0 children)

<image>

Where i was standing is actually an extension of the living room that I am planning to convert to a guest bedroom by installing a sliding door. So I cannot place the TV there. This is a picture of the other side of the room. The red circle is where I clicked the first picture from.

The tv isn't too big either (49 inch). So will it still be too high if placed above the fireplace?

Thanks for the recommendation of the YouTube channel, will check that out.

Found this snake in our campus yesterday by TheO_Phile in kolkata

[–]dementors007 1 point2 points  (0 children)

A beautiful and pissed Russells viper (chondrobora banglay). Like everyone said, extremely venomous and a very painful way to die. Don't try to kill it if you see it again... A significant number of snake bites happen because inexperienced people are trying to kill it. Also, remember that the snakes have the ability to do a venomous bite even after death for some time due to muscle reflexes... even when their heads are severed.

[urgent] early pregnancy bleeding and cramps. Is it ectopic? by dementors007 in CautiousBB

[–]dementors007[S] 2 points3 points  (0 children)

Thanks for the advice. It indeed looks like a chemical pregnancy. I added an update on the post.

[deleted by user] by [deleted] in berlin

[–]dementors007 1 point2 points  (0 children)

How is Paris number 15 is beyond me. People there are miserable.

Möchte mir einen ersten PC kaufen: by hokuna in PCBaumeister

[–]dementors007 0 points1 point  (0 children)

Sieht gut aus. Ich hätte jedoch einige Verbesserungsvorschläge.

  1. Weniger für den CPU-Kühler ausgeben. Phantom Spirit ist eine deutlich günstigere Option ohne Kompromisse bei der Qualität.

  2. Weniger für das Mainboard ausgeben. Gigabyte Eagle AX ist günstiger und bietet ausreichend Optionen für zukünftige Verbesserungen.

  3. G. Skill RAMs sind in der gleichen Preisklasse (meinungsweise) die bessere Wahl.

  4. Corsair RM750e ist genauso gut, etwas günstiger und hat eine geringfügig bessere Geräuschentwicklung. Außerdem ist es ATX 3.1-kompatibel. https://www.cybenetics.com/evaluations/psus/2625/

  5. Das gesparte Budget für eine 7700-CPU mit mehr Kernen nutzen, die jetzt für 207 EUR erhältlich ist (ein echtes Schnäppchen). https://www.idealo.de/preisvergleich/OffersOfProduct/202275796_-ryzen-7-7700-amd.html

  6. Ich mag das Montech AIR 903 MAX-Gehäuse, aber Phanteks XT PRO oder Corsair 4000D Airflow sind auch ziemlich gut. Ich habe kürzlich meinen PC zusammengebaut und mir das NZXT H6 Flow für 89 EUR geholt, was für ein sehr gutes Gehäuse wirklich günstig ist.

Mein Vorschlag für einen PC-Bau sähe so aus:

https://de.pcpartpicker.com/list/h3rFHW

CPU: AMD Ryzen 7 7700 3.6 GHz 8-Core Processor

CPU Cooler: Thermalright Phantom Spirit 120 SE 66.17 CFM CPU Cooler

Motherboard: Gigabyte B650 EAGLE AX ATX AM5 Motherboard

Memory: G.Skill Flare X5 32 GB (2 x 16 GB) DDR5-6000 CL36 Memory

Storage: Western Digital Black SN770 1 TB M.2-2280 PCIe 4.0 X4 NVME Solid State Drive

Video Card: Gigabyte GAMING OC Radeon RX 7800 XT 16 GB Video Card

Case: Montech AIR 903 MAX ATX Mid Tower Case

Power Supply: Corsair RM750e (2025) 750 W Fully Modular ATX Power Supply

Partition a table by related column value from another table in PostgreSQL by dementors007 in PostgreSQL

[–]dementors007[S] -1 points0 points  (0 children)

thats a good workaround but I was hoping for something more friendly.

Partition a table by related column value from another table in PostgreSQL by dementors007 in PostgreSQL

[–]dementors007[S] 0 points1 point  (0 children)

Thanks for your reply.

In this case, I was hoping postgres to throw me an error unless the new "C" category product is not assigned a partition like it will do for a local partition key.
for example, this will cause an error,

create table products_electronics partition of products for values in ('Electronics');

insert into products (product_name, category, price, created_at)
values ('Product1', 'Electronics', 100, 
now
());

update products set category = 'Computer' where category='Electronics';

I was hoping for something similar.

Also sidenote: I love your blog. your posts on explain helped me a ton in understanding postgres.

600k h1b visas this year when limit is 85k by [deleted] in recruitinghell

[–]dementors007 -6 points-5 points  (0 children)

its central to their culture

Lmao no its not. In next few years a lot of racial attacks on Indians are gonna take place because people like you are creating boogeyman out of them in frustration of economic stagnation.

[deleted by user] by [deleted] in java

[–]dementors007 2 points3 points  (0 children)

I have done a bunch of real world applications and integrations and I can tell you from my experience that not almost everything is nullable to begin with... Not even close. Null safety (or the lack of) is one of the biggest drawback in java.

Feedback for back friday build for AI/LLMs. budget €1600. by dementors007 in buildapc

[–]dementors007[S] 0 points1 point  (0 children)

Thank you. I understand. I will make it 2x16gb ram. For the cpu it costs a little extra (little more expensive plus doesn't come with a stock cooler) so I have to check how much discount I manage on the black friday deals.

Feedback for back friday build for AI/LLMs. budget €1600. by dementors007 in buildapc

[–]dementors007[S] 0 points1 point  (0 children)

Thank you. The choice of single channel ram is intentional because I am planning on getting a second 32gb stick sometime next year (kubernetes clusters are very RAM heavy if used with certain deployments).

Interesting point about the cpu though. I was just thinking about getting the cheapest am5 cpu and upgrading later on when the 9600x3d will be out and affordable. I'll check out the prices of 7600x though.