Re: EDB from a system designer's viewpoint
- Posted by kbochert at copper.net
Jan 18, 2004
--Alt-Boundary-17567.269269966
Content-description: Mail message body
On Sat, 17 Jan 2004 03:41:23 -0800 (PST), Miklos Hollender wrote:
>> 1) Keys.
>No. You have to maintain separate tables to simulate this.
>> 2) Transaction management, commit/rollback features.
>See next
>> 3) Multi-user features - locking.
>Not really. You could build a set of updates, and lock exclusively
>prior to verifying records still exist/still do not exist etc before
>applying the updates.
>You'd have to write your own log file for rollback though ;-((
>There are however some other possibilities (which I have not
>tested):
>EDS/Net by Jonas Temple
>Tsunami wrappers by Euman [don't think this has proper locking]
>ODBC(3) by Tone Skoda, Matthew Lewis, and Jonas Temple
>SQL(3) by Jonas Temple, Matthew Lewis, and Ray Smith
And don't forget SQLite:
-)Easy interface -- 3 functions, open, close, exec are enough --
about a dozen lines of Eu each.
-)Small -- 181K dll on windows
-)Fast -- about twice as fast as MySql or PostGres
-)Euphoria-ilke -- All fields are variable length, ideal for storing EU
objects
-)Locking performed on entire database -- can be slow if heavily
loaded. (see next point)
-)No separate database server.
>You can find these by searching at
>http://www.rapideuphoria.com/contrib.htm
>Regards,
>Pete
Karl Bochert
--Alt-Boundary-17567.269269966
Content-type: text/html; charset=US-ASCII
Content-transfer-encoding: 7BIT
Content-description: Mail message body
<?xml version="1.0" ?><html>
<head>
<title></title>
</head>
<body>
<div align="left"><font face="Arial"><span style="font-size:10pt">On Sat, 17 Jan
2004 03:41:23 -0800 (PST), Miklos Hollender wrote:</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>>
1) Keys.</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>No. You
have to maintain separate tables to simulate this.</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>>
2) Transaction management,
commit/rollback features.</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>See
next</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>>
3) Multi-user features -
locking.</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>Not
really. You could build a set of updates, and lock
exclusively</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>prior to
verifying records still exist/still do not exist etc before</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>applying
the updates.</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>You'd have
to write your own log file for rollback though ;-((</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>There are
however some other possibilities (which I have not
>tested):</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>EDS/Net by
Jonas Temple</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>Tsunami
wrappers by Euman [don't think this has proper locking]</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>ODBC(3) by
Tone Skoda, Matthew Lewis, and Jonas Temple</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>SQL(3) by
Jonas Temple, Matthew Lewis, and Ray Smith</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">And don't
forget SQLite:</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">
Easy
interface -- 3 functions, open, close, exec are enough --
about a dozen lines of Eu each.</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Small --
181K dll on windows</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Fast --
about twice as fast as MySql or PostGres</span></font></div>
<div align="left"><font face="Arial"><span
style="font-size:10pt">Euphoria-ilke -- All fields are variable length,
ideal for storing EU
objects</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Locking
performed on entire database -- can be slow if heavily
loaded. (see next point)</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">No separate
database server.</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">>You can
find these by searching at</span></font></div>
<div align="left"><font face="Arial"><span
style="font-size:10pt">>http://www.rapideuphoria.com/contrib.htm</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span
style="font-size:10pt">>Regards,</span></font></div>
<div align="left"><font face="Arial"><span
style="font-size:10pt">>Pete</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Karl
Bochert</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span
style="font-size:10pt"> </span></font></div>
--Alt-Boundary-17567.269269966--
|
Not Categorized, Please Help
|
|
