Questions tagged [database-development]
108 questions
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,205
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
- 11,018
6
votes
7 answers
Should there be separate database schemas for each developer or should there be just one that all developers share?
During development, should developers each have their own copy of the database to work on ? Or should there be a common shared development database ?
The former will give developers more flexibility. For ex., they can run their own regression tests…
Rahul
- 2,119
4
votes
1 answer
Database design and performance impact
I have a database design issue that I'm not quite sure how to approach, nor if the benefits out weigh the costs. I'm hoping some P.SE members can give some feedback on my suggested design, as well as any similar experiences they may have came…
Craige
- 3,781
- 22
- 30
3
votes
6 answers
Real-time stock market application
I'm an amateur programmer. I'd like to develop a software application (like Tradestation), to analyse real-time market data. Please teach me if the following approach is correct, ie the procedures, knowledge or software needed etc:
Use a DB to read…
Sam
- 57
3
votes
6 answers
What list of database features/elements are necessary for a programmer to understand?
What database features/elements are necessary for a programmer to understand in order to create non-trivial applications?
I was once asked in a job interview (by a DBA) to rate my understanding of database concepts -- I thought it would be…
Watson
- 2,262
- 14
- 16
3
votes
3 answers
Are database developers considered under DBA jobs?
This isn't career advice, this is more of a question of logistics.
When looking at job market and such there is a lower than what I think would be out there of database admins but I'm curious if database admins actually include strictly database…
user6791