Tag: pagination pattern

Herkese merhabalar, Bu yazımda nestJs ve veritabanlarını inceleyeceğiz.Continue reading on Medium »

Databases:Continue reading on Medium »

Hey! To dive into the concept of database connection pooling with SQLAlchemy lets take coffee shop analogy.. Imagine you’re at a busy…Continue reading on Medium »

Multiple users or processes frequently access the same data in databases simultaneously. This implies that we must ensure that these…Continue reading on Medium »

Introduction to Sage 50 and its database repair utilityContinue reading on Medium »

This article introduces the methods and recommendations for migrating from Netezza to GBase 8a MPP ClusterContinue reading on Medium »

Continue reading on Medium »

Continue reading on Medium »

Continue reading on Medium »

Continue reading on Medium »

Any solution where I can log in online to admin and do some staff with data, like delete some rows or insert etc. Like in supabase. I can do it locally via drizzle-kit studio or DataGrip, but I'm curious if there are any web-based versions. submitted by /u/Ankar1n [link] [comments]

Hello, I'm trying to think of how to design an SQL relationship for when a comment can contain multiple images. I was thinking of having a separate Image table that has an id and file path and a Comment table that has a foreign key to the Image table, but I'm wondering if there's a better way to approach this. Thanks! submitted by /u/camperspro [link] [comments]

Hi everyone, I'm working on a relational database for a school project that evolves scheduling a basketball game between two teams. I've got a Teams table and a Schedule table. The primary key in the Teams table is TeamID. My schedule table's primary key is MatchupID and has fields for HomeTeamID and AwayTeamID. I'm stumped on how to schedule a one to many relationship given the home and away aspects of the fields in the Schedule table. Any advice would be appreciated! submitted by /u/Oyyeee [link] [comments]

I feel like most of the comparative information for popular kev value stores were all over the place. I collected them all in one place and made a table for comparison. This took a lot of effort. Would appreciate the ⭐️ on this repository: https://github.com/basilysf1709/distributed-systems/databases submitted by /u/basilyusuf1709 [link] [comments]

I am relatively new to CDC and data intensive applications to be honest. Table on which CDC is implemented has very high rate of modification. I want change events to generated every 15 minutes or so in which 'before' is the original record and 'after' is the final record of all changes that happened during 15 minutes? I am wondering if members of this community have any insights in this or point me in any direction. PS: Do let me know if this is not the right place for this question. submitted by /u/goyalaman_ [link] [comments]

Hi Guys, we have added a Full Stack JavaScript Developer job on our platform so if you are looking for a JavaScript Developer job please check the link Role - Full Stack JavaScript Developer 🧑‍💻 (Remote, Full-Time) 🚀 Description - This a Full Remote job, the offer is available from: United States Overview: The Full Stack JavaScript Developer is responsible for developing and maintaining web and software applications that deliver exceptional user experiences. This role will collaborate with cross-functional teams to create dynamic and responsive software application solutions. Link - http://devloprr.com/jobs submitted by /u/devloprr [link] [comments]

Suppose the code will have an enum EmployeeStatus, which will be 1=hired, 2=fired, 3=interviewed, … Then in database, the table Employee will have a field named EmployeeStatus, containing 1 or 2 or 3. How will indexing EmployeeStatus increase performance upon querying the table such as “where employee_status = 1” ? And if the database had stored the string values (varchar) and not use any integer, how significant would the performance be upon querying “where employee_status = ‘hired’ “ (indexed, again) ? submitted by /u/Lge24 [link] [comments]

I now think GraphDBs are definitely over used and engineers should mostly use RDBMS for most of their stuff. Would love to hear your thoughts 🙏🏻 submitted by /u/rtalpaz [link] [comments]

We’re excited to announce another edition of TiDB Future App Hackathon! During this year’s Hackathon, participants will have an opportunity to develop new applications leveraging the new Vector Search feature on TiDB Serverless. We have over $US 30k in prizes, and beyond prizes, we want the Hackathon to provide opportunities for participants to expand your network and work with like-minded developers while working with the latest technologies. We hope you will join us! submitted by /u/rpaik [link] [comments]

What is in your opinion the best way to write a database (tables) so that i can look up a user using a set of tags? I want the fastest search possible. I an trying this with mysql P.s. i do not want to use joints, it has to be fast in CRUD submitted by /u/MajesticMistake2655 [link] [comments]

