Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database-development]

The tag has no usage guidance.

0
votes
2answers
57 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 ...
0
votes
1answer
40 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 ...
-1
votes
2answers
57 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 ...
1
vote
1answer
71 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, ...
0
votes
0answers
21 views

Implementing Products, Purchases and Payments and Statuses

I have Products, Purchases and Payments. I'm trying to figure out how to deal with Payments and statuses and the ultimate status of Purchase - "paid", "failed", "refunded", etc.... My requirements: ...
3
votes
2answers
100 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 ...
0
votes
2answers
180 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 ...
0
votes
3answers
165 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). ...
1
vote
1answer
28 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(....., ...
-6
votes
1answer
163 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/...
0
votes
2answers
52 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 "...
0
votes
1answer
177 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 ...
1
vote
2answers
67 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)" ...
23
votes
8answers
10k 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 ...
0
votes
1answer
211 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 ...
0
votes
1answer
43 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 ...
-1
votes
2answers
391 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 ...
1
vote
2answers
117 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. ...
3
votes
3answers
729 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 ...
0
votes
3answers
96 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 ...
2
votes
1answer
337 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 ...
0
votes
2answers
75 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
0answers
332 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: ...
3
votes
1answer
689 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 ...
3
votes
1answer
341 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 ...
4
votes
1answer
214 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: ...
5
votes
3answers
416 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 ...
3
votes
1answer
649 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
1answer
96 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 ...
3
votes
2answers
217 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 ...
2
votes
0answers
587 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 ...
4
votes
2answers
311 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 ...
1
vote
3answers
643 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 ...
4
votes
3answers
2k 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 ...
5
votes
2answers
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 ...
1
vote
1answer
735 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 (...
0
votes
1answer
671 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 ...
0
votes
1answer
257 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, ...
1
vote
1answer
554 views

What's the best approach to building a db schema for profile, but to track changes?

I'm working on a site where companies can create a profile then add locations for each profile. Those first two tables are simple enough. But any changes to their profiles or locations have to go ...
-1
votes
2answers
2k views

SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]

When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
12
votes
5answers
1k views

What methods are available to show colleagues the advantages of a database+application solution over Excel?

I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I'm sure they haven't contemplated that there might be a better/easier/more productive way of ...
2
votes
1answer
925 views

How can I maintain a SQL schema upgrade that goes out to our users on a regular basis?

I work on a project that uses a SQL database as a back end, and a desktop app as a front end. We do releases on a regular basis, and as part of a release, our client needs to update their SQL server. ...
1
vote
1answer
147 views

Visual Studio DBProjects and problem with it running post-build SQL (file too big)

What I am doing is creating a DBProject.. importing a DB.. then creating scripts in the PostBuild that are DATA scripts for each table (so that the post build can populate the tables after the schema ...
1
vote
3answers
232 views

How to maintain user relationship when user un-follows another user

I have a table of user relationship which stores who follows whom, the table structure is as follows -id -follower -following when someone follows any other user, I add a record with follower user ...
3
votes
3answers
268 views

Are database developers considered under DBA jobs?

This isn't career advice, this is more of a question of logistics. When looking at job market and such there is a lower than what I think would be out there of database admins but I'm curious if ...
4
votes
1answer
732 views

Database Schema Usage

I have a question regarding the appropriate use of SQL Server database schemas and was hoping that some database gurus might be able to offer some guidance around best practice. Just to give a bit of ...
1
vote
2answers
2k views

Fitting it together, database, reporting, applications in C#

Introduction Preamble I was hesitant to post this, since it's an application whose intricate details are defined elsewhere, and answers may not be helpful to others. Within the past few weeks (I was ...
31
votes
5answers
61k views

What are the advantages of myBatis over Hibernate? [closed]

I've done some research on my own and understand the basic concept. But some insights can only be gained through actual experience. What are the advantages of myBatis that would make it worth ...
6
votes
5answers
985 views

How do you keep track of the meaning of your SQL fields? [closed]

The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data. I use SQL ...
2
votes
1answer
246 views

In-memory DB to perform intersects on set slices

I have a specific programming need where I need to efficiently store large sorted sets in memory, query them for ranges, and intersect them against other sets that are also queried for ranged. I am ...