Tagged Questions
4
votes
2answers
250 views
Proper Data Structure for Commentable Comments
Been struggling with this on an architectural level.
I have an object which can be commented on, let's call it a Post. Every post has a unique ID.
Now I want to comment on that Post, and I can use ...
4
votes
2answers
2k views
What would your DB Schema look like if you are building a Reddit/Digg-like site?
Just found out something rather interesting about Reddit's database schema:
The way we’ve changed is we use an
“open schema”. Sometimes it’s called
“entity attribute value”. It’s
basically ...
3
votes
4answers
694 views
Better way of storing key-value pairs in the database?
I have a C#/SQL Server program that sometimes needs to store data. The data could be a response from a web service, a result of a database query, or any number of other things. There's no way of ...
3
votes
5answers
408 views
Using XML field Vs. creating a table for unstable organization
I am in the middle of design an application to issue and store invoices for an organization. The problem is the organization is not stable at all. There are many types of invoices and they may ...
2
votes
3answers
105 views
Is there a better way of handling access control logic instead of it being in the UI?
Through most of my dev experience, I've never had to deal with much variety of access control architectures.
They've all been pretty straight forward:
Group [Create, Update, Delete]
- User 1
...
2
votes
2answers
146 views
Are there standard strategies for defining job flow and dependencies?
I'm working on a project that involves the chaining of separate jobs into a single master job, though there may be parallel paths in the chain leading up to the final output. Job and chain details ...
1
vote
5answers
509 views
Worst practices in developing database applications [closed]
In constrast to
http://programmers.stackexchange.com/questions/123591/database-design-good-practices
I wanted to ask:
What are the top worst practises you encountered when having to work with other ...
1
vote
1answer
153 views
Representing a parent/child hierarchy in a Relational Database
I am working on an application that connects to another application (Quickbooks) using an API by sending/receiving XML requests/responses. I am able to work with the data in the XML response and load ...
1
vote
3answers
109 views
Schema/Code for respecting different schedules
We accept leads from lead providers. We only allow certain providers to post leads to us during certain days/times. Currently, we have 3 schedules, but we might add 1 or n more in the future:
Sunday ...
1
vote
1answer
125 views
Multi-user Configuration Settings design
I am designing a flexible and extensible way to store configuration settings for users.
Database Table Design:
╔═════════════════════════════╗
║ ConfigurationItemDefinition ║
...
-1
votes
2answers
520 views
Fitting it together, database, reporting, applications in C#
Introduction
Preamble
I was hesitant to post this, since it's an application whose intricate details are defined elsewhere, and answers may not be helpful to others. Within the past few weeks (I was ...
