Skip to content
SqLite Database Management Software implemented with Python3.4 and PyQt5.7 for teaching/learning purpuses
Python
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
icons Tue Apr 11 11:59:00 +03 2017 Apr 11, 2017
screenshots First commit Feb 4, 2017
README.md Tue Apr 11 11:59:00 +03 2017 Apr 11, 2017
mainwindow.ui Tue Apr 11 11:59:00 +03 2017 Apr 11, 2017
modify_table_dialog.ui First commit Feb 4, 2017
pyqt-sqlite.py Tue Apr 11 11:59:00 +03 2017 Apr 11, 2017
sample.sqltdb First commit Feb 4, 2017

README.md

PyQt SQLite

This software is written for teaching porposes. It is not a complete software to create/edit/modify SqLite. If you need such a software, there are many that you can find through internet serach. Don't use this package in production.

With this software, I will try to explain how PyQt can be used to develop a running software. After this software has somehow mature, I will write a tutorial.

You can write your suggestion for developing this software.

You need > python 3.4 and > PyQt5.7 to run this software.

Currently pyqt-sqlite can do the foolowings:

Main Screen

Show tables and views and their structure:

Screenshot

Create Table

Tables can be created (but currently you can not modify):

Screenshot

Insert/Remove/Edit Data

You can update, insert and/or remove data:

Screenshot

Execute SQL Query

SQL Queries can be executed, if it selects then the result is shown in the table:

Screenshot

You can save your query as a view by pressing save view icon.

You can’t perform that action at this time.