bookmarkext

Browser extension of bookmark system.

This extensions allows to assign tags to tags themselves. For example, it is possible to create the following hierarchy of tags:

If a bookmarks is created and e.g. tag "haskell" is assigned to it, then it will automatically have "programming", "functional programming", "programming language" and "functional language" tags.

SQL migrations

Flyway is used for migrations. First, create the database manually:

DROP DATABASE IF EXISTS bm;
CREATE DATABASE bm;

Edit backend/sql/flyway.conf. (If you are going to run DB unit tests, then stop at this point and install plpgunit first.) Apply migrations. That's it.

DB unit tests

Plpgunit is used to unit test the sql code. To run the tests:

• install plpgunit
• make sure test migrations from backend/sql/tests are applied
• execute

BEGIN TRANSACTION;
SELECT * FROM unit_tests.begin();
ROLLBACK TRANSACTION;

Backend config

To configure the backend, create backend.cfg file.
If you have custom database name, port, password, then you can specify these values in the config, e.g.:

dbpassword = "UifrxYfL3i5ZNDw8Ce3p"
dbport = 25432
dbname = "bookmarkext"

If you do not provide the values, by default the backend assumes that the password is an empty string, the port is 5432 and the database name is bm.