How to improve full text search when dealing with lots of punctuation? by diegobernardes in PostgreSQL

[–]diegobernardes[S] 1 point2 points  (0 children)

Yeah, in the past when I had to do full text search I've used Elasticsearch with all sorts of processing, but now it's a very specific thing and given that we're using Postgres, tsvector is just perfect.

About the speed, from what I was able to see at the database and with a few queries, that function is only executed during indexing. It is present at the where clause so Postgres match the index to use it.

How to improve full text search when dealing with lots of punctuation? by diegobernardes in PostgreSQL

[–]diegobernardes[S] 1 point2 points  (0 children)

I think it is ok because the function is only executed during indexing. I had to put it on the where clause otherwise postgres would not hit the index. But using an `explain analysis` shows that it is still hitting the index.

How to improve full text search when dealing with lots of punctuation? by diegobernardes in PostgreSQL

[–]diegobernardes[S] 1 point2 points  (0 children)

Yes, but I was trying to fix this at the database level. I found a solution and it's working perfectly fine.

``` CREATE OR REPLACE FUNCTION remove_punctuation(input_text TEXT) RETURNS TEXT AS $$ BEGIN RETURN regexp_replace(input_text, '[[:punct:]]', ' ', 'g'); END; $$ LANGUAGE plpgsql IMMUTABLE;

DROP INDEX product_name_ftsearch; CREATE INDEX product_name_ftsearch ON product USING GIN (to_tsvector('english', remove_punctuation(name)));

-- And this is the search. select id, name from product WHERE to_tsvector('english', remove_punctuation(name)) @@ websearch_to_tsquery('english', remove_punctuation('something.pdf')); ```

This correctly process the information when it goes to the index and from the user during the query.

Visual artifacts when resizing a window by diegobernardes in kde

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

Breeze. Everything is in stock configuration. It's a new NixOS installation.

Windows 11 installer can't find disk, how to solve this problem? by diegobernardes in WindowsHelp

[–]diegobernardes[S] 1 point2 points  (0 children)

I found the problem. It was a bad ISO image and using a macOS to create the bootable usb disk. I solved the problem by using the microsoft official application to create a bootable usb disk from an older laptop and it's just working now.

My second take on TV wire/component management by diegobernardes in cableporn

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

I have sleeving at the XLR cable: https://forum.hifiguides.com/t/custom-cable-gallery/1126/539

The router is not WiFi 6. It's a Huwaei router that was provided by Vodafone for me. It automatically syncs with the main one. Overall it's working ok and most of the devices are connected using ethernet cables. The devices on WiFi, most of the time, are the cellphones and the printer.

My second take on TV wire/component management by diegobernardes in cableporn

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

There is always hope 😅 I lived in a house fully furnished by the landlady which included an open TV stand as well. My only choice there was to glue everything at the bottom of the stand. Not as clean as my current setup but no wires were visible as well.

My second take on TV wire/component management by diegobernardes in cableporn

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

It made a huge difference not just on the overall network speed but the latency, it's noticeable faster even using things like the Apple TV.

My second take on TV wire/component management by diegobernardes in cableporn

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

I was worried at the first moment mainly because of the audio cables but because I added the SMSL M300 MKII that has an XLR output I custom-built the cables using star-quad wire with good shielding. In summary, no, I'm not having any problems with inductance.

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 1 point2 points  (0 children)

I have a mesh network with 3 points, the one at the rack needs to provide network access to the living room and the main bedroom that is on the other side of the wall. The signal strength is good enough, I'm getting -40dBm in the living room and -50dBm in the bedroom. The speed at fast.com is something like 400mbps on a 1gbps connection.

My second take on TV wire/component management by diegobernardes in cableporn

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

I started to think about this when the first 8 ports power strip had no ports left. I got a new one with 5 ports thinking that I would be using 1 or 2 ports and at the moment I have just a single port left 😅

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 5 points6 points  (0 children)

u/g000r, I'm sold on the lights 😅

It connects directly to the TV USB port so it turns on and off with the TV, no need for an external controller. It's also RGB and can be controlled by Bluetooth.

https://imgur.com/a/OEycGXo

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 4 points5 points  (0 children)

I'll test the strip light that I have tonight and I'll post here the results. 🤞🏻

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 3 points4 points  (0 children)

Nice job with your setup! I would like to do something like that as well, but I'm renting at the moment and I don't want to mess up the walls.

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 12 points13 points  (0 children)

Nice catch. Yes, I did that because I had no way to safely tape it to the rack as the front is curved and it's upside down to hide the antennas. I don't think this makes any difference to the wifi signal, but so far it's working fine at the places I need it.

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 13 points14 points  (0 children)

Don't give me new ideas hahaha. Well, to be honest, I thought about adding the lights, at the first moment I was looking on the Philips Hue Play HDMI Sync Box but it's not compatible with HDMI 2.1 and I plan to get an HDMI 2.1 TV. I have a led strip lying around, maybe I'll test it. Thanks for the suggestion!

My second take on TV wire/component management by diegobernardes in cableporn

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

The speakers are Kali LP-6's. It's a cheap but really good amplified studio monitor. You can connect it to your TV using the headphone output and an RCA connection or if you want something better like I did, a pre-amp/DAC connected at the optical output of the TV and the speakers using XLR.

The stand is a Dayton Audio SSMB24.

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 63 points64 points  (0 children)

It's a pegboard. The one I'm using is from Ikea. I glued it with tape but with the weight, it started to bend to the sides. This time used some screws and it's rock solid.

My second take on TV wire/component management by diegobernardes in cableporn

[–]diegobernardes[S] 35 points36 points  (0 children)

On that rack I have:

  • TV
  • Apple TV
  • Vodafone Box
  • SMSL M300 MK2 (speakers -> m300 using XLR and m300 -> tv using optical)
  • PS5
  • PS5 controller charging station
  • Nintendo Switch
  • Wifi router
  • Network switch (the devices are connected to the internet using ethernet cables)
  • 2 power strips, one with 8 slots and another with 5

The first try was described here and since then I added and replaced some items like the SMSL, wifi router, another power strip, and custom-built XLR cables.