Creating a database on each request seems strange, could make sense with in memory sqlite. A transaction represents a state in a space. In postgresql that space is exactly a single db (maybe it will change in the future). You may want to use a what postgresql calls "schema" you can use it but with caution because DAL in not aware of schemas.
2013/10/2 Niphlod <[email protected]> > let's say it's not a normal thing to do, and DAL doesn't support it out of > the box. the problem with postgresql is that a create database should be > issued in a non-transaction environment, that is what instead DAL uses by > default. > Instead of fiddling with DAL, just use raw psycopg commands to do it. > > with psycopg2.connect(connectionstring) as conn: > conn.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT) > with conn.cursor() as curs: > curs.execute('create database testdb') > > > On Wednesday, October 2, 2013 9:33:33 PM UTC+2, Richard wrote: > >> Creating an app that create database... There is much more thing to >> consider and there is already thing like webmin for that. >> >> Richard >> >> >> On Wed, Oct 2, 2013 at 3:32 PM, Richard Vézina <[email protected]>wrote: >> >>> Why would someone do that?! >>> >>> Richard >>> >>> >>> On Wed, Oct 2, 2013 at 1:48 PM, Cliff Kachinske <[email protected]>wrote: >>> >>>> Oops, maybe not. >>>> >>>> Psycopg2 certainly allows table creation, so maybe it's an adapter >>>> question rather than a dal question. >>>> >>>> >>>> On Wednesday, October 2, 2013 1:44:50 PM UTC-4, Cliff Kachinske wrote: >>>>> >>>>> Not for the fainthearted, but this should work. >>>>> >>>>> db = DAL('postgres://user_**authorize**d_to_create_db:**password_for_* >>>>> *that_user@**localhost:5432/db_**owned_by_**that_user, migrate=False) >>>>> stmt = """CREATE DATABASE foo WITH OWNER some_user_in_the_system""" >>>>> db.executesql(stmt ... >>>>> >>>>> On Wednesday, October 2, 2013 9:49:52 AM UTC-4, at wrote: >>>>>> >>>>>> >>>>>> Is is possible to create a postgres database from web2py application? >>>>>> >>>>>> Thanks & Regards >>>>>> >>>>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/**web2py >>>> <http://github.com/web2py/web2py>(Source code) >>>> - >>>> https://code.google.com/p/**web2py/issues/list<https://code.google.com/p/web2py/issues/list>(Report >>>> Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@**googlegroups.com. >>>> >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>> . >>>> >>> >>> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
