SV: interbase database schema

2001-01-27 Thread Markus Harnvi


Yes, SABDB would be another alterantive. Anyone tried it togheter with
Orion?

PostgreSQL seems to be more mature than SABDB, but SAPDB has a big company
supporting it.

/Markus


-Ursprungligt meddelande-
Fran: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]For Ray Harrison
Skickat: den 26 januari 2001 18:09
Till: Orion-Interest
Amne: Re: SV: interbase database schema


I have been reasonably impressed with SapDB - its got its quirks and I
haven't fully completed my
testing (database and jdbc driver), but is seems pretty solid on Windows
2000 thus far.
RHH
--- Markus Hdrnvi [EMAIL PROTECTED] wrote:

 MySQL lacks real transactions.

 My suggestion would be PostgreSQL. I have it running here on my Windows
 2000. It can be compiled with the Cygwin tools.

 http://people.freebsd.org/~kevlo/postgres/portNT.html

 I wouldn't run it on Windows in a production environment, but for
 development it is OK.

 http://theserverside.com uses PostgreSQL on Linux togheter with EJB.

   /Markus



 -Ursprungligt meddelande-
 Fren: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]Fvr Chris Bartling
 Skickat: den 26 januari 2001 03:10
 Till: Orion-Interest
 Dmne: RE: interbase database schema


 What about MySQL?  Works under both Windows and Linux and is open source.
 Doesn't do everything a DB2 or Oracle does (subselects instantly come to
 mind), but it does work well.  Plus, O'Reilly has a great book out on
MySQL,
 so documentation is not a problem.  JDBC drivers are readily available.
All
 of this can be found at http://www.mysql.com.  I've been using MySQL and
 Orion together on Windows 2000 without a problem.


 -- chris --





Re: SV: interbase database schema

2001-01-27 Thread Ray Harrison

Should have been more clear - we are using it with Orion 1.4.5 on W2K - the more I 
test and
stress it - the more I like it. I even like the tools that come with it. As it is 
being moved to
open source, it comes to us a little differently than other open source apps.  It is a 
mature
database already and I believe it can only get better as an open source app. I should 
say, rather,
that it has the potential to get better, time will tell of course.  How is it that 
PostgreSQL
seems more mature than SapDB? Kind of curious...

Cheers
Ray
--- Markus Harnvi [EMAIL PROTECTED] wrote:
 
 Yes, SABDB would be another alterantive. Anyone tried it togheter with
 Orion?
 
 PostgreSQL seems to be more mature than SABDB, but SAPDB has a big company
 supporting it.
 
   /Markus
 
 
 -Ursprungligt meddelande-
 Fran: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]For Ray Harrison
 Skickat: den 26 januari 2001 18:09
 Till: Orion-Interest
 Amne: Re: SV: interbase database schema
 
 
 I have been reasonably impressed with SapDB - its got its quirks and I
 haven't fully completed my
 testing (database and jdbc driver), but is seems pretty solid on Windows
 2000 thus far.
 RHH
 --- Markus Hdrnvi [EMAIL PROTECTED] wrote:
 
  MySQL lacks real transactions.
 
  My suggestion would be PostgreSQL. I have it running here on my Windows
  2000. It can be compiled with the Cygwin tools.
 
  http://people.freebsd.org/~kevlo/postgres/portNT.html
 
  I wouldn't run it on Windows in a production environment, but for
  development it is OK.
 
  http://theserverside.com uses PostgreSQL on Linux togheter with EJB.
 
  /Markus
 
 
 
  -Ursprungligt meddelande-
  Fren: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]Fvr Chris Bartling
  Skickat: den 26 januari 2001 03:10
  Till: Orion-Interest
  Dmne: RE: interbase database schema
 
 
  What about MySQL?  Works under both Windows and Linux and is open source.
  Doesn't do everything a DB2 or Oracle does (subselects instantly come to
  mind), but it does work well.  Plus, O'Reilly has a great book out on
 MySQL,
  so documentation is not a problem.  JDBC drivers are readily available.
 All
  of this can be found at http://www.mysql.com.  I've been using MySQL and
  Orion together on Windows 2000 without a problem.
 
 
  -- chris --
 
 


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/




SV: interbase database schema

2001-01-27 Thread Markus Härnvi


 PostgreSQL seems to be more mature than SABDB, but SAPDB has a big
company
 supporting it.

 what makes you think that way? SAPDB has a background in a commercial
 product that has been out for many years (decades?)

I mean as a repacked OSS product. That's a new situation. Look att
Netscape - Mozilla. It doesn't seem that easy to release a former
commercial product as OSS.
The SAP people take there time too:
http://www.sap.com/solutions/technology/sapdb/sap_db_roadmap.htm

Are there many installations of SAPDB as a standalone product? Isn't it a
bit different from using it as an integrated database engine in the SAP
environment?

Anyway, it's really nice with several well supported free database engines
around.

/Markus







SV: interbase database schema

2001-01-26 Thread Markus Härnvi


MySQL lacks real transactions.

My suggestion would be PostgreSQL. I have it running here on my Windows
2000. It can be compiled with the Cygwin tools.

http://people.freebsd.org/~kevlo/postgres/portNT.html

I wouldn't run it on Windows in a production environment, but for
development it is OK.

http://theserverside.com uses PostgreSQL on Linux togheter with EJB.

/Markus



