PyQt and SQLite Login System | compare values

Question

Hello, Im working on a Login system with Python,PyQt and SQLite. My Question is, how do i compare the input values(username and password) with the rows in the Database? And how do i creat a row like that? Its my first time working with SQLite and Databases. Thank you!

Answer 1

first you need to create a table with the correct columns(database schema), then insert rows with values, then run a query to get the password value using the user name as the key. then you compare the value retrived from pyqt ui with what you retrived from database. conplete a sql tutorial in sololearn, then find a sqlite python tutorial
also do not ever store passwords in database, you only want to store salted and hashed passwords using at least sha256