MySQL is an open-source database system. See below for further details.
"MySQL is the world's most popular Open Source Database, designed for speed, power and precision in mission critical, heavy load use." In Sep 2002, they won the Linux Journal's Editors' Choice Award. From the article:
Silas 2005-10-05: I've used the following code to test the MySQL remote server each one second with a recursive proc and connect if the internet is on (I'm using FBSQL here):
#make the connection
proc mysqlConnect {} {
set error [catch {
set result [exec ping -c 1 $glo::db(host) | grep received]
} error_message]
if {$error} {
if {$glo::db(connected)} {
tk_messageBox -message "The connection has been lost. It will be connected in $glo::db(time) seconds."
set glo::db(connected) 0
}
puts $error_message
after [expr $glo::db(time) * 1000] {mysqlConnect}
return
}
set index [string first {1 received} $result]
puts "($index) $result"
if {$index && $glo::db(connected) == 0} {
if {[tk_messageBox -message "The net is OK. Do you want to connect?" -type yesno] == yes} {
set error [catch {sql connect $glo::db(host) $glo::db(user) $glo::db(pass)} error_message]
sql selectdb $glo::db(db)
set glo::db(connected) 1
}
}
after [expr $glo::db(tempo) * 1000] {mysqlConnect}
}