Download the PHP package finesse/mini-db without Composer
On this page you can find all versions of the php package finesse/mini-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download finesse/mini-db
More information about finesse/mini-db
Files in finesse/mini-db
Package mini-db
Short Description Light database abstraction with a query builder
License MIT
Homepage https://github.com/Finesse/MiniDB
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 mini-db
MiniDB
Lightweight database abstraction in which rows are simple arrays. It has both a query builder for convenient fluent syntax and an interface for performing pure SQL queries.
Key features:
- Light with a small number of light dependencies.
- Extensible. Examples will come soon.
- The query builder and the database connector can be used separately.
- Supports table prefixes.
- No static facades. Explicit delivery using dependency injection.
- Exceptions on errors.
Supported DBMSs:
- MySQL
- SQLite
- Maybe any other, didn't test it
If you need a new database system support please implement it there and there using pull requests.
Installation
You need Composer to use this library. Run in a console:
Reference
Getting started
You need to make a Database instance once:
See more about the PDO options at the PDO constructor reference.
Alternatively you can create all the dependencies manually:
Raw SQL queries
The cell values are returned as they are returned by the underlying database connection. They are not casted automatically because casting can cause a data loss.
Table prefix is not applied in raw queries. Use $database->addTablePrefix() to apply it.
Be careful, the statements and the import methods don't throw an exception if the second or a next statement of the
query has an error. This is a PDO bug.
You can find more information and examples of raw queries there.
Query builder
Basic examples are presented here. You can find more cool examples there.
Values given to the query builder are treated safely to prevent SQL injections so you don't need to escape them.
Select
Many rows:
One row:
Pagination
We suggest Pagerfanta to make a pagination easily.
First install Pagerfanta using composer by running in a console:
Then make a query from which the rows should be taken:
And use Pagerfanta:
You can find more reference and examples for Pagerfanta there.
Chunking rows
If you need to process a large amount of rows you can use chunking. In this approach portions of rows are fetched from the database instead of fetching all the rows at once.
Aggregates
Other aggregate methods: avg(column), sum(column), min(column) and max(column).
Insert
Many rows:
The string array keys are the columns names.
One row:
From a select query:
Update
The array keys are the columns names.
Delete
Helpers
Escape LIKE special wildcard characters:
Wrap a table or a column name in quotes:
The above methods are also available in a Database object.
Make all the column names in the query have explicit table name or alias:
Versions compatibility
The project follows the Semantic Versioning.
License
MIT. See the LICENSE file for details.
