singlestoredb-laravel-driver
singlestoredb-laravel-driver copied to clipboard
The official SingleStore Laravel driver.
Just installed the package to test out singlestore on a local docker instance. I have the localhost cluster up and running, but when I changed my env connection to the...
Hey there, making my way through building an app based on SingleStore and noticed now, that when the migrations use `->unique()` it by default does not work, since it does...
Hi, The singlestore driver seems incompatible with Vapor. From a middleware where we do this : `auth()->check() === false` Here is the error received : ``` PDOException Illuminate\Database\QueryException SQLSTATE[HY000] [2002]...
Hi Aaron! Another draft PR here, it's missing tests and the implementation is just bare bones. I found [SingleStore's syntax](https://docs.singlestore.com/managed-service/en/reference/sql-reference/full-text-search-functions/match.html) is slightly different from MySQL, so the version from MySqlGrammar...
Hello @aarondfrancis! ```bash composer require --dev nunomaduro/larastan vendor/bin/phpstan analyze -c vendor/nunomaduro/larastan/extension.neon -l 5 src/ ``` You will discover things like ```diff diff --git a/src/Connect/Connection.php b/src/Connect/Connection.php index 5c3e52e..14007af 100644 --- a/src/Connect/Connection.php...
Follow up from https://github.com/singlestore-labs/singlestoredb-laravel-driver/pull/9 This adds support for using [Laravel's `whereFullText(...)`](https://laravel.com/docs/9.x/queries#full-text-where-clauses) method for full text search. Relevant docs pages: - https://docs.singlestore.com/managed-service/en/reference/sql-reference/data-definition-language-ddl/create-table.html#fulltext-behavior - https://docs.singlestore.com/managed-service/en/reference/sql-reference/full-text-search-functions/match.html This would also be the first step...
When adding a column like so: ``` $table->string('model_value')->nullable(); ``` I must set the charset and collation manually so it matches the driver config like so: ``` $charset = config('database.connections.singlestore.charset'); $collation...
Inserting emojis becomes ������ in JSON columns. ```sql CREATE TABLE `test` ( `a` JSON COLLATE utf8mb4_unicode_ci, `b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ); ``` ```php DB::table('test')->insert([ 'a' => json_encode(['text'...
Hey we've got this weird issue where migrations don't create composite primary keys the same way they used to. We used to be able to migrate nullable primary keys but...
When migrating a table with a very long primary key name (usually a set of 2 or more keys) Laravel generates a very long primary key name. This results in...