m Postgres RDB
- jim mason
- jimm1
Owned by jim mason
Key Points
- very good open-source RDB with vendor support available
- SQL compliant
- good stored procedure support including external procedures
- PLSQL languages include: PLSQL, Python, Java
- drivers for jdbc, odbc
- use the Pipeline DB version for stream processing support
References
| Reference_description_with_linked_URLs_______________________ | Notes______________________________________________________________ |
|---|---|
https://www.postgresql.org/files/documentation/pdf/14/postgresql-14-US.pdf postgres-db-v14.pdf link | postgres documentation |
| https://www.postgresql.org/docs/current/transaction-iso.html | |
| https://www.postgresql.org/docs/9.1/plpython.html | python - internal language along with plsql |
| java is externally supported | |
| https://medium.com/dataseries/using-postgresql-for-real-time-iot-stream-processing-applications-965741c57315 | use PipelineDB for Postgres stream processing support Pipeline was sold and is now discontinued - no SSE for Postgres |
Key Concepts
Potential Value Opportunities
Potential Challenges
Candidate Solutions
Step-by-step guide for Example
sample code block