StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONeed a file system metadata layer for applications
primarykey
Id
12433308
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-09-14T23:42:01.177
FavoriteCount
1
LastActivityDate
2012-10-24T00:11:18.110
LastEditDate
2012-09-15T04:41:42.493
LastEditorUserId
217403
OwnerUserId
217403
ParentId
0
PostTypeId
1
Score
5
ViewCount
2482
LastEditorDisplayName
text
Body
I'm looking for a metadata layer that sits on top of files which can interpret key-value pairs of information in file names for apps that work with thousands of files. More info: <ul> <li>These aren't necessarily media files that have built-in metadata - hence the key-value pairs. </li> <li>The metadata goes beyond os information (file sizes, etc) - to whatever the app puts into the key-values.</li> <li>It should be accessible via command line as well as a python module so that my applications can talk to it.</li> <li>ADDED: It should also be supported by common os commands (cp, mv, tar, etc) so that it doesn't get lost if a file is copied or moved.</li> </ul> Examples of functionality I'd like include: <ul> <li>list files in directory x for organization_id 3375</li> <li>report on files in directory y by translating load_time to year/month and show file count & size for each year/month combo</li> <li>get oldest file in directory z based upon key of loadtime</li> </ul> Files with this simple metadata embedded within them might look like: <ul> <li>bowling_state-ky_league-15_game-8_gametime-201209141830.tgz</li> <li>bowling_state-ky_league-15_game-9_gametime-201209141930.tgz</li> </ul> This metadata is very accessible & tightly joined to the file. But - I'd prefer to avoid needing to use cut or wild-cards for all operations. I've looked around and can only find media & os metadata solutions and don't want to build something if it already exists.
Tags
<python><file><metadata>
Title
Need a file system metadata layer for applications
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USKenFar
UserOwnerUserId
1. USKenFar
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PONeed a file system metadata layer for applications
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PONeed a file system metadata layer for applications
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.