Pwic.wiki 1.2 - Stable release

Pwic.wiki is a flexible and compact wiki server to support the documentation of your projects. It is based on Python, SQLite and Markdown. It is also integrated well with OpenDocument Text (ODT).

In comparison with the previous release 1.1, this version includes many technical features related to the performances, security and BI integration.

The future of Pwic.wiki will depend on your requests and contributions. Feel free to raise your needs in the tracker.

Upgrade

Adjusting your custom code will be required: some names and formats have changed. A simple check with flake8 and mypy can identify the required changes.

From the previous release 1.1, you must convert your database as follows:

UPDATE projects SET date = '1970-01-01' WHERE date = '';
UPDATE users SET password_date = '1970-01-01' WHERE password_date = '';
UPDATE users SET password_time = '00:00:00' WHERE password_time = '';
PRAGMA foreign_keys=OFF;
ALTER TABLE users RENAME TO tmp_users;
CREATE TABLE users ("user" TEXT NOT NULL, "password" TEXT NOT NULL, "initial" TEXT NOT NULL CHECK("initial" IN ('', 'X')), "totp" TEXT NOT NULL, "password_date" TEXT NOT NULL, "password_time" TEXT NOT NULL, PRIMARY KEY("user"));
INSERT INTO users (user, password, initial, totp, password_date, password_time) SELECT user, password, initial, '', password_date, password_time FROM tmp_users;
DROP TABLE tmp_users;
ALTER TABLE users RENAME TO tmp_users;
ALTER TABLE tmp_users RENAME TO users;
PRAGMA foreign_keys=ON;

It is recommend to clear the cache to benefit from the updated Markdown parser:

./pa clear-cache

Reference links

You can test the new release online at https://pwic.wiki !

Use our bug tracker if you have any question, idea or issue.

Pwic.wiki 1.1 - Stable release

Pwic.wiki is a flexible and compact wiki server to support the documentation of your projects. It is based on Python, SQLite and Markdown. It is also integrated well with OpenDocument Text (ODT).

In comparison with the previous release 1.0, this version includes the internationalization (i18n) with English/French/German to date, the compression of the cache, and a lot of internal improvements for the quality of the code base.

The future of Pwic.wiki will depend on your requests and contributions. Feel free to raise your needs in the tracker.

Upgrade

Adjusting your custom code will be required. Indeed, all the internal prefixes for the functions pwic_ and the constants PWIC_ have been renamed with PwicLib. and PwicConst. respectively. A simple check with flake8 will identify the obvious changes to be done.

From the previous release 1.0, you must convert your database as follows:

UPDATE env SET key = 'feed_size' WHERE key = 'rss_size';
UPDATE env SET key = 'no_feed' WHERE key = 'no_rss';

To benefit from the compression of the cache and the upgraded Markdown convertor, you may want to clear the cache:

./pa clear-cache

Reference links

You can test the new release online at https://pwic.wiki !

Use our bug tracker if you have any question, idea or issue.

The YouTube channel includes few videos already.

Pwic.wiki 1.0 - Stable release

Pwic.wiki is a flexible and compact wiki server to support the documentation of your projects. It is based on Python, SQLite and Markdown.

In comparison with the previous release 1.0-rc8, this version is a technical fine tuning with minor changes. But most importantly, it is the first major stable release that you can use at its best. It celebrates all the quality tests performed during the last months, and it finalizes all the core objectives identified 2 years ago.

We are now ready to hear you more about features and enhancements ! The most awaited one is i18n.

Upgrade

Only if you upgrade from the previous release 1.0-rc8, you must convert your database as follows:

    DROP TRIGGER audit.audit_archiver;
    CREATE TRIGGER audit.audit_archiver BEFORE DELETE ON audit.audit BEGIN INSERT INTO audit_arch SELECT * FROM audit WHERE id = OLD.id; END;

Reference links

You can test the new release online at https://pwic.wiki !

Use our bug tracker if you have any question, idea, or issue.

The YouTube channel includes few videos already, and will grow over the time.

Pwic.wiki 1.0-rc8

Pwic.wiki is a flexible and compact wiki server to support the documentation of your projects. It is based on Python, SQLite and Markdown.

This new big release brings to you the following features :

• Default support for HTML
• Import ODT files to Markdown
• Shortcuts for the editor
• Auto-table from the clipboard
• List of emojis
• Spoilers
• Sortable tables
• Copyable code blocks
• Annotations for the export to ODT
• Cache regeneration
• New options
• New enhancements points
• Stronger code base

Unless you start from this new release :

1. You must convert your existing database with the command python3 pwic_admin.py execute-sql :

DROP TRIGGER audit_archiver;
DROP TRIGGER audit_no_update;
ALTER TABLE audit.audit RENAME COLUMN revision TO reference;
ALTER TABLE audit.audit_arch RENAME COLUMN revision TO reference;
CREATE TRIGGER audit.audit_no_update BEFORE UPDATE ON audit.audit BEGIN SELECT RAISE (ABORT, 'The table AUDIT should not be modified'); END;
CREATE TRIGGER audit.audit_archiver BEFORE DELETE ON audit BEGIN INSERT INTO audit_arch SELECT * FROM audit WHERE id = OLD.id; END;

2. Regenerate your cache :

python3 pwic_admin.py clear-cache
python3 pwic_admin.py regenerate-cache

You can test the new release online at https://pwic.wiki !

Use our bug tracker if you have any question, idea, or issue.

The YouTube channel includes few videos already, and will grow over the time.

Pwic.wiki 1.0-rc7

Pwic.wiki is a lightweight wiki server to support the documentation of your projects through comprehensive features and 5 basic roles. Its purpose is to serve as a common repository where the essential documentation can be easily located, accessed, edited, compared, validated, shared, exported and eventually analyzed by your own scripts.

Pwic.wiki is an advanced concept that attempts to fix frequent caveats that you can face when you participate to an IT project. If you ever wasted your time on managing your files, templates, styles and validations, you are probably searching for a fresh solution to support your process!

The official homepage is running the latest version of the application.