<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:courier, monaco, monospace, sans-serif;font-size:10pt"><DIV style="FONT-SIZE: 10pt; FONT-FAMILY: courier, monaco, monospace, sans-serif">Dear Impalah:</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: courier, monaco, monospace, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: courier, monaco, monospace, sans-serif">We had been using mono-1.2.4. We are going to be standardizing on mono-1.2.5.1 for a while. We have had touble with mono-1.2.6 and are waiting for mono-1.2.6.1 to hope some of the problems have been fixed. So, for now, mono-1.2.5.1 is the answer.</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: courier, monaco, monospace, sans-serif"> </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: courier, monaco, monospace, sans-serif">Charles<BR><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Impalah <impalah@gmail.com><BR>To: opensim-dev@lists.berlios.de<BR>Sent: Tuesday, February 5, 2008 1:55:12 PM<BR>Subject: Re: [Opensim-dev] further db thoughts<BR><BR>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" target=_blank rel=nofollow ymailto="mailto:stefan@tribalmedia.se">stefan@tribalmedia.se</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<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>
<SPAN style="width:100%;height:2px;border-bottom:1px solid rgb(212,208,200); border-top:1px solid rgb(128,128,128);background-color:black;overflow:hidden; margin:8px 0px;"></SPAN>
<BR>> Date: Mon, 14 Jan 2008 12:07:34 -0500<SPAN class=q><BR>> From: <A href="mailto:sean@dague.net" target=_blank rel=nofollow ymailto="mailto:sean@dague.net">sean@dague.net</A><BR>> To: <A href="mailto:opensim-dev@lists.berlios.de" target=_blank rel=nofollow ymailto="mailto:opensim-dev@lists.berlios.de">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
rel=nofollow>http://dague.net</A> <A href="http://mhvlug.org/" target=_blank rel=nofollow>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 href="mailto:Opensim-dev@lists.berlios.de" target=_blank rel=nofollow ymailto="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</A><BR><A href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target=_blank rel=nofollow>https://lists.berlios.de/mailman/listinfo/opensim-dev</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: courier, monaco, monospace, sans-serif"><BR></DIV></div></body></html>