Skip to content

Migrate to PostgreSQL#519

Merged
MarekSuchanek merged 2 commits intodevelopfrom
feature/postgres
Mar 19, 2024
Merged

Migrate to PostgreSQL#519
MarekSuchanek merged 2 commits intodevelopfrom
feature/postgres

Conversation

@MarekSuchanek
Copy link
Copy Markdown
Contributor

@MarekSuchanek MarekSuchanek commented Mar 19, 2024

This pull request migrates the application's database from MongoDB to PostgreSQL. The transition is part of a broader effort to improve data integrity, performance, and maintainability. By leveraging PostgreSQL’s relational structure and robust feature set, we gain more control over data consistency, querying capabilities, and transactional operations.

  • Support for transactions: Ensures data consistency across complex operations.
  • Stronger data integrity: Enforces schemas, relationships, and constraints at the database level.
  • Advanced querying capabilities: Enables powerful SQL queries and indexing strategies.
  • Better alignment with RDF triple store: Simplifies integration and potential for joins where needed.
  • Improved maintainability: Easier to manage migrations, structure, and long-term evolution.
  • Operational maturity: PostgreSQL offers better tools for backup, monitoring, and scaling.

@MarekSuchanek MarekSuchanek added the feature Request for new functionality label Mar 19, 2024
@MarekSuchanek MarekSuchanek self-assigned this Mar 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

feature Request for new functionality

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant