Questions tagged [database-development]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
71 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 ...
user avatar
0 votes
1 answer
137 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 ...
user avatar
  • 3
-2 votes
2 answers
92 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-...
user avatar
1 vote
1 answer
66 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 ...
user avatar
-1 votes
1 answer
121 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 ...
user avatar
  • 27
0 votes
0 answers
39 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 ...
user avatar
6 votes
2 answers
233 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 ...
user avatar
1 vote
2 answers
152 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. ...
user avatar
  • 31
-1 votes
4 answers
318 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 ...
user avatar
0 votes
2 answers
307 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 a application that allows to extend the duration of the contract and to modify ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
49 votes
8 answers
12k 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) ...
user avatar
1 vote
1 answer
129 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" ...
user avatar
0 votes
2 answers
79 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 ...
user avatar
1 vote
1 answer
430 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 ...
user avatar
  • 139
-1 votes
2 answers
66 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 ...
user avatar
1 vote
1 answer
79 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, ...
user avatar
  • 111
3 votes
2 answers
113 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 ...
user avatar
  • 141
0 votes
2 answers
455 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 ...
user avatar
  • 123
0 votes
3 answers
226 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). ...
user avatar
1 vote
1 answer
30 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(....., ...
user avatar
  • 19
-7 votes
1 answer
421 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/...
user avatar
  • 51
0 votes
2 answers
57 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 "...
user avatar
  • 51
0 votes
1 answer
458 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 ...
user avatar
  • 51
2 votes
2 answers
97 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)" ...
user avatar
  • 777
34 votes
8 answers
32k 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 ...
user avatar
  • 381
0 votes
1 answer
952 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 ...
user avatar
  • 139
0 votes
1 answer
51 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 ...
user avatar
  • 285
1 vote
2 answers
1k 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 ...
user avatar
1 vote
2 answers
120 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. ...
user avatar
  • 139
3 votes
4 answers
1k 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 ...
user avatar
0 votes
3 answers
106 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 ...
user avatar
  • 643
2 votes
1 answer
617 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 ...
user avatar
0 votes
2 answers
79 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, ...
user avatar
1 vote
0 answers
532 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: ...
user avatar
  • 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 ...
user avatar
  • 336
3 votes
1 answer
709 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 ...
user avatar
4 votes
1 answer
368 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: ...
user avatar
  • 143
5 votes
3 answers
607 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 ...
user avatar
  • 2,151
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 ...
user avatar
1 vote
1 answer
125 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 ...
user avatar
  • 175
3 votes
2 answers
474 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 ...
user avatar
  • 131
3 votes
0 answers
793 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 ...
user avatar
  • 479
4 votes
2 answers
380 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 ...
user avatar
  • 249
1 vote
3 answers
807 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 ...
user avatar
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 ...
user avatar
  • 2,855
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 ...
user avatar
  • 153
1 vote
1 answer
1k 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 (...
user avatar
  • 113
0 votes
1 answer
990 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 ...
user avatar
  • 4,878
0 votes
1 answer
275 views

How should I evaluate the Database Solution for Large Data Application

Background I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
user avatar