Tag: pagination

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

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-bignum and perl-Math-BigRat packages as a prerequisite on Oracle Linux 8. Congrats to the HexaCluster team and Gilles Darold for their hard work and dedication in developing this valuable tool for the PostgreSQL community. Efforts like PGDSAT contribute significantly to enhancing the security and reliability of open-source software. submitted by /u/riddinck [link] [comments]

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 relational database for the same purposes? submitted by /u/Vraenir [link] [comments]

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/Row/Seat. A purchase could also be for every game within a given season. If a purchase if for every game, it is likely they would have the same tickets for each game, but I do need to account for the possibility they wont. Things to keep in mind I have a Home Game table because I only care about the home games for the team the purchase is actually for. The League/Season/Team/HomeGame tables will all be synced automatically by an external API that will return the schedules for all teams in a given league. A Purchaser is stored in the DB and they can have multiple Phone Numbers/Emails/Addresses Home Game Table Questions I am worried about the redundancy of my relationships here. I currently have a reference to the League table here, which can be inferred by the Season Table or Team Table. Is the way I currently have it setup not the most ideal way to handle this? Purchase Table Questions When I actually query on this table I need to know how many games this purchase was for, which I am not sure if I can actually do that at the moment. I feel there is a ton of redundancy here but I am unsure how to avoid it. For example I am linking to all 4 of the Purchaser tables here which seems like a bit much. I am really open to any sort of feedback here, database design has always been a struggle of mine. Any tips or any sort of direction you believe I should go in, I am totally open to. submitted by /u/Nickt1596 [link] [comments]

🚀 Supercharge your marketing campaigns with our responsive and up-to-date Nursing Director Email List! 💼 With SLN Solutions, enjoy a…Continue reading on Medium »

Best NoSQL DatabaseContinue reading on Medium »

Is Postgresql a NoSQL DatabaseContinue reading on Medium »

Types of no sqlContinue reading on Medium »

We explore the fundamental role memory plays within the architecture of PostgreSQL databases, shedding light on the intricacies of…Continue reading on Medium »

AWS RDS vs. Huawei Cloud RDSContinue reading on Huawei Developers »

Continue reading on Medium »

Database backup and recovery are fundamental aspects of data management, ensuring the preservation and restoration of vital information…Continue reading on Medium »

1/ What is Database Transaction?Continue reading on Medium »

A Republication of the ‘The Semantic Consistence Problem, and Why Big Data Will Not Solve It’ ArticleContinue reading on Medium »

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 [link] [comments]

how databases make sure that my data is not compromised? submitted by /u/savant78 [link] [comments]

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 address. Every customer has only one default address, however. Shipping status in the purchase table shows a very short summary of the status, while the status updates store the exact events that happened to the purchase. Purchase and product table has the price in it due to the fact that the price of the product may change after the order, so we need to keep a copy of the original price A subcategory can only belong to one category submitted by /u/dont_mess_with_tx [link] [comments]

Hello folks, this is my setting: Azure SQL Server, a star Schema Table with a few metadata columns for indexing and one big varchar(max) column filled with a JSON Data. We run a typical data warehousing application, relatively few inserts, practically no updates, but many bulk reads. The table is approaching a million rows. I am overall very happy with functionality and performance, but I am constantly looking for things to improve. One bottleneck on very large bulk reads is I/O, which is quite expensive in Azure. Of course, the best way would be avoiding these, but I have no influence on that. I was reading into CCI and some of MS articles and documentation praise it for huge compression gains (which I don't care about) but also vast improvements of I/O performance, which I do care about. My understanding is the column is compressed in partitions, but how does that help I/O? Sure, less disk reads because the data is highly compressed, but in the end, if the client requests the data, it must be unpacked and delivered, so at some point the unpacked data must pass the I/O barrier, before it is compressed for transport again anyway. Also, if a query requests data from different partitions, doesn't that create a huge overhead for the DBMS? Is it worth a try? Am I on the wrong path? Does anybody have experience with a similar setting? submitted by /u/roboblocky [link] [comments]

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 [link] [comments]

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-pcie5-drives/ submitted by /u/PltnvS [link] [comments]

submitted by /u/TekaiGuy [link] [comments]

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 anyone here have recommendations for such a tool? Your insights would be immensely helpful! Thanks in advance for your suggestions! submitted by /u/matthieukhl [link] [comments]

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 [link] [comments]

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 [link] [comments]

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 [link] [comments]

What languages are typically used for the expressions in computed database columns? I did a little research into a few relational databases, and I noticed that the computed columns are often defined using SQL expressions, usually with some restrictions (such as resulting in a scalar). That is, if the language used is mentioned at all (it often is not). This seems fine, but what if you have a non-relational database or document store, or if you have complex SQL in your computed columns that could result in performance problems? I was thinking that this could be especially problematic if users are able to type code into a textbox and the code gets executed with each update. IIRC the "Dataverse" technology from Microsoft allows users to type arbitrary code in an Excel-like language to define computed columns. Hopefully, there are no technologies out there that allow users to define computed columns with expressions like: while(true) Then every update to the database risks taking down the server (maybe). In a way, it almost seems like computed columns are really small "serverless" applications. If the performance of the computed column is left entirely to the database designer, without any help from the system, then it seems it could be very tricky to get it right, and if the original database designer leaves the team/is laid off, they take their knowledge with them. For a while now, I've been developing a new programming language named Moirai (MIT License), an interpreted language where the worst case execution time of each script is calculated before execution begins. I always thought of the language as being useful for microservices and serverless applications, but then I learned about computed columns in databases and it made me wonder if the language could be used there as well. submitted by /u/tsikhe [link] [comments]

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 (please explain). Here's where I'm stuck. I feel like a range should not be defined in the primary table (the "plants" table), but if I make a "Temperature" table, then I have to do either: A) Every possible temperature range (At least the ones that life can survive in), OR B) Create an arbitrary set of "common(?) temperature ranges" or something like that, which would essentially be made-up data. Thanks in advance! submitted by /u/TheNumber473 [link] [comments]

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 [link] [comments]

submitted by /u/Commercial-Run2185 [link] [comments]

Hello! ​ Does anyone know articles regarding databases and schema comparison state-of-the-art? I am searching but haven't been able to find anything but the tools' features (e.g. Schema Compare from SSDT). I need some articles regarding the state-of-the-art of these tools. ​ Thank you in advance submitted by /u/Wonderful_Self_2285 [link] [comments]

Let's understand what SQL & NoSQL databases mean and it's advantages and disadvantages submitted by /u/codeforthefuture [link] [comments]

submitted by /u/dmagda7817 [link] [comments]

Recently finished a class where most of the assignments involved writing a program that would parse and interpret datalog text files, create and substantiate relations, evaluate queries, etc. I decided I want to keep my classwork and use it to make local databases for my personal side projects. The problems is that the program isn't finished. It can create relations in memory, but can't write them to a filesystem. Where would I start with this? How is a relational database represented in text form? What functionalities should the program have besides parsing/interpretation? Besides the discrete data and fields of the relations, does anything else need to be written to file? submitted by /u/HStone32 [link] [comments]

submitted by /u/Own-Leopard-1983 [link] [comments]

submitted by /u/Adela_freedom [link] [comments]