SQLite
From Musik
musikCube uses SQLite (http://www.sqlite.org/) as an internal database to store the music library, standard and Dynamic Playlists, and more.
SQLite has most of the standard sql functionality, so if you are familiar with databases you will feel right at home. if you've never used an SQL database before: it's not that hard!
- SQLite wiki (http://www.sqlite.org/cvstrac/wiki)
- SQLite language reference (http://www.sqlite.org/lang.html)
[edit]
SQLite2Excel
SQLite2Excel is a tool created by ObsidianX to convert the database of musikCube to a .xls file
Download (http://www.musikcube.com/~mestk/other_stuff/sqlite2excel.zip)
[edit]
Forum Discussions
- Dynamic playlist. Some references (http://musikcube.com/punbb/viewtopic.php?id=266)
- SQLite2Excel (http://www.musikcube.com/punbb/viewtopic.php?id=1192)
[edit]
External Links
- the W3Schools tutorial (http://www.w3schools.com/sql/default.asp) is apparently a nice introduction to SQL
- SQLite Tutorial: Common Commands and Triggers (http://www.mirrormonster.com/linuxgazette.net/109/chirico1.html)
