Re: Table options in CREATE TABLE..

2006-07-18 Thread [EMAIL PROTECTED]
> If so, is this something that would work reasonably seamlessly on top of > J Pellerin's multi-database Summer of Code work (different engines => > different connections => essentially different database for that model, > so it falls out of his configuration changes)? Sort of. But mostly not. Th

Re: Table options in CREATE TABLE..

2006-07-18 Thread Nebojsa Djordjevic
DavidA wrote: > improve it a bit: > > 1) In addition to providing initial data in a file > /sql/.sql, I think it would be good to support a > form of /sql//.sql so if you want to put > DB-specific stuff in there you can. That way if I moved my app to > PostgreSQL, for example, it wouldn't try to

Re: Table options in CREATE TABLE..

2006-07-18 Thread DavidA
Geert, Just for the record, I use the "SQL initial data file" feature that Adrian mentioned to enable full-text indexing on a couple of my tables. The relevant part of my script is: ALTER TABLE data_rawtrade ENGINE=MyISAM; CREATE FULLTEXT INDEX ix_ft_data_rawtrade_all ON data_ra

Re: Table options in CREATE TABLE..

2006-07-17 Thread Geert Vanderkelen
Geert Vanderkelen wrote: > Hi! > > I'm currently looking into a possibility to define per Model which MySQL > Storage Engine it should use for creating the table. This would need a new > option called 'db_table_option' for the Model. .. Ok. Sorry for the noise, idea binned by all mighty FAQ. :

Re: Table options in CREATE TABLE..

2006-07-17 Thread Adrian Holovaty
On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: > No.. This is about table options. All of them! Not only storage engine > choice. All of the table options anyone can imagine. And "all of the table options anyone can imagine" are supported by that FAQ answer, as long as they can be appli

Re: Table options in CREATE TABLE..

2006-07-17 Thread James Bennett
On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: > No.. This is about table options. All of them! Not only storage engine > choice. All of the table options anyone can imagine. I still feel like it's way too much of a special case to try to do this; the proposed option of an "anything goe

Re: Table options in CREATE TABLE..

2006-07-17 Thread Geert Vanderkelen
Hi James, James Bennett wrote: > On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: .. > 1) The features common to all the RDBMS products it can be used with. > 2) A way to manually tweak its SQL output to take advantage of > features which only apply to one database. Well, my 'manually' t

Re: Table options in CREATE TABLE..

2006-07-17 Thread Geert Vanderkelen
Hi Adrian, Adrian Holovaty wrote: > On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: >> I'm currently looking into a possibility to define per Model which MySQL >> Storage Engine it should use for creating the table. This would need a new >> option called 'db_table_option' for the Model.

Re: Table options in CREATE TABLE..

2006-07-17 Thread James Bennett
On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: > This storage engine choice was only an example. There are lots of other > options which can be set per table. > As Honza replied, this is not MySQL specific and PostgreSQL as well as other > DBMS accept options like these. But pretty much

Re: Table options in CREATE TABLE..

2006-07-17 Thread Adrian Holovaty
On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: > I'm currently looking into a possibility to define per Model which MySQL > Storage Engine it should use for creating the table. This would need a new > option called 'db_table_option' for the Model. > > Not only for MySQL would this be han

Re: Table options in CREATE TABLE..

2006-07-17 Thread Geert Vanderkelen
Hi James, James Bennett wrote: > On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: >> Not only for MySQL would this be handy, for other backends as well. I think >> for PostgreSQL the inheritance feature would need this too. > > How so? Postgres doesn't have multiple storage engines like

Re: Table options in CREATE TABLE..

2006-07-17 Thread Geert Vanderkelen
Hi Malcolm, Malcolm Tredinnick wrote: > On Mon, 2006-07-17 at 12:15 +0200, Geert Vanderkelen wrote: >> A follow-up on my previous post, with a patch attached to make the >> db_table_options work, which was easy to put in. >> >> Any comments on this patch, or something I looked over? Otherwise I

Re: Table options in CREATE TABLE..

2006-07-17 Thread Honza Král
On 7/17/06, James Bennett <[EMAIL PROTECTED]> wrote: > > On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: > > Not only for MySQL would this be handy, for other backends as well. I think > > for PostgreSQL the inheritance feature would need this too. > > How so? Postgres doesn't have multipl

Re: Table options in CREATE TABLE..

2006-07-17 Thread James Bennett
On 7/17/06, Geert Vanderkelen <[EMAIL PROTECTED]> wrote: > Not only for MySQL would this be handy, for other backends as well. I think > for PostgreSQL the inheritance feature would need this too. How so? Postgres doesn't have multiple storage engines like MySQL does; a Postgres table is a Postgr

Re: Table options in CREATE TABLE..

2006-07-17 Thread Malcolm Tredinnick
On Mon, 2006-07-17 at 12:15 +0200, Geert Vanderkelen wrote: > A follow-up on my previous post, with a patch attached to make the > db_table_options work, which was easy to put in. > > Any comments on this patch, or something I looked over? Otherwise I make a > feature request with it, unless I

Re: Table options in CREATE TABLE..

2006-07-17 Thread Geert Vanderkelen
A follow-up on my previous post, with a patch attached to make the db_table_options work, which was easy to put in. Any comments on this patch, or something I looked over? Otherwise I make a feature request with it, unless I missed it while searching for an existing one.. -Geert Geert Vanderk