Can anyone explain why a company can’t simply query its transactional database? submitted by /u/Timely-Dimension9569 [visit reddit] [comments ..read more

PGDSAT (Postgresql Database Security Assessment Tool - https://github.com/HexaCluster/pgdsat) has been released. That sounds like fantastic news for PostgreSQL users! Having a dedicated security assessment tool like PGDSAT can greatly enhance the security posture of PostgreSQL clusters. With support for around 80 security controls, including CIS compliance benchmarks, it provides users with a comprehensive solution to identify and address potential security vulnerabilities. I've already tested and provided the summary of checks. You may run it without installation. It requires to install perl ..read more

Every article I look at claims horizontal scaling to be the biggest advantage in favour of NoSQL databases, but that's not even true since there are multiple solutions to horizontal scaling of relational databases if I am not mistaken. So what advantages do they actually have? Does it depend on the specific implementation of NoSQL database? Like graph database being able to handle relationships better, wide-column being better when you mainly work with specific columns within a row etc.... Or is it the fact that they handle unstructured data better? But isn't it possible to optimise relationa ..read more

Link to Diagram - https://imgur.com/a/PEWQkMJ I am working on creating a database for a project I am doing for my friend. It will be used by a .NET Web API eventually. To try to keep it as simple as possible, I have left off fields that aren't related to the concerns. Project Overview Essentially the database is to store ticket purchases. There will be multiple purchases by the same purchaser across various seasons/leagues/teams. Each purchase could be for one game, or for all of the games. A purchase for a game could have different seats with different pricing for each combination of Section ..read more

I’m trying to find a solution for work that would allow us to replace hand written QC forms with digital forms so the information can be more easily stored and accessed using a database. I’m sure this exists but I can’t seem to google the right combination of words to find it. Anyone seen an app like this before? submitted by /u/supermoto07 [visit reddit] [comments ..read more

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