Re^2: Keep a Database Connection Active and Reuse it Between Script Executions? (Database References)

in reply to Re: Keep a Database Connection Active and Reuse it Between Script Executions?
in thread RESOLVED - Keep a Database Connection Active and Reuse it Between Script Executions?

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:

Wikipedia References

EAV Data Model

Comment on Re^2: Keep a Database Connection Active and Reuse it Between Script Executions? (Database References)

In Section Seekers of Perl Wisdom