Add capability to find what's the maximum or minimum frequency that a string can produce for differing scale lengths

[haisamido]

Add capability to find what's the maximum or minimum frequency that a string can produce for differing scale lengths

select 
	part_id,
	string_note,
	scale_length,
	tension_maximum,
	frequency_minimum,
	frequency_at_note,
	frequency_maximum
from public.view_strings 
where
	(frequency_maximum > 110 and frequency_minimum < 110) and
	tension_minimum*(650/647.7)^2 < tension_maximum
order by frequency_maximum desc;

[haisamido]

-- SELECT 
-- 	string_note, 
-- 	mass_per_length, 
-- 	scale_length, 
-- 	tension_minimum, 
-- 	tension_at_note, 
-- 	tension_maximum,
-- 	(1/(2*6.477))*sqrt(tension_maximum/mass_per_length)
-- FROM 
-- 	public.strings
-- ORDER BY tension_maximum asc;

SELECT 13.1*453.592292*980.665,0.00001794*178.579673,25.5*25.4,music.frequency_from_mass_per_length(
	tension         => 13.1*453.592292*980.665,
	mass_per_length => 0.00001794*178.579673,
	scale_length    => 80.0
);

SELECT 
	part_id,
	string_note,
	tension_maximum,
	mass_per_length AS "mass_per_length (g/m)",
	mass_per_length/178.579673 AS "mass_per_length (lb/inch)",
	frequency_maximum 
FROM public.view_strings where 
	(SELECT frequency_a4_440 FROM music.view_frequency_by_notation where notation='G2') < frequency_maximum and
	(SELECT frequency_a4_440 FROM music.view_frequency_by_notation where notation='G2') >= frequency_minimum order by
	frequency_maximum desc;

select 
	part_id,
	string_note,
	scale_length,
	tension_maximum,
	frequency_minimum,
	frequency_at_note,
	frequency_maximum
from public.view_strings 
where
	(frequency_maximum > 98 and frequency_minimum < 98) and
	tension_minimum*(800/647.7)^2 < tension_maximum
order by frequency_maximum desc;