Hello.
Should i use connection to sql database in client side (client application)? Isn't it unsafe (sniffing / disassembling application to get password to database) ? And how can I use wxWidgets to connect to internal database (for example mysql / sqlite)?
SQL Database
Re: SQL Database
When you use a server-based database managment system you usually don't have a choice: you have to rely on the connection methods offered by the DBMS. In a company intranet securing the connection might not be an issue; in public networks it would be a good idea to use SSL protected connections.fex wrote:Should i use connection to sql database in client side (client application)? Isn't it unsafe (sniffing / disassembling application to get password to database) ?
Regarding password sniffing or disassembling an application as a developer you should be aware that storing a password within the application is usually not a good idea under security aspects. Your application should usually ask the user to enter his password and after establishing the connection the password string should be removed from memory ASAP.
How much effort you spend on securing your application depends on how high the requirements are. However keep in mind there is no protection scheme guaranteeing 100% security.
MySQL is mostly used as a client/server DBMS. If you want a compact SQL aware database for locally storing data of your application SQLite is certainly a good alternative. For accessing an SQLite database from a wxWidgets-based application you might consider to use wxSQLite3, a SQLite wrapper for wxWidgets. If you want to be able to easily exchange the underlying database system you might consider DatabaseLayer as it abstracts several different DBMSs for wxWidgets-based applications.fex wrote:And how can I use wxWidgets to connect to internal database (for example mysql / sqlite)?
Regards,
Ulrich