Hi Marvin,<br><br>this statement tempted me to jump in, even without using something like dynamic field creation myself __right now__. But I have been - especially on cms like projects badly in need for dynamic fields.<br>
<br>That something isn't common in sql doesn't mean that there is no need for this "something". This limitation of sql is the reason for doing things like storing xml in relational dbs as well as the reason for people using object dbs. I don't know if you had a look at dabble db, but imagine something like this with a relational dbms. not funny! Because of this they haven't even thought about using sql for dabble db. So maybe it's just me but the argument: you can't do this in sql either doesn't sound too convincing...
<br><br>Cheers,<br>Jan<br><br><div><span class="gmail_quote">On 6/6/06, <b class="gmail_sendername">Marvin Humphrey</b> <<a href="mailto:marvin@rectangular.com">marvin@rectangular.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>On Jun 6, 2006, at 10:11 AM, Lee Marlow wrote:<br><br>> Do you mean that all fields would have to be known at index creation<br>> time or just that once a field is defined it properties are the same<br>> across all documents? Right now I'm indexing documents that create
<br>> new fields as needed based on user defined properties, so we don't<br>> know all the fields initially.<br><br>How would you handle this if you were using an SQL database rather<br>than Ferret? Your app wouldn't be able to modify the table on the
<br>fly on that case, unless you did something insane like run a remote<br>"ALTER TABLE" command.<br><br>Marvin Humphrey<br>Rectangular Research<br><a href="http://www.rectangular.com/">http://www.rectangular.com/
</a><br><br>_______________________________________________<br>Ferret-talk mailing list<br><a href="mailto:Ferret-talk@rubyforge.org">Ferret-talk@rubyforge.org</a><br><a href="http://rubyforge.org/mailman/listinfo/ferret-talk">
http://rubyforge.org/mailman/listinfo/ferret-talk</a><br></blockquote></div><br>