Question

0

Which database to use for quickly and pygtk

rated 0 times [ 0] [ 0] / answers: 1 / hits: 925 / 3 Years ago, sun, august 22, 2021, 12:00:22

I'm writing application using quickly Pygtk and glade.

this application should have database connection (such as MySQL) for reading and writing data from the local or outsourcing machine server.

However, in my machine there is MySQL installed, but when releasing the app it should be installed on another ubuntu machine, which may not have mysql and moreover not the same database with the required database name and structure....

So my questions are:

Is it a good choice using mysql as database

1.2 If not what is?

Is it possible to embed mysql or other database program during the installation from ubuntu software center?

2.2 If it's possible: how (any tutorial?)

Where to store secure data outside the mysql (or whatever) for connecting the database every time a user launch the application

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

tonhorn

Add To Favorites

Follow

Total Points: 196

Total Questions: 118

Total Answers: 95

Location: Vanuatu

Member since Fri, May 13, 2022

2 Years ago

tonhorn questions

1 Cannot install docker-desktop on ubuntu 22.04

Tue, May 10, 22, 12:01, 2 Years ago

1 SGX disabled by BIOS in Ubuntu 22.04

Sat, Dec 18, 21, 06:23, 2 Years ago

1 How to install GEOS on Ubuntu 20.04

Thu, Jun 16, 22, 04:03, 2 Years ago

1 dependency not found

Fri, Apr 1, 22, 05:23, 2 Years ago

1 20.04 with I217-LM driverversion=3.8.7-NAPI won't take address

Tue, Jan 18, 22, 18:56, 2 Years ago

View All

answered 3 Years ago giccolla · Accepted Answer

Consider using an outside MySQL, like xeround

Consider using XML, it can be a poor mans dB.

If you REALLY need mysql. Then you can make mysql-server a dependency for your app. But that's not a good idea... It will require you setting up mysql on install of your app. That can get tricky.

A trick for setting up the database once you install mysql, is to go to phpmyadmin, and "export" your db. Choose sql export. Then open the file it downloads. It will be a massive sql command. Copy-paste than into your program, and once you get the needed info from the user (mysql username/password), you can execute that export, and then their database will look identical to the one you created on your local machine.

Though again, I typically recommend against using mysql-server on local machines unless its REALLY needed.