Postgres - Interface

[flurfis]

Summary

Implemented a PostgreSQL interface (PGInterface). With the interface, it is possible to connect to polypheny via the PostgreSQL JDBC driver.

---

Changes

The interface is mainly isolated from the rest of the code, so apart from the new features, no changes to the existing architecture were done.

---

Features

• Ability to create a PGInterface via the UI
• Connect with a PostgreSQL JDBC driver to Polypheny via the PGInterface
• Execute queries through this connection

---

Tests

The tests were implemented in the dbms module.

• Integration tests for the PGInterface - tests simulate a client who uses PostgreSQL JDBC
• Some DML, DQL and DDL commands are tested
• Prepared Statements are tested

---

ToDo

There are several starting points for future work. Some major points of interest are listed below, and smaller ToDo's are marked in the code.

• [ ] Verify design and implementation
• [ ] Verify test coverage and CI build status
• [ ] Verify documentation (including upgrade notes)
• [ ] Implement SSL - support into Netty (--> enable other authentication methods)
• [ ] Support and test more data types
• [ ] Support and test more SQL commands (mainly TCL and DCL)
• [ ] Improve how incoming messages are categorized
• [ ] Improve how information from the incoming messages is gathered
• [ ] Support Prepared Statement sent via the JDBC framework