PERL reading .sql file?
-
Hi, I have a device(mote) that monitor temperature, light and sound. It transmit the data to PC using wireless and store in a database (PostgreSQL). After storing the data, i have it exported out becoming a .sql extenstion file. I will be only able to view the data via a program provided by the device company. The main aim of my project is to make data viewable on html where im able to publish it online. Where i will be using the output data (.sql file) and publish it on html using PERL and CGI. Any helps on how i can make the .sql file readable in PERL or do i need another program to read the database output(.sql file) then making PERL script able to read the filen and then publish it online? The device I'm using which is made by Xbow and im running Win XP. Any help would be greatly appreciated. Regards Joseph
-
Hi, I have a device(mote) that monitor temperature, light and sound. It transmit the data to PC using wireless and store in a database (PostgreSQL). After storing the data, i have it exported out becoming a .sql extenstion file. I will be only able to view the data via a program provided by the device company. The main aim of my project is to make data viewable on html where im able to publish it online. Where i will be using the output data (.sql file) and publish it on html using PERL and CGI. Any helps on how i can make the .sql file readable in PERL or do i need another program to read the database output(.sql file) then making PERL script able to read the filen and then publish it online? The device I'm using which is made by Xbow and im running Win XP. Any help would be greatly appreciated. Regards Joseph