Download the PHP package ice-cream/database without Composer
On this page you can find all versions of the php package ice-cream/database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download ice-cream/database
More information about ice-cream/database
Files in ice-cream/database
Package database
Short Description Database connection handler for IceCream Framework
License MIT
Informations about the package database
Ice Cream Database
A DBAL at the most simplest of terms. Its a thin wrapper around PDO, while returning a connected PDO object.
We can connect to multiple database instances of either PGSQL or MYSQL (see below) and create open connections to each.
- Requires PHP 7.2.x
- Is Standalone
Install
composer require ice-cream/database
Purpose?
I wanted to understand PDO, and I still have a lot to learn about it. I could have used and created a thin wrapper around Doctrines DBAL, much like I did with Ice Cream Router in the sense that I did a thin wrapper around Symfony's router.
But I thought I could build something super simple, super easy to get started with and something that allowed me to understand exactly how PHP connects to a database.
While this isn't as fully flushed out as a regular DBAL, it is a good step in the process. You open a connection, get a db object back, do your work and you move on with your life.
There is room for growth here and room for improvement and your feedback and help will help to shape Ice Cream components into a framework.
Documentation
You can see the full documentation for the project here
Configuration
Create a new connection instance:
This will throw a PDO exception if we cannot connect to the database. This constructor will also connect to all databases registered in the connection array.
ATTN!!
At this time the options you see specified in the array are the only ones we accept. I wanted to get this component out the door in a couple of days and decided to keep it as simple as possible for the first iteration.
So now that we are connected what can we do?
ATTN!!
Notice in the configuration how we have the key as
mysql
orpgsql
as well assqlite
?This is important because these correlate to the supported drivers that create the connection strings to connect to the database in question.
These names are also whats stored in the associated connections manager that manages all connections.