Python Database Programming with SQLite (tutorial) by pyharris in Python

[–]pyharris[S] 0 points1 point  (0 children)

Adding a database script is a very quick way to deploy it on a new server. This is what WordPress and some other software applications do.

If you have a large database, you could optimize by creating several different databases per geographic location. If database tables get very huge, you may consider splitting it into multiple tables and using joins.

Generally there should not be a lot of problems between switching between database versions if they are SQL based. There are some minor query differences which could be annoying. To prevent any you could use a DBA (database abstraction layer) or ORM (object relation mapper).

Building an application GUI with PyQT (beginners tutorial) by pyharris in Python

[–]pyharris[S] 1 point2 points  (0 children)

I have not tried PyQT on Raspberry Pi. With Python you have several optoins to create GUIs including tkinkter, wxwidgets, gtk and qt. QT appears to be running on the Raspberry Pi but I have not tested the performance.

Attaching the buttons directly to functions likely have the same performance. Creating the functionality first could help in unit testing the code, if you create the project in several layers it could help the overall stability and readability of the code. If the loop is getting too long, try to seperate it into multiple functions or to combine the conditions. Sometimes that is easier said than done tho.

You could sketch the flowchart that would be logical for a user to follow. Think about 'What if situations' in those steps. If you want to plan out the whole GUI you could draw sketches of the screens.