Databases Generation

Negroni simplifies the process of integrating with various database types by offering support for:

• PostgreSQL
• MySQL
• HSQL
• MSSQL
• Oracle

You have the flexibility to choose the database that best suits your needs or preferences. Each option comes with its own set of syntaxes for creating tables, auto-increment, and other database-specific features. Negroni employs ANSI query language to ensure that generated queries seamlessly work across different database types.

Components Generated Under Databases

Auto-Increment Functionality

Negroni automates the generation of unique identifiers, commonly known as primary keys, for each model in your application. This eliminates the need for users to implement their own solutions for creating unique identifiers. The syntax for this functionality is tailored to the specific requirements of each supported database type.

Coalesce Function

Negroni introduces the Coalesce function, allowing you to ignore null values in each column during updates. This ensures that the Update operation only modifies the provided values while ignoring null columns, enhancing the precision of data manipulation.

Limit & Offset Optimization

For efficient data retrieval, Negroni provides the option to apply Limit & Offset when fetching records from the database. This functionality proves particularly useful when dealing with large datasets, significantly improving response times and reducing the amount of data transferred to the client.

Join Queries

Negroni goes beyond basic CRUD operations by enabling the generation of JOIN queries based on the relationships defined in your models. This feature is invaluable for fetching data based on associations between models. For example, you can easily retrieve all orders associated with a specific customer.

These comprehensive functionalities make Negroni a powerful tool for database generation, streamlining the development process and enhancing the performance of your applications.