Hi,
To start with it will only be one message every 5 seconds or so but later may end up with 15 so still only 3 / sec average.
Bob
Populating MySQL database function.
-
- Posts: 279
- http://meble-kuchenne.info.pl
- Joined: Sat Mar 19, 2022 4:53 pm
- Has thanked: 25 times
- Been thanked: 30 times
-
- Valued Contributor
- Posts: 401
- Joined: Mon Dec 07, 2020 1:00 pm
- Has thanked: 73 times
- Been thanked: 218 times
Re: Populating MySQL database function.
Just to add another piece to the jigsaw puzzle and good work from chipfryer27
Here's a demo of the capabilities of GNU/Linux and Flowcode.
This script will install mysql and create a demo database and table.
Edit the user 'leigh' to your login account and download it to your Raspberry Pi.
In the terminal (or putty, ssh), make the file executable (chmod 777 setup_db.txt) and run it (./setup_db.txt)
Similarly, this script can be used to test the DB and data insert.
And here is a demo Flowcode project that records temperature measurements to the test DB.
Hope it helps, at least it will get you started with SQL statements.
Here's a demo of the capabilities of GNU/Linux and Flowcode.
This script will install mysql and create a demo database and table.
Edit the user 'leigh' to your login account and download it to your Raspberry Pi.
In the terminal (or putty, ssh), make the file executable (chmod 777 setup_db.txt) and run it (./setup_db.txt)
Similarly, this script can be used to test the DB and data insert.
And here is a demo Flowcode project that records temperature measurements to the test DB.
Hope it helps, at least it will get you started with SQL statements.
-
- Valued Contributor
- Posts: 1188
- Joined: Thu Dec 03, 2020 10:57 am
- Has thanked: 289 times
- Been thanked: 418 times
Re: Populating MySQL database function.
Hi Leigh
Thanks for the above.
I'm creating a little guide regarding this and Bob is helping proof read. It will show how to create a DB and tables, then the steps to create a script that will update tables etc. Then a Flowcode example that updates.
Interesting to see your use of script, different to mine but then you are after all a Guru
Regards
Thanks for the above.
I'm creating a little guide regarding this and Bob is helping proof read. It will show how to create a DB and tables, then the steps to create a script that will update tables etc. Then a Flowcode example that updates.
Interesting to see your use of script, different to mine but then you are after all a Guru
Regards
Re: Populating MySQL database function.
Hi Martin,
Apologies for not replying earlier, I will have a play with your example later, I have been spending a lot of time with the example from Chipfryer and the brain cell cannot handle more than one thing at a time.
Bob
Apologies for not replying earlier, I will have a play with your example later, I have been spending a lot of time with the example from Chipfryer and the brain cell cannot handle more than one thing at a time.
Bob
Re: Populating MySQL database function.
I should have mentioned Leigh in the post above, I was thinking of Martin in a different post
I have just managed to modify chipfryers example to run on a Raspberry Pi from the other post and simulate it with everything on the same PC so this will come in very handy when I test it out on the actual Raspberry Pi hardware.
Regards,
Bob
I have just managed to modify chipfryers example to run on a Raspberry Pi from the other post and simulate it with everything on the same PC so this will come in very handy when I test it out on the actual Raspberry Pi hardware.
Regards,
Bob
-
- Valued Contributor
- Posts: 1188
- Joined: Thu Dec 03, 2020 10:57 am
- Has thanked: 289 times
- Been thanked: 418 times