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 ...
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 ...
As someone who first encountered relational databases and SQL at uni in the early 90's, and who has spend a goodly slice of a fifteen year career working with MS SQL Server, I'm probably a textbook ...
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 ...
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 ...
What database system do you enjoy working with from a programming perspective (not as a database administrator)?
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 ...
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 ...
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 ...
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 + ...
Does anyone have experience with NoSQL databases (CouchDB, MongoDB, Google's BigTable, Dynamo, Cassandra...)? What was it like? Was it actual production/on the job experience? What will happen to ...
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; ...