Greetings, As per the title, what convention's does one prefer when naming bridging tables for many-to-many relationships? I'm going with a simple approach, but I'm open to hearing of better. CREATE TABLE ${table1}_${table2} .... Cheers, submitted by /u/lickety-split1800 [visit reddit] [comments ..read more

Hello Database community, We at Xinnor have been working on optimizing the performance of PostgreSQL databases, especially in virtual environments. We built a high-performance storage solution with Kioxia PCIe5 NVMe drives, motherboard by Supermicro and our RAID engine. I thought it might be of interest to this community. Have you tried any similar solutions? It would be great to learn more about your experience as well. More details in our blog post - https://xinnor.io/blog/high-performance-storage-solution-for-postgresql-database-in-virtual-environment-boosted-by-xiraid-engine-and-kioxia-pc ..read more

submitted by /u/TekaiGuy [visit reddit] [comments ..read more

I've been testing CloudBeaver these last few days, and it seems great so far, but to the best of my knowledge, Google Authentication is not available on the Community Edition. As we're keen on integrating Google Authentication for user convenience and security, I'm exploring alternatives that better suit our team's needs. Specifically, I'm looking for a free solution that supports Google Authentication for user login and can connect to MySQL and Clickhouse databases. It would be great if it offers similar features to Cloudbeaver in terms of database management and querying capabilities. Does ..read more

so im currently doing a college work and generative ai just gave me a code where it uses CLOB instead of Varchar, is it going to put my college's connection in any danger? (I really need to write paragraphs inside serveral lines so...) submitted by /u/Mostardu [visit reddit] [comments ..read more

Hi guys, I have a bunch of data in an excel sheet that I update with monthly stats, then I run tableau on top of it. The data is sensitive and can’t be on my local machine anymore. So I have access to a container running red hat on it. I want to start putting the data into a db and visualize that data. Trying to figure out what’s the simplest and easiest database to learn? Data is not really complex, it’s just rows and columns with data regarding how well my platform is being adopted submitted by /u/wake_the_dragan [visit reddit] [comments ..read more

Assuming you wanted a document database,what are some good ones? I hear a lot about how mongodb is awful but not about what is a good alternative to the job ig is supposed to do. submitted by /u/Effective_Will_1801 [visit reddit] [comments ..read more

Here is the example I'm thinking of. This relates to pretty much nothing, I'm just having some trouble drawing the line for 5NF. I am new to normalization, so I appreciate any and all help: ​ Say I have a list of plants that I'm growing. Each row has a plant ID, plant species ID, Common Name, //other stuff here that isn't relevant, and a temperature range. Should I do this: The row has a minTemp & maxTemp column, with the range defined in this plants table OR: The row has a Temp ID (FK) column, and there is an additional "Temperature" table, with defined temperature ranges. OR: Neither (p ..read more

In this blog post, I will show you how to seamlessly level up your Patroni cluster environment in an air-gapped environment, without an internet connection. You'll learn how to navigate through each step with ease, from adding essential extensions to installing the latest PostgreSQL 16 release. https://insanedba.blogspot.com/2024/04/howtoupgrade-postgresql.html submitted by /u/riddinck [visit reddit] [comments ..read more

submitted by /u/Commercial-Run2185 [visit reddit] [comments ..read more