-Ursprungligt meddelande-
Frn: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Fr Chris Bartling
Skickat: den 26 januari 2001 03:10
Till: Orion-Interest
mne: RE: interbase database schema


What about MySQL?  Works under both Windows and Linux and is open source.
Doesn't do everything a DB2 or Oracle does (subselects instantly come to
mind), but it does work well.  Plus, O'Reilly has a great book out on MySQL,
so documentation is not a problem.  JDBC drivers are readily available.  All
of this can be found at http://www.mysql.com.  I've been using MySQL and
Orion together on Windows 2000 without a problem.


-- chris --



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Magnus Rydin
Sent: Thursday, January 25, 2001 3:35 AM
To: Orion-Interest
Subject: SV: interbase database schema


hSQL (java based) that is shipped with Orion is very neat for development,
but probably not the best choice for a production environment.
In production I would recommend DB2 or Oracle.. Not open source, but
trustworthy.
WR
 -Ursprungligt meddelande-
 Frn: H.Bakker [mailto:[EMAIL PROTECTED]]
 Skickat: den 25 januari 2001 00:46
 Till: Orion-Interest
 mne: interbase database schema


 Good morning.

 We are doing some experiments with Orion, and it looks very good.

 We are looking for a (preferable open source) database with
 will work in a
 production environment under Linux, but can also be used
 under Windows in a
 development environment because not all developers we have,
 use Linux as
 their development environment.

 We already use Interbase from Borland, but I could not find a database
 scheme in 1.45
 Does anybody already have a schema or a other suggestion for
 a database?

 thanks in advance,

 Regards

 Hans Bakker
 A-Net Internet Services
 www.a-net.nl/english
 partner of www.ejbprovider.com









Re: SV: interbase database schema

2001-01-26 Thread Ray Harrison

I have been reasonably impressed with SapDB - its got its quirks and I haven't fully 
completed my
testing (database and jdbc driver), but is seems pretty solid on Windows 2000 thus far.
RHH
--- Markus Härnvi [EMAIL PROTECTED] wrote:

 MySQL lacks real transactions.

 My suggestion would be PostgreSQL. I have it running here on my Windows
 2000. It can be compiled with the Cygwin tools.

 http://people.freebsd.org/~kevlo/postgres/portNT.html

 I wouldn't run it on Windows in a production environment, but for
 development it is OK.

 http://theserverside.com uses PostgreSQL on Linux togheter with EJB.

   /Markus



 -Ursprungligt meddelande-
 Från: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]För Chris Bartling
 Skickat: den 26 januari 2001 03:10
 Till: Orion-Interest
 Ämne: RE: interbase database schema


 What about MySQL?  Works under both Windows and Linux and is open source.
 Doesn't do everything a DB2 or Oracle does (subselects instantly come to
 mind), but it does work well.  Plus, O'Reilly has a great book out on MySQL,
 so documentation is not a problem.  JDBC drivers are readily available.  All
 of this can be found at http://www.mysql.com.  I've been using MySQL and
 Orion together on Windows 2000 without a problem.


 -- chris --



 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Magnus Rydin
 Sent: Thursday, January 25, 2001 3:35 AM
 To: Orion-Interest
 Subject: SV: interbase database schema


 hSQL (java based) that is shipped with Orion is very neat for development,
 but probably not the best choice for a production environment.
 In production I would recommend DB2 or Oracle.. Not open source, but
 trustworthy.
 WR
  -Ursprungligt meddelande-
  Från: H.Bakker [mailto:[EMAIL PROTECTED]]
  Skickat: den 25 januari 2001 00:46
  Till: Orion-Interest
  Ämne: interbase database schema
 
 
  Good morning.
 
  We are doing some experiments with Orion, and it looks very good.
 
  We are looking for a (preferable open source) database with
  will work in a
  production environment under Linux, but can also be used
  under Windows in a
  development environment because not all developers we have,
  use Linux as
  their development environment.
 
  We already use Interbase from Borland, but I could not find a database
  scheme in 1.45
  Does anybody already have a schema or a other suggestion for
  a database?
 
  thanks in advance,
 
  Regards
 
  Hans Bakker
  A-Net Internet Services
  www.a-net.nl/english
  partner of www.ejbprovider.com
 
 






__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/




SV: interbase database schema

2001-01-25 Thread Magnus Rydin
Title: SV: interbase database schema





hSQL (java based) that is shipped with Orion is very neat for development,
but probably not the best choice for a production environment.
In production I would recommend DB2 or Oracle.. Not open source, but trustworthy.
WR


 -Ursprungligt meddelande-
 Från: H.Bakker [mailto:[EMAIL PROTECTED]]
 Skickat: den 25 januari 2001 00:46
 Till: Orion-Interest
 Ämne: interbase database schema
 
 
 Good morning.
 
 We are doing some experiments with Orion, and it looks very good.
 
 We are looking for a (preferable open source) database with 
 will work in a
 production environment under Linux, but can also be used 
 under Windows in a
 development environment because not all developers we have, 
 use Linux as
 their development environment.
 
 We already use Interbase from Borland, but I could not find a database
 scheme in 1.45
 Does anybody already have a schema or a other suggestion for 
 a database?
 
 thanks in advance,
 
 Regards
 
 Hans Bakker
 A-Net Internet Services
 www.a-net.nl/english
 partner of www.ejbprovider.com