On 2013/11/08 05:47, James K. Lowden wrote:
Not that you asked, but I also suggest you consider dropping the Tbl from the table names. Noting that at table is a table in
its name is like calling every file data. It makes it harder to read and conveys no information. I myself prefer plurals for
Hi James K. Lowden,
Sorry. My backup application pulls tracks from albums and upload to
server. Here, I need to store these Albums and Tracks information into
database. From my application point of view, Every Track is a
file.File may be track. When same track avail with different albums,
then
Hi All,
I am working on sqlite database schema for Music/Track files. I am
posting few tables schema here.
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT NULL,
UNIQUE(file_path));
CREATE TABLE if not exists AlbumTbl
On Thu, Nov 7, 2013 at 11:50 AM, dd durga.d...@gmail.com wrote:
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT NULL,
UNIQUE(file_path));
Some years ago i worked on something similar to keep track of my multimedia
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
ad this to my schema.
On Thu, Nov 7, 2013 at 3:07 PM, Stephan Beal sgb...@googlemail.com wrote:
On Thu, Nov 7, 2013 at 11:50 AM, dd durga.d...@gmail.com wrote:
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
On Thu, Nov 7, 2013 at 12:15 PM, dd durga.d...@gmail.com wrote:
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
ad this to my schema.
If you're only storing the list for local use on one machine, adding the
media ID is almost certainly overkill, but i found it useful for
It has to work with multiple devices in future. This is valid point
for me. Thanks.
On Thu, Nov 7, 2013 at 3:42 PM, Stephan Beal sgb...@googlemail.com wrote:
On Thu, Nov 7, 2013 at 12:15 PM, dd durga.d...@gmail.com wrote:
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
ad
On Thu, 7 Nov 2013 14:50:44 +0400
dd durga.d...@gmail.com wrote:
I am working on sqlite database schema for Music/Track files. I am
posting few tables schema here.
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/11/13 19:47, James K. Lowden wrote:
You might guess from my email domain name that I take an interest in
posts like yours. And it's pretty good first cut, no pun intended.
;-)
It is also worthwhile looking at musicbrainz