Questions tagged [database]
This tag is for general database questions; if you question is specific to SQL use that tag instead.
-2
votes
0answers
24 views
Selecting database for building highly scalable and available URL shortner service [on hold]
We want to build a URL shortening service.
Requirement:
URL Shortening
URL Redirection
Tracking URL shortening requests count per user
Traffic:
Expected Avg Shortening request is 200 request/...
2
votes
1answer
139 views
How to handle database connection password?
I have a question about using databases in my application. I have the User table which stores password for my users. I know how to handle user authentication, but how to handle the password for the ...
0
votes
0answers
21 views
How to store message content in a webservice
I am building a service responsible for sending email/sms communications. The service receives a request that contains information necessary to build an email/sms template and the recipient ...
0
votes
0answers
60 views
At what point in design do you create a new database or just keep adding tables [on hold]
My question is at what point should you create a new database and why?
So after many years of creating small projects I have come to the realization that I have way to many db's. Now it's not a ...
0
votes
3answers
89 views
Could you please recommend an approach on converting non-unique field to a unique field?
On our prod db we have two tables:
companies
invoices
Relationship:
A company has many invoices
An invoice belong to a company
The invoices table contains duplicate invoice_number for each company. ...
1
vote
2answers
132 views
What is the best model to catch DB side error?
We have a web application that all update, insert and DB operation procedure handle via SQL Server DB 2017. What is the best way to handle and get error (in Web-app or SQL server error handler?). for ...
0
votes
0answers
36 views
Designing database relationships for a voting application
So I designed database relationships for a voting/polling application. I want a user to only be able to pick 1 option on a poll. I want multiple options per poll.
So what I have here is this.
User
...
0
votes
1answer
60 views
Multiple stored procedures or 1 with parameter
I need some advice...
I started working at a financial business world recently.
Looks like the DB architect uses auto generate function to create stored procs. At the end, we have way too many procs ...
-2
votes
1answer
111 views
Mock db out or not during testing?
I am writing an app that mainly consists of just creating, editing and reading records in database. I was persuaded that any app has to be covered with tests. I was told that it's a good practice to ...
14
votes
4answers
2k views
Why not use SQL instead of GraphQL?
Recently I learned about GraphQL which claims to be superior to RESTful. However, I started wondering why don't we simply put SQL statements into an HTTP GET request.
For example, in GraphQL I would ...
-2
votes
1answer
68 views
Generate HTTP RESTful server from database schema
Today the job of most Java-based servers is to translate HTTP requests into SQL commands/queries and send a JSON-ed response back to the client. That's a pretty generic (and honestly boring) job.
I ...
6
votes
4answers
559 views
Am I right in writing our own database migration/versioning software?
I have started work on writing a tool to version the database schemas we use at work and enable migrations under version control. My first research into existing tools turned out to be too cursory due ...
1
vote
2answers
140 views
Small databases online
This is to ask whether accdb databases are suitable for this application, and how to connect the user with the database (and the phone network with the database if anyone has a comment on this).
I ...
0
votes
0answers
42 views
How to design database tables for complex build of materials as product models?
I need to redesign a 10 year old Product Management Portal and underlying Data-model. There are build of materials as products in the system.
Product managers update pricing frequently for products. ...
0
votes
2answers
57 views
Is it worth to use a sql db for just two columns (possibly extensible)?
So, first of all hello to everyone, I hope you are having a good day :)
I will give you a little context. I coded a program for my job, in which I save to a database Errors ID and their solutions. It ...
6
votes
3answers
544 views
How should I design database, where I have 30 users, each who needs full access to their data?
I work for something like a consulting company. I have a web application that I built for one client. Now around 30 other clients want about the same product. The problem is, I don't know where to put ...
0
votes
2answers
53 views
Database agnostic DAO (NoSQL + SQL)
Background
While writing a new component, I m in middle of making a decision of SQL/NOSQL database (Mongo vs Mysql) for my storage layer. As of today, mysql seems to be a perfect fit for my use-case (...
0
votes
1answer
57 views
Custom service layer logic vs Custom DB query
I am trying to confirm best practice around architecture I am working with.
Frontend <-> API gateway <-> Service layer (Rest API) <-> DB
I have an incoming request which is asking for huge ...
1
vote
2answers
114 views
Multiple use/semantics of the same database fields - is it acceptable practice?
I have ERP database whose good or person entities each have several hundreds of fields. Many of them are used for some subjects only. And hence senior companions (especially from the business division)...
0
votes
1answer
165 views
An approach to writing database applications [closed]
I'd like to share my approach to writing database applications for small businesses. It's possibly unconventional, but it's something I have been developing for nearly 20 years.
The approach I use is ...
1
vote
1answer
39 views
Storing answers of a form builder where question sections may be repeated N times
I built a form builder with which administrators of the system I work on can build forms (or blueprints as we call them). The structure of these blueprints are as follows:
blueprint X
section 1
...
1
vote
2answers
95 views
Real Time Web Sockets Architecture
I am confused here on how real time analytics is accomplished with web sockets when data is inserted into the system via a REST API. In my (admitted immature) understanding of web sockets, you have ...
1
vote
1answer
37 views
different data connectors for different objects and users
I have an application which needs to store different objects in different data stores based on the user's authorization credentials. I.E. the user may need to save object 1 to their BI postgres ...
1
vote
1answer
62 views
Check if object exists before updating/deleting
In an application that doesn't use an ORM, is it good practice to check whether an object exists before attempting to update/delete it?
For example:
@Route(method="DELETE", path="/posts/\d+")
...
-2
votes
1answer
44 views
Preuso/empty entity or only real entities + nulls?
I have a table "products" and a child one "product_modifications"
Some products have "product_modifications": "colour", "size",, .... But not all.
When a client orders a product, views pictures and ...
11
votes
5answers
710 views
My team is scared of relational database entities with foreign key relationships and I don't understand why
I'm relatively fresh out of college so most of my familiarity with relational databases is from my databases course where anything not in BCNF or 3NF is a travesty. Certainly that's one end of the ...
3
votes
2answers
127 views
How to improve code quality in database driven applications
I'm working for a company with a big ass legacy codebase. Changing existing code is like a guarantee to break things. Most functions are a few thousand lines, using some global flags, having different ...
0
votes
2answers
96 views
Referencing Database Primary Keys from Codebase
I don't have a lot of experience with these kind of issues, but I feel I need to consult on this issue. The current codebase I'm working on is using what I consider to be a questionable technique to ...
2
votes
4answers
142 views
What is the name of DB design pattern which support only soft-deletes and soft-updates?
I heard that there is some DB design in relational databases where updating a record will create a new record with different timestamp or status. Also, deletion will be soft-delete (it updates the ...
4
votes
1answer
72 views
Maintaining parallel libraries: Binary files access + Metadata Database ORM design
I'm dealing with a higher-level data abstraction that I would appreciate some input on.
I'm working on an application that uses a large data lake. The data lake is consisted of thousands of large ...
3
votes
1answer
98 views
Auto incrementing from two different points on the same table?
Each customer has an ID. For every new customer it's incremented by 1.
My company is wanting to start selling to a new type of customer (lets call it customer B), and have their ID start at 30k on ...
4
votes
4answers
195 views
Splitting application into multiple but keeping database same
I have a medium scale e-commerce application. Over a period of time our monolithic project got quite heavy in terms of code base. I was exploring the solutions for it and found micro-services is one ...
0
votes
2answers
72 views
What is the best method to avoid company data duplication in mixed B2C and B2B product in account creation?
I'm building a user license portal, store, SSO, and mini CRM and admin for internal people to manage those users for a niche 3D software company, similar to Autodesk. Licenses are sold to both ...
0
votes
2answers
61 views
Most efficient way to get unique customer count
I'm working on a system that stores details of customer purchases for several stores. One statistic that they would like is to know how many unique customers they have had over a specified day range, ...
-1
votes
1answer
33 views
How should I update back-end data (e.g. follows, likes, etc.) which changes at an inconsistent rate?
(This is a conceptual question but as reference, I'm using Android Studio (Java) and Firebase Firestore...)
My app currently has a structure where the user can follow authors and favorite their works....
10
votes
5answers
558 views
Do I really need triggers for relational database, for example, PostgreSQL?
I know that triggers can be used to validate stored data to keep database consistent. However, why not perform validation of data on the application side before storing them into the database?
For ...
3
votes
2answers
97 views
How to design a multi-year statistics database?
I'm designing a database for name statistics (how many people where given that name). The data consists of names, and numbers for how many men and women were given that name within a time period (...
0
votes
1answer
44 views
Database design for a survey app [closed]
I'm creating a survey app and I don't know how to design database. I need surveys with multiple questions and multiple types of questions. There are 3 ways that I could think of:
a) Create a ...
1
vote
1answer
53 views
MongoDB: Two documents of separate types that reference each other
I'm writing the back-end for a chat application. The database being used is MongoDB, which uses objects that have their own unique IDs.
I've run into a problem; I have two document types, channels ...
-2
votes
1answer
47 views
Designing a facial recognition systems database
First of all, I hope im in the right stack exchange.
So I'm trying to build a facial recognition system, e.g. one that recognizes a face and compares it to a database of known faces. For the first ...
0
votes
2answers
115 views
Running automation tests in production
Although many people understand that even if we have the same setup for TEST and UAT environments as we have for PROD, there're still a lot of reasons why it makes sense to run smoke tests in ...
1
vote
1answer
68 views
How to safely allow different end users to insert data into a table stored in an Oracle database?
This is a basic question, but I don't have any sense of what other developers do in this scenario.
The Situation
I am creating an interface to allow end users to insert and update data in a table ...
1
vote
0answers
46 views
Strategies for dealing with Stale data and Fetching
I'm working with firestore and have encountered several situations where a document will contain stale data which is a duplicate of the source of truth located elsewhere in the database.
For ...
0
votes
1answer
34 views
In a parent table - Child table relation , where to store order of children
Assume a Parent -> Child relationship in RDBMS.
questionnaire table and question table.
question table has a foreign key questionnaire_id to store which questionnaire it belongs to.
Questionaire ...
3
votes
1answer
171 views
Does it make sense to use both Cosmos DB and Elasticsearch?
My app uses Cosmos DB to store data. I have a requirement to support full-text search, which Cosmos does not provide out of the box. One of the recommendations was to use Elasticsearch, and I have ...
0
votes
0answers
37 views
Migrating a messaging service to end-to-end encryption
If I have a web app for messaging that started as non-end-to-end encrypted and I want to migrate that same service to be e2ee, how might I deal with old messages? If I'm using something like the ...
1
vote
1answer
63 views
How/when to normalize during ETL?
Let's say you're loading a denormalized flat file of purchase transactions that looks like this:
| location_name | location_zip | product | product_price |
|---------------|--------------|---------|--...
3
votes
6answers
292 views
Should I use entity framework for CRUD and let the database handle the complexity that comes with high end queries?
I am new to ef and liking it since it reduces the overhead of writing common queries by replacing it with simple add, remove functions. Agreed.
Today I got into the argument with my colleague who has ...
11
votes
5answers
785 views
If passwords are stored hashed, how would a computer know that your password is similar to the last one if you try resetting your password?
If passwords are stored hashed, how would a computer know that your password is similar to the last one if you try resetting your password? Wouldn't the two passwords be totally different since one is ...
0
votes
1answer
62 views
Benefits of placing error logs in a database by itself
I am working on a project where logs of all kinds (e.g. errors, warnings, etc.) are stored in a database table, in the same transactional database used for the other business purposes. It is a MSSQL ...
