The Reload Bulletin Board
  Bulletin Board Feedback
  New database: Load Data?

Post New Topic  Post A Reply
profile | register | preferences | abuse | faq | search

UBBFriend: Email this page to someone!  Convert to a Printer Friendly format.    Go to the previous topic in this forum.   Go to the next topic in this forum.
Author Topic:   New database: Load Data?
Greg
Administrator
Administrator & 264 RLB #1
264 RLB #1

Posts: 7868
From: Orange County, New York
Registered: Jan 2000

posted 01-04-2005 02:16 PM    Click Here to See the Profile for GregClick here to email GregEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedVisit Greg's Homepage!Reply w/Quote
Since the the Shooting Range database is now complete (although I already have a growing list of new ranges to add) I've started another database. This new database will be for load data. Over the last two years I've talked about this several times and this would be by far the biggest SQL database on the site yet, not to mention the most work. So, before I get too involved in it I wanted to get some feedback.

This demo version has 32 entries which are from the VihtaVuori 2/2002 PDF manual. They include 17 Remington, 22 Hornet and 222 Remington. The information for each individual load is as follows:

  • Cartridge The name of the cartridge.
  • Cartridge Drawing If a drawing is available, either the image or a link to that image will be displayed.
  • Case Length Listed in inches.
  • Case Manufacturer R-P, Federal, Lapua, etc.
  • Bullet Manufacturer Hornady, Sierra, Barnes, etc.
  • Bullet Weight Listed in grains.
  • Bullet Description SP, HP, FMJ, etc.
  • Bullet Part # Bullet manufacturer part number, if available.
  • Bullet BC Ballistic Coefficient, if available.
  • Bullet Image Image of the particular bullet, if available.
  • Powder Manufacturer Hodgdon, IMR, etc.
  • Powder Type Varget, 30-31, etc.
  • Starting Load (grains) Suggested starting load from the specific manual listed below.
  • Starting Velocity (fps) Velocity of suggested starting load.
  • Starting Pressure Pressure of suggested starting load, if available. Listed in either CUP or PSI.
  • Maximum Load (grains) Maximum load listed from the specific manual listed below.
  • Max. Load Velocity (fps) Velocity of maximum load.
  • Max. Load Pressure Pressure of maximum load, if available. Listed in either CUP or PSI.
  • Primer Primer used during testing.
  • COL Loaded cartridge overall length, in inches.
  • Test Firearm Test firearm used to determine data.
  • Test Barrel Length Length of test barrel used, in inches.
  • Test Barrel Twist Twist rate of test barrel used.
  • Notes (1) Specific notes from the manual for a specific load.
  • Notes (2) Additional space for notes.
  • Notes (3) Additional space for notes.
  • Notes (4) General notes from the manual regarding load, test equipment, or cartridge.
  • Data Source Where the data came from. (VihtaVuori, Hodgdon, Alliant, etc.)
  • TRB (data) ID # The ID number for all the information regarding one particular load.


You can also search for a particular load by Cartridge Name, Bullet Manufacturer, Bullet Weight, or Powder. For example, to search for a 222 Remington load using Hornady bullets enter 222 Remington in the Cartridge field and Hornady in the Bullet Manufacturer field. Out of the 32 demo listings your search will yield 10 results. With a full working database, you could narrow the results by also using the Bullet Weight and Powder fields.

So what do you think? Would this be worth having on the site? Yes? No? Maybe? What if's?

You can click on the Load Data Demo link in the upper left hand corner of the current database page or use this link:
http://www.reloadbench.com/specs/index.php?table_name=data

------------------

grandpao
Older Than Dirt
Member
Older Than Dirt Member: 301 to 500 Posts

Posts: 358
From: wis.
Registered: Nov 2001

