jeudi 28 janvier 2016

Is there a (not ORM but end-user-friendly) UI abstraction layer for SQLite?

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