Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [database-development]

108 questions
80
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,380
  • 1
  • 12
  • 14
62
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
  • 801
  • 1
  • 7
  • 10
50
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
  • 654
  • 1
  • 5
  • 10
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
  • 15
  • 19
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
  • 817
  • 4
  • 10
  • 14
36
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
  • 401
  • 1
  • 4
  • 4
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
30
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
  • 403
  • 1
  • 5
  • 6
27
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,475
  • 2
  • 31
  • 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,118
  • 1
  • 17
  • 17
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
  • 6
  • 13
17
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
  • 10,938
  • 6
  • 61
  • 86
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
  • 1
  • 1
  • 3
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
  • 23,979
  • 16
  • 91
  • 159
15
votes
6 answers

Isn't SQLite a bit underestimated?

Before I ask the question, let me first describe my thoughts about SQLite. I happen to like tools that are small, fast and, more importantly, have only the really necessary functionality. That's why I like SQLite and I like MS-SQL a bit less. For…
user32197
1
2 3 4 5 6 7 8