The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
6answers
9k views

Real-time stock market application [closed]

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, ...
12
votes
3answers
9k views

Microsoft's current best practices for building a .NET data tier? And reality?

The development team I'm working with will be moving to .NET 4.0 soon, however, the data access class library we use still uses ADO.NET "classic", meaning SqlDataReader, DataTable, and the like. ...
14
votes
6answers
41k views

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 ...
1
vote
5answers
1k views

What is better making a separate temporary table or inserting directly to big table?

I have a big table with 1,400,000 rows, and I need to insert 3000 rows daily in it. When I insert 3000 rows daily should I first insert to a temporary table than dump that temporary table to the ...
0
votes
1answer
65 views

what should i use running cron or getting by query

I have a table which has the amount,entrydate and amtperday field , which is to decrease daily. so what is better running the cron job daily to decrease amount. or or at the time of fetching data ...
26
votes
8answers
9k 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....
5
votes
5answers
458 views

What are the standard practices for database access in .net?

I have seen weird database access practices in .net. I have seen stored procedures for every database tasks. I have seen every database property name is preceded by it's table name. I have seen fully ...
5
votes
4answers
1k views

Unit testing data access objects

I have recently started using test-driven development and unit testing, and it has paid off immensely in the areas where I have aplied it. One area that it has been helpful in is database access. When ...
10
votes
4answers
786 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 ...
10
votes
5answers
329 views

Can it be a good idea to create a new table for each client of a webapp?

This is semi-hypothetical, and as I've no experience in dealing with massive database tables, I have no idea if this is horrible for some reason. On to the situation: Imagine a web based application -...
4
votes
1answer
369 views

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 ...
-1
votes
1answer
169 views

Launching web-app with database without static ip [closed]

I have created a small web-app and want to deploy it. I have used struts2 and mysql for the database. The problem is that I do not have a static ip to run the app on my machine. Can anyone suggest me ...
8
votes
3answers
706 views

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 ...
12
votes
3answers
924 views

Does ORM promote database de-normalisation?

Doctrine and Propel both make use of single and concrete table inheritance to map object relationships. The former sees all possible fields in the class tree mapped to a single table - whereas the ...
1
vote
1answer
167 views

Database strategy for connected but disparate applications

I'm working on a series of inter-related but separate web applications, all situated on the same host: Super Admin | ---Site Network Admin | | | ---Site | | | ---Site | | | ---Site | ---...
4
votes
6answers
674 views

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

Cross border data obfuscation and how to deal with it?

I am currently facing a situation where I will need to obfuscate data for legal reasons (these are countrywide rules and not specific to me) I will still need to work with teams outside this area who ...
17
votes
5answers
3k views

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 ...
2
votes
2answers
147 views

Best way to store revision information for quick access to view or revert changes

What I am looking for is the most optimal solution for storing content revisions in an MSSQL database. We have an application that allows users to make changes to small HTML content blocks similar to ...
16
votes
5answers
356 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 ...
20
votes
9answers
4k views

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 ...
7
votes
1answer
629 views

How to read and understand ER diagrams

I've been handed the ER diagram for a quite complex database. Complex to me at least, 849 tables. One of the architects says to understand the code, you need to understand the database and ...
20
votes
14answers
2k views

What are the benefits of using database abstraction by ORM? [closed]

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 ...
45
votes
11answers
3k 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 ...
6
votes
4answers
2k views

Is it time to use MariaDB instead of MySQL on application development? Why? [closed]

If you know MariaDB, what's your opinion about migrate applications to use MariaDB instead of MySQL? What we gain and what we lost with this change? Is it really unnecessary to change the ...
3
votes
1answer
552 views

What is the best toolset for developing an enterprise application for SMBs?

Need a Free, Fast(development and runtime) and Reliable(transactions and locking) tool set for creating an enterprise application for SMBs. I'm thinking of an application framework + UI framework + ...
6
votes
1answer
1k views

What are some easy-to-implement scaffolding systems? [closed]

Often when stating a new project I'll require a "quick 'n' dirty" content management solution. Ideally something that can read my database schema and generated HTML forms. Previously I've used; ...