From owner-freebsd-database Sun Nov 19 12:54:24 2000 Delivered-To: freebsd-database@freebsd.org Received: from smtp4.libero.it (smtp4.libero.it [193.70.192.54]) by hub.freebsd.org (Postfix) with ESMTP id 4B7A037B479 for ; Sun, 19 Nov 2000 12:54:22 -0800 (PST) Received: from parkinson.it (151.20.62.185) by smtp4.libero.it; 19 Nov 2000 21:54:10 +0100 Message-ID: <3A183DF1.39CE2462@parkinson.it> Date: Sun, 19 Nov 2000 21:54:09 +0100 From: Gianluca Sordiglioni X-Mailer: Mozilla 4.72 [en] (X11; I; FreeBSD 4.2-BETA i386) X-Accept-Language: it, en MIME-Version: 1.0 To: freebsd-database@freebsd.org Subject: Which ODBC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG How unixODBC compares to myODBC? Thank you. Luke To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Nov 19 14: 1:51 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id CCDD737B4C5 for ; Sun, 19 Nov 2000 14:01:48 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13xbqk-0002eZ-00; Sun, 19 Nov 2000 13:18:10 -0800 Date: Sun, 19 Nov 2000 13:18:07 -0800 (PST) From: Tom Samplonius To: Gianluca Sordiglioni Cc: freebsd-database@freebsd.org Subject: Re: Which ODBC In-Reply-To: <3A183DF1.39CE2462@parkinson.it> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Sun, 19 Nov 2000, Gianluca Sordiglioni wrote: > How unixODBC compares to myODBC? > Thank you. They are not really comparable. unixODBC is a ODBC driver manager. myODBC is the ODBC driver for MySQL. > Luke Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Nov 19 14:48:39 2000 Delivered-To: freebsd-database@freebsd.org Received: from smtp3.libero.it (smtp3.libero.it [193.70.192.53]) by hub.freebsd.org (Postfix) with ESMTP id 7D52F37B479 for ; Sun, 19 Nov 2000 14:48:37 -0800 (PST) Received: from parkinson.it (151.20.60.172) by smtp3.libero.it; 19 Nov 2000 23:48:33 +0100 Message-ID: <3A1858C0.704A2EBB@parkinson.it> Date: Sun, 19 Nov 2000 23:48:32 +0100 From: Gianluca Sordiglioni X-Mailer: Mozilla 4.72 [en] (X11; I; FreeBSD 4.2-BETA i386) X-Accept-Language: it, en MIME-Version: 1.0 To: freebsd-database@freebsd.org Subject: Re: Which ODBC References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Tom Samplonius wrote: > They are not really comparable. unixODBC is a ODBC driver manager. > myODBC is the ODBC driver for MySQL. Mmm... ok. I tried to compile PostgreSQL 7 and it crashes in the odbc files under FreeBSD 4.2BETA. So PostgreSQL uses its own ODBC driver manager? I don't see any dipendencies to unixODBC, but do you think I should deinstall unixODBC first? Luke To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Nov 19 22:43:25 2000 Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id 60E3F37B479 for ; Sun, 19 Nov 2000 22:43:12 -0800 (PST) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id eAK6ZOv73552; Mon, 20 Nov 2000 12:35:24 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Mon, 20 Nov 2000 12:35:24 +0600 (NS) From: Max Khon To: Tom Samplonius Cc: Calvin , freebsd-database@FreeBSD.ORG, posonsky@braz.ru Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Fri, 17 Nov 2000, Tom Samplonius wrote: > > We are running Oracle database 8.1.6.2.1 in Sun Solaris and C programs at > > FreeBSD platform need to access the database thru OCI. We knew from Oracle > > Support that we have to install Oracle client software with libs in the > > client side in order to have C programs connect to the database using OCI. > > However, Oracle doesn't support FreeBSD platform. Is there anyone running > > OCI freebsd program to access db, or anyone setup the Oracle client software > > 8.1.6 in FreeBSD 4.02-Stable? > > There are a few options and none of them is very appealing: > > - Use the Linux OCI driver and compile all your applications are Linux > binaries and run them on FreeBSD under emulation. > > - Use the request broker from Openlink Software > (http://www.opelinksw.com). It should be free for up to two connections. > Basically, your FreeBSD application must be able to support ODBC. > Openlink providers a ODBC driver for FreeBSD and a request broker that can > be run on your database server (or anywhere else that a native Oracle > interface is available). The Openlink ODBC driver will connect to the > request broker, and the broker to Oracle. This will not work if your app > does not use an ODBC interface and requires the propietary Oracle OCI > API. > > - Re-write your app in Java. Type 4 JDBC drivers are truly OS > independant and work on any system with a JVM. There are native OCI (aout) libraries out there: ftp://www.kuzbass.ru/pub/freebsd/oracle/oracle7.client.OCI.tar.gz /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Nov 19 23:14:46 2000 Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id ED1DA37B479 for ; Sun, 19 Nov 2000 23:14:39 -0800 (PST) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id eAK7CWE74994; Mon, 20 Nov 2000 13:12:32 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Mon, 20 Nov 2000 13:12:32 +0600 (NS) From: Max Khon To: Tom Samplonius Cc: Calvin , freebsd-database@FreeBSD.ORG, posonsky@braz.ru Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Mon, 20 Nov 2000, Max Khon wrote: > There are native OCI (aout) libraries out there: > ftp://www.kuzbass.ru/pub/freebsd/oracle/oracle7.client.OCI.tar.gz ahem, sorry, ELF libraries /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Nov 19 23:50: 8 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 014FC37B479 for ; Sun, 19 Nov 2000 23:49:01 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13xkmA-00036N-00; Sun, 19 Nov 2000 22:50:02 -0800 Date: Sun, 19 Nov 2000 22:48:01 -0800 (PST) From: Tom Samplonius To: Max Khon Cc: Calvin , freebsd-database@FreeBSD.ORG, posonsky@braz.ru Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Mon, 20 Nov 2000, Max Khon wrote: > There are native OCI (aout) libraries out there: > ftp://www.kuzbass.ru/pub/freebsd/oracle/oracle7.client.OCI.tar.gz That is amazing. Now since I'm not downloading these from Oracle, I kinda wondering where they came from. I know that Oracle was playing with FreeBSD a few years ago as a potentional embedded OS. I understand that Oracle was ported at that time, but never released... > /fjoe Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Nov 20 9:55:19 2000 Delivered-To: freebsd-database@freebsd.org Received: from pefw00.ivmg.net (pefw00-gblx.ivmg.net [64.209.84.66]) by hub.freebsd.org (Postfix) with ESMTP id 0819A37B4CF for ; Mon, 20 Nov 2000 09:55:17 -0800 (PST) Received: from pimx00.ivmg.net (pimx00.ivmg.net [192.168.0.10]) by pefw00.ivmg.net (iVMG) with ESMTP id eAKHtGQ69295; Mon, 20 Nov 2000 17:55:16 GMT Received: from ibm300pl0002 (iVMG-192-168-0-141.dhcp.ivmg.net [192.168.0.141]) by pimx00.ivmg.net (iVMG) with SMTP id eAKHtFc15683; Mon, 20 Nov 2000 09:55:15 -0800 From: "Calvin" To: "Max Khon" , "Tom Samplonius" Cc: Subject: RE: How to run OCI FreeBSD Program to access Oracle database? Date: Mon, 20 Nov 2000 09:57:21 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal In-Reply-To: Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi there, >ahem, sorry, ELF libraries What do you mean? do you mean it's a wrong libraries? Calvin To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Nov 20 11:51:19 2000 Delivered-To: freebsd-database@freebsd.org Received: from c017.sfo.cp.net (c017-h014.c017.sfo.cp.net [209.228.12.228]) by hub.freebsd.org (Postfix) with SMTP id 95F4A37B479 for ; Mon, 20 Nov 2000 11:51:16 -0800 (PST) Received: (cpmta 14476 invoked from network); 20 Nov 2000 11:51:15 -0800 Received: from dhcp239.ratexchange.net (HELO filip) (63.201.151.239) by smtp.pakana.com (209.228.12.228) with SMTP; 20 Nov 2000 11:51:15 -0800 X-Sent: 20 Nov 2000 19:51:15 GMT Reply-To: From: "Filip Hanik" To: Subject: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? Date: Mon, 20 Nov 2000 11:50:29 -0800 Message-ID: <002401c0532b$22b65e10$ef97c93f@pakana.com> 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 CWS, Build 9.0.2416 (9.0.2910.0) In-Reply-To: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Any thoughts on PostgreSQL? Filip Filip Hanik Technical Architect Pakana Corporation fhanik@pakana.com 415-371 9200 ext 3529 -----Original Message----- From: owner-freebsd-database@FreeBSD.ORG [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of Tom Samplonius Sent: Wednesday, November 15, 2000 8:29 PM To: Nicole Harrington Cc: freebsd-database@freebsd.org Subject: Re: Which is Better for MySQL FreeBSD or BSDi? On Wed, 15 Nov 2000, Nicole Harrington wrote: > Well in the hope that this list is not dead... > > My question> for running MySql, which would be better, FreeBSD or BSDi? > > I Thought I had heard that BSDi would be better. > > Any opinions, thoughts? > > > Nicole I think FreeBSD is better supported by MySQL. However, you should probably direct this to the MySQL developers. I have a 2GB MySQL database under FreeBSD 3.x. It works ok. MySQL's table-locking stinks, but that isn't an OS issue. If I was going to start again, I wouldn't use MySQL because of the table-locking issues. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Nov 20 14:19:35 2000 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (CDR22-173.accesscable.net [24.138.22.173]) by hub.freebsd.org (Postfix) with ESMTP id C9D7937B479 for ; Mon, 20 Nov 2000 14:19:30 -0800 (PST) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.11.1/8.11.1) with ESMTP id eAKMJ6V14637; Mon, 20 Nov 2000 18:19:06 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Mon, 20 Nov 2000 18:19:06 -0400 (AST) From: The Hermit Hacker To: Filip Hanik Cc: freebsd-database@FreeBSD.ORG Subject: Re: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? In-Reply-To: <002401c0532b$22b65e10$ef97c93f@pakana.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Mon, 20 Nov 2000, Filip Hanik wrote: > Any thoughts on PostgreSQL? Not sure what you are looking for here ... Tim Perdue @ PHPBuilder found that they hit scalability issues with MySQL, and is switching to either PgSQL or Oracle ... last I heard, PgSQL won out, but don't quote me on that ... He wrote an article on it available at the following URL: http://www.phpbuilder.com/columns/tim20001112.php3 Basically, they found that once you hit ~5 simultaneous connections, performance of MySQL nose-dived, whereas the same test on PgSQL peaked and flattened out ... My theory is that in most cases where MySQL users are talking about how well it performs, they are dealing with very low hit sites where the database isn't having to deal with heavy traffic, so its more an 'SQL over flatfile' situation :( > Filip Hanik > Technical Architect > Pakana Corporation > fhanik@pakana.com > 415-371 9200 ext 3529 > > > -----Original Message----- > From: owner-freebsd-database@FreeBSD.ORG > [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of Tom Samplonius > Sent: Wednesday, November 15, 2000 8:29 PM > To: Nicole Harrington > Cc: freebsd-database@freebsd.org > Subject: Re: Which is Better for MySQL FreeBSD or BSDi? > > > > On Wed, 15 Nov 2000, Nicole Harrington wrote: > > > Well in the hope that this list is not dead... > > > > My question> for running MySql, which would be better, FreeBSD or BSDi? > > > > I Thought I had heard that BSDi would be better. > > > > Any opinions, thoughts? > > > > > > Nicole > > I think FreeBSD is better supported by MySQL. However, you should > probably direct this to the MySQL developers. > > I have a 2GB MySQL database under FreeBSD 3.x. It works ok. MySQL's > table-locking stinks, but that isn't an OS issue. If I was going to start > again, I wouldn't use MySQL because of the table-locking issues. > > Tom > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Nov 20 16:13:27 2000 Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id B443B37B4C5 for ; Mon, 20 Nov 2000 16:13:17 -0800 (PST) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id eAL0C2b10293; Tue, 21 Nov 2000 06:12:13 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Tue, 21 Nov 2000 06:12:01 +0600 (NS) From: Max Khon To: Calvin Cc: Tom Samplonius , freebsd-database@FreeBSD.ORG Subject: RE: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Mon, 20 Nov 2000, Calvin wrote: > >ahem, sorry, ELF libraries > > What do you mean? do you mean it's a wrong libraries? no /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Nov 20 20:32:39 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 813AE37B4CF for ; Mon, 20 Nov 2000 20:32:35 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13y4Ov-0004a3-00; Mon, 20 Nov 2000 19:47:21 -0800 Date: Mon, 20 Nov 2000 19:47:20 -0800 (PST) From: Tom Samplonius To: Max Khon Cc: Calvin , freebsd-database@FreeBSD.ORG Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Mon, 20 Nov 2000, Max Khon wrote: > hi, there! > > On Mon, 20 Nov 2000, Max Khon wrote: > > > There are native OCI (aout) libraries out there: > > ftp://www.kuzbass.ru/pub/freebsd/oracle/oracle7.client.OCI.tar.gz > > ahem, sorry, ELF libraries Are you sure they are ELF? After grabbing this, all I see are *.a files, which I believe are neither ELF or aout. I don't see any shared libraries (*.so). I know for certain that shared libraries are aout and ELF specific, but I don't think *.a files are. For everyone else, the above file seems to contain a snapshot of the client libs for FreeBSD taken from an Oracle 7.3.2 system. No FreeBSD version of SQL*Plus though. Lots of messages files and *.sql files which are useless without the server binaries though. The log subdirectory contains a log file. Presumably the log file of the server this snapshot was made from! > /fjoe Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Nov 20 20:49:56 2000 Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id 511C437B4C5 for ; Mon, 20 Nov 2000 20:49:30 -0800 (PST) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id eAL4lNY18186; Tue, 21 Nov 2000 10:47:23 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Tue, 21 Nov 2000 10:47:23 +0600 (NS) From: Max Khon To: Tom Samplonius Cc: Calvin , freebsd-database@FreeBSD.ORG Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Mon, 20 Nov 2000, Tom Samplonius wrote: > > > There are native OCI (aout) libraries out there: > > > ftp://www.kuzbass.ru/pub/freebsd/oracle/oracle7.client.OCI.tar.gz > > > > ahem, sorry, ELF libraries > > Are you sure they are ELF? After grabbing this, all I see are *.a > files, which I believe are neither ELF or aout. I don't see any shared > libraries (*.so). I know for certain that shared libraries are aout and > ELF specific, but I don't think *.a files are. yes. .o files in archives have ELF header and symbols do not have leading underscores > For everyone else, the above file seems to contain a snapshot of the > client libs for FreeBSD taken from an Oracle 7.3.2 system. No FreeBSD > version of SQL*Plus though. Lots of messages files and *.sql files which > are useless without the server binaries though. The log subdirectory > contains a log file. Presumably the log file of the server this snapshot > was made from! sorry, I do not maintain that site. I can put libraries-only tarball (it's about only 2M) available for download. I think those libraries were made by converting SCO Oracle 7 libraries (COFF/i386) to ELF format /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 21 7:51:12 2000 Delivered-To: freebsd-database@freebsd.org Received: from alpha.netaccess.on.ca (alpha.netaccess.on.ca [199.243.225.10]) by hub.freebsd.org (Postfix) with ESMTP id 4460437B4FE for ; Tue, 21 Nov 2000 07:51:06 -0800 (PST) Received: from schizo.controlq.com (dial080.nas.net [207.176.144.80]) by alpha.netaccess.on.ca (8.9.0/8.9.0) with ESMTP id KAA28528; Tue, 21 Nov 2000 10:50:58 -0500 (EST) Date: Tue, 21 Nov 2000 10:56:59 -0500 (EST) From: "Robert S. Sciuk" To: Filip Hanik Cc: freebsd-database@FreeBSD.ORG Subject: Re: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? In-Reply-To: <002401c0532b$22b65e10$ef97c93f@pakana.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Mon, 20 Nov 2000, Filip Hanik wrote: > Any thoughts on PostgreSQL? > > Filip > > Filip Hanik > Technical Architect > Pakana Corporation > fhanik@pakana.com > 415-371 9200 ext 3529 Yes, and they are all good. PostgreSQL is shaping up into a useful and scalable dbms. Given the features, the additional setup required is worth it, and the security is better (flexible). I've had very few problems, and a great deal of success with it. Msql and Mysql have dropped off the map as far as I'm concerned. Cheers, R. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 21 8:42: 2 2000 Delivered-To: freebsd-database@freebsd.org Received: from cc677580-a.sumt1.nj.home.com (cc677580-a.sumt1.nj.home.com [24.180.22.57]) by hub.freebsd.org (Postfix) with ESMTP id 6275E37B4CF for ; Tue, 21 Nov 2000 08:41:59 -0800 (PST) Received: from localhost (squirk@localhost) by cc677580-a.sumt1.nj.home.com (8.11.0/8.11.0) with ESMTP id eALGaZ728018; Tue, 21 Nov 2000 11:36:35 -0500 (EST) (envelope-from squirk@home.com) Date: Tue, 21 Nov 2000 11:35:15 -0500 (EST) From: Steve Quirk X-Sender: squirk@cc677580-a.sumt1.nj.home.com To: Max Khon Cc: freebsd-database@FreeBSD.ORG Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Now I'm confused. Are these native FreeBSD libraries or are they for SCO and need to be run with IBCS emulation (or whatever)? What was the process for "converting" them from COFF to ELF and does this remove any SCO dependencies? What's the origin of these? Did Oracle ever support FreeBSD? Thanks, Steve On Tue, 21 Nov 2000, Max Khon wrote: > hi, there! > > On Mon, 20 Nov 2000, Tom Samplonius wrote: > > > > > There are native OCI (aout) libraries out there: > > > > ftp://www.kuzbass.ru/pub/freebsd/oracle/oracle7.client.OCI.tar.gz > > > > > > ahem, sorry, ELF libraries > > > > Are you sure they are ELF? After grabbing this, all I see are *.a > > files, which I believe are neither ELF or aout. I don't see any shared > > libraries (*.so). I know for certain that shared libraries are aout and > > ELF specific, but I don't think *.a files are. > > yes. .o files in archives have ELF header and symbols do not have > leading underscores > > > For everyone else, the above file seems to contain a snapshot of the > > client libs for FreeBSD taken from an Oracle 7.3.2 system. No FreeBSD > > version of SQL*Plus though. Lots of messages files and *.sql files which > > are useless without the server binaries though. The log subdirectory > > contains a log file. Presumably the log file of the server this snapshot > > was made from! > > sorry, I do not maintain that site. > I can put libraries-only tarball (it's about only 2M) available for > download. I think those libraries were made by converting SCO Oracle 7 > libraries (COFF/i386) to ELF format > > /fjoe > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 21 10:14:53 2000 Delivered-To: freebsd-database@freebsd.org Received: from pefw00.ivmg.net (pefw00-gblx.ivmg.net [64.209.84.66]) by hub.freebsd.org (Postfix) with ESMTP id 039D137B4D7 for ; Tue, 21 Nov 2000 10:14:52 -0800 (PST) Received: from pimx00.ivmg.net (pimx00.ivmg.net [192.168.0.10]) by pefw00.ivmg.net (iVMG) with ESMTP id eALIEgQ73201; Tue, 21 Nov 2000 18:14:47 GMT Received: from ibm300pl0002 (iVMG-192-168-0-141.dhcp.ivmg.net [192.168.0.141]) by pimx00.ivmg.net (iVMG) with SMTP id eALIEZc11521; Tue, 21 Nov 2000 10:14:35 -0800 From: "Calvin" To: "Max Khon" , "Tom Samplonius" Cc: Subject: RE: How to run OCI FreeBSD Program to access Oracle database? Date: Tue, 21 Nov 2000 10:16:43 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal In-Reply-To: Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG >sorry, I do not maintain that site. >I can put libraries-only tarball (it's about only 2M) available for >download. I think those libraries were made by converting SCO Oracle 7> >libraries (COFF/i386) to ELF format Can you pls let me know how I can download it? thanx. -Calvin To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 21 10:27:48 2000 Delivered-To: freebsd-database@freebsd.org Received: from sampnt500.avantgo.com (unknown [209.220.59.68]) by hub.freebsd.org (Postfix) with ESMTP id 4756437B479 for ; Tue, 21 Nov 2000 10:27:46 -0800 (PST) Received: by sampnt500.avantgo.com with Internet Mail Service (5.5.2650.21) id ; Tue, 21 Nov 2000 10:28:38 -0800 Received: from river.avantgo.com ([10.1.30.114]) by sampnt500.avantgo.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id W0LZ2X14; Tue, 21 Nov 2000 10:28:27 -0800 From: Scott Hess To: The Hermit Hacker Cc: Filip Hanik , freebsd-database@FreeBSD.ORG Date: Tue, 21 Nov 2000 10:32:29 -0800 (PST) Subject: Re: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Mon, 20 Nov 2000, The Hermit Hacker wrote: > My theory is that in most cases where MySQL users are talking about how > well it performs, they are dealing with very low hit sites where the > database isn't having to deal with heavy traffic, so its more an 'SQL > over flatfile' situation :( I know of at least one high-volume site running MySQL on FreeBSD... it did require a fair bit of tuning, such as moving most blobs out of MySQL and into a simple external solution. Also, we run with multiple mysqld against the same tables, because FreeBSD3.x's pthread library is suboptimal for apps with heavy disk I/O (disk I/O's are always ready, and userland pthreads rely heavily on non-blocking I/O working). During peak times, we have well over 1000 db connections on a single box, split across 8 mysqld. Not all connections are running a query at any give time, of course, but certainly more than 5 :-). Later, scott To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 21 23: 5:35 2000 Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id 0CA9E37B4D7 for ; Tue, 21 Nov 2000 23:05:29 -0800 (PST) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id eAM747c70311; Wed, 22 Nov 2000 13:04:12 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Wed, 22 Nov 2000 13:04:05 +0600 (NS) From: Max Khon To: Steve Quirk Cc: freebsd-database@FreeBSD.ORG Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Tue, 21 Nov 2000, Steve Quirk wrote: > Are these native FreeBSD libraries or are they for SCO and need to be run > with IBCS emulation (or whatever)? What was the process for > "converting" them from COFF to ELF and does this remove any SCO > dependencies? > > What's the origin of these? Did Oracle ever support FreeBSD? native FreeBSD libraries. Oracle never supported FreeBSD officially. /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Nov 22 0:26:28 2000 Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id 35F7337B4CF for ; Wed, 22 Nov 2000 00:25:54 -0800 (PST) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id eAM8JmF72769; Wed, 22 Nov 2000 14:20:04 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Wed, 22 Nov 2000 14:19:47 +0600 (NS) From: Max Khon To: Calvin Cc: Tom Samplonius , freebsd-database@FreeBSD.ORG Subject: RE: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Tue, 21 Nov 2000, Calvin wrote: > >sorry, I do not maintain that site. > >I can put libraries-only tarball (it's about only 2M) available for > >download. I think those libraries were made by converting SCO Oracle 7> > >libraries (COFF/i386) to ELF format > > Can you pls let me know how I can download it? thanx. ftp://iclub.nsu.ru/pub/FreeBSD/incoming/OCI.freebsd.elf.tar.gz /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Nov 22 4:59:25 2000 Delivered-To: freebsd-database@freebsd.org Received: from spammie.svbug.com (mg134-015.ricochet.net [204.179.134.15]) by hub.freebsd.org (Postfix) with ESMTP id BAD8037B4C5 for ; Wed, 22 Nov 2000 04:59:21 -0800 (PST) Received: from spammie.svbug.com (localhost.mozie.org [127.0.0.1]) by spammie.svbug.com (8.9.3/8.9.3) with ESMTP id EAA00448; Wed, 22 Nov 2000 04:58:28 -0800 (PST) (envelope-from jessem@spammie.svbug.com) Message-Id: <200011221258.EAA00448@spammie.svbug.com> Date: Wed, 22 Nov 2000 04:58:27 -0800 (PST) From: opentrax@email.com Reply-To: opentrax@email.com Subject: Re: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? To: rob@ControlQ.com Cc: freebsd-database@freebsd.org In-Reply-To: MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 21 Nov, Robert S. Sciuk wrote: > On Mon, 20 Nov 2000, Filip Hanik wrote: > >> Any thoughts on PostgreSQL? >> >> Filip >> >> Filip Hanik >> Technical Architect >> Pakana Corporation >> fhanik@pakana.com >> 415-371 9200 ext 3529 > > Yes, and they are all good. PostgreSQL is shaping up into a useful and > scalable dbms. Given the features, the additional setup required is worth > it, and the security is better (flexible). I've had very few problems, > and a great deal of success with it. Msql and Mysql have dropped off the > map as far as I'm concerned. > I disagree. Mysql continues to improve, making sure their product still lives within their definition. If it's not to your liking and PostgreSQL I don't think anyone would have issue with that. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message