I am trying to understand the difference in the need for online database solutions for small and large-scale firms. For instance, if small-scale business firms can still go without online database solutions, and large-scale firms need to regularly upgrade the solutions they use in the form of online databases. What are your findings? submitted by /u/edwardthomas__ [link] [comments]

I don’t know whether to use Azure, MySQL,Postgres lol submitted by /u/FortSimYT_1 [link] [comments]

Hi guys, we're currently planning migrating from SQL Server to another db engine because of the costs. Basically we're storing all data in SQL Server databases. One for system database which size is ~5GB. The data we store here, customers, users, settings etc.. like required to run the product. Another db, that we store the data have fixed schema. Besides the schema, the data is not changing either. Once created it stay same forever. We call it DATA db. We shard this DATA db annually. Every Jan 1st, we create a new db for that year with year suffix and redirect queries to this db for inserts. Annual size is ~2TB and ~3 billion rows. But this db frequently queried by customers. We have 18 DATA db for last 18 years. After short brief, we're planning to migrate another db engine to reduce costs and the first candidate for the system db is Postgres. Since our data is relational and team has experience on Postgres as well as SQL Server, we keen to pick Postgres. But for the DATA dBs, we have doubts about picking Postgres for that purpose, not because of problems but we're thinking if there's better option for that use case. Basically we're looking a database that can handle 100K+ writes/second and much more important it should serve 100K+ rows in seconds (under 5 seconds could be best if possible) Just letting you know, currently we're having 100K+ rows in 15 seconds min. Not going down. Our most used query has 4 where clauses and we have composite index which contains these 4 columns in the same order of the query and wee maintenanced. (Server: Xeon Premium, 16 cores, 128GB RAM and there's no disk performance issues. avg. disk queue len is ok, avg. disk read is ok) We're aware that Postgres can handle both of this workload but would love to hear some recommandations. Especially NoSQL databases look promising but I don't have enough experience to convince the team about them. submitted by /u/Secure-Economist-986 [link] [comments]

Good day, At this time I'm in need of Maria DB ColumnStore Kettle plugin because I'm moving some data to a ColumnStore based database for some reports. I tried compiling the github sources but I couldn't, and all prebuilt versions mentioned in the docs arent available. I'm using Pentaho Data Integration 9.4 submitted by /u/Konatokun [link] [comments]

I am trying to build an application and I am trying to create role-based access control for my application. To explain I am going to use a basic scenario below. Assume I have 5 users for a blog, regular USER, SUPER ADMIN, ADMIN, EDITOR, REVIEW. A SUPER ADMIN has all the privileges. An ADMIN can have permissions specified by SUPER ADMIN. Scenario: A SUPER ADMIN can create an ADMIN and an ADMIN can for example create a REVIEWER ADMIN. A REVIEWER ADMIN can create more REVIEWERS and limit the permissions specific to reviewers. For example, the REVIEWER ADMIN creates 2 users, Reviewer A and Reviewer B and then gives them permissions. Reviewer A can only view blog posts and Reviewer B can view and delete posts. Note that the permissions will be specific to only reviewers. For example, the Reviewer ADMIN can only create users and then set permissions relating to review routes. I want to design the database in Postgres for the above but I am having a hard time understanding how to model the resources. Any sample database similar to the above or pointing me in the right direction will help as I have exhausted searching online and watching videos on YouTube. Thank you. submitted by /u/silverparzival [link] [comments]

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

The primary key is forced to be unique. But is it the enforced uniqueneess of the entity column (the column the table is about) that actually makes the table perform as a one to many. If I were to allow duplicates on this field, they would essentially behave as a many to many table. Am I understanding this properly? Edit for clarity: I understand that one to many reflects business rules and real-world relationships: I'm asking, very specifically, to understand conceptually, whether it's constraints applied to the table on the many side that truly makes a table behave as a "many" side. Is that constraint what ensures that the one to many relationship actually works as expected. submitted by /u/PersonalFigure8331 [link] [comments]

I have a dataset of tens of thousands of directed subgraphs. The subgraphs are trees, they branch from the root node and never merge. I want to find all the unique subgraphs based on the event_type attribute of the nodes. Currently I have a solution that returns all subgraphs, converts the subgraph into a NetworkX DiGraph, before calling the weisfeiler_lehman_graph_hash to return a unique hash for the graph. This isn't efficient nor does it make use of the graph database. Is there a way I can do this with Cypher queries or within the graph database itself? submitted by /u/Montags25 [link] [comments]

