The "replies that are written by your fellow-monks" differ from yours in only one respect: they apparently make more sense than yours do.

Update: using this node nowadays for Database References.

Database References

Performance related:

• Re^3: How can I keep the first occurrence from duplicated strings? by Bod (2023) - Perl hashes are often way faster than an external database (BrowserUk experience)
• Re: Memory efficient way to deal with really large arrays? by Tux (2020) - Perl hash vs database benchmark

SQL related:

• Best practices for closing database connections? by Polyglot (2022)
• Re^3: Best practices for closing database connections? by hippo (2022)
• Re^7: Best practices for closing database connections? by Fletch (2022)
• Re^7: Best practices for closing database connections? by marto (2022)
• Re^2: processing PSQL with system command by g_speran (2022)
• DBI connecting to MS SQL Server TLS 1.2 by PearlNovice (2019 - see response by Tux)

DBI DBD::SQLite related:

• SQLite (wikipedia)
• DBI DBD::SQLite unable to open Firefox cookies.sqlite database by Discipulus (2022)
• How should I tell DBD::SQLite to use a newer binary? by Cody Fendant (2023)
• threads::shared referencing confusion by anonymonk (2024) - problems using SQLite with threads and threads::shared

XAMPP related:

• XAMPP (wikipedia)
• Perl XAMPP DB Connect issue (Windows/Strawberry?) by Polyglot (Dec 2022)

JSON, YAML ... related:

• A good way to input data into a script w/o an SQL database by ObiPanda (2023)
• Data-driven Programming: fun with Perl, JSON, YAML, XML... by me (2015)

Storable related:

• Storable - persistence for Perl data structures (perldoc)
• Storable - File empties itself? by feumw (2023)
• Storable for user preferences by Bod (2023)
• Will these functions for use with Storable properly lock my file? by nysus (2021)

flock related:

• Re: Preventing multiple instances (References on flock and running one copy of a script at a time) by me (2020)

Virtual File Systems (TODO):

• What would you like to see in a Virtual Filesystem for Perl? by NERDVANA (2023)

Data Structure References

• Data Structure References

Files References

• Re^2: Shotgun.pl - Shoots Holes in Files (Files References)

CPAN References

• Tie::Hash

By Tux:

• CPAN Author HMBRAND
• DBI
• Tie::Hash::DBD
• Tie::Array::DBD

• RESOLVED - Keep a Database Connection Active and Reuse it Between Script Executions? by perldigious (2020)
• Best practices for closing database connections? by Polyglot (2022)

Wikipedia References

• EAV Data Model

---

---

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.