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

composer require xBu3n0/laravel-sybase

Update

Update the following in the require section of your composer.json:

"xBu3n0/laravel-sybase": "~3.3"

Update the package dependencies executing:

#> composer update

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)

<?php
...
return [
    ...
    'connections' => [
        ...
        'sybase' => [
            'driver' => 'sybasease',
            'host' => env('DB_HOST', 'sybase.myserver.com'),
            'port' => env('DB_PORT', '5000'),
            //'dsn' => env('DB_DSN'),  // remove comment in case you define an odbc connection in your env
            'database' => env('DB_DATABASE', 'mydatabase'),
            'username' => env('DB_USERNAME', 'user'),
            'password' => env('DB_PASSWORD', 'password'),
            'prefix' => '',
            'charset' => '', // change to the charset used in your application
        ],
        ...
    ],
    ...
]

You can keep the columns cached to optimize library queries, saving 100~150ms for each `select`, `update` and `delete`.

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

The cache cost is `Sum (column name size)` that the cached tables have (the memory cost to activate compensates for the efficiency).

To enable this feature add this to the `.env` file of your project:
```dotenv
SYBASE_CACHE_COLUMNS=true
SYBASE_CACHE_COLUMNS_TIME=TIME_IN_SECONDS # e.g. SYBASE_CACHE_COLUMNS_TIME=600 for 10 minutes

Update your .env with the settings for the sybase connection. See the following example:

...

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

...

Configuration of freetds driver

In Linux systems the driver version must be set in freetds.conf file to the right use of charset pages.

The file is usualy found in /etc/freetds/freetds.conf. Set the configuration at global section as the following example:

[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