posted 01-05-2005 06:01 AM    Click Here to See the Profile for grandpaoClick here to email grandpaoEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedReply w/Quote
quote:
Originally posted by Greg:
[

[/B]


first i think you better check with the wife ha ha
i think it is a good idea. just my 2 cents

4thebrdz
Recurring Magnum Member and Sponsor (11/25/07)Recurring
Magnum
Member

Posts: 4211
From: Albany, NH "LIVE FRE OR DIE"
Registered: Dec 2003

posted 01-05-2005 09:09 AM    Click Here to See the Profile for 4thebrdzClick here to email 4thebrdzEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedReply w/Quote
I think it's a great IDEA! But like you said you would have a lot of work, but the benifits! ahhh
I wonder if the powder burn rate % could be listed also?
Thanks Greg for all you do for us.

------------------
PAUL
-------------------------"THE UNSATISFIED LED BY THE UNQUALIFIED TO DO THE UNNESSARY FOR THE UNGRATEFUL"

whelenfan
Older Than Dirt
Member
Older Than Dirt Member: 301 to 500 Posts

Posts: 398
From: Hamilton, NJ USA
Registered: Nov 2003

posted 01-05-2005 04:58 PM    Click Here to See the Profile for whelenfanClick here to email whelenfanEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedVisit whelenfan's Homepage!Reply w/Quote
I would agree that the load data base would be extememly beneficial to everyone.
Capt B
New Member
New Member: Under 5 Posts

Posts:
From:
Registered:

posted 01-06-2005 08:58 PM    Click Here to See the Profile for Capt BClick here to email Capt BEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedReply w/Quote
Looks like a lot of entry and a lot of late nights. Geez almighty. Demo looks good. Would be really nice to have access to all that in 1 database. What if any legalities would come into play by reproducing the manufacturers load data from their manuals? Would you have to seek their permission to reproduce the data?
Greg
Administrator
Administrator & 264 RLB #1
264 RLB #1

Posts: 7868
From: Orange County, New York
Registered: Jan 2000

posted 01-06-2005 10:06 PM    Click Here to See the Profile for GregClick here to email GregEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedVisit Greg's Homepage!Reply w/Quote
CaptB,

It's been a couple of late nights already but I've been adding the data a little at a time, here and there. I've been doing all the adding, editing, and checking on the reloadbench.org server and then uploading the SQL database to this server. I have an HTML interface to add the data and have it setup and working pretty good now.

As far as the actual data, it is all from the free manuals, either online (HTML or PDF format) or in several of the free published data manuals. I've also included the source of the data on every load listed.

Regarding data from published manuals (that are normally purchased), I won't be listing that. At least not before contacting each of the respective publishers and getting permission first.

------------------

critter-ridder
New Member
New Member: Under 5 Posts

Posts:
From:
Registered:

posted 01-07-2005 07:55 PM    Click Here to See the Profile for critter-ridderClick here to email critter-ridderEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedReply w/Quote
Greg, the load data really looks good, my hat is off to you for even wanting to undertake this project. It looks like a lot of long nights, make sure to spend time with the family as well. I guess this is just one more reason to like this site.
Greg
Administrator
Administrator & 264 RLB #1
264 RLB #1

Posts: 7868
From: Orange County, New York
Registered: Jan 2000

posted 01-09-2005 02:30 PM    Click Here to See the Profile for GregClick here to email GregEdit/Delete MessageSearch the Bulletin Board Feedback forumIP LoggedVisit Greg's Homepage!Reply w/Quote
There is a lot of work involved in adding all the data. That is one of the reasons why I haven't done this before. Originally, just after I started the bulletin board four years ago, I wanted to compile all this info. It was going to be basic static HTML pages, which would have involved a lot of clicking around to navigate the data.

While I'm still not a code writer or programer, over the last few years I've picked up enough info on PHP and MySQL to get them to work together. I think having the load data, or any information for that matter, in a database is a lot more interactive than the basic HTML web pages.

The hardest part will be sorting the information once I compile load data from various sources. Each entry has a unique ID number and when you look at the flat SQL file (which holds all the data and formatting) each line of text is a separate entry. Once all the information/entries have been made, I'll have to move the lines around and group the cartridge together by name, then re-assign new ID numbers to each entry so they are consecutively labeled. By doing this, all the same cartridge names will show up together on the database instead of in the order they were entered.

The good thing is that this project isn't under any time frame restrictions. When time permits, I'll add a little more to the database. If this takes several months or even a year, then so be it. By having both reloadbench.com and reloadbench.org domains and servers, I can add, edit, and test the database on the .org site. Once each step is complete, I can transfer the entire database from the .org site to the .com site.

------------------

All times are ET (US)

Go to the previous topic in this forum.   Go to the next topic in this forum.

Administrative Options:
Back to Forums Main Page  Post New Topic  Post A Reply
Hop to:

Contact Us | TOS | The Reload Bench | Privacy Statement

© www.reloadbench.com 1999-2009 All Rights Reserved

Powered by Infopop www.infopop.com © 2000
Ultimate Bulletin Board 5.47e


Use these links to return to The Reload Bench main site...
Home | What's New | Search | Site Map | Guest Book | Links | Reload Components | Privacy Policy
Cartridges & Reload Data | Reload Info & Articles | Specifications | Survey | Contact | Link to Us | Sponsors