Database and Entity Support

[lcnvdl]

Title: Database and Entity Support

Description: This ticket aims to introduce comprehensive support for databases and entities in HtmlGo. The goal is to enable developers to seamlessly interact with databases, read and interpret entities, and automatically map them for easy usage within HtmlGo applications.

Key Objectives:

• Database Connectivity: Implement a robust database connectivity mechanism that allows HtmlGo applications to establish connections with various database systems.
• Entity Definition and Mapping: Introduce a syntax for defining entities within HtmlGo, specifying their attributes, relationships, and mapping details.
• CRUD Operations: Provide built-in support for common CRUD (Create, Read, Update, Delete) operations on entities, simplifying database interactions.
• Query Language: Design and implement a query language that allows developers to perform advanced database queries and retrieve specific data from entities.
• Transaction Management: Implement transactional support to ensure data integrity and consistency when performing database operations on entities.
• Error Handling: Introduce robust error handling mechanisms to gracefully handle database-related errors and exceptions within HtmlGo applications.

By incorporating database and entity support into HtmlGo, we aim to streamline the development process for database-driven applications. This ticket involves extensive database integration, query parsing, and mapping logic, and it requires careful consideration of performance, security, and usability aspects.

Contributions and suggestions are welcome as we work together to bring database and entity support to HtmlGo and empower developers to build dynamic, data-driven applications. Let's make HtmlGo a versatile language for database interactions and entity management!

Please feel free to provide feedback, ask questions, and contribute to this ticket. Let's shape the future of HtmlGo together!

[lcnvdl]

Here are the notes regarding the decisions made for the database plugin (devlog):

• Choice of NHibernate and NHibernate Fluent: To expedite development, we've decided to use NHibernate along with NHibernate Fluent for database connection and operations.

• Partial Plugin System: We've implemented a basic plugin system that will serve as the foundation for the plugin system ticket #2.

• Database Connectivity: Database connection information will be read from environment variables to ensure flexibility and security. The initial focus is on supporting a single database rather than multiple databases. However, we plan to extend this functionality in the future.

• Initial SQLite Support: Currently, HtmlGo supports SQLite as the database engine. However, future updates will include support for other popular database engines such as Oracle, MySQL, and SQL Server.

• Entity Definition and Mapping: We are currently working on designing entity mappings. We are considering basing entities on HTML

  definitions, but this is still under development.

  CRUD Operations: We are actively working on implementing CRUD (Create, Read, Update, Delete) operations for database entities.

  Query Language: Initially, direct raw queries to the database will not be allowed. However, we are considering the possibility of incorporating a query language in the future.

  Transaction Management: We support transaction management for those developers who require it.

  Error Handling: Error handling has not been addressed at this stage, but it will be taken into consideration as the development progresses.

  These notes highlight the decision-making process and the current state of the database plugin development. Please note that these details are subject to refinement and updates as we continue to improve HtmlGo's database functionality.

  Your feedback and suggestions regarding these decisions are highly appreciated as we work towards creating a robust and feature-rich database plugin for HtmlGo.

  lcnvdl commented 1 year ago

  Reopen reason: not finished. Just a first approach.

  • © Githubissues.
  • Githubissues is a development platform for aggregating issues.

[lcnvdl]

Reopen reason: not finished. Just a first approach.