PLEASE NOTE: In order to post on the Board you need to have registered. To register please email paul@sexyloops.com including your real name and username. Registration takes less than 24hrs, unless Paul is fishing deep in the jungle!

Datatables

Moderators: Viking Lars, Magnus

User avatar
Graeme H
Posts: 2898
Joined: Fri Jan 25, 2013 2:54 pm
Answers: 0
Location: Perth, Western Australia

Re: Datatables

#11

Post by Graeme H »

... and then they go "pseudo-metric" with thousandths of an inch! :)

Whatever works. As long as the data is recorded consistently, we can deal with it. Once it's in a database, calculations on fields are easy.
FFi CCI
User avatar
Paul Arden
Site Admin
Posts: 19644
Joined: Thu Jan 03, 2013 11:20 am
Answers: 2
Location: Belum Rainforest
Contact:

Re: Datatables

#12

Post by Paul Arden »

Sounds good. I’m just in the middle of a very long server upgrade from MySQL to MariaDB. Once this is complete I can tidy up these database tables.

I shall be keying in the information. It’s simpler!

I am wondering about how many entries we are going to get. It would be an option to have a database for each line class. The problem with that is if you want to search by true AFFTA weight (which is very handy) then you lose the ability to quickly compare lines of different line classes. So I’m of the opinion that we just stick everything in one table. We will undoubtedly end up with 100s of entries over time. I’ll probably put 30 in there alone.

Cheers, Paul
It's an exploration; bring a flyrod.

Flycasting Definitions
User avatar
Paul Arden
Site Admin
Posts: 19644
Joined: Thu Jan 03, 2013 11:20 am
Answers: 2
Location: Belum Rainforest
Contact:

Re: Datatables

#13

Post by Paul Arden »

How to deal with old lines? Have two dates - submission date and in notes say that the line is from year X?
It's an exploration; bring a flyrod.

Flycasting Definitions
Boisker
Posts: 635
Joined: Wed Jul 06, 2016 7:30 pm
Answers: 0

Re: Datatables

#14

Post by Boisker »

That’s funny Paul... perhaps it’s a U.K. thing, I do the same and mix and match all the time....
ordering timber at the sawmill-.... “I need 60 rails, 4.2m long in 4” by 2”...”
But you definitely need to stick to one... metric or imperial, but using both is a bit nuts for the rest of the world....
User avatar
Merlin
Posts: 2113
Joined: Wed Jan 09, 2013 8:12 pm
Answers: 0
Location: France

Re: Datatables

#15

Post by Merlin »

Remember that ERN is not the line number, there is a half point difference. An ERN 5.5 means a #5 line.

And ERN does not measure rod stiffness in fact, mechanically speaking, it is a mass scale.

Merlin
Fly rods are like women, they won't play if they're maltreated
Charles Ritz, A Flyfisher's Life
User avatar
Paul Arden
Site Admin
Posts: 19644
Joined: Thu Jan 03, 2013 11:20 am
Answers: 2
Location: Belum Rainforest
Contact:

Re: Datatables

#16

Post by Paul Arden »

Balances have arrived. Testing them on coins they appear to be 0.01g out. The instructions say they should be calibrated with a 500g mass which is interesting because the balances only go up to 200g :D

I have some new lines from SA that I can measure when I’ve sharpened up the datatable.

Cheers, Paul
Attachments
10BA8AC7-56E8-4548-9938-9A120D36D1E1.jpeg
It's an exploration; bring a flyrod.

Flycasting Definitions
User avatar
piffilus
Posts: 213
Joined: Fri Jun 30, 2017 3:04 pm
Answers: 0
Location: Stockholm, Sweden
Contact:

Re: Datatables

#17

Post by piffilus »

They don't seem to be able to spell either...
User avatar
Paul Arden
Site Admin
Posts: 19644
Joined: Thu Jan 03, 2013 11:20 am
Answers: 2
Location: Belum Rainforest
Contact:

Re: Datatables

#18

Post by Paul Arden »

:D
It's an exploration; bring a flyrod.

Flycasting Definitions
Post Reply

Return to “Tackle”