PyQt database (SQLite) basic use example

I've stopped updating this, see "See Also" below and check the pyside-database-chart-example. I'm currently working on that one instead of this.

But you can still look through this and help yourself as well. This works like a charm.

• PyQt5 >= 5.12

Because one of QSortFilterProxyModel's function(setFilterRegularExpression) requires at least 5.12. This is indeed very convinient function so you don't have to worry.

Also you can use this in PyQt6 or PySide6, if you change all of "import PyQt5" in whole repo.

python -m pip install git+https://github.com/yjg30737/pyqt-database-example.git --upgrade

• Add/delete record (one record at a time)
• Search the text by each column
• Set by ascending/descending order (ascending order by default)

Code Sample

from PyQt5.QtWidgets import QApplication
from pyqt_database_example import createConnection, initTable, addSample, QtDatabaseExample

if __name__ == "__main__":
    import sys

    app = QApplication(sys.argv)
    if not createConnection():
        sys.exit(1)
    initTable() # Create table. After create table, you don't need to do it unless you want to make the table to empty.
    # addSample() Add sample records (Joe, Lara, David, Jane. See result image below.)
    ex = QtDatabaseExample()
    ex.show()
    sys.exit(app.exec_())

If you execute the script, "contacts.sqlite" SQLite database file will be made.

Result

'contacts' is table's name.

You can search the text with search bar. (instant search)

You can also set the column to search with combobox which is placed right next to search bar.

Add button literally adds new empty record.

Delete button deletes selected row. (Only one row can be selected currently)

Let's set the column to search as "Name" and search the text "Dav".

• pyside-database-chart-example - PySide6 version of this (+chart)
• Handling SQL Databases With PyQt: The Basics - I made this thanks to this article.