From owner-freebsd-database Sun Dec 26 4:46:15 1999 Delivered-To: freebsd-database@freebsd.org Received: from carlton.innotts.co.uk (carlton.innotts.co.uk [212.56.32.2]) by hub.freebsd.org (Postfix) with ESMTP id D71EC14DC4 for ; Sun, 26 Dec 1999 04:46:01 -0800 (PST) (envelope-from robmel@nadt.org.uk) Received: from muffin.highwire.local (pool-1-p9.innotts.co.uk [212.56.33.9]) by carlton.innotts.co.uk (8.9.3/8.9.3) with ESMTP id MAA03519 for ; Sun, 26 Dec 1999 12:45:59 GMT Received: from [172.16.17.20] (robsmac.highwire.local [172.16.17.20]) by muffin.highwire.local (8.9.3/8.9.3) with ESMTP id MAA01264; Sun, 26 Dec 1999 12:42:46 GMT (envelope-from robmel@nadt.org.uk) Mime-Version: 1.0 X-Sender: robmel@mailhost Message-Id: Date: Sun, 26 Dec 1999 12:42:54 +0000 To: Gabor Esperon , freebsd-database@FreeBSD.ORG From: Robin Melville Subject: Re: What database i can use? Content-Type: text/plain; charset="us-ascii" ; format="flowed" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk At 9:05 am -0800 24/12/99, Gabor Esperon wrote: >I need a good database server in my network, under >FreeBSD 3.3 > >What is recommended: Oracle, MySQL, PostgreSQL or >another? Previous responses by others are reasonable, although MySQL is better than Berend de Boer said for quick and effective apps using many accesses - few (and not too complex) updates. Another alternative is Interbase 4 in the ports collection. This is a back version of Interbase (which is a commercial database) but works very well & is free. Other native FreeBSD SQL databases which you pay for are Yard (http://www.yard.de/) and Solid (http://www.solidtech.com/) both of which have strengths and weaknesses but are full SQL implementations. You can also get trial versions of them. Plenty to play with here :) Regards Robin. ---------------------------------------------------------------------- Robin Melville, Addiction Information Service Nottingham Alcohol & Drug Team Tel: +44 (0)115 952 9478 Fax: +44 (0)115 952 9421 work: robmel@nadt.org.uk Pages: http://www.nadt.org.uk/ ---------------------------------------------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Dec 26 5:36: 3 1999 Delivered-To: freebsd-database@freebsd.org Received: from whizzo.transsys.com (whizzo.TransSys.COM [144.202.42.10]) by hub.freebsd.org (Postfix) with ESMTP id 9A7861508C for ; Sun, 26 Dec 1999 05:36:00 -0800 (PST) (envelope-from louie@whizzo.transsys.com) Received: from whizzo.transsys.com (localhost.transsys.com [127.0.0.1]) by whizzo.transsys.com (8.9.3/8.9.1) with ESMTP id IAA66179; Sun, 26 Dec 1999 08:36:25 -0500 (EST) (envelope-from louie@whizzo.transsys.com) Message-Id: <199912261336.IAA66179@whizzo.transsys.com> X-Mailer: exmh version 2.1.1 10/15/1999 To: Robin Melville Cc: Gabor Esperon , freebsd-database@FreeBSD.ORG From: "Louis A. Mamakos" Subject: Re: What database i can use? References: In-reply-to: Your message of "Sun, 26 Dec 1999 12:42:54 GMT." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sun, 26 Dec 1999 08:36:25 -0500 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > At 9:05 am -0800 24/12/99, Gabor Esperon wrote: > >I need a good database server in my network, under > >FreeBSD 3.3 > > > >What is recommended: Oracle, MySQL, PostgreSQL or > >another? > > Previous responses by others are reasonable, although MySQL is better > than Berend de Boer said for quick and effective apps using many > accesses - few (and not too complex) updates. If you don't need transactions and rollback capability (and triggers), then I would recommend that you seriously consider it. I'm using MySQL for a couple of applications on my FreeBSD home automation system. It collects caller-id (for inbound) and call detail records (for outbound) calls from my PBX into a table, as well as periodic temperature measurements every 4 minutes from 11 temperature probes in various locations. For my application, the transactions are generally pretty simple with lots of inserts (there are 719,000 records in the temperature measurement table, 5255 in the inbound call table and 4812 in the outbound call table). The database server simply seems to work. I can't remember the last time I manually restarted it; currently, it's been up for for a bit more than 48 days which corresponds to the last time that system booted. There are also client-side interfaces available in perl, tcl, php3 as well as a C API. louie To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Dec 26 6:23:46 1999 Delivered-To: freebsd-database@freebsd.org Received: from mail.scc.nl (node1374.a2000.nl [62.108.19.116]) by hub.freebsd.org (Postfix) with ESMTP id E34A9152DD for ; Sun, 26 Dec 1999 06:23:39 -0800 (PST) (envelope-from freebsd-database@scc.nl) Received: (from daemon@localhost) by mail.scc.nl (8.9.3/8.9.3) id PAA45660 for database@FreeBSD.org; Sun, 26 Dec 1999 15:16:10 +0100 (CET) (envelope-from freebsd-database@scc.nl) Received: from GATEWAY by dwarf.hq.scc.nl with netnews for database@FreeBSD.org (database@FreeBSD.org) To: database@FreeBSD.org Date: Sun, 26 Dec 1999 15:16:06 +0100 From: Marcel Moolenaar Message-ID: <38662326.4A4CCD1E@scc.nl> Organization: SCC vof Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit References: <19991224170541.29128.qmail@web1302.mail.yahoo.com>, <001d01bf4e3a$f89a3a70$0321a8c0@bmach.nederware.nl> Subject: Re: What database i can use? Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Berend de Boer wrote: > > > What is recommended: Oracle, MySQL, PostgreSQL or > > another? > > Oracle costs money, hard to setup, but most features. > > MySQL isn't a real RDBMS, so not an option. > > Leaves PostgreSQL. Stable and reasonably fast. Doesn't support full ANSI92 > SQL (no JOIN statement for example). But has many other features. > > I would start with PostgreSQL. The new Informix server (IDS.2000) for Linux seems to work fine on both -stable and -current. You may want to check it out as well. -- Marcel Moolenaar mailto:marcel@scc.nl SCC Internetworking & Databases http://www.scc.nl/ The FreeBSD project mailto:marcel@FreeBSD.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Dec 26 12: 1:55 1999 Delivered-To: freebsd-database@freebsd.org Received: from hub.org (hub.org [216.126.84.1]) by hub.freebsd.org (Postfix) with ESMTP id 885DB14BF2 for ; Sun, 26 Dec 1999 12:01:49 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by hub.org (8.9.3/8.9.3) with ESMTP id PAA52457; Sun, 26 Dec 1999 15:01:44 -0500 (EST) (envelope-from scrappy@hub.org) Date: Sun, 26 Dec 1999 15:01:43 -0500 (EST) From: "Marc G. Fournier" To: Berend de Boer Cc: freebsd-database@FreeBSD.ORG Subject: RE: What database i can use? In-Reply-To: <001d01bf4e3a$f89a3a70$0321a8c0@bmach.nederware.nl> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 24 Dec 1999, Berend de Boer wrote: > > What is recommended: Oracle, MySQL, PostgreSQL or > > another? > > Oracle costs money, hard to setup, but most features. > > MySQL isn't a real RDBMS, so not an option. > > Leaves PostgreSQL. Stable and reasonably fast. Doesn't support full ANSI92 > SQL (no JOIN statement for example). But has many other features. JOIN statement? I take it that this is different then: SELECT a.field1, b.field2 from table1 a, table2 b where a.key = b.key To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Dec 26 23:53:51 1999 Delivered-To: freebsd-database@freebsd.org Received: from mail.scc.nl (node1374.a2000.nl [62.108.19.116]) by hub.freebsd.org (Postfix) with ESMTP id 2110014C88 for ; Sun, 26 Dec 1999 23:53:42 -0800 (PST) (envelope-from freebsd-database@scc.nl) Received: (from daemon@localhost) by mail.scc.nl (8.9.3/8.9.3) id IAA97220 for database@FreeBSD.org; Mon, 27 Dec 1999 08:37:18 +0100 (CET) (envelope-from freebsd-database@scc.nl) Received: from GATEWAY by dwarf.hq.scc.nl with netnews for database@FreeBSD.org (database@FreeBSD.org) To: database@FreeBSD.org Date: Mon, 27 Dec 1999 08:37:18 +0100 From: Remco Moolenaar Message-ID: <3867172D.D9B5E046@scc.nl> Organization: SCC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit References: <19991224165155.27619.qmail@web1302.mail.yahoo.com> Reply-To: remco@scc.nl Subject: Re: What database i can use? Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Gabor Esperon wrote: > I need a good database server in my network, Under > FreeBSD 3.3 I have three questions: 1) What do you want to do with it? 2) What's the budget? 3) Did you look at the database section of www.bsdapps.org In my honest opinion, you were asking the wrong question. Normally you must start with question 1 and 2. After you have answered them, you can ask us what we think of MySQL, PostGreSQL, Oracle, Sybase, Informix and the lot! Remco. -- Remco Moolenaar mailto:remco@scc.nl SCC Internetworking & Databases http://www.scc.nl/ Amsterdam, The Netherlands mailto:remco@bsdapps.org Maintainer of the BSD Applications database at http://www.bsdapps.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Dec 27 1:42:20 1999 Delivered-To: freebsd-database@freebsd.org Received: from smtp1.xs4all.nl (smtp1.xs4all.nl [194.109.127.48]) by hub.freebsd.org (Postfix) with ESMTP id C9A4914D24 for ; Mon, 27 Dec 1999 01:42:16 -0800 (PST) (envelope-from berend@pobox.com) Received: from auke.nederware.nl (nederware.nl [194.109.55.62]) by smtp1.xs4all.nl (8.9.3/8.9.3) with ESMTP id KAA17590 for ; Mon, 27 Dec 1999 10:42:14 +0100 (CET) Received: from bmach (bmach.nederware.nl [192.168.33.3]) by auke.nederware.nl (8.8.8/8.8.8) with SMTP id KAA07922 for ; Mon, 27 Dec 1999 10:39:35 +0100 (CET) (envelope-from berend@pobox.com) From: "Berend de Boer" To: Subject: RE: What database i can use? Date: Mon, 27 Dec 1999 10:39:31 +0100 Message-ID: <002601bf504e$47b0e630$0321a8c0@bmach.nederware.nl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 In-reply-to: Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > Another alternative is Interbase 4 in the ports collection. This is a > back version of Interbase (which is a commercial database) but works > very well & is free. It is indeed a good alternative. I've quite some experience with 4.x: Some caveats: 1. don't use views, it generates bad plans. 2. The optimizer is not very smart, so in 10-25% of your queries you have the specify the correct plan. But it's stable, fast and free. I've employed it with Delphi clients and FreeBSD as server with excellent results. Groetjes, Berend. (-: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Dec 27 1:42:23 1999 Delivered-To: freebsd-database@freebsd.org Received: from smtp1.xs4all.nl (smtp1.xs4all.nl [194.109.127.48]) by hub.freebsd.org (Postfix) with ESMTP id 620691521E for ; Mon, 27 Dec 1999 01:42:17 -0800 (PST) (envelope-from berend@pobox.com) Received: from auke.nederware.nl (nederware.nl [194.109.55.62]) by smtp1.xs4all.nl (8.9.3/8.9.3) with ESMTP id KAA17595; Mon, 27 Dec 1999 10:42:15 +0100 (CET) Received: from bmach (bmach.nederware.nl [192.168.33.3]) by auke.nederware.nl (8.8.8/8.8.8) with SMTP id KAA07919; Mon, 27 Dec 1999 10:36:56 +0100 (CET) (envelope-from berend@pobox.com) From: "Berend de Boer" To: "'Marc G. Fournier'" Cc: Subject: RE: What database i can use? Date: Mon, 27 Dec 1999 10:36:52 +0100 Message-ID: <002501bf504d$e917faf0$0321a8c0@bmach.nederware.nl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 In-reply-to: Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > JOIN statement? I take it that this is different then: > > SELECT a.field1, b.field2 from table1 a, table2 b where a.key = b.key ANSI92 supports the far better readable JOIN statement: select a.field1, b.field2 from table1 a join table2 b on a.key = b.key Left outer joins are now easy to: select a.field1, b.field2 from table1 a left outer join table2 b on a.key = b.key It generally parses and optimizes faster too. For MS SQL Server I've seen improvements of up to 75% percent: execution time was the same, but the plan was calculated much faster. Groetjes, Berend. (-: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Dec 27 6:44: 2 1999 Delivered-To: freebsd-database@freebsd.org Received: from carlton.innotts.co.uk (carlton.innotts.co.uk [212.56.32.2]) by hub.freebsd.org (Postfix) with ESMTP id B582F14F68 for ; Mon, 27 Dec 1999 06:43:55 -0800 (PST) (envelope-from robmel@nadt.org.uk) Received: from muffin.highwire.local (pool-1-p16.innotts.co.uk [212.56.33.16]) by carlton.innotts.co.uk (8.9.3/8.9.3) with ESMTP id OAA05199; Mon, 27 Dec 1999 14:43:52 GMT Received: from [172.16.17.20] (robsmac.highwire.local [172.16.17.20]) by muffin.highwire.local (8.9.3/8.9.3) with ESMTP id OAA01000; Mon, 27 Dec 1999 14:30:44 GMT (envelope-from robmel@nadt.org.uk) Mime-Version: 1.0 X-Sender: robmel@mailhost Message-Id: In-Reply-To: <199912261336.IAA66179@whizzo.transsys.com> References: <199912261336.IAA66179@whizzo.transsys.com> Date: Mon, 27 Dec 1999 14:31:02 +0000 To: "Louis A. Mamakos" From: Robin Melville Subject: Re: What database i can use? Cc: Gabor Esperon , freebsd-database@FreeBSD.ORG Content-Type: text/plain; charset="us-ascii" ; format="flowed" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk At 8:36 am -0500 26/12/99, Louis A. Mamakos wrote: > > >I need a good database server in my network, under > > >FreeBSD 3.3 > > > > > >What is recommended: Oracle, MySQL, PostgreSQL or > > >another? > > > > Previous responses by others are reasonable, although MySQL is better > > than Berend de Boer said for quick and effective apps using many > > accesses - few (and not too complex) updates. > >I'm using MySQL for a couple of applications on my FreeBSD home >automation system [...] the transactions are generally pretty simple >with lots of inserts [...] Yes, sorry, I should have been more explicit... MySQL is very fast, but less good where you have many multi-user updates, particularly across multiple tables. It has only one write thread, although many read threads. Also, because it lacks row-level locking & transaction/rollback it's necessary to use table level write locks to achieve atomic write consistency unless you can absolutely guarantee cooperative application-level access control (ie. you never use the general MySQL client or non-cooperative applications to update/insert while running multiuser). Regards Robin. ---------------------------------------------------------------------- Robin Melville, Addiction Information Service Nottingham Alcohol & Drug Team Tel: +44 (0)115 952 9478 Fax: +44 (0)115 952 9421 work: robmel@nadt.org.uk Pages: http://www.nadt.org.uk/ ---------------------------------------------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 31 22:14:10 1999 Delivered-To: freebsd-database@freebsd.org Received: from mail.rdc1.nj.home.com (ha1.rdc1.nj.home.com [24.3.128.66]) by hub.freebsd.org (Postfix) with ESMTP id CEA0214CCD for ; Fri, 31 Dec 1999 22:13:55 -0800 (PST) (envelope-from damascus@eden.rutgers.edu) Received: from damascus ([24.3.219.36]) by mail.rdc1.nj.home.com (InterMail v4.01.01.00 201-229-111) with ESMTP id <20000101061349.NNNS18367.mail.rdc1.nj.home.com@damascus> for ; Fri, 31 Dec 1999 22:13:49 -0800 Message-Id: <4.2.2.20000101010952.039bcd50@email.eden.rutgers.edu> X-Sender: damascus@email.eden.rutgers.edu X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.2 Date: Sat, 01 Jan 2000 01:14:50 -0500 To: freebsd-database@FreeBSD.ORG From: Carroll Kong Subject: Re: Oracle for Linux in FreeBSD problems? In-Reply-To: References: <199912261336.IAA66179@whizzo.transsys.com> <199912261336.IAA66179@whizzo.transsys.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Sorry to bother everyone with this, but I tried a lot of different tricks and nothing seemed to work. After installing oracle for linux 8.0.5 under freebsd 3.3-stable, I tried to create my own database. (I did not let the install make database objects for me). After going into svrmgrl and starting up an instance without mounting, and then creating my own DB. I tried running sqlplus and I got this error message. I just ran sqlplus and waited for the prompts. Enter user-name: system Enter password: ERROR: ORA-06553: PLS-213: package STANDARD not accessible Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-06553: PLS-213: package STANDARD not accessible Connected to: Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.5.1.0 - Production SQL> Also, for some odd reason, if I try to reinstall oracle for linux 8.0.5 with the new redhat 6.1 development port, when I run sqlplus, it says the TNS listener is not listening (even after relinking it!). However, if I have the old 5.2 redhat base installed, try to install, then watch it fail the link, then use the 6.1 port and relink manually, it works!?!? I tried it using two different machines. So, basically this got me to wonder, if this is normal? (this sqlplus error?). If they avoided it, can you please tell me which redhat setups you have? I only have the linux_base 6.1 and linux_devtools 5.2..... i guess it's a bad idea that they are split, but I ran into problems getting the linux_devtools 6.1 patch going. Anyway, does it work if you have both 6.1 on base and devel? Or am I the only one with this problem? Thanks a lot in advance! -Carroll Kong To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message