> 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 <abasta...@gmail.com> wrote:
> 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.person.insert(name='John')
>
> Notice that the 'name' field was never defined before the insert -- the
> 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). So, it enables use of a schema-based RDBMS more like a
> schema-less NoSQL db. This "fluid" mode is recommended in development only,
> after which, you are advised to "freeze" the
> schema:http://redbeanphp.com/manual/freeze. So, it's taking automatic
> migrations a step further and doing automatic (inferred) schema definitions
> as well.
>
> Anthony
