how databases make sure that my data is not compromised? submitted by /u/savant78 [visit reddit] [comments ..read more

I'm working on an ecommerce website for my thesis project. Of course, that means I will also need a database for storing the products, orders, customers, etc. I decided to go with Postgres. I came up with this schema. Does this look okay? Are there any pitfalls I did not consider? I also stored the SQL for the creation of the tables here. If you guys have any tips for improvements I would love to hear that. Some parts that may be worth explaining: Order is called purchase since order is a reserved word in SQL Customer and address is one to many, since a customer can have more than one addres ..read more

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