I will scrape with Python some jobs-related data into a SQLite (sqlite3) database, to be queried by a non-technical end-user with no SQL knowledge.
Were I to be querying the data myself, I would do so on the command line or by using something like SQLiteStudio. This would save me having to create a UI component in Python.
The end-user is non technical, however, and would prefer to see drop-downs containing column names, boolean operators etc, that the UI would translate into the appropriate SQL, similar to what one can avail of in Toad and PL/SQL Developer. Does such a component/functionality exist for SQLite?
Aucun commentaire:
Enregistrer un commentaire