Questions tagged [database-development]
The database-development tag has no summary.
109 questions
2
votes
1
answer
436
views
Does it make sense to use a graph database (Neo4j) for a diagramming app?
I am developing a diagramming application and want to optimize operations with the Nodes and Relations of the diagram. Currently, I am using a relational database with tables for diagrams and nodes. ...
- 29
1
vote
1
answer
334
views
An effective database migration pattern for many instances of the same app over a long period of time
How do you handle migrations to your database after a long period of time?
I'm using fluent migrator, and after some months or years, the number of migrations could be (and has been in previous ...
- 144
0
votes
1
answer
597
views
Developing a database: How to keep track of log files
I am building a database, and have implemented a transaction log system to ensure that writes are atomic, idempotent & consistent.
When a transaction is 'committed' it is appended to a log file ...
- 103
-2
votes
2
answers
190
views
Database Structure for The Best Efficiency
I want a database table that can hold all of the group chat messages from all of the group chats.
The max amount of users per group chat would be 20.
The max amount of group chats per user would 25-...
- 39
1
vote
1
answer
122
views
How do I store reported comments/photos in firestore?
I want to learn firestore and to this end I created small project which replicates instagram. Not all functionalities of course, just the very basics - photo sharing, comments and the possibility to ...
- 111
-1
votes
1
answer
143
views
As a client; how to present database needs to perspective designers?
[I am preparing to solicit proposals for database/project management software design. I know that the quality of the final product will depend on how clearly and completely I can organize and explain ...
- 27
0
votes
0
answers
72
views
What is best approach to designing a local-to-cloud cloud-to-local Infrastructure?
I plan to have a cloud web application(CWA) and several local web application(LWA), let's assume 3 LWAs and 1 CWA. CWA === LWA.
This web application would consist of a database server, file storage ...
- 109
6
votes
2
answers
366
views
How do services distribute their servers around the globe while maintaining their whole dataset intact?
I've always been curious on how services such as google/youtube have multiple datacenters across the globe to serve requests faster to users while keeping their whole dataset structure intact. There ...
- 251
1
vote
2
answers
198
views
When placing an order in a shop, should a snapshop be taken of the products in an order also?
...to prevent messing up with data updates, such as prices, titles, of the products that are placed in an order.
Namely, a customer buys 3 items: for $5, $10 and $33 and pays for them. All is well. ...
- 31
-1
votes
4
answers
489
views
Proper development workflow for fullstack app with multiple developers?
Say that I am developing a web application that has the following structure:
An SPA web frontend (angular in my case)
Postgresql database with:
A bunch of initial data in CSV's and JSON's that need to ...
- 288
2
votes
4
answers
1k
views
What's the best way to save/track change requests on multiple objects in a database?
I have a schema containing contracts, sub-contracts, services offered by each of those, and sub-services.
I also have an application that allows me to extend the duration of the contract and to modify ...
0
votes
1
answer
2k
views
ER Diagram in Barker Notation
I engineered an ERD diagram using Barker's notation.
The problem was to make a database for system of water pipes where one node is connected to another using a section (pipe), each node can have ...
53
votes
8
answers
15k
views
Is domain driven design an anti-SQL pattern?
I am diving in the domain driven design (DDD) and while I go more deeply in it there are some things that I don't get. As I understand it, a main point is to split the Domain Logic (Business Logic) ...
- 684
4
votes
1
answer
600
views
How to ease the pain of lack of diffs when using database migrations?
The pain that I've often felt when creating database migration files, is best described in this Speakerdeck: Sane Database Change Management with Sqitch.
Paste entire function to new "up" script
...
0
votes
2
answers
92
views
Will introducing a long standing Dev branch create unnecessary maintenance overhead?
I am seeing bad practices occurring in our version control where my colleagues are creating their own versioning system with stored procedures so that they can compare results before/after changes and ...
- 245
1
vote
1
answer
761
views
Best way to model pricelist per customer for products in webshop
I am making a b2b-webshop system that will have multiple customers. Each customer will have a separate active pricelist which contains the products that they can buy and the prices that applies for ...
- 139
-1
votes
2
answers
118
views
The challenges of removing/modifying entries from a database located in persistent storage
I'm implementing my own simple database with disk storage, and I'm not sure how to go about modifying and deleting entries.
The problem is that as you delete a record from arbitrary position within ...
- 284
1
vote
1
answer
89
views
How to go about accessing data on a server that has large downtime periods
Where I work, there is an Oracle data warehouse that is managed by another group that contains some pretty critical information for the company to run smoothly. The issue is that they (apparently, ...
- 111
3
votes
2
answers
135
views
API-oriented databases: is it maintained by the back or API team?
From what I understand, no-SQL databases differ from SQL databases because they allow the developpers to designe the tables to fit the usage, rather than fitting the model. Which means most of the ...
- 141
0
votes
2
answers
606
views
Optimistic locking with business constraints [closed]
Consider this simple example:
Tables (in a restaurant) can be booked for a period.
Business constraint: No two table bookings for the same table may overlap in time.
How might one prevent business ...
- 123
0
votes
3
answers
350
views
How to associate one type with another in multiple contexts?
An application has types Game (and other business units) and Message.
(Message is not a simple class with text, but a composition of a variable number of blocks like texts, images, and videos).
...
- 41
1
vote
1
answer
93
views
Imagers for a product in Internet Store -- one to many or many to many?
I'm creating a database schema for a internet store and I wonder how to better create the tables "images" and "products". A simpler way will be to have it as one_to_many, that is:
images(....., ...
- 19
-6
votes
1
answer
776
views
Where should I store data related to UI/presentation?
Say, I have a table Categories. On a page I have a header and for each category the colour of a header varies.
A colour is of the presentation level and I've heard that what's related to the UI/...
- 83
-1
votes
2
answers
86
views
A single field or 2 fields for "description" and "content" of Article?
Say, I want to create a db schema for a blog. So far I've used 2 separate fields for "description" and "content" of Article. But I've seen a lot that usually only a single is used for both. The "...
- 83
-1
votes
1
answer
656
views
How should I go about creating a db schema for "news subscription" and connecting it with "users"?
On my website there's a new subscription form. And users can also register and subscribe to news after. When an anonymous user subscribes to the news, how should I better handle that? Should I create ...
- 83
2
votes
2
answers
130
views
unique varchar(NNN) with an index in database and its overhead
I've seen the url like this
domain.com/some-article-title-which-can-be-very-long
many times. There's no ID embedded in it. Therefore, in a db it must be defined as "unique article_url varchar(NNN)"
...
- 797
37
votes
8
answers
41k
views
What's a universal way to store a geographical address/location in a database? [closed]
What's a correct format of a geographical address/location which is a good fit for any address on the Earth?
At the moment I have:
country
city
street
number
text data (for simplicity)
zip
lat/lng
But ...
- 411
0
votes
1
answer
2k
views
Shared configs between backend and frontend
I have some data (list of parameters) that should be shared across the backend and the frontend. The changes are really infrequent, and changes usually mean a redeploy. Currently, it is stored in the ...
- 139
0
votes
1
answer
61
views
design implementation for a postgres database in a not connected environment
I have several postgres DB, on distant sites, two in China, 1 in India , one in Korea, one in Germany, one in France and one in Mexico.
All dbs, regardless of their site, have one table that is part ...
- 285
1
vote
2
answers
2k
views
Best way to sync data from one database to another
Let's say I have my web shop and database have multiple tables like Products, Product prices and similar.
I'm selling my software solution to my affiliate partner. He gets its database, it window ...
- 127
1
vote
2
answers
147
views
How to create database, tables and stored procedures during installation of application
Our company code base still has some code that will create the database, tables, stored procedures and the like.Coding the SQL stored procedures line by line in Java, in string format is a real pain.
...
- 139
3
votes
4
answers
2k
views
Database modeling, software development, and version control
Here is the framework
We have an SQL database in which our database model lives in. On the other side, there is a bunch of code using and filling that database.
Here is what we want
We want to put ...
- 141
0
votes
3
answers
119
views
using two database in .net
I am trying to implement the use of two database in my application, sqlite and mysql.
Currently i added references to both database connection library, and duplicate all first checking which database ...
- 643
2
votes
1
answer
813
views
How to show if a database is ACID or BASE?
I was wondering if there are general guides or standards which can be followed when trying to show if your own database implementation is ACID or BASE compliant?
For example are there any specific ...
- 123
0
votes
2
answers
87
views
Should we sanitise and clean data or only display it in the expected format?
So my problem is, I have users entering their data(names, address) in a mixed form- some with first letter in caps and some without, some inserting more than necessary spaces and so forth.
Also, ...
1
vote
0
answers
829
views
Best way to handle multiple environment specific sql scripts in source control
I am maintaining an app that uses a lot of sql server 2008r2 stored procs, views etc.
The problem that I have is that certain stored procedures/views have code that is specific to the environment: ...
- 141
3
votes
1
answer
1k
views
How is one or more aggregate function implemented in most SQL engines?
In the book Database Fundamentals, Silberschatz. It is explained that aggregate functions can be calculated on the march.
This make sense. What it means is that for calculating the maximun, average ...
- 336
3
votes
1
answer
795
views
Managing a development database in a group project
I'm working for a small webdevelopment company and we want to set up development environments. We'll be using the Laravel framework in combination with Homestead. Now, Homestead has its own database ...
- 359
4
votes
1
answer
458
views
What's the advantage of storing database transaction changes in the log as well as data pages?
I know the basics of why a database uses a transaction log - fulfilling ACID properties, ability to rollback/restore, etc.
The basic algorithm that I see for a transaction is as follows:
transaction ...
- 143
5
votes
3
answers
744
views
Is it a good practice to have a pre-filled embedded database for development?
I'm currently working on a project which only uses its database for data storage. This means there are no triggers or stored procedure in it, just tables and data to put into it. In this scenario I'm ...
- 2,241
3
votes
1
answer
1k
views
Good approach/Strategy to keep integration test database in-sync with production db?
I'm building a web application in Spring.
I'm using an in-memory (embedded) database for my integration test - HSQL
My production database is MySQL.
When i setup my integration tests a while back i ...
1
vote
1
answer
168
views
Creating a specific table for shared columns among other tables (models)?
I'm creating a webapp that has a variety of models: Product, Category, ProductOption, etc.
All of these models have a set of shared attributes: name, description, image, etc.
There are two options I ...
- 175
3
votes
2
answers
887
views
Is there any point in preventing developers from having a local copy of the database in their machine?
Is there any point to having a dedicated development database server(s) that all developers can use, i.e. they don't have a local copy of the db in their machines. Quite clearly, this will slow down ...
- 131
3
votes
0
answers
909
views
how to import large amounts of data without locking sqlite database
Background Information
I have a web app that provides the user with the usual CRUD functionality for "widgets" let's say.
But I also have give them the option of creating widgets in bulk via ...
- 581
4
votes
2
answers
432
views
How does I/O work for large graph databases?
I should preface this by saying that I'm mostly a front end web developer, trained as a musician, but over the past few years I've been getting more and more into computer science.
So one idea I have ...
- 249
1
vote
3
answers
903
views
Select custom output formats from database with SQL
I am planning to make a simple rest service application, and I am currently deciding the architecture. I have decided that I want to write the middle layer in multiple languages, so that it is easy to ...
- 329
3
votes
3
answers
3k
views
Tracking correct order details in commerce database when modifying 'products'
I am implementing an ecommerce database. This is slightly different than most as the 'products' that are for sale are for services provided. For example a user (vendor) of the system may define a ...
- 3,263
5
votes
2
answers
1k
views
Deploying Database Schema changes in a patching process [duplicate]
I am facing a conceptual development methodology problem that I was hoping you could help me with. Firstly, a little bit of background.
Background
The project I am developing is a niche application ...
- 153
1
vote
1
answer
2k
views
How to store Status for Reservation table
I have a reservation table (a user fills out a form to request a reservation).
It has two parts that need to be confirmed. isReservationAccepted (decline,accept,waiting) and hasReservationBeenSent (...
- 113
0
votes
1
answer
1k
views
How does this normalized example work?
I had the following DB schema:
Customer Car Rental
------- ---- ------
Name Name Car_ID
ID ID Customer_ID
Date
This is said to be non normalized ...
- 4,946