0
votes
2answers
88 views

Guidance on connecting a common database to several instances of the same application [closed]

I'm looking for advice regarding a future development of mine, concerning a application that may be run in several machines that need to use and manipulate the same data. As this sounds somewhat vague ...
1
vote
1answer
88 views

Keeping database connection

Say you are developing a desktop application that extensively uses a database, should you have one handle for the database that the entire app references? Or should you open a connection when you need ...
13
votes
6answers
3k views

How much business logic should the database implement? [duplicate]

I've worked in some projects where most of the business logic was implemented on the database (mostly through stored procedures). On the other side, I've heard from some fellow programmers that this ...
14
votes
5answers
615 views

Is having functionality in DB a road block to scalability?

I may not be able to give the right title to the question. But here it is, We are developing financial portal for wealth management. We are expecting over 10000 clients to use the application. The ...
3
votes
4answers
240 views

How can I design an application so that it works well with a database selected by the customer?

I want to write an ASP.NET 4.0 application with IBM DB2 Express-C as its back-end. One thing that worries me, is hosting this application on a remote server. I don't know any hosting provider who ...
4
votes
4answers
641 views

How to add image support to client-server database application?

I have an architectural question about a project that I am working on. Currently it is a simple .NET C# application that runs on several client machines, and communicates with a central MySQL server ...