Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.548.371 Times

Audio::DB::Adaptor::dbi::sqlite 0.01

  Date Added: October 21, 2010  |  Visits: 660

Audio::DB::Adaptor::dbi::sqlite

Report Broken Link
Printer Friendly Version


Product Homepage
Download (72 downloads)



Audio::DB::Adaptor::dbi::sqlite is a database adaptor for a specific mysql schema. This adaptor implements a specific mysql database schema that is compatible with Audio::DB. It inherits from Audio::DB. In addition to implementing the abstract SQL-generating methods of Audio::DB::Adaptor::dbi, this module also implements the data loading functionality of Audio::DB. The schema uses several tables: artists This the artists data table. Its columns are: artist_id artist ID (integer); primary key artist artist name (string); may be null; indexed albums This is the albums table. Its columns are: album_id album ID (integer); primary key album album name (string); may be null; indexed album_type one of compilation or standard; may be null total_tracks total songs on album (integer) year self explanatory, no? (integer) songs This is the primary songs table. Its columns are: song_id song ID (integer); primary key title song title (string) artist_id artist ID (integer); indexed album_id album ID (integer) genre_id genre ID (integer) # may be superceded...see note track track number (integer) duration formatted song length (string) seconds length in seconds (integer) lyrics song lyrics (long text) comment ID3 tag comment (text) bitrate encoded bitrate (integer) samplerate sample rate (real) format format of the file (ie MPEG) (string) channels channels (string) tag_types type of ID3 tags present (ie ID3v2.3.0) (text) filename file name (text) filesize file size in bytes (real) filepath absolute path (text) year the year tag for single tracks (since singles or songs on compilations each may be different) (integer) uber_playcount total times the song has been played uber_rating overall song rating (see "users" below) Currently, ID3 tags support but a single genre. The genre_id is now stored with the song table. Multiple genres may be assigned via the song_genres join table below. The year is a database denormalization that allows the assignment of years to single tracks not belonging to an album..

Requirements: No special requirements
Platforms: Linux
Keyword: Album Artist Audiodbadaptordbisqlite Database Db Id Integer Libraries May Be Programming Song String
Users rating: 0/10

License: Freeware Size: 62.46 KB
USER REVIEWS
More Reviews or Write Review


AUDIO::DB::ADAPTOR::DBI::SQLITE RELATED
Libraries  -  Audio::DB::Adaptor::dbi::mysql 0.01
Audio::DB::Adaptor::dbi::mysql implements a specific mysql database schema that is compatible with Audio::DB. It inherits from Audio::DB. In addition to implementing the abstract SQL-generating methods of Audio::DB::Adaptor::dbi, this module also...
62.46 KB  
Libraries  -  DB2::db 0.20
DB2::db is a framework wrapper around DBD::DB2 for a specific database. SYNOPSIS package myDB; use DB2::db our @ISA = qw( DB2::db ); ... use myDB; my $db = myDB->new; my $tbl = $db->get_table(myTable); my $row = $tbl->find($id);...
20.48 KB  
Libraries  -  CompBio::DB 0.47
CompBio::DB is a Perl module with methods for accessing data stored according to the CompBio base schema. SYNOPSIS use CompBio::DB; my $cbdb = CompBio::DB->new({host => "foo.bar.edu"); my $AR_defs = $cbdb->get_annotation([keys %seqs]);...
63.49 KB  
Database Tools  -  Database Record Selector and Editor (DB-RSE) 1.33
Database Record Selector and Editor (DB-RSE) is a PHP database script, which is intended to be a very simplified MySQL database record selector and editor. Having only two files, it is simple to install and setup. Just put both files in a folder...
10 KB  
Database Tools  -  PHP Database Access Through Arrays 0.7.0
PHP Database Access Through Arrays project can be used to access data stored in MySQL tables like accessing arrays. It uses SPL to implement several classes and iterators interfaces to access MySQL databases. Examples: $DB[test_table][] =...
 
Libraries  -  MP3::Tag::File 0.9708
MP3::Tag::File is a Perl module for reading / writing files. SYNOPSIS my $mp3 = MP3::Tag->new($filename); ($title, $artist, $no, $album, $year) = $mp3->parse_filename(); see MP3::Tag MP3::Tag::File is designed to be called from the...
174.08 KB  
Database Tools  -  Result Class 1.0
Rule based system for taking data associated with a database result id and pushing through specified templates.Result Class allows for significant reuse of code, particularly forms.
10 KB  
Audio Tools  -  SmarTagger 0.1
SmarTagger is a perl script that read a text file with the album info and use it to write the MP3 tags and rename the files according to a format string. The origin of the problem is people that dont save the MP3 tags o choose bad names (like...
3.07 KB  
Database Tools  -  DBConvert for SQLite & MySQL 1.4.3
DBConvert for SQLite & MySQL is a database migration tool which performs two-way conversion from SQLite databases to MySQL server and from MySQL to SQLite. The tool is also applicable for MySQL database migration to another MySQL database or to...
 
Utilities  -  Ordnung 32
Ordnung organizes and renames your music collection based on criteria like album, artist and title.
1.87 MB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by freedesktop.org, it is used to describe information about an application such as the name and...
327.68 KB  
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB  
Libraries  -  App::SimpleScan::Substitution::Line 2.02
App::SimpleScan::Substitution::Line is a line with optional fixed variable values. SYNOPSIS my $line = App::SimpleScan::Substitution::Line->new(" this "); # Use only this value when substituting " ". $line->fix(substituite =>...
54.27 KB