Perl 5.8.8 on Redhat RHEL Linux 5.5.56

I'm using SDBM to store data, but it can only store data where the key and data length is less than 1008 bytes. I've hit that limit. I'd like to use a hash-like storage, but what are my options here?

• Super Search on Perlmonks back to 2005 years did not help.
• ODBM, NDBM, GDBM all have the same limit of 1008 bytes.
• MLDBM seems to have a file size limit of 2GB. That may not be enough. See this Perlmonk question.
• BerkeleyDB seems promising but I couldn't find a limit on the data per key or number of keys.
• The data field should hold 50,000 bytes just in case. There will be about 1000 keys. The largest data size for a single key is unknown since I've never done this before.
• For the future, I'd like to use a hash-tied DB which has very large limits. I might need them.
• Speed is not critical.
• Does DBD::SQLite require installing SQL or anything else?
• I'd prefer to do a hash-like structure, but I'm willing to use a database via Perl also. I know I need to be flexible and plan for the future.
• I'm looking for any and all ideas. Please don't stop commenting just because someone proposed a solution. There are many ways to do things.
• I'm the only programmer (and user of the software), so I don't have to adhere to all programming rules specific to a large group of programmers.

Thank you!

EDIT: Looks like DBD::Sqlite has no limit on TEXT fields. Is there anything I should watch out for using DBD::SQLite? Through very basic testing I did notice:

• I have to create my own table for a new db file.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.