Search Results for "oracle sql query builder"

ATK Data is a data persistence and modeling framework for PHP, developed as part of the Agile Toolkit. It provides a high-level abstraction for working with databases, making it easier to define and manipulate data models with minimal boilerplate code. It supports various SQL and NoSQL databases and integrates seamlessly with Agile UI and other PHP frameworks.

DoctrineJsonFunctions is a library that adds native support for JSON-related SQL functions to Doctrine ORM. It extends Doctrine’s DQL capabilities to handle PostgreSQL, MySQL, and SQLite JSON functions, enabling developers to write expressive queries involving JSON fields directly in DQL. This is especially useful for applications that store semi-structured data in relational databases.

Advanced data tables using Laravel, Livewire, Tailwind CSS, and Alpine JS. It is possible to take full control over your table, you can define a builder method using whatever query you like, using your own joins, groups, etc., and then name your columns using your normal SQL syntax. If you want to give your users the ability to pin specific records to be able to, for example, compare them with each other, you can use the CanPinRecords trait. Ensure to have at least one Checkbox Column so the user can select records.

FluentPDO is a PHP library that provides a fluent interface for building SQL queries using PHP’s PDO. It helps developers write clean, readable SQL-like statements in a programmatic way, simplifying interaction with relational databases while retaining full control. FluentPDO is ideal for lightweight PHP applications that need query flexibility without a full ORM.

github: https://github.com/samedog/phpmvs

This is a component to create dinamic database queries from a check list view. You can set a db object (views/tables/etc) to select columns to be shown in the main checklist to build a query based in the check selection. Add dinamic (sql) or static HTML selects to filter results through wheres with few lines. Create dinamic XLSX reports easily (XLSXWritter)

SynApp2 builds feature-packed web applications and versatile PDF reports for MySQL and Oracle Database. The SynApp2 web application generator and MVC framework is written in PHP and JavaScript.

DBE (Database Explorer) is a complete database front-end written in PHP. It supports MySQL, PostgreSQL, Oracle, MSSQL, Firebird/Interbase, and SQLite. Features include relations support, custom query execution, and data imports/exports. Please note that this page only contains stable releases. For up-to-date code please visit the project's GitHub Page: https://github.com/voran/dbe .

BASE is the Basic Analysis and Security Engine. It is based on the code from the Analysis Console for Intrusion Databases (ACID) project. This application provides a web front-end to query and analyze the alerts coming from a SNORT IDS system.

reportmaker allows you to define a generic report in xml containing sections,graphs,tables,images. The data can be retrieved directly with sql query. The report can be exported in various formats (html,xml,rtf,pdf)