Download the PHP package xbu3n0/laravel-sybase without Composer
On this page you can find all versions of the php package xbu3n0/laravel-sybase. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package laravel-sybase
Sybase ASE based Eloquent module extension for Laravel
- Original codebase https://github.com/uepg/laravel-sybase.
- Use default eloquent: works with odbc and dblib!
- Improvements in delete and insert statements when using array based clauses like whereIn, whereBetween, etc
- Works with MS-SQL connections too via FreeTds
- Support for Laravel versions 7.x, 8.x, 9.x, 10.x
Install
Update
Update the following in the require section of your composer.json:
Update the package dependencies executing:
Install
Update your config/database.php's default driver with the settings for your sybase server or your custom odbc. See the following example: (please note the sybasease driver name)
select top 1 [A] from [...] Without cache: 147ms With cache: 29.17ms
select * from [B] [...] Without cache: 126ms With cache: 7.91ms
select count(*) as aggregate from [...] Without cache: 223ms With cache: 11.91ms dotenv SYBASE_CACHE_COLUMNS=true SYBASE_CACHE_COLUMNS_TIME=TIME_IN_SECONDS # e.g. SYBASE_CACHE_COLUMNS_TIME=600 for 10 minutes text ...
DB_CONNECTION=sybase DB_HOST=sybase.mycompany.com DB_PORT=5000
remove comment on next line to use odbc
DB_DSN="odbc:\\sybase_odbc_name"
DB_DATABASE=mydatabase DB_USERNAME=user DB_PASSWORD=password
... text [sybase] host = sybase.mycompany.com
port is important
port = 6000
# TDS protocol version
tds version = 5.0
[sqlserver] host = mssql.mycompany.com
When connecting to an instance you specify it, and there's no need for the port directive
instance = sqlexpress
tds version = 7.3
[sqlserverexpress] host = myssqlexpress.mycompany.com port = 1433 tds version = 7.3
## Issues
Feel free to ask in https://github.com/xBu3n0/laravel-sybase/issues
All versions of laravel-sybase with dependencies
doctrine/dbal Version ^3.5
illuminate/database Version 8.*|9.*|10.*
illuminate/support Version ~8.0|~9.0|~10.0