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 8.3.
License GPL-3.0-or-later
Homepage https://github.com/yousha/dbalite
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package dbalite
DBALite
A lightweight DBAL(Database Abstraction Layer) library for PHP 8.3.
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
- PHP 8.3
Supported databases
This library supports multiple database drivers, including:
- MySQL: Default driver for MySQL/MariaDB databases.
- OracleDB: Driver for Oracle Databases.
- SQLite: Lightweight driver for SQLite databases.
Installation
Via Composer:
Configuration
Create a configuration array with your database settings:
Or configuration for OracleDB:
Or configuration for SQLite:
Initialize Dbal instance:
Usage examples
1. Querying data
2. Executing statements
3. Managing transactions
4. Schema management
5. Security
Sanitize inputs to prevent XSS and SQL injection:
6. Dynamic configuration
Merge additional settings into configuration:
7. Running migrations
To run migrations, use bin/dbalite-migrate.php script:
QC test
Run tests to ensure everything works as expected:
Or:
Changes/Updates
See CHANGELOG.txt file.
Support
For issues and feature requests, please open an issue.
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 information see CONTRIBUTORS.txt files.
Code of Conduct & DCO
See DCO.txt files.
License
This project is licensed under GNU GPLv3. See LICENSE file for details.
All versions of dbalite with dependencies
ext-pdo Version *
ext-filter Version *