Download the PHP package yoramdelangen/laravel-pdo-odbc without Composer
On this page you can find all versions of the php package yoramdelangen/laravel-pdo-odbc. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download yoramdelangen/laravel-pdo-odbc
More information about yoramdelangen/laravel-pdo-odbc
Files in yoramdelangen/laravel-pdo-odbc
Package laravel-pdo-odbc
Short Description PDO ODBC/Snowflake integration for Laravel framework. Support ODBC and native PDO Snowflake.
License MIT
Homepage https://github.com/yoramdelangen/laravel-odbc
Informations about the package laravel-pdo-odbc
ODBC/Snowflake Integration for Laravel Framework
This repository provides seamless integration of ODBC/Snowflake with Laravel Eloquent. It aims to create a comprehensive ODBC package for Laravel, while also functioning as a standalone solution.
Unlike the odbc_*
functions, this package utilizes the PDO
class,
resulting in smoother and more convenient integration with Eloquent.
The primary goal of this package is to offer a standardized approach to connect with an ODBC connection. It supports custom grammars and schemas to accommodate various ODBC connections, such as Snowflake.
How to Install
Before proceeding, ensure that you have PHP version 8.x installed on your system.
To add the package to your project, run the following command:
By default, the package will be automatically registered through the
package:discover
command.
Alternatively, you can manually register the service provider in the app.php
file:
If you intend to use the snowflake_pdo
PHP extension, please follow the
installation guide provided here
to set it up.
Starting from version 1.2.0
, the package includes support for snowflake_pdo
,
but it will still function without the Snowflake extension (via ODBC).
Configuration
The available driver flavors are:
- ODBC (generic)
- Snowflake (via ODBC and native through PHP extension)
- ...
Snowflake Specific environment variables
You have the option to customize the Snowflake driver using the following parameters:
Usage
Configuring the package is straightforward:
Add a Database Configuration to database.php
Starting from version 1.2, we recommend using the native Snowflake extension instead of ODBC, but we'll keep supporting it.
You have multiple ways to configure the ODBC connection:
-
Simple configuration using DSN only:
or, if you don't have a datasource configured within your ODBC Manager:
Note: The DSN
Driver
parameter can either be an absolute path to your driver file or the name registered within theodbcinst.ini
file/ODBC manager. -
Dynamic configuration:
All fields, except for
driver
,odbc_driver
,options
,username
, andpassword
, will be dynamically added to the DSN connection string.Note: The DSN
odbc_driver
parameter can either be an absolute path to your driver file or the name registered within theodbcinst.ini
file/ODBC manager.
Eloquent ORM
You can use Laravel, Eloquent ORM, and other Illuminate components as usual.
Troubleshooting and more info
We have documented all weird behavious we encountered with the ODBC driver for Snowflake. In case of trouble of weird messages, checkout the following links:
- Snowflake ODBC
- Snowflake ODBC Troubleshooting
Customization
- Custom
getLastInsertId()
Function - Custom Processor/QueryGrammar/SchemaGrammar