Entity Framework as a type checking/verification system for database code
When I read pro and con lists of using Entity Framework (or any modern ORM really), I’m surprised that the following point doesn’t arise (self quote):
Database connection – should they be passed as parameter?
We have a system whereby the database connection is get once using a common method, and being pass throughout the relevant class to be used. There are doubts that passing the database connection as a parameter to different classes would cause problem, so i’m checking here to see whether this is actually viable, and are there any better patterns to do it?
Multiple Display of a Document and persist each viewer change in a single document
i have a scenario where i have to make available a document for viewing and editing to multiple users, the users can edit and view the document at the same time. Now the problem arises here if for example user A and user B are viewing a document at the same time and if both the user change the state of the document and user A saves it at x instant of time and user B saves it at y instant of time where y>z in the time dimension. The changes by the user A will be overridden by changes made by the user B.
Table scaling with partitions or with separate databases?
Hypothesis: I have a table (named BigTable) which could experience 5,000,000 INSERTS per day (with possibly just as many SELECTs). Each row inserted is about 50kb.
Database data structures for RESTful api
I am creating a RESTful API. I am struggling to decide on the best way to design my database tables around my resources.
Domain Driven Design with an EAV database model
How can one apply DDD to a EAV database model?
Testing interaction with large CRM database
In our company we have two large systems, basically they are scoring and CRM. Both have large SQL Server databases running on Windows servers on the intranet. These two databases are managed by other department, which we have a direct contact with.
Plugin Architecture: How to Handle Databases and Logging?
I am in the process of designing an architecture for a plugin based application and I have some questions about how to handle database access and logging. The goal of my application is to allow a device my company is manufacturing to send messages over any number of third-party protocols and to any number of third party devices. Because of the nature of my application, I need to log every message that is sent via my system in reasonable detail.
Why use a database instead of just saving your data to disk?
Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. Answers without enough detail may be edited or deleted. Instead of a database I just serialize my data to JSON, saving and loading it to disk when necessary. All the data management is […]
Designing a loosely coupled app -> stored proc interface for PostgreSQL. A couple of questions
I am in the middle of designing a next generation database access class for one of the programs I am building. We use PostgreSQL exclusively.