Sorry for answering a bit late, I have not much time for development :-(<br><br>I'm making tests with NHibernate (a sample data model with several tables for burning test... 20000+ registers). I tested by now in mysql and mssql, both mono and .NET. I think tomorrow I could try sqlite but... a little problem. Seems that the "official" driver is outdated and everybody recommends to use the one shipped with mono (version 1.2.4 and higher).<br>
<br>Is there any restriction for the mono version opensim uses?<br><br>Thanks<br><br><br><div><span class="gmail_quote">2008/1/14, Stefan Andersson <<a href="mailto:stefan@tribalmedia.se">stefan@tribalmedia.se</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Yes, as I said at the start, how things play together might take a while to get used to. The lib is supposed to create parameterized dynamic sql, so that bit should be injection-aversive.<br>
<br>
And, by all means, feel free to find other ways to slice the cake; I put it there for us to extend and modify, in the hope that it could function as a help also for people who want to extend our db definitons with their own need for light-weight persistence.<br>
<br>
I know my code sample was stenographic at best, but I hope to deliver some working code (ideally, shape, part and group) at the end of this week - I have it on my hard disk, just have to 'clean' it from context-specifics.<br>
<br>
Best,<br>
/Stefan<br><br><br><br><br>
<hr>
<br>
> Date: Mon, 14 Jan 2008 12:07:34 -0500<span class="q"><br>> From: <a href="mailto:sean@dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">sean@dague.net</a><br>> To: <a href="mailto:opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">opensim-dev@lists.berlios.de</a><br>
> Subject: Re: [Opensim-dev] further db thoughts<br>> <br></span><div><span class="e" id="q_1177a3623f0b635b_2">> On Mon, Jan 14, 2008 at 11:31:50AM +0100, Stefan Andersson wrote:<br>> > <br>> > <br>> > ---<br>
> > Stefan, It would be motivating if you could provide a sample about how the TribalMedia data framework should work. Could that be done by implementing the very simple asset server as an example ? I propose we would make it work, make tests, comment and try to improve it, then it may serve as a baseline for the other db stuff ?<br>
> > --- <br>> > <br>> > *doh*<br>> > <br>> > I'll just post the code; but beware, it doesn't work, it's just to show you how stuff would interact<br>> > <br>> > (Also, the code could probably be cleaner...)<br>
> > <br>> > What to look for:<br>> > * how the Schema is created and populated<br>> > * how the m_keyFieldMapper (that is used to extract primary key from queries) is initialized<br>> > * how the FromReader passes on to FillObject() - the function that will use the Schema to populate the RowMapper (and the PrimitiveBaseShape)<br>
> > * How the CRUD and CreateRowMapper functions are really just there to<br>> > get a cleaner interface for the caller.<br>> <br>> I'm a bit concerned about the ability to get SQL injection through the<br>
> process (unless I missed something). We need to either put in filter<br>> for that, or use the parametrized SQL for the base drivers to let them<br>> filter that.<br>> <br>> I'm still wrapping my head around all of it, but I like much of what I'm<br>
> seeing so far. More later.<br>> <br>> -Sean<br>> <br>> -- <br>> __________________________________________________________________<br>> <br>> Sean Dague Mid-Hudson Valley<br>> sean at dague dot net Linux Users Group<br>
> <a href="http://dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://dague.net</a> <a href="http://mhvlug.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://mhvlug.org</a><br>
> <br>> There is no silver bullet. Plus, werewolves make better neighbors<br>> than zombies, and they tend to keep the vampire population down.<br>> __________________________________________________________________<br>
<br></span></div></div>
<br>_______________________________________________<br>Opensim-dev mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br><br></blockquote></div><br>