Songlist

/home/laurence/songlist_new/Songlist/README

Created by Laurence D. Finston (LDF) Mon 12 Apr 2021 05:12:46 PM CEST

* Copyright and License.

This file is part of songlist, a package for keeping track of songs.

Copyright (C) 2021, 2022, 2023 Laurence D. Finston

songlist is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 3 of the License, or

(at your option) any later version.

songlist is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with songlist; if not, write to the Free Software

Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA

Please send bug reports to Laurence.Finston@gmx.de

Songlist is a database application for keeping track of songs.

It includes code for setting up a MySQL database and a C++ program for generating text output. The output format it uses is (plain) TeX.

It is designed specifically for the needs of the author, but it might be useful for other people and could be easily adapted, so I've decided to make it publicly available at GitHub.

Please contact the author with any questions. See email address above.

The easiest way to set up the database is to use the file `dump.sql' in the top-level directory ([...]/Songlist/):

mysql> source dump.sql

Of course, a MySQL user must be created and permissions must be granted to it in order to set up and use the database.

For instructions on using MySQL see the MySQL 8.0 Reference Manual: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/index.html

For specific information on using "mysql — The MySQL Command-Line Client" see: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql.html

The file [...]/Songlist/database/songlist.sql contains the SQL code that the author uses to send queries to the database (for adding songs, etc.). It is NOT meant to be "sourced". Sourcing it will almost certainly result in errors.

The directory /Songlist/public_domain/' contains PDF files containing lead sheets for songs that are in the public domain in both the USA and Germany. See the file /Songlist/public_domain/README' for more information.

In addition, the directory `/Songlist/lead_sheets/' contains hand-written lead sheets by the author of songs that are in the public domain in both the USA and Germany.