# Database

# General information

Hand2Note uses PostgreSQL to store hands and statistical data. However, Hand2Note doesn't require PostgreSQL installed on your PC. Hand2Note by default uses its own bundled database server, so you don't need to worry about PostgreSQL at all.

By default, Hand2Note database is stored in C:/Users/YourUsername/AppData/Roaming/Hand2Note/h2ndb folder.

# Database management

# Creating a new database

1. Go to Configuration → Database
2. Click "Create database…"
3. Enter the name of a new database
4. Click "Activate"
5. Wait while Hand2Note restarts.
6. Go back to Configuration → Database and delete the old database, if necessary.

# Moving database to another disk or directory

By default, Hand2Note database is stored on C drive. If you wish, you can change the location of database files, for example, if you run out of free space on that drive.

To move database to another directory, do the following:

1. Go to Configuration → Database
2. Click "Open Folder"
3. Move the contents of the opened folder to the desired directory
4. Click "Change folder" and set the path to the folder where you moved the files on the previous step
5. Wait while Hand2Note restarts

# Additionally

# How to delete hands from database

You can’t selectively delete hands from the database. This feature is not implemented, since the violation of data integrity significantly reduces the performance of the database.

You can create a new database and import only the necessary hands into it.

# How to use your own PostgreSQL server

# How to connect to database using PgAdmin

1. Start Hand2Note
2. Go to Configuration → Database
3. Disable "Connect to custom server" option and then activate an existing database
4. Start the file Hand2Note/pgsql/bin/pgadmin3.exe
5. Press "Add new connection to server"
6. Enter Name=h2nserver, Host=localhost, Port=5318 and press OK
7. Done! Server h2nserver should appear in the list of available servers