Re: [web2py] Database table prefix

2012-11-27 Thread Andrew W
What about a "prefix" column, and filter all selects on the prefix. A single database ctructure sounds more scalable and logically you're partitioning the data based on login or context. Prefixing table names doesn't sound like a good idea. --

Re: [web2py] Database table prefix

2012-11-27 Thread Chr_M
No, in some specific cases I can not create another db, because of restrictive permissions of client systems. In worst case I will have to search and replace prefixes in the files. I thought that maybe there is an easier solution that I did not know of. Thanks for all the suggestions! Regards,

Re: [web2py] Database table prefix

2012-11-26 Thread Niphlod
On Monday, November 26, 2012 7:38:31 PM UTC+1, Richard wrote: > > You can't create more db? > > If you use postgres database, you could have look at schema, they serves > that purpose, and I am not sure but I think I read that web2py now support > postgres schemas. > > no schema support in web2

Re: [web2py] Database table prefix

2012-11-26 Thread Richard Vézina
You can't create more db? If you use postgres database, you could have look at schema, they serves that purpose, and I am not sure but I think I read that web2py now support postgres schemas. Richard On Fri, Nov 23, 2012 at 3:09 PM, Chr_M wrote: > That, but even the same app using different ta

Re: [web2py] Database table prefix

2012-11-26 Thread Chr_M
Well, ideal for me would be to define a prefix in the model file and this is automatically added to every defined table and all queries (no idea if it is possible). But this multi-tenancy looks interesting as well, so I will look into it... Thanks! Regards, Chris On Monday, November 26, 2012

Re: [web2py] Database table prefix

2012-11-26 Thread Anthony
Do you have a proposal for how an easier implementation should work? Also, rather than separate tables for different clients, have you considered either multi-tenancyor just using separate databases (in the latter ca

Re: [web2py] Database table prefix

2012-11-26 Thread Chr_M
I guess that nobody has ever had a need for this and that there is not really a solution for it? Regards, Chris On Friday, November 23, 2012 9:09:24 PM UTC+1, Chr_M wrote: > > That, but even the same app using different tables in the same db (but for > different cliënts)... > > Regards, Chris

Re: [web2py] Database table prefix

2012-11-24 Thread Chr_M
That, but even the same app using different tables in the same db (but for different cliënts)... Regards, Chris On Friday, November 23, 2012 7:00:28 PM UTC+1, Richard wrote: > > Why exactly you change prefix? Installing differents apps dbs in the same > db? > > Richard > > On Fri, Nov 23, 2012

Re: [web2py] Database table prefix

2012-11-23 Thread Richard Vézina
Why exactly you change prefix? Installing differents apps dbs in the same db? Richard On Fri, Nov 23, 2012 at 10:57 AM, Chr_M wrote: > Hi, > > I am new to web2py and am migrating an application to web2py. All the > tables have a prefix that changes for the different deployments of the > applica

[web2py] Database table prefix

2012-11-23 Thread Chr_M
Hi, I am new to web2py and am migrating an application to web2py. All the tables have a prefix that changes for the different deployments of the application. Is there a way in web2py to have a prefix for all the tables in the database that I can change easely for different deployments? At this