Re: [OT] SQL woes

2003-08-23 Thread Shevek
On Sat, 23 Aug 2003, David Cantrell wrote: > Dominic Mitchell wrote: > > > Many people say the same thing about perl code in general. Like all > > tools you need to know when to say "no". At the moment, we're just > > using triggers to put an mtime field onto all of our rows, and this > > works

Re: [OT] SQL woes

2003-08-23 Thread David Cantrell
Dominic Mitchell wrote: Many people say the same thing about perl code in general. Like all tools you need to know when to say "no". At the moment, we're just using triggers to put an mtime field onto all of our rows, and this works well. But I'd want to think carefully about more advanced uses

Re: hash lookup with regex

2003-08-23 Thread Shevek
On Tue, 19 Aug 2003, Martin Bower wrote: > I have 2 hashes, one with 10,000 entries and the other with 5,000, and > these are loaded from a database table(sybase). > > %hash1 contains values such as "111.666.fff.jjj.ccc.222" > %hash2 contains values such as "111.666.fff.___.ccc.222" (where

Re: [OT] SQL woes

2003-08-23 Thread Chris Benson
On Fri, Aug 22, 2003 at 05:59:01PM +0100, Colin Magee wrote: > > SuSE 8.1. As I say, I can see the files installed in usr/bin, as root, but > when I try running it I get all sorts of error messages: > 1."Can't connect to local MySQL server through socket > /var/lib/mysql/mysql.sock". Try che

Re: [OT] SQL woes

2003-08-23 Thread David Wright
What Linux distro are you running? SuSE 8.1. As I say, I can see the files installed in usr/bin, as root, but when I try running it I get all sorts of error messages: 'it' being the server or the client? 1. "Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock". Try chec

RE: [OT] SQL woes

2003-08-23 Thread Jason Clifford
On Fri, 22 Aug 2003, Colin Magee wrote: > >What Linux distro are you running? > > SuSE 8.1. As I say, I can see the files installed in usr/bin, as root, but > when I try running it I get all sorts of error messages: > 1."Can't connect to local MySQL server through socket > /var/lib/mysql/mys

Re: [OT] Decompiling perl2exe apps

2003-08-23 Thread Nicholas Clark
On Fri, Aug 15, 2003 at 03:02:27PM +0100, Nicholas Clark wrote: > On Fri, Aug 15, 2003 at 12:46:50PM +0100, Shevek wrote: > > On Fri, 15 Aug 2003, James Campbell wrote: > > > > > I have managed to lose some source code (ahem) for a script that I packaged > > > with perl2exe on a Windows 2000 PC. I

RE: [OT] SQL woes

2003-08-23 Thread Colin Magee
>What Linux distro are you running? SuSE 8.1. As I say, I can see the files installed in usr/bin, as root, but when I try running it I get all sorts of error messages: 1. "Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock". Try checking mysqld is running and that

RE: [OT] SQL woes

2003-08-23 Thread Jason Clifford
On Thu, 21 Aug 2003, Colin Magee wrote: > As a Perl beginner who has realised I need to set up a database, I have to > add that I immediately went for MySQL due to all the attention it seems to > have, and bought a few books to get me started. The whole thing - using > installing etc etc looks he

Re: [OT] SQL woes

2003-08-23 Thread Peter Sergeant
> Thanks - I did see the module on CPAN but wan't sure if I only needed the > one download. What I can't see there (or at the SQLite site) is a nice > example which shows creates, updates and queries a dbase. If I look at the > books I've got which show the DBI working with MySQL, can I simply tr

RE: [OT] SQL woes

2003-08-23 Thread Colin Magee
>You don't even need to install a separate SQLite; the CPAN module includes everything you need. Thanks - I did see the module on CPAN but wan't sure if I only needed the one download. What I can't see there (or at the SQLite site) is a nice example which shows creates, updates and queries a dbas

Re: [OT] SQL woes

2003-08-23 Thread Elizabeth Mattijsen
At 09:03 + 8/23/03, Dominic Mitchell wrote: Tony Bowden <[EMAIL PROTECTED]> wrote: > Unchecked they lead to an unmaintainable mess quicker than most other > things can ... Many people say the same thing about perl code in general. Like all tools you need to know when to say "no". At the mom

Re: [OT] SQL woes

2003-08-23 Thread Dominic Mitchell
Roger Burton West <[EMAIL PROTECTED]> wrote: > On Thu, Aug 21, 2003 at 08:51:49PM +0100, Colin Magee wrote: > >>So this SQLite seems like a great idea IF it makes setting up and >>administering a dbase simple. Unfortunately I just looked up where I can >>download it, but didn't see any example co

Re: [OT] SQL woes

2003-08-23 Thread Dominic Mitchell
Tony Bowden <[EMAIL PROTECTED]> wrote: > On Fri, Aug 22, 2003 at 03:30:48PM +0100, Andy Ford wrote: >> Well thanks for summing that up - it was an interesting read!! >> Currently I use mySQL only and don't really need transactional stuff. >> Now triggers I can see a need for!! > > Triggers at the

Re: [OT] SQL woes

2003-08-23 Thread Dominic Mitchell
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > What about Firebird? > > http://firebird.sourceforge.net/ > > does anyone here have personal experience? On paper (well, online) it > compares favorably to PostgreSQL, and it can be easily embedded. It's an excellent browser, much quicker than mozi