Questions tagged [database-development]
The database-development tag has no summary.
109 questions
2
votes
1
answer
430
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
0
votes
1
answer
590
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
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
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
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
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 ...
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
0
votes
2
answers
91
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
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
3
votes
2
answers
133
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
3
answers
349
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
-6
votes
1
answer
774
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
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
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
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
146
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
0
votes
3
answers
118
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
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, ...
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
4
votes
1
answer
457
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
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 ...
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
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
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
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