Try the Julia demo program to automatically insert a FITS table HDU into a DB table.
Follow the instructions on the reference page.
Please report any problem.
p.s. note the link to Giorgio’s presentation Julia for Astronomers and pass it to any potentially interested person you know. Thanks.
2 thoughts on “Julia demo program”
For Mac users:
to be able to run “julia” from the command line, create this (or a similar) logical link:
sudo ln -s /Applications/Julia-0.6.app/Contents/Resources/julia/bin/julia /usr/local/bin/julia
This assumes you have downloaded “Julia-0.6” and copied in your Application folder.
Remember to check you version with the command “ls -d /Applications/Julia*”.
L.
As someone noticed, if a column in a FITS file is named “DEC” (no matter if lower case or upper case) the program would not work. It is because “DEC” in MySQL is the name of the function DECIMAL (DEC is a synonym) so it has to be used like this `DEC`. I fixed the program to quote all the column names so that it does not complain. However remember that you also need to quote it when performing queries. For example:
SELECT ra, `dec` FROM mytable WHERE `dec` > 80.5;
L.