[web2py] Re: Redbean-like ORM in web2py

2012-02-15 Thread Anthony
> > There has been a POC implementation in Python: > http://pypi.python.org/pypi/pybean > which supports SQLite, but looking at it's description, is not meant > for primetime yet. > Also, this: https://github.com/stochastic-technologies/goatfish

[web2py] Re: Redbean-like ORM in web2py

2012-02-01 Thread Cliff
I experience too many unexpected changes during development as it is. :) Having an ORM create more would not be good. During development I might inadvertently attempt to insert a string into a decimal field. I do dumb stuff like that sometimes, as I think most of us do. Would the schema then ch

[web2py] Re: Redbean-like ORM in web2py

2012-02-01 Thread Anthony
On Wednesday, February 1, 2012 9:02:01 AM UTC-5, Cliff wrote: > > > > insert prompts the creation of the 'name' column in the 'person' table > > (type is inferred based on the data, and altered if necessary based on > > subsequent inserts) > > Wow. I would not be comfortable with this. > My un

[web2py] Re: Redbean-like ORM in web2py

2012-02-01 Thread Cliff
> insert prompts the creation of the 'name' column in the 'person' table > (type is inferred based on the data, and altered if necessary based on > subsequent inserts) Wow. I would not be comfortable with this. On Jan 30, 10:13 am, Anthony wrote: > On Monday, January 30, 2012 9:37:29 AM UTC-5,

[web2py] Re: Redbean-like ORM in web2py

2012-01-31 Thread Chnrxn
Thanks Anthony, that's exactly right. In fact, there is even no need for us to call db.define_table('person') at all with RedBean. It would look more like dal.insert(, =, ...) and gets created automatically if it does not exist. The best use case IMO is the ability to store/insert variable dictio

[web2py] Re: Redbean-like ORM in web2py

2012-01-30 Thread Anthony
On Monday, January 30, 2012 9:37:29 AM UTC-5, Massimo Di Pierro wrote: > > You can create schemas on the fly with web2py (web2py will do the > alter table). I think in RedBean you don't have to define the schema at all. With the DAL, it would look something like: db.define_table('person') db.p

[web2py] Re: Redbean-like ORM in web2py

2012-01-30 Thread Massimo Di Pierro
You can create schemas on the fly with web2py (web2py will do the alter table). It would be possible to allow redefining a table within the same http request but why? you can also do this: def associate(t1, t2, *fields): db = t1._db f1 = t1._tablename+'_id' f2 = t2._tablename+'_id'

[web2py] Re: Redbean-like ORM in web2py

2012-01-30 Thread Chnrxn
It brings in the power of NoSQL. On my part, having used SQLObject, SQLAlchemy, DAL, and RedBean, I find that Redbean does a wonderful job of removing obstacles, no doubt many might deem them to be insignificant, during development. It does make a big difference for me, especially during developmen

[web2py] Re: Redbean-like ORM in web2py

2012-01-27 Thread pbreit
Is the main benefit not having to pre-define models? I suppose that could be nice during development but don't find that to be a big problem with DAL. DAL is pretty integral to Web2py and one of the most popular features. And it has many of the same advantages as RedBean and from my brief look,

Re: [web2py] Re: Redbean-like ORM in web2py

2012-01-27 Thread Vasile Ermicioi
> However, there is nothing stopping you from using RedBrean or even > SQLAlchemy in your web2py projects. RedBean is a php library... :) I used it but I can't say that it is better than web2pys DAL

[web2py] Re: Redbean-like ORM in web2py

2012-01-27 Thread Ross Peoples
I don't know about future development plans, but I can say that web2py does not use an ORM, it uses a database abstraction layer that generates the proper SQL (and NoSQL) code. Lack of an ORM is sometimes touted as a feature of web2py because ORMs are usually big, complicated, and difficult to