The database-development tag has no wiki summary.
2
votes
2answers
90 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 ...
14
votes
5answers
298 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 ...
8
votes
5answers
737 views
Want to learn one of those NoSQL databases, looking for advice on which one to check out
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 ...
14
votes
8answers
1k 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 ...
4
votes
1answer
465 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 ...
13
votes
9answers
764 views
As a programmer, what is your favorite database managment system and why? [closed]
What database system do you enjoy working with from a programming perspective (not as a database administrator)?
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 ...
42
votes
12answers
1k views
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 ...
5
votes
4answers
948 views
Is it time to use MariaDB instead of MySQL on application development? Why?
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
303 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 + ...
22
votes
8answers
2k views
Are NoSQL databases going to take the place of relational databases? Is SQL going away? [closed]
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 ...
6
votes
1answer
681 views
What are some easy-to-implement scaffolding systems?
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; ...
