Download the PHP package yousha/dbalite without Composer
On this page you can find all versions of the php package yousha/dbalite. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download yousha/dbalite
More information about yousha/dbalite
Files in yousha/dbalite
Package dbalite
Short Description A lightweight Dbal(Database Abstraction Layer) library for PHP.
License GPL-3.0-only
Homepage https://github.com/yousha/dbalite
Informations about the package dbalite
DBALite
A lightweight DBAL(Database Abstraction Layer) library for PHP.
Contents
- Overview
- Features
- Requirements
- Installation
- Configuration
- Usage
- FAQ
- Support
- Changelog
- ToDo
- Contributing
- Code of Conduct
- DCO
- Contributors
- Notice
- License
Overview
DBALite is a powerful yet lightweight Database Abstraction Layer(DBAL) library designed for PHP developers who need a simple, efficient, and secure way to interact with multiple database systems. Built with modern PHP practices in mind, DBALite provides a clean, intuitive API for performing database operations while ensuring security, flexibility, and performance.
Features
- Database Drivers: Supports MySQL/MariaDB, OracleDB, and SQLite databases.
- Schema Management: Create tables, add columns, drop tables, manage indexes, and more.
- Schema Inspection: Retrieve tables, columns, and check column existence.
- Query Builder: Build SQL queries dynamically using a fluent interface.
- Migrations: Manage database schema changes with migration classes.
- Entity Management: Map database rows to entities and perform CRUD operations.
- Security: Sanitize inputs, validate data, and prevent XSS and SQL injection.
- Transaction Handling: Begin, commit, or rollback transactions safely.
- Query Logging: Log executed queries for debugging purposes.
- Bulk Operations: Perform bulk inserts efficiently.
- SSL Support: Secure connections with SSL certificates.
- Dynamic Configuration: Merge and extend configuration settings at runtime.
- Supported PHP: 8.3
- Supported databases: MySQL/MariaDB(Default), OracleDB, SQLite
- Supported platforms: Microsoft Windows, GNU+Linux, Apple MacOS
Requirements
- PHP >= 8.3
- Composer >= 2
- Database server(MySQL/MariaDB, OracleDB, or SQLite)
Installation
Via Composer:
Configuration
Create a configuration array with your database settings:
Or configuration for OracleDB:
Or configuration for SQLite:
Initialize Dbal instance:
Usage
Quick start snippet:
QA/QC
Run tests to ensure everything works as expected:
Or:
FAQ
See FAQ.txt file.
Support
For any question, issues and feature requests, open an issue..
Changelog
See CHANGELOG.txt file.
ToDo
See TODO.txt file.
Contributing
Contributions are welcome! Please follow these steps:
- Fork repository.
- Create a new branch for your feature or bugfix.
- Submit a pull request with a detailed description of your changes.
For more details see CONTRIBUTING.txt.
Code of Conduct
See CODE_OF_CONDUCT.txt file.
DCO
See DCO.txt file.
Contributors
See CONTRIBUTORS.txt file.
Notice
See NOTICE.txt file.
License
This open-source software is distributed under the GPL-3.0 license. See LICENSE file.
All versions of dbalite with dependencies
ext-filter Version *
ext-pdo Version *