Creating a database

In this recipe, we will be prompting the user to enter a database name, followed by clicking the push button. Upon clicking the push button, if the specified database does not exist, it is created and, if it already exists, it is connected.

How to do it…

Follow this step-by-step procedure to create a database in SQLite:

1. Let's create an application based on the Dialog without Buttons template.
2. Add two QLabel widgets, one QLineEdit widget, and one QPushButton widget to the form by dragging and dropping two Label widget, one Line Edit widget, and a Push Button widget on the form.
3. Set the text property of the first Label widget to Enter database name.
4. Delete the text property of the second Label widget because this is established.
5. Set the objectName property of the Line Edit widget to lineEditDBName.
6. Set the objectName property of the Push Button widget to pushButtonCreateDB.
7. Set the objectName property of the second Label widget to labelResponse.
8. Save the application by name as demoDatabase...