Free, simple databases?

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Databases by perrin (Chancellor) on Jul 16, 2003 at 15:53 UTC
There are several dbms freely available on unix systems, including gdbm, BerkeleyDB (which you can use with the exact same interface as sdbm), and ndbm which comes with Perl. Maybe if you told us why you can't use sdbm, we could be more helpful.	[reply]
Re: Re: Databases by Anonymous Monk on Jul 16, 2003 at 15:59 UTC
The reason I need a new DB is based off the assumption that the problem in my current script which still, after a month and a half of debugging and asking for help, is a database problem rather than coding error. I can't give specifics as they aren't even known to me, I just wanted to see if the script would function more properly if it used a different DB (hopefully one similar to SDBM).	[reply]
Re: Re: Re: Databases by perrin (Chancellor) on Jul 16, 2003 at 16:45 UTC
Assuming you used SDBM_File, you can just switch to NDBM_File or GDBM_File with almost no changes. Without knowing any more details about the problem you're having with sdbm, that's as much help as I can offer.	[reply]
Re: Re: Re: Databases by TomDLux (Vicar) on Jul 16, 2003 at 22:32 UTC
I can't give specifics as they aren't even known to me If you don't know what the errors are, how will you tell whether the other DB works correctly or not? I betcha 20 to 1 that the database does what it's supposed to do, just as it has for the last 20 years. The problem is in your understanding of what it does, how it works, or how to invoke it. So replacign one functioning DB with a different functioning DB won't get you any further. Figure out what you want it to do, figure out how to do it manually, one step at a time, and then automate. -- `TTTATCGGTCGTTATATAGATGTTTGCA`	[reply]
Re: Databases by ctilmes (Vicar) on Jul 16, 2003 at 15:53 UTC
>I love the functionality of SDBM but for my current project I'll be needed to use something else. Why? The reasons will help determine what else may be appropriate for you.	[reply]
Re: Free, simple databases? by princepawn (Parson) on Jul 16, 2003 at 16:59 UTC
SQLite is faster than Postgresql and MySQL and there is DBD::SQLite for Perl access Carter's compass: I know I'm on the right track when by deleting something, I'm adding functionality	[reply]
Re^2: Free, simple databases? by adrianh (Chancellor) on Jul 16, 2003 at 19:25 UTC
While SQLite is dead useful it's not always faster. If you've just got a single process reading and writing data it probably will be. If you have multiple processes simultaneously reading and writing from the same table it probably won't (database level locking and all that...)	[reply]
Re: Databases by Taulmarill (Deacon) on Jul 16, 2003 at 15:44 UTC
seems to me that MySQL is what you're looking for.	[reply]
Re^2: Databases by Aristotle (Chancellor) on Jul 16, 2003 at 15:48 UTC
That is less complicated than BerkeleyDB? It isn't even anything like SDBM or BerkeleyDB. Did you read the entire question? Makeshifts last the longest.	[reply]