[Mono-list] Any interest in a new open source project?
Clayton Harbour
claytonharbour@sporadicism.com
Fri, 30 Jul 2004 07:25:31 -0700
This is a multi-part message in MIME format.
------_=_NextPart_001_01C47641.11EBCCB8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi Andrew,
=20
I use a similar product called Gentle.Net:
http://www.mertner.com/confluence/homepage.action which handles a lot of
the plumbing. It also has a number of database backend providers
(Oracle, MySql, Postgresql, Firebird, Sqllite, Access). I am not sure
how close of a match the architecture for Safari Cell and Gentle.Net are
but at the very least there is an opportunity here for idea sharing.
=20
=20
Cheers,
=20
Clayton
-----Original Message-----
From: Andrew Arnott [mailto:AndrewArnott@byu.edu]=20
Sent: July 29, 2004 9:44 PM
To: mono-list@lists.ximian.com
Subject: [Mono-list] Any interest in a new open source project?
I have a project I call Safari Cell, for now, that takes a relational
SQL database and turns it into a DataSet with DataTables for every
table, complete with DataRelations, UniqueConstraints,
ForeignKeyConstraints and a few other handy things. All the Data...
objects are hidden, however, behind classes that manage filling those
entities with data from the database on an as-called-for basis.
Modified data is cached and written later by a lazy-writer thread.
Unused data is eventually removed from the cache. Any modified column
is validated against any extra schema available from the DB server. =20
=20
The goal is to make it really easy to write business objects that
operate on relational databases, to take advantage of fast caching,
transactions, and all without writing any plumbing code in the business
object itself. Safari Cell scans the database schema at startup and
exposes everything through typed classes. =20
=20
I have done a great deal of work on this project, all in Visual Studio
.NET in C#. I want to make it open source so that others can help add
code to support other DB servers besides just MS SQL Server. I started
the project with extensibility and multiple database server backends in
mind. =20
=20
Is there a great deal of interest in helping these classes grow and
mature? I am planning on putting the source up on Novell's sourceforge
if people are willing to use/contribute.
=20
- Andrew Arnott
------_=_NextPart_001_01C47641.11EBCCB8
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in =
1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2>Hi=20
Andrew,</FONT></SPAN></DIV>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2>I use=20
a similar product called Gentle.Net: <A=20
href=3D"http://www.mertner.com/confluence/homepage.action">http://www.mer=
tner.com/confluence/homepage.action</A> which=20
handles a lot of the plumbing. It also has a number of database =
backend=20
providers (Oracle, MySql, Postgresql, Firebird, Sqllite,=20
Access). </FONT></SPAN><SPAN class=3D542351614-30072004><FONT =
face=3DArial color=3D#0000ff size=3D2>I am not sure how close of a match =
the=20
architecture for Safari Cell and Gentle.Net are but at the very least =
there is=20
an opportunity here for idea sharing.</FONT></SPAN></DIV>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2>Cheers,</FONT></SPAN></DIV>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D542351614-30072004><FONT face=3DArial color=3D#0000ff =
size=3D2>Clayton</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B> =
Andrew Arnott=20
[mailto:AndrewArnott@byu.edu] <BR><B>Sent:</B> July 29, 2004 9:44=20
PM<BR><B>To:</B> mono-list@lists.ximian.com<BR><B>Subject:</B> =
[Mono-list] Any=20
interest in a new open source project?<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have a project I call =
Safari=20
Cell, for now, that takes a relational SQL database and turns it into =
a=20
DataSet with DataTables for every table, complete with DataRelations,=20
UniqueConstraints, ForeignKeyConstraints and a few other handy =
things. =20
All the Data… objects are hidden, however, behind classes that =
manage filling=20
those entities with data from the database on an as-called-for =
basis. =20
Modified data is cached and written later by a lazy-writer =
thread. =20
Unused data is eventually removed from the cache. Any modified =
column is=20
validated against any extra schema available from the DB server. =
<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">The goal is to make it =
really easy=20
to write business objects that operate on relational databases, to =
take=20
advantage of fast caching, transactions, and all without writing any =
plumbing=20
code in the business object itself. Safari Cell scans the =
database=20
schema at startup and exposes everything through typed classes. =20
<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have done a great deal =
of work=20
on this project, all in Visual Studio .NET in C#. I want to make =
it open=20
source so that others can help add code to support other DB servers =
besides=20
just MS SQL Server. I started the project with extensibility and =
multiple database server backends in mind. =
<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Is there a great deal of =
interest=20
in helping these classes grow and mature? I am planning on =
putting the=20
source up on Novell’s sourceforge if people are willing to=20
use/contribute.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">- Andrew=20
Arnott<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C47641.11EBCCB8--