From owner-freebsd-database Sun Jan 25 03:10:11 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id DAA00705 for database-outgoing; Sun, 25 Jan 1998 03:10:11 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from ns.cityip.co.za (ns.cityip.co.za [196.25.205.129]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id DAA00653 for ; Sun, 25 Jan 1998 03:09:58 -0800 (PST) (envelope-from wjv@cityip.co.za) Received: from localhost.cityip.co.za [127.0.0.1] by ns.cityip.co.za with esmtp (Exim 1.71 #1) id 0xwPwW-0001Y3-00; Sun, 25 Jan 1998 13:09:36 +0200 To: freebsd-database@FreeBSD.ORG Subject: mSQL "losing" data? X-Mailer: MH 6.8.4 X-PGP: ftp://ftp.cityip.co.za/users/wjv/pubkey.asc X-URL: http://www.cityip.co.za/~wjv/ Date: Sun, 25 Jan 1998 13:09:36 +0200 From: Johann Visagie Message-Id: Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi there, Has anyone else had the experience that MiniSQL 2.0.1 (as installed from the ports collection, running on 2.2.1-RELEASE) has a tendency to "lose" chunks of data between restarts? It is as if some disk writes are simply not committed, leaving the data in one or more tables incomplete. I was evaluating MiniSQL for a commercial application - its simplicity was its major advantage over, say, Postgres. But since it seems to have these sort of holes in it, I'm currently porting everything over to MySQL. -- V Johann Visagie | Email: wjv@CityIP.co.za | Tel: +27 21 75-1317 From owner-freebsd-database Sun Jan 25 11:34:38 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA07943 for database-outgoing; Sun, 25 Jan 1998 11:34:38 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from pop.uniserve.com (pop.uniserve.com [204.244.156.3]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id LAA07938 for ; Sun, 25 Jan 1998 11:34:37 -0800 (PST) (envelope-from tom@uniserve.com) Received: from shell.uniserve.com [204.244.186.218] by pop.uniserve.com with smtp (Exim 1.73 #1) id 0xwXp3-0003lj-00; Sun, 25 Jan 1998 11:34:25 -0800 Date: Sun, 25 Jan 1998 11:34:24 -0800 (PST) From: Tom To: Johann Visagie cc: freebsd-database@FreeBSD.ORG Subject: Re: mSQL "losing" data? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sun, 25 Jan 1998, Johann Visagie wrote: > Hi there, > > Has anyone else had the experience that MiniSQL 2.0.1 (as installed from the mSQL 2.0.1 is old and simply should not be used. mSQL 2.0.3 is current and stable. Tom From owner-freebsd-database Mon Jan 26 17:39:44 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA10903 for database-outgoing; Mon, 26 Jan 1998 17:39:44 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from lint.cisco.com (lint.cisco.com [171.68.223.44]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id RAA10897 for ; Mon, 26 Jan 1998 17:39:41 -0800 (PST) (envelope-from skrishna@cisco.com) Received: from localhost (skrishna@localhost) by lint.cisco.com (8.8.5/CISCO.SERVER.1.2) with SMTP id RAA16581 for ; Mon, 26 Jan 1998 17:39:11 -0800 (PST) Date: Mon, 26 Jan 1998 17:39:10 -0800 (PST) From: SRIDHAR KRISHNAN To: freebsd-database@FreeBSD.ORG Subject: Which SQL Database for Web Applications ? Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Are there any docs /experiences comparing freeware databases available on FreeBSD like mSQL, mysql, postgreSQL, Berkeley DB, typhoon etc. Looking for support Perl5::dbi modules, maintain good data integrity and about 10-15 users. Any thoughts ? -- Sridhar From owner-freebsd-database Mon Jan 26 17:56:46 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA13102 for database-outgoing; Mon, 26 Jan 1998 17:56:46 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from saba.kuentos.guam.net (pkelly@saba.kuentos.guam.net [198.81.233.14]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id RAA13096 for ; Mon, 26 Jan 1998 17:56:42 -0800 (PST) (envelope-from pkelly@saba.kuentos.guam.net) Received: (from pkelly@localhost) by saba.kuentos.guam.net (8.8.6/8.8.6) id MAA02059; Tue, 27 Jan 1998 12:08:02 +1000 (GST) Date: Tue, 27 Jan 1998 12:08:02 +1000 (GST) From: Patrick Kelly To: SRIDHAR KRISHNAN cc: freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I was using (briefly) postgreSQL, but got frustrated with the limited SQL. Now I'm using Solid (not free). I've committed to it (ie paid license fees), but havn't used it enough to really give a qualified opinion. patrick On Mon, 26 Jan 1998, SRIDHAR KRISHNAN wrote: > Date: Mon, 26 Jan 1998 17:39:10 -0800 (PST) > From: SRIDHAR KRISHNAN > To: freebsd-database@FreeBSD.ORG > Subject: Which SQL Database for Web Applications ? > > Are there any docs /experiences comparing freeware databases available on > FreeBSD like mSQL, mysql, postgreSQL, Berkeley DB, typhoon etc. Looking > for support Perl5::dbi modules, maintain good data integrity and about > 10-15 users. > > Any thoughts ? > > -- Sridhar > > From owner-freebsd-database Mon Jan 26 18:32:43 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id SAA17794 for database-outgoing; Mon, 26 Jan 1998 18:32:43 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from pop.uniserve.com (pop.uniserve.com [204.244.156.3]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id SAA17787 for ; Mon, 26 Jan 1998 18:32:41 -0800 (PST) (envelope-from tom@uniserve.com) Received: from shell.uniserve.com [204.244.186.218] by pop.uniserve.com with smtp (Exim 1.73 #1) id 0xx0pC-00024x-00; Mon, 26 Jan 1998 18:32:30 -0800 Date: Mon, 26 Jan 1998 18:32:27 -0800 (PST) From: Tom To: Patrick Kelly cc: SRIDHAR KRISHNAN , freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 27 Jan 1998, Patrick Kelly wrote: > I was using (briefly) postgreSQL, but got frustrated with the limited SQL. > Now I'm using Solid (not free). I've committed to it (ie paid license > fees), but havn't used it enough to really give a qualified opinion. > > patrick Solid is nice. Of the free databases, PostgreSQL probably has the least limited SQL support though. Both mSQL and MySQL lacked all kinds of things that PostgreSQL does. I belive that Solid is the only SQL database for FreeBSD that offers logging and automatic crash recovery. Only Solid and PostgreSQL provide support for transactions. Tom From owner-freebsd-database Mon Jan 26 19:22:54 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA22733 for database-outgoing; Mon, 26 Jan 1998 19:22:54 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (tc-48.acadiau.ca [131.162.2.148]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id TAA22723 for ; Mon, 26 Jan 1998 19:22:43 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.8.8/8.8.2) with SMTP id XAA13572; Mon, 26 Jan 1998 23:20:14 -0400 (AST) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Mon, 26 Jan 1998 23:20:14 -0400 (AST) From: The Hermit Hacker To: Patrick Kelly cc: SRIDHAR KRISHNAN , freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 27 Jan 1998, Patrick Kelly wrote: > I was using (briefly) postgreSQL, but got frustrated with the limited SQL. Limited SQL? *raised eyebrows* What version were you using? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org From owner-freebsd-database Mon Jan 26 20:14:50 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA28045 for database-outgoing; Mon, 26 Jan 1998 20:14:50 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from pop.uniserve.com (pop.uniserve.com [204.244.156.3]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id UAA28038 for ; Mon, 26 Jan 1998 20:14:44 -0800 (PST) (envelope-from tom@uniserve.com) Received: from shell.uniserve.com [204.244.186.218] by pop.uniserve.com with smtp (Exim 1.73 #1) id 0xx2Py-0002uu-00; Mon, 26 Jan 1998 20:14:34 -0800 Date: Mon, 26 Jan 1998 20:14:30 -0800 (PST) From: Tom To: freebsd-database@FreeBSD.ORG Subject: SOLID Server BETA Versions (fwd) Message-ID: MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="0-50297043-885874470=:29803" Content-ID: Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. --0-50297043-885874470=:29803 Content-Type: TEXT/PLAIN; CHARSET=iso-8859-1 Content-Transfer-Encoding: QUOTED-PRINTABLE Content-ID: This announcement was posted to the Solid mailing list, announcing a open BETA of the new FreeBSD port. FreeBSD pricing will be the same as Linux. You just need to get a license key to upgrade the evaluation copy to a full release. See http://www.solidtech.com Tom ---------- Forwarded message ---------- Date: Wed, 21 Jan 1998 22:47:26 +0200 From: Jouni Lahteenmaki Reply-To: solid-list@solidtech.com To: solid-list@solidtech.com Subject: SOLID Server BETA Versions The SOLID Server for FreeBSD 2.2.2 and for Solaris 2.5.1/2.6=20 have been in a controlled BETA program. We have received very good feedback and now the time seems ripe for their=20 release to a more general availability. FreeBSD 2.2.2=20 ------------- The BETA packages can be downloaded from our FTP site as: ftp://ftp.solidtech.com//pub/outgoing/bs22fbx.tar.gz (server) ftp://ftp.solidtech.com//pub/outgoing/bt22fbx.tar.gz (tools) SUN Solaris 2.5.1 / 2.6 ----------------------- The BETA packages can be downloaded from our FTP site as: ftp://ftp.solidtech.com//pub/outgoing/bs22ssx.tar.Z (server) ftp://ftp.solidtech.com//pub/outgoing/bt22ssx.tar.Z (tools) Controlled BETA programs are about to start for: - Multithreaded Linux (Linux 2.x + GNU libc 6.0) - Alpha Linux (single-threaded) Please let me know if you are interested to join these programs. - jouni - Solid Product Management --=20 J o u n i L =E4 h t e e n m =E4 k i Solid Information Technology Ltd Huovitie 3, FIN-00400 Helsinki, Finland Tel +358-9-4774 7340 Fax +358-9-4774 7390 Mobile +358-40-556 9114 mailto:jouni.lahteenmaki@solidtech.com http://www.solidtech.com --0-50297043-885874470=:29803-- From owner-freebsd-database Mon Jan 26 20:16:10 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA28290 for database-outgoing; Mon, 26 Jan 1998 20:16:10 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fxp0.Simon-Shapiro.ORG [206.190.148.34]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id UAA28275 for ; Mon, 26 Jan 1998 20:16:06 -0800 (PST) (envelope-from shimon@sendero-fxp0.simon-shapiro.org) Received: (qmail 26679 invoked by uid 1000); 27 Jan 1998 04:18:41 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-011998 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: Date: Mon, 26 Jan 1998 20:18:41 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: SRIDHAR KRISHNAN Subject: RE: Which SQL Database for Web Applications ? Cc: freebsd-database@FreeBSD.ORG Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 27-Jan-98 SRIDHAR KRISHNAN wrote: > Are there any docs /experiences comparing freeware databases available on > FreeBSD like mSQL, mysql, postgreSQL, Berkeley DB, typhoon etc. Looking > for support Perl5::dbi modules, maintain good data integrity and about > 10-15 users. > > Any thoughts ? > > -- Sridhar For this load, just anything you said, but what about complexity, features, etc.? BTW, I like (nd frequently use) DB, but a database management system it ain't :-) ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 From owner-freebsd-database Mon Jan 26 20:16:58 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA28395 for database-outgoing; Mon, 26 Jan 1998 20:16:58 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fxp0.Simon-Shapiro.ORG [206.190.148.34]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id UAA28386 for ; Mon, 26 Jan 1998 20:16:54 -0800 (PST) (envelope-from shimon@sendero-fxp0.simon-shapiro.org) Received: (qmail 26695 invoked by uid 1000); 27 Jan 1998 04:19:31 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-011998 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: Date: Mon, 26 Jan 1998 20:19:31 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Patrick Kelly Subject: Re: Which SQL Database for Web Applications ? Cc: freebsd-database@FreeBSD.ORG, SRIDHAR KRISHNAN Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Can you point us at it? I have a keen interest. Thanx, simon On 27-Jan-98 Patrick Kelly wrote: > I was using (briefly) postgreSQL, but got frustrated with the limited > SQL. > Now I'm using Solid (not free). I've committed to it (ie paid license > fees), but havn't used it enough to really give a qualified opinion. > > patrick > > On Mon, 26 Jan 1998, SRIDHAR KRISHNAN wrote: > >> Date: Mon, 26 Jan 1998 17:39:10 -0800 (PST) >> From: SRIDHAR KRISHNAN >> To: freebsd-database@FreeBSD.ORG >> Subject: Which SQL Database for Web Applications ? >> >> Are there any docs /experiences comparing freeware databases available >> on >> FreeBSD like mSQL, mysql, postgreSQL, Berkeley DB, typhoon etc. Looking >> for support Perl5::dbi modules, maintain good data integrity and about >> 10-15 users. >> >> Any thoughts ? >> >> -- Sridhar >> >> > ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 From owner-freebsd-database Mon Jan 26 20:18:37 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA28596 for database-outgoing; Mon, 26 Jan 1998 20:18:37 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from ajax.wcs.uq.edu.au (ajax.wcs.uq.edu.au [130.102.222.4]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id UAA28590 for ; Mon, 26 Jan 1998 20:18:33 -0800 (PST) (envelope-from garyr@ajax.wcs.uq.edu.au) Received: (from garyr@localhost) by ajax.wcs.uq.edu.au (8.8.5/8.8.5) id OAA15599; Tue, 27 Jan 1998 14:19:56 GMT From: Gary Roberts Message-Id: <199801271419.OAA15599@ajax.wcs.uq.edu.au> Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: from Tom at "Jan 26, 98 06:32:27 pm" To: tom@uniserve.com (Tom) Date: Tue, 27 Jan 1998 14:19:56 +0000 () Cc: pkelly@kuentos.guam.net, skrishna@cisco.com, freebsd-database@FreeBSD.ORG Organisation: Well Control Australia Phone: +617 3844 0400 Fax: +617 3844 0444 Reply-To: garyr@wcs.uq.edu.au X-Mailer: ELM [version 2.4ME+ PL31 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Tom writes: > On Tue, 27 Jan 1998, Patrick Kelly wrote: > > > I was using (briefly) postgreSQL, but got frustrated with the limited SQL. > > Now I'm using Solid (not free). I've committed to it (ie paid license How much does it cost? Can you post ordering details, thanks? > Solid is nice. Of the free databases, PostgreSQL probably has the least > limited SQL support though. Both mSQL and MySQL lacked all kinds of > things that PostgreSQL does. How quickly are the `free three' developing? Anyone care to venture opinions about `ease of learning and use' type issues. How viable would any of the above be for setting up a project to manage bookings for special courses conducted frequently (30+ courses per year, 10 students per course). Need to manage booking details, information mail-outs, exam results, invoicing, retrieval of previous results (full student history), etc. > I belive that Solid is the only SQL database for FreeBSD that offers > logging and automatic crash recovery. Only Solid and PostgreSQL provide > support for transactions. Is Solid a native FreeBSD app or does it run under some (linux?) emulation? Thanks for any replies. Cheers, -- Gary Roberts (garyr@wcs.uq.edu.au) From owner-freebsd-database Mon Jan 26 20:24:53 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA29260 for database-outgoing; Mon, 26 Jan 1998 20:24:53 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fxp0.Simon-Shapiro.ORG [206.190.148.34]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id UAA29254 for ; Mon, 26 Jan 1998 20:24:50 -0800 (PST) (envelope-from shimon@sendero-fxp0.simon-shapiro.org) Received: (qmail 26812 invoked by uid 1000); 27 Jan 1998 04:27:26 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-011998 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: Date: Mon, 26 Jan 1998 20:27:26 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Tom Subject: RE: SOLID Server BETA Versions (fwd) Cc: freebsd-database@FreeBSD.ORG Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Thanx! Boy, is this fast service!!! Simon On 27-Jan-98 Tom wrote: > > This announcement was posted to the Solid mailing list, announcing a > open BETA of the new FreeBSD port. > > FreeBSD pricing will be the same as Linux. You just need to get a > license key to upgrade the evaluation copy to a full release. See > http://www.solidtech.com > > Tom > > ---------- Forwarded message ---------- > Date: Wed, 21 Jan 1998 22:47:26 +0200 > From: Jouni Lahteenmaki > Reply-To: solid-list@solidtech.com > To: solid-list@solidtech.com > Subject: SOLID Server BETA Versions > > The SOLID Server for FreeBSD 2.2.2 and for Solaris 2.5.1/2.6 > have been in a controlled BETA program. We have received > very good feedback and now the time seems ripe for their > release to a more general availability. > > FreeBSD 2.2.2 > ------------- > The BETA packages can be downloaded from our FTP site as: > ftp://ftp.solidtech.com//pub/outgoing/bs22fbx.tar.gz (server) > ftp://ftp.solidtech.com//pub/outgoing/bt22fbx.tar.gz (tools) > > SUN Solaris 2.5.1 / 2.6 > ----------------------- > The BETA packages can be downloaded from our FTP site as: > ftp://ftp.solidtech.com//pub/outgoing/bs22ssx.tar.Z (server) > ftp://ftp.solidtech.com//pub/outgoing/bt22ssx.tar.Z (tools) > > > Controlled BETA programs are about to start for: > - Multithreaded Linux (Linux 2.x + GNU libc 6.0) > - Alpha Linux (single-threaded) > Please let me know if you are interested to join these programs. > > > - jouni - > Solid Product Management > > -- > J o u n i L ä h t e e n m ä k i > Solid Information Technology Ltd > Huovitie 3, FIN-00400 Helsinki, Finland > Tel +358-9-4774 7340 Fax +358-9-4774 7390 > Mobile +358-40-556 9114 > mailto:jouni.lahteenmaki@solidtech.com > http://www.solidtech.com ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 From owner-freebsd-database Mon Jan 26 21:18:10 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA06767 for database-outgoing; Mon, 26 Jan 1998 21:18:10 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (tc-43.acadiau.ca [131.162.2.143]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id VAA06744 for ; Mon, 26 Jan 1998 21:18:05 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.8.8/8.8.2) with SMTP id BAA15262; Tue, 27 Jan 1998 01:17:28 -0400 (AST) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Tue, 27 Jan 1998 01:17:28 -0400 (AST) From: The Hermit Hacker To: garyr@wcs.uq.edu.au cc: Tom , pkelly@kuentos.guam.net, skrishna@cisco.com, freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: <199801271419.OAA15599@ajax.wcs.uq.edu.au> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 27 Jan 1998, Gary Roberts wrote: > > Solid is nice. Of the free databases, PostgreSQL probably has the least > > limited SQL support though. Both mSQL and MySQL lacked all kinds of > > things that PostgreSQL does. > > How quickly are the `free three' developing? We (PostgreSQL) are restricting ourselves to a 3 per year release cycle (3 months heavy development, 1 month of beta before release) which we find works well. Like FreeBSD-current, we generally try and make sure that bugs are cleaned up as they are found, so you *could* use the source tree pretty much at any time (available via CVSup), but we don't recommend it for those unwilling to accept problems. This release (v6.3) is what I'm considering to be our biggest one yet, with a major amount of new features being added that ppl have been asking for (UNIONs, subselects, etc)... > Anyone care to venture > opinions about `ease of learning and use' type issues. I would imagine that any of the 'free three' are about the same in this regard, in that their 'basis' is SQL. PostgreSQL is extendable, so if you want to get into some of the more advanced features, the learning curve is slightly stepper, but that is to be expected... > How viable would > any of the above be for setting up a project to manage bookings for special > courses conducted frequently (30+ courses per year, 10 students per course). > Need to manage booking details, information mail-outs, exam results, > invoicing, retrieval of previous results (full student history), etc. Depends on what you mean by viable...most of what you describe above is alot of front-end code, and therefore could be done using any of the three... Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org From owner-freebsd-database Mon Jan 26 22:14:03 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA16807 for database-outgoing; Mon, 26 Jan 1998 22:14:03 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from ajax.wcs.uq.edu.au (ajax.wcs.uq.edu.au [130.102.222.4]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA16761 for ; Mon, 26 Jan 1998 22:14:00 -0800 (PST) (envelope-from garyr@ajax.wcs.uq.edu.au) Received: (from garyr@localhost) by ajax.wcs.uq.edu.au (8.8.5/8.8.5) id PAA15787; Tue, 27 Jan 1998 15:55:03 GMT From: Gary Roberts Message-Id: <199801271555.PAA15787@ajax.wcs.uq.edu.au> Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: from The Hermit Hacker at "Jan 27, 98 01:17:28 am" To: scrappy@hub.org (The Hermit Hacker) Date: Tue, 27 Jan 1998 15:55:02 +0000 () Cc: freebsd-database@FreeBSD.ORG Organisation: Well Control Australia Phone: +617 3844 0400 Fax: +617 3844 0444 Reply-To: garyr@wcs.uq.edu.au X-Mailer: ELM [version 2.4ME+ PL31 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk The Hermit Hacker writes: > > How viable would .... > Depends on what you mean by viable...most of what you describe > above is alot of front-end code, and therefore could be done using any of > the three... Sure, so what do most people use to write front-ends? I guess I'm looking for advice based on (others) experience in that I don't have the time to get that experience myself. I'm willing to pay someone to do the initial development and then (probably) take over the ongoing maintenance and enhancement of the system myself. For that reason it would need to be something relatively easy for a novice to understand and master. Any thoughts anyone?? Thanks. Cheers, -- Gary Roberts (garyr@wcs.uq.edu.au) From owner-freebsd-database Mon Jan 26 22:55:58 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA24053 for database-outgoing; Mon, 26 Jan 1998 22:55:58 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from vnode.vmunix.com (vnode.vmunix.com [209.112.4.20]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA24045 for ; Mon, 26 Jan 1998 22:55:56 -0800 (PST) (envelope-from mark@vnode.vmunix.com) Received: (from mark@localhost) by vnode.vmunix.com (8.8.8/8.8.8) id BAA28281; Tue, 27 Jan 1998 01:58:42 -0500 (EST) (envelope-from mark) Message-ID: <19980127015842.50119@vmunix.com> Date: Tue, 27 Jan 1998 01:58:42 -0500 From: Mark Mayo To: garyr@wcs.uq.edu.au Cc: The Hermit Hacker , freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? References: <199801271555.PAA15787@ajax.wcs.uq.edu.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.88e In-Reply-To: <199801271555.PAA15787@ajax.wcs.uq.edu.au>; from Gary Roberts on Tue, Jan 27, 1998 at 03:55:02PM +0000 X-Operating-System: FreeBSD 2.2.5-STABLE i386 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, Jan 27, 1998 at 03:55:02PM +0000, Gary Roberts wrote: > The Hermit Hacker writes: > > > > How viable would > .... > > > Depends on what you mean by viable...most of what you describe > > above is alot of front-end code, and therefore could be done using any of > > the three... > > Sure, so what do most people use to write front-ends? I guess I'm looking > for advice based on (others) experience in that I don't have the time to > get that experience myself. I'm willing to pay someone to do the initial > development and then (probably) take over the ongoing maintenance and > enhancement of the system myself. For that reason it would need to be > something relatively easy for a novice to understand and master. > > Any thoughts anyone?? Thanks. Well, PHP is really great for embedding SQL queries into web pages - if that's what you're looking for. PHP works with PostgreSQL,MySQL, and Solid. (php.iquest.net) All 3 above support Perl interfaces, and at least Solid has the DBD:: thing for generic database access using Perl. I've only used the PostgreSQL and MySQL C APIs, and although PostgreSQL is a lot closer to "the big guns" (i.e. Oracle, Informix, etc.) the MySQL API is *super* simple and easy to work with.. If you can write a few lines of C code, you can write a simple MySQL C app. Great for beginners. Postgres is quite easy too, FWIW... I think there's a GUI Tcl front-end available for both PostgreSQL and mySQL... There are a few details I prefer in the PostgreSQL command line "interactive query editor" over the mySQL one. Nothing major though. I guess when all is said and done mySQL and PostgreSQL are great packages. Solid is of course a commercial offering so you get more goodies and better ODBC and JDBC drivers. One thing I've noticed is that MySQL seems to have a far better ODBC driver, which may be a deciding factor depending on if you need WIndows access to the DB.. The JDBC drivers for both Postgres and mySQL seem good, although I personally haven't tested them too much. Most of my database stuff is on the web, so Perl and PHP are my clear favorites for the front-ends.. Aside from a few simple C programs, I haven't done much with Postgres or mySQL outside of web applications, so I can't help you much there... Good luck, -Mark P.S. I don't know if it's worth anything to you, but over the last 8 months or so I've gradually moved away from mySQL towards PostgreSQL, mostly because of the development model and the simple fact that it does more! With v6.2.1 it's become very stable for my apps, and the SQL syntax is really filling in. The only thing I wish for is a better free ODBC driver... When UNION and subselects are working with the upcoming v6.3 I'll be seriously considering not renewing our Oracle license at the lab I admin at school... :-) > > Cheers, > -- > Gary Roberts (garyr@wcs.uq.edu.au) -- ------------------------------------------------------------------------ Mark Mayo mark@vmunix.com RingZero Comp. http://www.vmunix.com/mark finger mark@vmunix.com for my PGP key and GCS code ------------------------------------------------------------------------ Win95/NT - 32 bit extensions and a graphical shell for a 16 bit patch to an an 8 bit operating system originally coded for a 4 bit microprocessor, written by a 2 bit company that can't stand 1 bit of competition. -UGU From owner-freebsd-database Mon Jan 26 23:38:52 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id XAA02992 for database-outgoing; Mon, 26 Jan 1998 23:38:52 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from pop.uniserve.com (pop.uniserve.com [204.244.156.3]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id XAA02983 for ; Mon, 26 Jan 1998 23:38:50 -0800 (PST) (envelope-from tom@uniserve.com) Received: from shell.uniserve.com [204.244.186.218] by pop.uniserve.com with smtp (Exim 1.73 #1) id 0xx5ax-00034a-00; Mon, 26 Jan 1998 23:38:08 -0800 Date: Mon, 26 Jan 1998 23:38:03 -0800 (PST) From: Tom To: Mark Mayo cc: garyr@wcs.uq.edu.au, The Hermit Hacker , freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: <19980127015842.50119@vmunix.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > P.S. I don't know if it's worth anything to you, but over the last 8 > months or so I've gradually moved away from mySQL towards PostgreSQL, > mostly because of the development model and the simple fact that Yep. I don't like the fact that MySQL 3.21 is the recommended version, but is still in beta and new betas come out monthly, and the last beta (as of today 3.21.21) has several known bugs invovling fairly simple queries, but the only way to get fixes is cut and paste patches from the mailing list... ugh Tom From owner-freebsd-database Tue Jan 27 01:31:21 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id BAA17926 for database-outgoing; Tue, 27 Jan 1998 01:31:21 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from saba.kuentos.guam.net (root@saba.kuentos.guam.net [198.81.233.14]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id BAA17917 for ; Tue, 27 Jan 1998 01:31:18 -0800 (PST) (envelope-from pkelly@saba.kuentos.guam.net) Received: (from pkelly@localhost) by saba.kuentos.guam.net (8.8.6/8.8.6) id TAA03463; Tue, 27 Jan 1998 19:33:31 +1000 (GST) Date: Tue, 27 Jan 1998 19:33:30 +1000 (GST) From: Patrick Kelly To: freebsd-database@FreeBSD.ORG Subject: Postgres and Solid In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Mon, 26 Jan 1998, The Hermit Hacker wrote: > On Tue, 27 Jan 1998, Patrick Kelly wrote: > > > I was using (briefly) postgreSQL, but got frustrated with the limited SQL. > > Limited SQL? *raised eyebrows* What version were you using? I was using 6.1.1 (still am). A cute little application that we did with it can be seen at http://weather.guam.net/ http://weather.guam.net/charts.html I did a good bit of work to bundle FastCGI, Tcl and the Postgres TCL access together. That's described at http://bolts.guam.net/fpgtcl http://photo.net/wtr/cheap-tcl.html (duplicate +comments at end) There are several things that I really like about Postgres. The TCL extensions are really nice and clean. The "psql" command line interface is really cool. (Especially compared to Solid's "solsql" which is absolute bare minimum functionality on FreeBSD.) Also, I was doing some Java stuff against Postgres and that worked real well, too. (That was a web explorer for http://search.micronesia.net [site is very incomplete/ inactive currently].) I started looking at doing extensions for Postgres, but decided that it would be better to not get into that. That would raise issues with keeping up with new versions/melding code, etc. And, I didn't want the risk of my breaking the database server myself. So, I started checking out Solid. ODBC support on PC's is really nice to have. I paid extra to get JDBC, cuz I want it. My bill was $1193 (if memory serves) for WebEngine + JDBC + 2 client connections. According to the licensing, this gives me unlimited connections from the machine where the server sits, plus up to 2 connections from clients on other machines. I grabbed the Perl DBI stuff and started playing with that. I've done a lot of Perl4 stuff, and moving to DBI means Perl5. It seems that Perl has become a monster, and it makes me nervous. I'm afraid that I'm gonna miss something, or not know something that I should, and screw something up. (I'm tired of breaking things.) So, now, I'm mapping the core ODBC library calls into TCL. I've never worked with ODBC before, but it looks like (from the Solid documentation) that the stuff I'm building will work where ever I can find an ODBC library. I like TCL because it's simpler and more easily groked than much of Perl. The plan is to get a webserver with TCL built in for the front end, but I haven't started working on the webserver yet. I know it's possible because of NeoWebScript (http://www.neosoft.com). I really like Postgres, but it seemed that Solid's limitations were more easily overcome than Postgres'. Also, ODBC is a real plus. If it had to be free, I would be using Postgres. But where I'm at, $1k looked like a good deal. patrick From owner-freebsd-database Tue Jan 27 04:51:17 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id EAA11179 for database-outgoing; Tue, 27 Jan 1998 04:51:17 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from hub.org (hub.org [209.47.148.200]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id EAA11171 for ; Tue, 27 Jan 1998 04:51:13 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by hub.org (8.8.8/8.7.5) with SMTP id HAA07888; Tue, 27 Jan 1998 07:51:13 -0500 (EST) Date: Tue, 27 Jan 1998 07:51:12 -0500 (EST) From: The Hermit Hacker To: garyr@wcs.uq.edu.au cc: freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? In-Reply-To: <199801271555.PAA15787@ajax.wcs.uq.edu.au> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 27 Jan 1998, Gary Roberts wrote: > The Hermit Hacker writes: > > > > How viable would > .... > > > Depends on what you mean by viable...most of what you describe > > above is alot of front-end code, and therefore could be done using any of > > the three... > > Sure, so what do most people use to write front-ends? I guess I'm looking > for advice based on (others) experience in that I don't have the time to > get that experience myself. I'm willing to pay someone to do the initial > development and then (probably) take over the ongoing maintenance and > enhancement of the system myself. For that reason it would need to be > something relatively easy for a novice to understand and master. I've not looked into MySQL and what it has available, but PostgreSQL has interfaces for C, C++, perl, JDBC, ODBC, tcl, python, and PHP/FI supports it. I've programmed interfaces in C, perl and PHP/FI...and find that perl tends to be about the most comfortable for me. From owner-freebsd-database Tue Jan 27 05:21:26 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA14512 for database-outgoing; Tue, 27 Jan 1998 05:21:26 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from hub.org (hub.org [209.47.148.200]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA14506 for ; Tue, 27 Jan 1998 05:21:24 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by hub.org (8.8.8/8.7.5) with SMTP id IAA10837; Tue, 27 Jan 1998 08:21:28 -0500 (EST) Date: Tue, 27 Jan 1998 08:21:28 -0500 (EST) From: The Hermit Hacker To: Patrick Kelly cc: freebsd-database@FreeBSD.ORG Subject: Re: Postgres and Solid In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 27 Jan 1998, Patrick Kelly wrote: > On Mon, 26 Jan 1998, The Hermit Hacker wrote: > > > On Tue, 27 Jan 1998, Patrick Kelly wrote: > > > > > I was using (briefly) postgreSQL, but got frustrated with the limited SQL. > > > > Limited SQL? *raised eyebrows* What version were you using? > > I was using 6.1.1 (still am). A cute little application that we did with > it can be seen at *Alot* of changes since v6.1.1 and v6.2, and even more of a difference between v6.2 and v6.3 (to be released)...in alot of ways, it would be like comparing apples to oranges. Working from v1.01 (Berkeley's virgin code) thru to v6.0/v6.1 was alot of bug fixes and stability...few other things were really focused on. v6.1 and beyond have been spent more bringing in missing standard SQL and improving performance, as well as resource utilization. When I upgraded my server from v6.1.1 to v6.2, one of the WWW projects that I'm working on (www.ncres.com) showed a massive improvement in response time to queries...enough so that the client actually commented on it. From owner-freebsd-database Thu Jan 29 10:53:11 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA26419 for database-outgoing; Thu, 29 Jan 1998 10:53:11 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from carlton.innotts.co.uk (root@carlton.innotts.co.uk [194.176.128.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id KAA26404 for ; Thu, 29 Jan 1998 10:53:05 -0800 (PST) (envelope-from robmel@innotts.co.uk) Received: from muffin.highwire.local (serialA2b.innotts.co.uk [194.176.130.44]) by carlton.innotts.co.uk (8.8.5/8.8.5) with ESMTP id SAA01142; Thu, 29 Jan 1998 18:52:58 GMT Received: from [172.16.17.20] (robsmac.highwire.local [172.16.17.20]) by muffin.highwire.local (8.8.8/8.8.5) with ESMTP id SAA04527; Thu, 29 Jan 1998 18:52:50 GMT X-Sender: robmel@muffin.highwire.local Message-Id: In-Reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Thu, 29 Jan 1998 18:53:38 +0000 To: Tom , Patrick Kelly From: Robin Melville Subject: Re: Which SQL Database for Web Applications ? Cc: SRIDHAR KRISHNAN , freebsd-database@FreeBSD.ORG Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe database" At 6:32 pm -0800 26/1/98, Tom wrote: >On Tue, 27 Jan 1998, Patrick Kelly wrote: > >> I was using (briefly) postgreSQL, but got frustrated with the limited SQL. >> Now I'm using Solid (not free). I've committed to it (ie paid license >> fees), but havn't used it enough to really give a qualified opinion. >> >> patrick > > Solid is nice. Of the free databases, PostgreSQL probably has the least >limited SQL support though. Both mSQL and MySQL lacked all kinds of >things that PostgreSQL does. > > I belive that Solid is the only SQL database for FreeBSD that offers >logging and automatic crash recovery. Only Solid and PostgreSQL provide >support for transactions. > >Tom I've been trying another (non-free) SQL server that runs native on FreeBSD called YARD. It seems a pretty complete & robust implementation (inc logging & transactions). I've not tried linking it to web pages since I'm working on unix & windoze apps, but it definitely has a JDBC interface as well as ODBC and embedded C SQL. They're at http://www.yard.de/ & you can d/l a trial version to see if it's any good for you. I'm a little disturbed about the problems with MySQL that Mark Mayo mentioned: >... I don't like the fact that MySQL 3.21 is the recommended version, >but is still in beta and new betas come out monthly, and the last beta (as >of today 3.21.21) has several known bugs invovling fairly simple queries, >but the only way to get fixes is cut and paste patches from the mailing >list... ugh ... since we've been thinking of using it for less "critical" stuff. Do these problems lose data? Robin. From owner-freebsd-database Thu Jan 29 12:14:40 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id MAA10159 for database-outgoing; Thu, 29 Jan 1998 12:14:40 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from pop.uniserve.com (pop.uniserve.com [204.244.156.3]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id MAA10154 for ; Thu, 29 Jan 1998 12:14:39 -0800 (PST) (envelope-from tom@uniserve.com) Received: from shell.uniserve.com [204.244.186.218] by pop.uniserve.com with smtp (Exim 1.73 #1) id 0xy0La-0007Ym-00; Thu, 29 Jan 1998 12:14:02 -0800 Date: Thu, 29 Jan 1998 12:14:00 -0800 (PST) From: Tom To: Robin Melville cc: freebsd-database@FreeBSD.ORG Subject: Re: Which SQL Database for Web Applications ? 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-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe database" On Thu, 29 Jan 1998, Robin Melville wrote: > I've been trying another (non-free) SQL server that runs native on FreeBSD > called YARD. It seems a pretty complete & robust implementation (inc > logging & transactions). I've not tried linking it to web pages since I'm > working on unix & windoze apps, but it definitely has a JDBC interface as > well as ODBC and embedded C SQL. > > They're at http://www.yard.de/ & you can d/l a trial version to see if it's > any good for you. Interesting. Never heard of them before. They only have a FreeBSD 2.1.6 version, so I'm not sure how much Yard is still developed. > I'm a little disturbed about the problems with MySQL that Mark Mayo mentioned: Actually I posted the following... > >... I don't like the fact that MySQL 3.21 is the recommended version, > >but is still in beta and new betas come out monthly, and the last beta (as > >of today 3.21.21) has several known bugs invovling fairly simple queries, > >but the only way to get fixes is cut and paste patches from the mailing > >list... ugh > > ... since we've been thinking of using it for less "critical" stuff. Do > these problems lose data? Mainly they just produce incorrect query results. 3.21.22 is now out, and already someone found a fairly simple query that produces incorrect results. > Robin. Tom From owner-freebsd-database Thu Jan 29 20:19:50 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA06066 for database-outgoing; Thu, 29 Jan 1998 20:19:50 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fxp0.Simon-Shapiro.ORG [206.190.148.34]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id UAA06015 for ; Thu, 29 Jan 1998 20:19:22 -0800 (PST) (envelope-from shimon@sendero-fxp0.simon-shapiro.org) Received: (qmail 10384 invoked by uid 1000); 30 Jan 1998 04:26:32 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-011998 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: Date: Thu, 29 Jan 1998 20:26:32 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: The Hermit Hacker , freebsd-database@FreeBSD.ORG Subject: Re: your mail Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe database" I am redirecting to the database list, which is more appropriate. I think. On 29-Jan-98 The Hermit Hacker wrote: > On Thu, 29 Jan 1998, Simon Shapiro wrote: > >> I am on shaky ground here, so be kind to me: >> >> I am trying to get a very new PostgreSQL snapshot to work. >> One of the things it does is create a UNIX Socket in /tmp. >> It uses a template to create the ``filename'': >> >> #define UNIXSOCK_PATH(sun,port) \ >> (sprintf((sun).sun_path, "/tmp/.s.PGSQL.%d", (port)) + \ >> sizeof ((sun).sun_family)) >> >> This seems to work OK (I traced it in the RDBMS code), up to the bind >> syscall. The port is 5432, and the socket gets created as: >> >> srwx------ 1 pgsql bin 0 Jan 27 16:18 /tmp/.s.PGSQL.543 >> >> The bind(2) call is: > > > Just curious, but I'm running the snapshot on my 3.0-CURRENT > machine and I can run the full regression tests without a problem...what > sort of problem are you experiencing? Cannot connect. It looks like either the pg_hba.conf file is incorrect (including the one which works in 6.2.1), or that the sockets cannot be opened. While digging, I see that the filename representing the Unix socket is wrong (the last digit gets truncated). I need to try today's snapshot. Maybe the problem is gone. ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 From owner-freebsd-database Fri Jan 30 05:07:28 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA25713 for database-outgoing; Fri, 30 Jan 1998 05:07:28 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from hub.org (hub.org [209.47.148.200]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA25616 for ; Fri, 30 Jan 1998 05:06:02 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by hub.org (8.8.8/8.7.5) with SMTP id IAA14487; Fri, 30 Jan 1998 08:04:56 -0500 (EST) Date: Fri, 30 Jan 1998 08:04:56 -0500 (EST) From: The Hermit Hacker To: Simon Shapiro cc: freebsd-database@FreeBSD.ORG Subject: Re: your mail 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-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe database" On Thu, 29 Jan 1998, Simon Shapiro wrote: > I am redirecting to the database list, which is more appropriate. I think. I've forwarded this over to pgsql-ports@postgresql.org...the version that Simon is using is a purely development snapshot...not even beta yet...the problems report are most likely PostgreSQL/Alpha related then anything in FreeBSD... > > On 29-Jan-98 The Hermit Hacker wrote: > > On Thu, 29 Jan 1998, Simon Shapiro wrote: > > > >> I am on shaky ground here, so be kind to me: > >> > >> I am trying to get a very new PostgreSQL snapshot to work. > >> One of the things it does is create a UNIX Socket in /tmp. > >> It uses a template to create the ``filename'': > >> > >> #define UNIXSOCK_PATH(sun,port) \ > >> (sprintf((sun).sun_path, "/tmp/.s.PGSQL.%d", (port)) + \ > >> sizeof ((sun).sun_family)) > >> > >> This seems to work OK (I traced it in the RDBMS code), up to the bind > >> syscall. The port is 5432, and the socket gets created as: > >> > >> srwx------ 1 pgsql bin 0 Jan 27 16:18 /tmp/.s.PGSQL.543 > >> > >> The bind(2) call is: > > > > > > Just curious, but I'm running the snapshot on my 3.0-CURRENT > > machine and I can run the full regression tests without a problem...what > > sort of problem are you experiencing? > > Cannot connect. It looks like either the pg_hba.conf file is incorrect > (including the one which works in 6.2.1), or that the sockets cannot be > opened. While digging, I see that the filename representing the Unix > socket is wrong (the last digit gets truncated). > > I need to try today's snapshot. Maybe the problem is gone. > > ---------- > > > Sincerely Yours, > > Simon Shapiro > Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 > From owner-freebsd-database Fri Jan 30 21:06:42 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA14378 for database-outgoing; Fri, 30 Jan 1998 21:06:42 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from ymris.ddm.on.ca (cisco4-200.cas.golden.net [207.6.168.200]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id VAA14195; Fri, 30 Jan 1998 21:04:22 -0800 (PST) (envelope-from dchapes@ddm.on.ca) Received: from squigy.ddm.on.ca (squigy.ddm.on.ca [209.47.139.138]) by ymris.ddm.on.ca (8.8.8/8.8.8) with ESMTP id AAA03419; Sat, 31 Jan 1998 00:04:05 -0500 (EST) (envelope-from dchapes@ymris.ddm.on.ca) From: Dave Chapeskie Received: (from dchapes@localhost) by squigy.ddm.on.ca (8.8.8/8.8.7) id AAA03033; Sat, 31 Jan 1998 00:04:02 -0500 (EST) Message-ID: <19980131000402.29261@ddm.on.ca> Date: Sat, 31 Jan 1998 00:04:02 -0500 To: Omar Thameen Cc: freebsd-isp@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: SQL choice questions. Reply-To: freebsd-database@FreeBSD.ORG References: <027301bd2ce2$05517f20$0f3d31cc@electron.nuc.net> <3.0.3.32.19980129140755.033893e0@infowest.com> <19980130233347.07030@clifford.inch.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.88 In-Reply-To: <19980130233347.07030@clifford.inch.com>; from Omar Thameen on Fri, Jan 30, 1998 at 11:33:47PM -0500 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe database" [BTW, this belongs in freebsd-database, send all replies there] On Fri, Jan 30, 1998 at 11:33:47PM -0500, Omar Thameen wrote: > Check on the MySQL homepage (http://www.tcx.se) - there's a link to a > bunch of benchmarks if performance is an issue for you. FYI, we use > MySQL. It performs well and has a nice license agreement. Take those benchmarks with a huge grain of salt. They've been discussed recently on the PgSQL mailing lists (with the guy who did the benchmarks participating in the discussion). The impression I got was that his only experience with PgSQL was to get it to run the benchmarks and that he doesn't understand how the PgSQL 'vacuum' command is used in the real world. I'm also not sure how well he understands how large RDBMS systems are used. IMHO, if all you want is simple single table lookups then msql or MySQL may be fine but if you want something free that approaches a real RDBMS then go for PostgreSQL. -- Dave Chapeskie, DDM Consulting E-Mail: dchapes@ddm.on.ca