Hello, I currently work as a ETL developer, but have no certificates. I was thinking about taking some certificates, but I'm not sure about which one is better. Do you have any advice? submitted by /u/ennezetaqu [link] [comments]

Hey there, I have a question that is about views in postgres. I have records that I want to be available to public/anon. Problem is, that userIDs are part of the record and I do not want to expose them. I created a security definer view, that hides the ids and only exposes the information I want. I am unexperienced with databases and can not really estimate the risks of this. I thought views are exactly for this use-case, but I am getting warned about this. I would be glad if you could provide information what a good practice would be, and what I have to ensure that my application is safe. Thank you! submitted by /u/Desater_ [link] [comments]

Hello, we're trying to create a schema for our laundry POS project. Here is our initial representation of the schema. This project is a simple one, we would like to receive feedback from sources other than ourselves and our peers. We are still students and new to this, but we are mainly concerned about the one-to-many and many-to-one or many to many relationship. Please make an honest review on our laundry POS ERD roast it if you have to. https://preview.redd.it/iybphc0ft7ed1.jpg?width=3669&format=pjpg&auto=webp&s=cefdc2119bfa0b183e0d0986967c0b967d0d9faf submitted by /u/Menihocbacc [link] [comments]

Background: this is an annual PITA that I'm told will never change. I have greater hopes. It works as follows... Committee decides on what laptop specifications are acceptable this year for vendors to sell to us They send the specs in a spreadsheet We update a template in Excel that has validations for all options (OS, RAM, Storage, etc) That template goes out to vendors, they select options and send back to us We upload to a database via Java web app This whole thing seems incredibly complicated and clunky. The committee decides the minimum specs, but our developers (not our database people or me) decide what "other" values can be in there. For example, if 32G of memory is minimum, they will put in 32G, 64G, etc, etc. This also means that if a vendor has a config that we don't have in the list but meets the minimum, the validations still think that is wrong. Sometime back, they allowed free text in all fields but then complained about cleaning the data that came in. That's why the validations were done. But that's the opposite end of the spectrum because now we are shooting in the dark at options that may or may not be there. And then they will free-text options like graphics and put in proprietary language that doesn't even tell if it meets minimum spec. I want to re-architect this but am told it's been this way and always will be. What makes sense in my head is to have the vendors put in the models of the laptops they sell and then behind the scenes we go to CDW or somewhere similar to grab the specs on those machines. That would then pull in the specs and the vendors can validate from there. We spend so many hours propping up a bad process. I mean, honestly the spreadsheet is pretty useless in terms of "validating." How would you redesign this? submitted by /u/bishop491 [link] [comments]

Hello everyone! I have 700 .gz files, each around 200MB compressed, which expand to 2GB each (totaling 1.5TB). I want to avoid making a huge 1.5TB database. Is there a good way to store this compressed data so it’s queryable? Also, how can I efficiently load these 700 files? I use Postgresql for the DB. Thanks in advance! You're awesome! submitted by /u/nikola_0020 [link] [comments]

I'm somewhat new to database development but know enough to be dangerous. I'm trying to build a relational database that has 3 tables - a table containing a list of medications, a table with a list of health problems, and a link table that links a medication to a health problem. I'm looking for something that has more of a GUI and the ability to manually enter data like you would with Microsoft Access. Unfortunately I'm on a Mac and so Access isnt really an option. The ultimate goal is a web application so a web page frontend with php and mysql on the backend. The only reason I am inclined to use mysql is it is all I know. Perhaps PostgreSQL or MongoDB would be easier? Are there other options that are easier to use than MySQL? Ideally I could build and test self-hosting and then move to a hosted site / server to deploy. submitted by /u/Fxguy1 [link] [comments]

I'm trying to understand what are typical designs for storing image metadata. Imagine you might have scans of drawings, scans of documents, photos, etc. A scan of a multipage document represented as a sequence of images might lead to something like the below tables such as the following as a super basic starting point. Here a scanned document would be represented by a images_groups and the multiple images point back to that with group_id. Now for the various one off photos would these also need an entry in images_groups even if there is only a single image. Is paying the cost of a row in images_groups a typical design here? I'm trying to learn what are the various options that have been tried in the past and thought of even for something nit picky like having to store an extra row for each image. images - id - group_id - filepath images_groups - id submitted by /u/kevinfat2 [link] [comments]