HI All !
Many thanks Salvatore for that very impressive piece of software.
I extended dump1090 to make use of a mysql database:
http://dl6kbg.blogspot.de/2013/03/dump1090-with-mysql-support.html
I will work on the code the next days to improve it for a more easy db setup.
Some results and a description you may see here:
http://dl6kbg.blogspot.de/2013/03/dump1090-with-mysql-support.html
the forked repo is here:
https://github.com/dl6kbg/dump1090
You need a mysql database called "dump1090" with a table "tracks". You may easily setup the db using the supplied script "tracks.sql"
Username and password ist coded for now as mysql user: root mysql password: root.
Run: ./dump1090 --mysql
Have fun !
73 Oliver DL6KBG
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 08/03/13 07:12, Oliver Goldenstein wrote:
HI All !
Many thanks Salvatore for that very impressive piece of software.
I extended dump1090 to make use of a mysql database:
http://dl6kbg.blogspot.de/2013/03/dump1090-with-mysql-support.html
I will work on the code the next days to improve it for a more easy db setup.
Some results and a description you may see here:
http://dl6kbg.blogspot.de/2013/03/dump1090-with-mysql-support.html
the forked repo is here:
https://github.com/dl6kbg/dump1090
You need a mysql database called "dump1090" with a table "tracks". You may easily setup the db using the supplied script "tracks.sql"
Username and password ist coded for now as mysql user: root mysql password: root.
Run: ./dump1090 --mysql
Have fun !
73 Oliver DL6KBG
Very nice Oliver!
Something like this was on my todo list, so thanks for saving me the effort!
Paul.
Good idea!
Oliver Goldenstein wrote:
You may easily setup the db using the supplied script "tracks.sql"
Please treat DDL like all the other source code.
In particular, avoid storing DDL generated by a tool (maybe in particular by phpMyAdmin) under version control.
Write DDL by hand, like the other source code, and store that under version control. Otherwise you will inevitably get lots of noise in the repository. For example because your web server PHP version changes. And of course the Erstellungszeit timestamp will be different whenever you ask phpMyAdmin to generate a new file the next time. That makes no sense.
Username and password ist coded for now as mysql user: root mysql password: root.
I suggest using the configuration files read by the client library to set a password, if any. I would suggest $USER as default username, and connecting without a password by default. If a password is needed, set it in one of the config files read by libmysqlclient.
Oh, and I recommend everyone to use MariaDB instead of MySQL - the most competent MySQL developers left Oracle several years ago and work on MariaDB now. Drop-in replacement. https://mariadb.org/
//Peter
Hi Peter !
Many thanks for your helpful suggestions.
Write DDL by hand, like the other source code, and store that under version control. Otherwise you will inevitably get lots of noise in the repository.
fixed that.
I suggest using the configuration files read by the client library to
set a password, if any. I would suggest $USER as default username, and connecting without a password by default. If a password is needed, set it in one of the config files read by libmysqlclient.
will fix at over the weekend.
Oh, and I recommend everyone to use MariaDB instead of MySQL - the most competent MySQL developers left Oracle several years ago and work on MariaDB now. Drop-in replacement. https://mariadb.org/
to be honest i heard the first time of it.
73 Oliver DL6KBG
Oliver Goldenstein wrote:
Oh, and I recommend everyone to use MariaDB instead of MySQL - the most competent MySQL developers left Oracle several years ago and work on MariaDB now. Drop-in replacement. https://mariadb.org/
to be honest i heard the first time of it.
That's what Monty (whose daughter is My, in MySQL) is doing these days. They're a really great team doing awesome work.
//Peter
On 03/08/2013 09:40 AM, Peter Stuge wrote:
Oliver Goldenstein wrote:
Oh, and I recommend everyone to use MariaDB instead of MySQL - the most competent MySQL developers left Oracle several years ago and work on MariaDB now. Drop-in replacement. https://mariadb.org/
to be honest i heard the first time of it.
That's what Monty (whose daughter is My, in MySQL) is doing these days. They're a really great team doing awesome work.
//Peter
yes, and some distros have already started to switch from mysql to mariadb, like Fedora 19: http://fedoraproject.org/wiki/Features/ReplaceMySQLwithMariaDB#Summary