dump1090 - forked repo and added mysql support - some artwork

[Oliver Goldenstein]

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

[Paul Warren]

Post by Oliver Goldenstein
HI All !
Many thanks Salvatore for that very impressive piece of software.
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.
http://dl6kbg.blogspot.de/2013/03/dump1090-with-mysql-support.html
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.

[Peter Stuge]

Good idea!

Post by Oliver Goldenstein
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.

Post by Oliver Goldenstein
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

[Oliver Goldenstein]

Hi Peter !

Many thanks for your helpful suggestions.

Post by Peter Stuge
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

Post by Peter Stuge
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.

Post by Peter Stuge
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

[Peter Stuge]

Post by Oliver Goldenstein

Post by Peter Stuge
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

[Limaunion]