Shifting to SQlite

So today I have worked on the database creation for the 'Admin' and 'Users' tables - both within the database. It is a simple program only designed for creating the database in the first place, later-on I will be working on the adding and removal of users.

This first image shows the program accessing the database and creating the new table within the database as the program calls it. (shown below)

The second image calls the create_table function , adding a new table to the database and then proceeding to add all the relevant data columns, such as email address, username and user ID.

The user ID is a new addition from the previous excel method - which may be useful in streamlining search methods for calling data from the db later in the program.

*Edit*

This is what the table structure looks like in the database itself. (viewed using the SQlite Inspector program, as recommended by Python Schools)

Another Update

I forgot to mention this in the last post, but I've decided to make a change to my "database" system. It has up to been now done in MS Excel, which is a spreadsheet. While it is allowed within the marking bounds of my project, I have been advised to change it in for a proper database software/ system such as SQL or Access.

Once I have a SQL viewer/ reader installed I will be re-working parts of my program to use a SQlite database rather than a spreadsheet.