Questions tagged [database-development]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
13
votes
1answer
8k views

Database Application Design Best Practices [duplicate]

Once upon a time it was common practice for both the business logic and database logic to be written in the same language (eg PL/SQL, Transact SQL, etc), more recently the practice is to separate the ...
45
votes
11answers
4k views

What are the arguments against or for putting application logic in the database layer? [closed]

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 ...
3
votes
3answers
1k views

database migration: upgrade schema deployed on client machines

I'm working on an application, which when deployed is installed locally on client machines, and uses a local database server. Stupidly, I didn't plan for schema changes -- and now it needs to change. ...
58
votes
2answers
36k views

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 ...
3
votes
4answers
1k 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 ...
16
votes
5answers
417 views

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 ...
6
votes
5answers
1k 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 ...
31
votes
8answers
27k 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 ...
32
votes
8answers
22k views

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....
11
votes
2answers
8k views

How can I keep my visualstudio database project in sync with my database?

I'd like to have my database schema synchronized with my Visual Studio .dbproj database project. Right now, I'm using SSMS for most of my database development work, and I've to manually use the ...
11
votes
4answers
1k views

Stored procedure Naming conventions? [closed]

One of our senior developers has stated that we should be using a naming convention for stored procedures with an "objectVerb" style of naming such as ("MemberGetById") instead of a "verbObject" type ...
2
votes
5answers
501 views

Organizing my products database

I’m developing a web-based store in MVC (very closely based on the SportsStore example in Pro ASP.Net MVC 3 Framework http://www.powells.com/biblio/61-9781430234043-0). I’m using a SQL database and ...