The Banner
 
Welcome Guest Search | Active Topics | Members | Log In

Public (read-only) access to the database? Options · View
orangeboy
Posted: Thursday, March 15, 2012 5:08:08 AM
Rank: Newbie

Joined: 3/25/2009
Posts: 4
Points: 12
Location: Columbia, MO
First, just have to say what a great site. Your effort is appreciated!

As the topic subject indicates, I'm curious if there is a way to directly access the database? I am in the process of working with the files in my collection, and having the ability to create and use my own queries against the database would greatly ease the gathering of what I consider accurate information!

Specifically, I'd like to gather certain field's values relating to a source, and the setpage for that source.


An example:
Code:

Dec 30, 1968
Venue: John F. Kennedy Pavilion - Gonzaga University
City: Spokane, WA
Country: United States
Source Name: First Audience
Type: Live Audience Recording
Master Media Type: Unknown
Length: 58 Minutes
Taper: Unknown

01)Train Kept a Rollin'              02:23 cut
02)I Can't Quit You Baby    05:36
includes 01)Unknown    00:50
03)As Long as I Have You    08:10
includes 01)Fresh Garbage    01:40
includes 01)Unknown    00:50
02)Bags' Groove    01:55
03)Mockingbird    00:34
04)Dazed and Confused    09:29
includes 01)Early Shuffle    00:22
02)Bow Solo    02:38
includes 01)Vocal Accompanied Section    00:40
02)Crescendo Section    00:08
03)Moaning Section    00:06
04)Outro Shuffle    00:21
05)White Summer-Black Mountain Side    06:41
includes 01)Casbah    00:20
06)How Many More Times    14:40
includes 01)Beck's Bolero    00:32
02)Bow Solo    03:15
03)The Hunter    02:24
04)Musical Copulation    00:12
07)Pat's Delight    06:47 cut
includes 01)No-Sticks Section    01:05


I've written a program to name/rename my files in a very consistent manner using a dictionary of known song titles and whatever original information was provided by the bootleg label (sketchy at times), or provided by the generous posters on various torrenting sites or usenet (also sketchy at times). Unfortunately, the results are "fuzzy" at best due to misspelled titles, or missing information altogether. Getting accurate information from the DB would/should eliminate any "fuzzy" results!

Your Overlord
Posted: Friday, March 16, 2012 6:53:24 PM

Rank: Administration

Joined: 2/10/2008
Posts: 336
Points: 1,027
I can't say that I understand what you are trying to do, but email me at ebown5@gmail.com and explain it further please.

The database is the central asset of this site and I am not inclined to give direct access to it, but I may be willing to explain it to you better and produce reports from it.

email me...
orangeboy
Posted: Sunday, March 18, 2012 5:38:32 AM
Rank: Newbie

Joined: 3/25/2009
Posts: 4
Points: 12
Location: Columbia, MO
Thanks YO -

I believe I've come up with an alternative solution. There is a little utility called cURL that can programmatically "read" html pages. I should be able to get the information I'm looking for using that method, and eliminate the need of accessing the underlying database and tables directly.
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

SoClean Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.6 (NET v2.0) - 11/14/2007
Copyright © 2003-2006 Yet Another Forum.net. All rights reserved.
This page was generated in 0.021 seconds.