Hi Stewart,
On Dec 15, 2009, at 11:05 PM, Stewart Smith wrote:
On Tue, Dec 15, 2009 at 12:59:33PM +0100, Paul McCullagh wrote:
Can you give an example of what the actions would be?
Are you thinking of things like ADD COLUMN, ALTER COLUMN TYPE, etc.
or something else.
Yep. basically just representations of the ALTER TABLE clauses but in
a data structure (well... protobuf message).
e.g.
ADD COLUMN
DROP COLUMN
ADD INDEX
DROP INDEX
etc.
I tend to agree here, that this form of command representation would
be easier for the engine to handle than a before/after schemas.
Basically, the first job of the engine would otherwise be to extract
the change information by comparing the before and after schemas.
This also allows an engine to quickly recognize if it can perform the
alter table internally (for example, an engine that can do ADD/DROP
INDEX, but nothing else).
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
