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

[eyepopslikeamosquito]

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