• 0 Posts
  • 54 Comments
Joined 3 years ago
cake
Cake day: July 22nd, 2023

help-circle






  • Personally? No I’ve never bought a cert before. Given there’s free alternatives and it’s a homelab it doesn’t make sense. Otherwise I’ve used them on AWS, where ACM also just provides them for free.

    What you’re saying is that certificate providers will still charge you and provide certificates for a year, but just provide you with N certificates to span that year?

    E.g. if the duration is 45 days then they will give you 365/45 certificates ?



  • Where is this even coming from? The guy above me is saying not to give devs better hardware and to teach them to code better.

    I followed up with an example of how using indices in a database to boost the performance helped more than throwing more hardware at it.

    This has nothing to do with having worked on old code. Stop trying to pull my comment out of context.

    But yes you’re right. Adding indexes to a database does nothing to solve adding a new feature in the scenario you described. I also never claimed it did.






  • Libreoffice their latest blogpost is from the 20th of August 2025. There have been a few releases in the past few months as well.

    Openoffice their latest ( Apache Openoffice 4.1.15 ) was released almost 2 years ago ( December 2023 ).

    Libreoffice seems like a more recent, better supported tool over Openoffice which hasn’t seen any updates since 2023 according to their own website.

    I’m on my phone, so I didn’t search extensively. But I think that also plays a role in why there’s a much larger fanbase for libreoffice rather than Openoffice.

    I’ve no recent experience with either so I can’t comment on how well either works.

    Edit: I looked up the wrong one. My statement remains correct w.r.t. Openoffice, but they mentioned Onlyoffice which is a different product.




  • I think it’s MAC based, but I’m not sure

    Specifically talking about the FireTV, 99% sure the app doesn’t have a Killswitch, I’ve checked. I use it all the time on PC and Mobile though :)

    Ah! I can’t get a fire stick here so no experience with that.

    Setting up the VPN on the router sounds great, but can home routers (I have Cox) flash VPN software on them (thought they couldn’t)?

    The asus router I have has a feature called VPN fusion. I specifically bought a set of routers for my home that are in front of my ISP router because I wanted a single SSID and wanted to set my own DNS servers without having to specify them per device . They (ISP) keep restricting features on their router ( can barely do anything on them nowadays ). Also switching ISPs became easier as any config is done in my devices rather than theirs.

    Also is it MAC or IP filtering (would I have to set a device to static IP) for deciding which devices use the VPN tunnel? How good is it about switching servers (like if a server I’m connected to is on maintenance or is overloaded)? Not too worried about the web issues, can always hop back on the regular Wi-Fi and use the app.

    I THINK it’s Mac based, but I really can’t say. I named the devices on my router and they keep reconnecting as the same device. Either that or it uses some combination of info from the device to identify it.

    E.g.: my work MacBook should switch MAC addresses every time it connects to a WiFi, but it’s consistently identified by my router.

    Additionally, they have some routers that are supported by custom firmware ( asuswrt-merlin ). Mine don’t support it unfortunately. https://www.asuswrt-merlin.net/


  • Protonvpn has a Killswitch: https://protonvpn.com/support/what-is-kill-switch

    A kill switch is available to all Proton VPN users on Windows, macOS, Linux, iOS and iPadOS. Newer versions of Android now have built-in kill switch feature, as explained below.

    Please note that our regular kill switch feature can’t protect you if you intentionally disconnect from a VPN server. However, the feature does protect you while switching servers with Proton VPN.

    Our Windows and Linux apps now also feature an Advanced kill switch. In addition to protecting you from accidental VPN disconnections, this prevents you from accidentally using the internet without the VPN turned on, and it will persist when you shut down and restart your device. You will not be able to connect to the internet if you manually disconnect the VPN without also disabling Advanced kill switch.

    or are you in a different scenario where that doesn’t work?

    I’ve configured my router to set up a VPN connection to proton ( wireguard config ). I then decide which devices gonout without vpn and which with VPN. ( Default being with VPN ). If the wireguard tunnel happens to go down, the devices can’t surf the web.


  • RDBMS shines on getbyId queries. Queries where the value starts with should also work well. But queries where the word is in the middle of the value or column generally don’t perform well. Since it’s just for personal use that might not matter too much. If you’re querying on exact values it’ll go pretty smooth. If you’re querying on ‘deniro’ while the value contains ‘bob deniro’ and others it’ll be less performant. But it’s possible it works well enough for your case.

    Elasticsearch is well known for text searches and being incredibly flexible with queries and filtering. https://www.elastic.co/

    Manticore is one that’s been on my check-it-out for I don’t know how long. It looks great imo: https://manticoresearch.com/

    Open search: https://opensearch.org/

    Disclaimer: I haven’t really used any RDBMS systems extensively for years so it’s possible there are some that added support for full text searches being more performant.

    Aleph also seems to be able to cross reference data between documents. I don’t think any of the ones listed above do this. But I also don’t know if this is part of your requirements.