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: 1615
Joined: Fri Jan 25, 2013 2:54 pm
Location: Perth, Western Australia

Re: Datatables

#11

Post by Graeme H » Fri Jun 28, 2019 4:17 am

... 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: 12134
Joined: Thu Jan 03, 2013 11:20 am
Location: Belum Rainforest
Contact:

Re: Datatables

#12

Post by Paul Arden » Fri Jun 28, 2019 4:50 am

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: 12134
Joined: Thu Jan 03, 2013 11:20 am
Location: Belum Rainforest
Contact:

Re: Datatables

#13

Post by Paul Arden » Fri Jun 28, 2019 4:52 am

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: 386
Joined: Wed Jul 06, 2016 7:30 pm

Re: Datatables

#14

Post by Boisker » Fri Jun 28, 2019 7:21 am

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: 1313
Joined: Wed Jan 09, 2013 8:12 pm
Location: France

Re: Datatables

#15

Post by Merlin » Mon Jul 01, 2019 7:21 am

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: 12134
Joined: Thu Jan 03, 2013 11:20 am
Location: Belum Rainforest
Contact:

Re: Datatables

#16

Post by Paul Arden » Fri Jul 05, 2019 5:17 am

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: 170
Joined: Fri Jun 30, 2017 3:04 pm
Location: Stockholm, Sweden
Contact:

Re: Datatables

#17

Post by piffilus » Fri Jul 05, 2019 6:10 am

They don't seem to be able to spell either...

User avatar
Paul Arden
Site Admin
Posts: 12134
Joined: Thu Jan 03, 2013 11:20 am
Location: Belum Rainforest
Contact:

Re: Datatables

#18

Post by Paul Arden » Fri Jul 05, 2019 6:45 am

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

Flycasting Definitions

Post Reply

Return to “Tackle”