Questions tagged [database-development]

The tag has no usage guidance.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
766 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 ...
1
vote
0answers
474 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: ...
1
vote
1answer
332 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 ...
0
votes
0answers
34 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 ...
0
votes
0answers
41 views

NoSQL Database Schema w/ Very Flexible Hierarchy

Recently I have been working with a NoSQL database (Firestore to be exact) to be used for my Web App where we essentially allow our users to create 'trees' of some sort. What this means is that you ...
0
votes
3answers
192 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 ...
0
votes
2answers
169 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 ...
-1
votes
1answer
54 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" ...