Readme
.. image:: https://travis-ci.org/sprin/pg-discuss.svg :target: https://travis-ci.org/sprin/pg-discuss
pg-discuss is a comment system backend written in Python on top of a
PostgreSQL_ database. It is designed to support JavaScript comment widgets
embedded in any page, such as static sites generated by Pelican, Sphinx,
or Nikola. pg-discuss can also be used with a content management system such
as WordPress, or within your own dynamic web app that needs a robust comment
system.
.. _PostgreSQL: http://www.postgresql.org/
.. _Pelican: http://getpelican.com/
.. _Sphinx: http://sphinx-doc.org/
.. _Nikola: https://getnikola.com/
.. _WordPress: https://wordpress.org/
Demo_Features_Installation_Configuration_Internals_ (for Extension Authors and Contributors).. _Demo: https://pg-discuss.sprin.io/en/latest/demo.html .. _Features: https://pg-discuss.sprin.io/en/latest/features.html .. _Installation: https://pg-discuss.sprin.io/en/latest/installation.html .. _Configuration: https://pg-discuss.sprin.io/en/latest/configuration.html .. _Internals: https://pg-discuss.sprin.io/en/latest/internals/index.html
pg-discuss has a feature set comparable to popular commercial comment management systems. However, pg-discuss does not sell your users' browsing habits and comments to marketers. You have full control over how your users' information is used.
pg-discuss is a MIT-licensed open source project that allows you to operate, extend, and redistribute the application as you see fit. Contributions are welcome.
The pg-discuss API can be adapted to work with existing embeddable comment widgets. Of course, new widgets can also be written using the default REST API.
The application is highly extensible, with most default features implemented as extensions which are bundled. Extensions can change the comment workflow, comment metadata collection, rendering engine, authentication, and HTTP API format and endpoints. Extensions are implemented using a simple API that exposes logical plugpoints and events.
The core package of pg-discuss is less than 1000 lines. Code is structured for readability, conforms to PEP8, and has ample comments. It is written to be very approachable for both auditors and extension developers. Both prose and API documentation of internals are published.
PostgreSQL offers strong data guarantees, ease of management, and high performance. pg-discuss is written to take advantage of several PostgreSQL-specific features that enable flexible extension and low latency querying.
The pg-discuss application can be deployed across many hosts for redundancy or load balancing since it does not store any application state itself - all state is held in the PostgreSQL database or in the client browser session. pg-discuss also plays well with HTTP caches such as nginx, and a simple extension can inform the cache when to purge stale objects.
There are several good alternatives to pg-discuss that are also open source, but have somewhat different design goals.
Perhaps you don't want to run a database?
Isso_ is an excellent SQLite-backed comment server - there is no separate
database instance to run, since the data is stored in a file. Also written
in Python. MIT licensed.
.. _Isso: http://posativ.org/isso/
Need a comment widget that also has file uploads, polling, private messaging, analytics, all out of the box?
Discourse_ is a discussion platform with a long list of features_, with a
Ruby on Rails backend on top of PostgreSQL. GNU GPL v2 licensed.
.. _Discourse: http://www.discourse.org/ .. _long list of features: http://www.discourse.org/about/
FAQs
A comment system backend on top of PostgreSQL
We found that pg-discuss demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
The Socket research team breaks down a sampling of malicious packages that download and execute files, among other suspicious behaviors, targeting the popular Discord platform.
Security News
Socket CEO Feross Aboukhadijeh joins a16z partners to discuss how modern, sophisticated supply chain attacks require AI-driven defenses and explore the challenges and solutions in leveraging AI for threat detection early in the development life cycle.
Security News
NIST's new AI Risk Management Framework aims to enhance the security and reliability of generative AI systems and address the unique challenges of malicious AI exploits.