Skip Navigation
Share a script/alias you use a lot

  • Agree, comes down to risk acceptance honestly.

    I accepted the risk that comes with it. Same with some other aliases on equally hazardous commands.

    • Sysadmin @lemmy.world WQMann @lemmy.ml
    OpenText - Allow case-insensitive with AWS RDS PostgreSQL

    Hi all, hopefully this question isn't out of context.

    I'm currently working with OpenText Content Management Solution hosted on AWS using Kubernetes.

    Currently facing a challenge related to case sensitivity in our PostgreSQL database.

    ---

    We are using AWS RDS PostgreSQL v15.0 with OpenText version 24.4.6.

    By default, PostgreSQL is case-sensitive, which is causing issues with the content management services; Users are looking for case-insensitive functionality, but our current setup does not support this.

    Did want to suggest switching to Oracle Database or Microsoft SQL, as both can be configured for case insensitivity. Unfortunately, due to organization requirements, I cant change it.

    > I have a friend who also used OpenText Content Services, but he didn't encounter the same issue because he was using Microsoft SQL. Additionally, he was running it on a bare metal Windows server rather than Kubernetes.

    ---

    I looked through the official Cloud Deployment Guide for OpenText, but I couldn't find any configuration options related to case insensitivity.

    Additionally, I explored suggested solutions on StackOverflow regarding case-insensitive queries or collation, but these are not applicable since we do not have control over the SQL queries or table creation in OpenText.

    ---

    Currently the organization is trying to get developers to customize it on the API level to make it case-insensitive. But was wondering if anyone encountered a similar issue and managed to configure OpenText to be case-insensitive instead.

    0
    Share a script/alias you use a lot

  • I replaced rm with trash-put, just in case I realize I need some files that I removed down the line.

    alias rm='trash-put'

    Official author don't recommend it due to different semantics. But honestly for my own personal use case its fine for me.

    Also I like to alias xclip:

    alias clippy='xclip -selection clipboard'

# cat things.txt | clippy
    • Do you think sometimes privacy practices of people at c/privacy or r/privacy communities are overparanoid or take things too far?

  • https://www.explainxkcd.com/wiki/index.php/2501:_Average_Familiarity

    Relevant XKCD;

    I feel that it is closer to the fact that the communities forgot most beginners are completely new to this in general. They might not even know what exactly a 'browser' is, much less cookies and stuff.

    Hence when we try to spoonfeed them information, it comes off as overwhelming and forced.

    Agree that there are some extremist, but they mostly act in good faith tbh.

    Another thing I noticed is there are more preachers of 'how' than 'why'. Having a beginner go down the route of privacy without giving them a purpose to do so is quite off-putting.

    • WQMan WQMann @lemmy.ml

    Average Linux enjoyer. I do system administration mostly, but can do developer related work.

    ---

    Old Profile at lemm.ee: https://lemm.ee/u/WQMan

    • Codeberg: https://codeberg.org/wqyeo
    • GitHub: https://github.com/wqyeo
    Posts 1
    Comments 3