Re: PyQT app accessible over network?

2013-02-25 Thread Chris Angelico
On Tue, Feb 26, 2013 at 10:26 AM, Dennis Lee Bieber wrote: > On Mon, 25 Feb 2013 17:35:44 +1100, Chris Angelico > declaimed the following in gmane.comp.python.general: >> It may take a lot of work to get the permissions down to their >> absolute minimum, but one easy "half-way house" would be to

Re: PyQT app accessible over network?

2013-02-25 Thread Frank Millman
On 25/02/2013 08:35, Chris Angelico wrote: On Mon, Feb 25, 2013 at 5:14 PM, Frank Millman wrote: On 24/02/2013 16:58, Chris Angelico wrote: MySQL has a philosophical structure of "user logs in to app, but app logs in to database as superuser regardless of user login". Out of curiosity, is th

Re: PyQT app accessible over network?

2013-02-24 Thread Chris Angelico
On Mon, Feb 25, 2013 at 5:14 PM, Frank Millman wrote: > On 24/02/2013 16:58, Chris Angelico wrote: >> MySQL has a philosophical structure of "user logs in to app, >> but app logs in to database as superuser regardless of user login". > > Out of curiosity, is there anything wrong with that approach

Re: PyQT app accessible over network?

2013-02-24 Thread Frank Millman
On 24/02/2013 16:58, Chris Angelico wrote: [...] MySQL has a philosophical structure of "user logs in to app, but app logs in to database as superuser regardless of user login". Out of curiosity, is there anything wrong with that approach? The project I am developing is a business/accountin

Re: PyQT app accessible over network?

2013-02-24 Thread Chris Angelico
On Mon, Feb 25, 2013 at 1:31 AM, Wolfgang Keller wrote: >> As far as doing client/server stuff with just a database engine, >> unless you have tight control over the environment end to end, from a >> security pov, it's not a good idea to expose the database engine >> itself to the internet. Bette

Re: PyQT app accessible over network?

2013-02-24 Thread Wolfgang Keller
> As far as doing client/server stuff with just a database engine, > unless you have tight control over the environment end to end, from a > security pov, it's not a good idea to expose the database engine > itself to the internet. Better to put a restricted web services API > in front of it that

Re: PyQT app accessible over network?

2013-02-24 Thread Wolfgang Keller
> My concern is that using postgres or mysql for this would be akin to > using a sledgehammer to swat a fly, I wouldn't use MySQL for anything that requires anything else than "select". And PostgreSQL has extremely spartanic resource requirements in the default configuration. It runs on Linux on

Re: PyQT app accessible over network?

2013-02-24 Thread Alec Taylor
On Sat, Feb 23, 2013 at 10:37 AM, Michael Torrie wrote: > On 02/22/2013 02:49 PM, Monte Milanuk wrote: >> Web2py does seem pretty attractive in that it seems to come with a lot >> of functionality rolled in already. It seems to be pretty easy to >> deploy... since this would be more of a case whe

Re: PyQT app accessible over network?

2013-02-22 Thread Chris Angelico
On Sat, Feb 23, 2013 at 11:20 AM, Dennis Lee Bieber wrote: > Problem: SQLite3 (and M$ JET/Access) are considered "file server" > databases. Each instance of the program accessing the database is > directly opening the database file(s). While SQLite3 has a fairly > complex locking system, t

Re: PyQT app accessible over network?

2013-02-22 Thread Michael Torrie
On 02/22/2013 02:49 PM, Monte Milanuk wrote: > Web2py does seem pretty attractive in that it seems to come with a lot > of functionality rolled in already. It seems to be pretty easy to > deploy... since this would be more of a case where the volunteer match > directors are not necessarily comp

Re: PyQT app accessible over network?

2013-02-22 Thread Monte Milanuk
On 02/22/2013 08:57 AM, Alec Taylor wrote: Monte: I noticed you mentioned web2py; that would be my recommendation. You also mention different features being available to different users; perfect use-case for web2py's built-in RBAC. Scalability: Go with Postgres, MySQL; or considering how much d

Re: PyQT app accessible over network?

2013-02-22 Thread Alec Taylor
Monte: I noticed you mentioned web2py; that would be my recommendation. You also mention different features being available to different users; perfect use-case for web2py's built-in RBAC. Scalability: Go with Postgres, MySQL; or considering how much data you're talking about, even SQLite would b

Re: PyQT app accessible over network?

2013-02-22 Thread Monte Milanuk
Yes, I am looking at a database-centric application. I know that the 'larger' databases such as PostgreSQL, MySQL, etc. would not have any problem handling that small amount of traffic. My concern is that using postgres or mysql for this would be akin to using a sledgehammer to swat a fly, wh

Re: PyQT app accessible over network?

2013-02-22 Thread Wolfgang Keller
> I've been working at learning python off and on now for a while, with > a couple programs in mind as a goal - kind of specialized stuff that > I can't seem to find a good match for already available, competitor > records, score-keeping & results for an amateur sports tournament. So you want to

Re: PyQT app accessible over network?

2013-02-21 Thread Michael Torrie
On 02/21/2013 09:22 AM, Monte Milanuk wrote: > What I was wondering is what would be a good way of handling this with a > PyQt app? Build the desktop app first, and add some sort of > functionality to enable a lightweight web server and framework for the > additional data entry 'clients'? Or

PyQT app accessible over network?

2013-02-21 Thread Monte Milanuk
Hello all, New guy here, with a kind of general question. Hopefully its not too silly... I've been working at learning python off and on now for a while, with a couple programs in mind as a goal - kind of specialized stuff that I can't seem to find a good match for already available, compet