Questions tagged [database-development]
109 questions
81
votes
8 answers
Create my own database system
I need to learn how databases work in order to use them more efficiently, and my way of learning is by doing.
I want to create my own database system. I am not referring to creating a pseudo-database that would use query to parse files; this would…
Xananax
- 1,390
66
votes
2 answers
Best practice/Patterns for two way data synchronisation
Quite often in my work the idea of 2-way data synchronisation between database systems crops up. The classic example is two slightly different CRM systems (say, Raiser's Edge and Salesforce) and the need to have a two-way sync of Contact data…
codeulike
- 849
53
votes
8 answers
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) from the Infrastructure (DB, File System,…
Leonardo Mangano
- 684
45
votes
11 answers
What are the arguments against or for putting application logic in the database layer?
Most software developers want to keep application logic in the application layer, and it probably feels natural for us to keep it here. Database developers seem to want to put application logic in the database layer, as triggers and stored…
Vetle
- 2,185
37
votes
8 answers
What's a universal way to store a geographical address/location in a database?
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 I believe I can improve it: there might be a…
Xwaro
- 411
37
votes
5 answers
What are the advantages of myBatis over Hibernate?
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 learning a new framework?
In what case would you avoid…
Kshitiz Sharma
- 837
33
votes
8 answers
Front end first or Back end first. Of the two which is a Good system design pratice?
I have a client right now requiring me to develop a school enrollment system. Now this is the first time im having this kind of challenge. Most of the past software that i created are not that complex.
I know most all of you have created complex…
drexsien
- 441
- 1
- 4
- 6
31
votes
9 answers
Should a primary key be immutable?
A recent question on stackoverflow provoked a discussion about the immutability of primary keys. I had thought that it was a kind of rule that primary keys should be immutable. If there is a chance that some day a primary key would be updated, I…
Vincent Malgrat
- 413
28
votes
3 answers
Conflict resolution for two-way sync
How do you manage two-way synchronization between a 'main' database server and many 'secondary' servers, in particular conflict resolution, assuming a connection is not always available?
For example, I have a mobile app that uses CoreData as the…
K.Steff
- 4,525
- 2
- 33
- 28
20
votes
7 answers
Is writing your own Data Access / Data Mapping Layer a "good" idea?
We're currently in a situation where we have a choice between using an out-of-the-box object-relational mapper or rolling our own
We have a legacy application (ASP.NET + SQL Server) where the data-layer & business-layer are unfortunately mashed…
Eoin Campbell
- 2,128
19
votes
14 answers
What are the benefits of using database abstraction by ORM?
I'm starting to use the ORM recommended by the framework I choose, and though I like the idea of the added layer of abstraction the ORM provides, I'm starting to realize what this really means. It means I'm no longer working with my database (mysql)…
jblue
- 778
18
votes
5 answers
Is LINQ to SQL dead?
Is there any reason to keep using Linq to SQL, or is it better to move to ORM techniques like EF, NHibernate etc.
We are using Linq to SQL in a new large enterprise application that will exist for a long time. The motivation for this new enterprise…
Amir Rezaei
- 11,068
16
votes
6 answers
what do database programmers do?
Every time I read about Oracle programmers etc, I get confused. I don't know what exactly they do.
From my understanding, application programmers need to develop the core functionality. The libraries they use might help in GUI development or…
Thomas
- 169
16
votes
10 answers
Best way to model a singleton in a relational database
When designing relational database schema for web applications, I often find a case where I end up creating a table just to contain one row, and only one row. It feels like that is the wrong way to design it, but I can't come up with anything…
Apreche
- 329
16
votes
5 answers
Should my multi-server RDBMS or my Application handle database Referential Integrity?
Should items like Foreign Keys, Constraints, Default Values, and so on be handled by the database management system (in this case, MS SQL 2005) or the application? I have heard opinions from both sides and I'm honestly not sure which way to…
Rachel
- 24,037