Oracle Support

[ChandanShakya]

Add support for oracle database

• Missing: Case in-sensitive search
• camelCase relationship access

Currently how i have been doing it:

• For case insensitive search
• Used raw to lower

Column::make('Name', 'full_name')
  ->searchable(
      fn (Builder $query, $searchTerm) => $query->orWhereRaw('LOWER(full_name) LIKE ?', ['%'.strtolower($searchTerm).'%'])
  )->sortable(),

• For camelCasing relationships
• Used snake-Casing

// CalendarEvents model

public function user_creator(): BelongsTo
{
  return $this->belongsTo(User::class, 'created_by', 'id');
}

// CalendarEventsTable
Column::make('Created by', 'user_creator.username')
  ->sortable()
  ->collapseAlways(),

[lrljoe]

Just to confirm - all of your Models are living in Oracle world?

[ChandanShakya]

I have made them such that they are compatible with oracle, mysql and postgresql

[lrljoe]

The only first-party supported by Laravel themselves are:

MariaDB 10.3+ ([Version Policy](https://mariadb.org/about/#maintenance-policy))
MySQL 5.7+ ([Version Policy](https://en.wikipedia.org/wiki/MySQL#Release_history))
PostgreSQL 10.0+ ([Version Policy](https://www.postgresql.org/support/versioning/))
SQLite 3.26.0+
SQL Server 2017+ ([Version Policy](https://docs.microsoft.com/en-us/lifecycle/products/?products=sql-server))

Now, that's not to say that we can't figure something out for Oracle

[ChandanShakya]

I am using the yajra oci8 package for connection

[lrljoe]

Just so I can start to dig into this, what does the below return:

Column::make('Name', 'full_name')
  ->searchable(
      fn (Builder $query, $searchTerm) => $query->orWhereLike('full_name', '%'.$searchTerm.'%', caseSensitive: false)
  )->sortable(),

Does it bring back the correct results or incorrect?

Also try

Column::make('Name', 'full_name')
  ->searchable(
      fn (Builder $query, $searchTerm) => $query->whereLike('full_name', '%'.$searchTerm.'%', caseSensitive: false)
  )->sortable(),

[ChandanShakya]

Column::make('Name', 'full_name')
  ->searchable(
      fn (Builder $query, $searchTerm) => $query->orWhereLike('full_name', '%'.$searchTerm.'%', caseSensitive: false)
  )->sortable(),

This works correctly

Also try

Column::make('Name', 'full_name')
  ->searchable(
      fn (Builder $query, $searchTerm) => $query->whereLike('full_name', '%'.$searchTerm.'%', caseSensitive: false)
  )->sortable(),

This doesnt even search so result is blank