StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8022794
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-11-05T19:44:41.950
FavoriteCount
0
LastActivityDate
2011-11-05T19:44:41.950
LastEditDate
LastEditorUserId
0
OwnerUserId
533120
ParentId
7963656
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
For completeness, let me just mention that some databases allow you to have a "hybrid" of these two approaches, for example <a href="http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/oralob.htm" rel="nofollow">Oracle BFILE</a> or <a href="http://technet.microsoft.com/en-us/library/bb933993.aspx" rel="nofollow">MS SQL Server FILESTREAM</a>. There is also an interesting discussion at Ask Tom on <a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0%3a%3a%3a%3aP11_QUESTION_ID:1011065100346196442" rel="nofollow">storing files in Oracle BLOBs</a> (in a nutshell: "BLOBs are better than files"). <hr> BTW, you don't necessarily need to chose one over another... If you can afford storage overhead and you are operating in a read-mostly environment, you could store the "master" data in the BLOB for integrity but "cache" that same data in a file for quick read-only access. Some considerations: <ul> <li>You'd need to make sure the file is updated/removed if BLOB is updated/removed.</li> <li>Consider creating/updating the file on-demand.</li> <li>Consider evicting old files from the "cache" even if corresponding BLOBs still exist.</li> <li>Consider using several "caches" (e.g. if you have a middle tier and is distributed to multiple physical machines, each machine could have its own file cache).</li> <li>And finally, you'd need to make sure all this works robustly in a concurrent environment.</li> </ul> So, this is not the simplest approach but, depending on your needs, may be a good tradeoff between integrity, performance and implementation effort.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POBest practices for mixed usage of RDBMS and files on filesystem
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USBranko Dimitrijevic
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POBest practices for mixed usage of RDBMS and files on filesystem
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COGood point. Unfortunately, I am on MySQL, which if I am not mistaken, doesn't have such a feature and thus would require complete application layer logic to turn disk representation of the file (s.a. PDF or image) into a BLOB, and vice-versa.
 singulars
 PostPostId
 PO
 UserUserId
 USicarus74

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.