Scheduler with SQLite only

I am having this idea in my head and i tried, but cannot get it to work so far. My goal is to have a Laravel SAAS App running in Cloud with Task Scheduler Enabled and Postgres Hibernation. So lets explain: I have multiple SaaS Services which use Postgre Database i would love to migrate them to Cloud. They fetch some Data like once and hours or every six hours from somewhere and

xasz's avatar
xasz's avatar vincent150...Laravel
1

SQLSTATE[HY000]: General error: 1 no such table: sessions (Connection: sqlite, SQL: select * from "sessions" where "id" =

Hello there, I'm working on a multi-tenancy application and just setting it up. I'm using stancl/tenancy following the guide on tenancyforlaravel.com. After setting it up, everything worked fine, but when I moved my 0001_01_01_000000_create_users_table.php migration into the database/migrations/tenant directory and reran the migration, I started getting the following error: SQL

christaiwo's avatar
christaiwo's avatar kai.trenba...General
2

Deploying app to Forge that uses sqlite database

I have been testing an app that currently runs on a sqlite db. I deployed it to a Forge site via my git repo. How do I push the sqlite file up to the server? Do I just add the database file to the git repo?

earmsby's avatar
earmsby's avatar SnapeyForge
3

Odd issue with casting on SQLite database

I really hope someone could shed some light becuase I haven't got a clue what could be wrong. I have a project that generates calendar events and send them to a Google calendar. The events are first generated locally and then sent to Google. Both of these operations are done by jobs, and they are queued. My app was running PHP 8.3.15, Laravel10.43.0, SQLite 3.40.1 on a Raspberr

troccoli's avatar
troccoli's avatar troccoliLaravel
2

sqlite migration is weird

I have the following database table in a sqlite database: sqlite> .schema owners CREATE TABLE IF NOT EXISTS "owners" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "phone" varchar, "address" varchar, "tos" text not null, "created_at" datetime,

splitbrain's avatar
splitbrain's avatar splitbrainEloquent
1

Poor performances when migrating from SQLite to Postgresql

I am using Laravel 11 with Inertia.js and React. Until now, as I was prototyping, I was using SQLite in development environment as well as in a test prod environnement I had set up. Recently attempted to deploy to a real production server based in Switzerland (I'm based in Montréal), with Laravel Forge to provision the server, and Postgresql instead of SQLite (hosted on the sam

mathcrln's avatar
mathcrln's avatar mathcrlnEloquent
6

Database locked errors with multiple queue workers and SQLite

I have two queue workers listening on the same queue thats using SQLite. When they both get a lot of short tasks I start seeing database locked errors in logs. This causes the job to have a failed state and be retried even if it was successful. This is a bit problematic since the jobs deal with files and executing them again fails with a file not found. Here is a relevant log l

OrakMoya's avatar
OrakMoya's avatar Tray2Laravel
5

Integrity constraint violation on a nullable field with sqlite testing

I am trying again to get some test set up, but starting to remember why i gave up on them in the past. I am using PEST, along with laravel modules set up, PHPunit.xml is set with the following: <env name="DB_CONNECTION" value="sqlite"/> <env name="DB_DATABASE" value=":memory:"/> PEST.PHP (note it was suggested to ad

jcc5018's avatar
jcc5018's avatar LaryAILaravel
1

Strange Issue with `selectRaw` and `with` during Testing with SQLite

Hello everyone, I've encountered a strange issue in my Laravel project and could really use some help. I have the following method in my Statement model: public function territoryRevenues() { return $this->revenues() ->selectRaw(" 'App\\\\Territory' as source_type, series.territory_id as id, series.territory_id as sourc

MichMich's avatar
MichMich's avatar MichMichLaravel
2

RefreshDatabase / SQLite / Not running schema?

So I have a bunch of tests set up to use RefreshDatabase ... and I have the testing-db set to be an in-memory SQLite ... But we currently have squashed migrations (and subsequent migrations since that) ... and it appears that RefreshDatabase isn't actually running the squashed schema at all? As none of the tables appear to exist. But all the documentation just say to use Refr

EliW's avatar
EliW's avatar ks500Laravel
2

SQLite : dropForeign method removes all my database tables after doing migrate:rollback

Doing php artisan migrate:rollback removes all my tables in my database. The down method in my migration file should drop the foreign key user_id. but instead it removes all my tables. I use SQLite, and the Laravel documentation says : SQLite only supports foreign keys upon creation of the table and not when tables are altered. When writing my down method like that, I get an

loddaa's avatar
loddaa's avatar loddaaLaravel
1

Can any one help to confirm sqlite not allow custom collation

Fresh install Laravel 11 with use sqlite and then change the users migration // change $table->string('name'); // to $table->string('name')->collation('utf8mb4_bin')->unique(); and then refresh the database with use php artisan migrate:fresh will you see an error of this? SQLSTATE[HY000]: General error: 1 no such collation sequence: utf8mb4_bin

newbie360's avatar
newbie360's avatar newbie360Laravel
9

Laravel 11 PHPUnit Testing SQLite morphTo attach double prefix in database name

I just upgraded to Laravel 11 and started running my PHPUnit tests when I ran into this error: SQLSTATE[HY000]: General error: 1 no such table: main.PRE_PRE_event_registrations (Connection: sqlite, SQL: insert into "PRE_event_registration_items" ("cost", "created_at", "event_registration_id", "name", "quantity", "

codegreen's avatar
codegreen's avatar russellxuEloquent
15

Tinker not reading SQLite Through Models

I am getting an error when I am trying to call for a model Job using tinker: Illuminate\Database\QueryException SQLSTATE[HY000]: General error: 10 disk I/O error (Connection: sqlite, SQL: select * from "job_listings"). I wonder what I am missing here? Do I need to change anything in project so SQLite working with tinker or something. Thanks

azizabbas's avatar
azizabbas's avatar SnapeyEloquent
9

Locale aware SQLite orderBy

another question somewhat related to my previous question https://laracasts.com/discuss/channels/laravel/locale-aware-collection-sorting When using SQLite db how do I make Eloquent ->orderBy() sort these czech characters correctly like this? ['a', 'á', 'c', 'č', 'd', 'ď', 'e', 'é', 'ě', 'i', 'í', 'n', 'ň', 'o', 'ó', 'r', 'ř', 's', 'š', 't', 'ť', 'u', 'ú', 'ů', 'z', 'ž']; T

vitnasinec's avatar
vitnasinec's avatar LaryAIEloquent
1

Trying to switch Dusk to use sqlite test DB

I'm trying to configure Dusk to use a sqlite DB instead of mysql as I currently have, in the (vain?) hope that this will speed my tests up a little. My project is a Laravel 10 /Vue 3 project running inside Homestead Vagrant 2.3.3 with Ubuntu. And I'm running Vite on Windows 10, so outside the vm. I have a .env.dusk.local file used when I run Dusk with: DB_CONNECTION=sqlite DB_D

bwrigley's avatar
bwrigley's avatar bwrigleyTesting
0

problem with creating a sqlite database

I am running Laravel Herd on my Windows system. During the setup of my project, I selected "sqlite" as my database. However, when I try to verify this using the command "php artisan db:show", I get an error that indicates a dependency conflict between doctrine/dbal and carbonphp/carbon-doctrine-types via nesbot/carbon. I believe I resolved this conflict with

lornstil's avatar
lornstil's avatar LaryAIGeneral
1

Create testing env sqlite

Hello, I want to create tests. My database is MySQL and I created a mysql-schema file. My test environment is sqlite. How to recreate my database in sqlite with the mysql schema file. When I run the tests it only shows me the latest migrations. Thank you in advance for your assistance

dam28800's avatar
dam28800's avatar tykusLaravel
1

Log sqlite query in Telescope / Debugbar

I use SQLite (in file, not in memory) for some of my models. I would like to log the underlying queries in my debugbar and/or Telescope as it happens for the underlying queries I have for models queried from MySQL. For now, I see the loaded models both in my debugbar and Telescope but the queries are not logged. I don't find any configuration in the Debugbar or Telescope to log

renov's avatar
renov's avatar renovLaravel
2

Larvel Pulse: Unsupported database driver [sqlite].

When executing phpunit, the migration 2023_06_07_000001_create_pulse_tables.php is run on the SQLite database, resulting in an Exception: Unsupported database driver [sqlite]. Is it possible to skip the migration? I tried adding PULSE_ENABLED=false to phpunit.xml, but it didn't have any effect.

davidvandertuijn's avatar
davidvandertuijn's avatar davidvande...Laravel
3

Does dropColumn() deletes virtualAs column in sqlite?

I have an issue with PHPUnit/PEST test running with sqlite. First I have the following migration, which creates and end_date column with the ->virtualAs() method: public function up(): void { $isSqlite = \Illuminate\Support\Facades\DB::getDriverName() === 'sqlite'; Schema::create('project_assignments', function (Blueprint $table) use ($isSqlite) {

Marven's avatar
Marven's avatar MarvenLaravel
2

How to upgrade Sqlite to the latest version

Hello everyone, At this moment, I am running phpunit tests, using Sqlite database engine, which its version is 3.37.2. However, I would like to upgrade it to the latest one (3.43.0), in order to get all new features. Has anyone dealt with a similar case or know how to do it ? Or maybe, sail is still not compatible with the latest version of sqlite? Sail Version 1.25.0 Laravel V

KarinaRashchynskaya's avatar
KarinaRashchynskaya's avatar KarinaRash...Laravel
0

Disable foreign keys in sqlite on specific tests

Hello! In order to avoid having to do too much setup, I want to disable foreign key checks in sqlite. I'm aware of the DB_FOREIGN_KEYS option inside config/database.php, but it's global and I only want them off in certain tests. On the other hand I've tried using PRAGMA foreign_keys=off using the DB facade, but it doesn't have any visible effect. Any ideas?

nlsnightmare's avatar
nlsnightmare's avatar nlsnightma...Testing
4

Storing float numbers in SQLite

I use SQLite database in my project. I have a table with float columns: $table->unsignedFloat(column: 'amount', places: 2)->nullable(); My request validation rules are: 'amount' => 'required|numeric', When I create a model with a float value: Amount::create([ 'amount' => $request->amount, ]); values after floating point are lost. Request input 'amo

NameUnknown's avatar
NameUnknown's avatar amariano19...Laravel
7

Use sqlite command-line (ui)

Perhaps this is going to be a strange question and i prob have to do my best to correctly write it down. English is not my native and coding jargon is ... well, let's not talk about that. Here we go: I work on a Desktop app with Laravel (10) and NativePHP. NativePHP is pretty new and allows you to build desktop Apps ( for: Windows, Linux and Mac os) with Laravel and all its fea

osc2nuke's avatar
osc2nuke's avatar osc2nukeEloquent
0

Laravel and SQLite dot commands

Hello everyone, I am trying to import a csv file into a SQLite table. Do you know if there is any way to use dot commands through laravel in sqlite? I am trying this command: DB::connection()->getpdo()->exec(".import --csv file.csv tablename"); But it seems to not work and I get this error: SQLSTATE[HY000]: General error: 1 near ".": syntax error Than

JohnnyBigodes's avatar
JohnnyBigodes's avatar JohnnyBigo...Laravel
8

SQLite is locked.

I use SQLite in my laravel project but when running this query: SELECT * FROM 'searches'; I get: Query 1: database is locked

MohammadEzady0's avatar
MohammadEzady0's avatar MohammadEz...Laravel
7

Laravel connection persistent SQLite in memory database configuration

I am setting up a Laravel solution where I want to use a SQLite database configured as in memory database. I have the following configuration for this: .env: DB_CONNECTION_DATA=sqlite DB_DATABASE_DATA=:memory: database.php: ... 'sqlite' => [ 'driver' => 'sqlite', 'url' => env('DATABASE_URL'), 'database' => env('DB_DATABASE_DATA')

ACH's avatar
ACH's avatar ACHGeneral
0

Laravel Pest testing error table already exists with SQLite

I have a SQLite database that I used for part of my application, mainly I used MySQL. But whenever I run a test I always get an error said that the table is already exists in the SQLite database. Is there any specific things to do if I wanna use SQLite?

fikurimax's avatar
fikurimax's avatar fikurimaxLaravel
2

Drop and recreate sqlite database files between tests

I'm using Spatie's multitenancy package with separated databases per each tenant. Now I want to start e2e testing with Dusk. I want to use sqlite database for testing with a landlord.sqlite and tenant.sqlite database file. My issue is when I start tests I need to use special artisan commands for migrating (because of spatie's package). I want to put this command somewhere gener

netdjw's avatar
netdjw's avatar SinnbeckTesting
1

SQLite database path in .env

My project unable to connect to SQLite database under Sail. Does DB_DATABASE value is incorrect? .env DB_CONNECTION=sqlite # DB_HOST=localhost # DB_PORT=3306 DB_DATABASE=database\database.sqlite # DB_USERNAME=sail # DB_PASSWORD=password I tried to use: DB_DATABASE="database\database.sqlite" But it failed! I think this related to absolute/relative path issue. Does it

mbnoimi's avatar
mbnoimi's avatar SinnbeckLaravel
8

Testing - SQLite vs MYSQl

Currently i've got a project and to get some testing started i've had to use MYSQL, this is becasue one table uses Enums. Becuase of this i can't use SQLite as you end up with the error General error: 1 table sqlite_master may not be modified (SQL: delete from sqlite_master where type in ('table', 'index', 'trigger')) I know i can swap this out to use another table with foreig

ashler2's avatar
ashler2's avatar Tray2Testing
9

Change database just for one test (SQLite to MySQL)

Hi all, (this thread is not about setting one database for test and another for development) I am using SQLite for testing. Everything is nice but one thing: I use one package that performs a query not supported by SQLite. One option that I have tested succesfully is changing phpunit.xml configuration to use a MySQL database during testing (separate database than dev database).

LaraNewDev's avatar
LaraNewDev's avatar LaraNewDevTesting
3

i made a laravel app using sanctum ,axios api .i want to convert it to a desktop app using phpdesktop-chrome-57.0 , but it doesnt connect my sqlite or mysql till i run command "php artisan serve "

i made a laravel app using sanctum ,axios api .i want to convert it to a desktop app using phpdesktop-chrome-57.0 , but it doesnt connect my sqlite or mysql till i run command "php artisan serve "...the app is working well locally as a website . but when i use phpdesktop-chrome-57.0 it doesnt connect database

Emad_nour's avatar
Emad_nour's avatar martinbeanLaravel
1

SQLite doesn't support multiple calls to dropColumn / renameColumn in a single modification.

Hello, I upgraded from laravel 8 to 9 and now my (single) pest test fails with the following error: SQLite doesn't support multiple calls to dropColumn / renameColumn in a single modification. It fails here: at vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:156 152▕ protected function ensureCommandsAreValid(Connection $connection) 153▕

Brainmaniac's avatar
Brainmaniac's avatar chrismcint...Testing
3

sqlite: "php artisan db" works but "db:show" fails. no such table: dbstat

I am using sqlite for my app, I'd like to use the artisan command php artisan db:show to inspect my database. I'm getting the following error: Illuminate\Database\QueryException SQLSTATE[HY000]: General error: 1 no such table: dbstat (SQL: SELECT SUM(pgsize) AS size FROM dbstat WHERE name=failed_jobs) If I access the db using php artisan db I can run the following query no pr

bbenz's avatar
bbenz's avatar SinnbeckLaravel
14

Sqlite Laravel SESSION sql required primary key=0

Hi, I am trying to build some tests and use an in_memory sqlite database. As I run my first test I get the following error on my last table SQLSTATE[HY000]: General error: 1 near "SET": syntax error (SQL: SET SESSION sql_require_primary_key=0) . . . 8 database/migrations/2022_09_12_153840_create_notifications_table.php:2 I've tried some workaround on my notific

tnort's avatar
tnort's avatar mvdTesting
4

Issue with SQLite version

Hi! I had SQLite v3.31 on Ubuntu v20.04. Than I removed SQLite v3.31 and install SQLite v3.34. But my Laravel application continue using SQLite v3.31. Than I removed my old local.db file and create new one. It was not help - app continue uses SQLite v3.31. For check version I use this script - "select sqlite_version()". I don't have any idea why I have this issue. Can

ILikeDARts's avatar
ILikeDARts's avatar SinnbeckServers
19

Does calebporzio/sushi require Sqlite?

I'm using suchi as a dependency for my package Laravel Algerian provinces class Wilaya extends Model { use Sushi; protected $fillable = []; public function getRows(): array { $rows = require __DIR__ . './../../arrays/wilayas.php'; return $rows; } } And I hope that it doesn't force users to have SQLite set up. Also, does not having SQLite

medilies's avatar
medilies's avatar SnapeyEloquent
4

Are sqlite and my sql 100% compatible in phpunit ?

Hello. Making phpunit tests for laravel 8 app I found error : Sqlite does not support dropping foreign keys (you would need to recreate the table) I was raised by line in migration file : Schema::table('tables', function (Blueprint $table) { $table->dropForeign('tables_category_id_foreign'); ... That raised a question are sqlite and my sql 100% compatible in phpunit ?

mstdmstd's avatar
mstdmstd's avatar martinbeanLaravel
2

Sqlite driver could not be found, even though it's installed

I have a laravel project I'm trying to build with docker compose. Here's my compose file: # Set up php ini and project .env cp /usr/local/etc/php/php.ini-development /usr/local/etc/php/php.ini; cp .env.example .env; echo DB_CONNECTION=mysql >> .env; sed -i.bak "s/^DB_HOST.*/DB_HOST=database/" .env; # Install nvm and node v10.14.2 curl -o- https://raw.githubuser

SteveRaines's avatar
SteveRaines's avatar SinnbeckLaravel
3

RefreshDatabase issue with seed data when switching from SQLite to Postgres

I have been advised to change my test db from SQLite to Postgres as I am using Postgres in production (https://laracasts.com/discuss/channels/testing/run-different-migration-in-test?page=1&replyId=796678). So I started changing the testing environment to Postgres and noticed that RefreshDatabase does not function the same. In my SQLite tests I have the following to seed the

CLab's avatar
CLab's avatar CLabTesting
0

Testing: SQLite or MySQL

Who is using what and why? We are using SQLite currently but are considering switching. Mick

phpMick's avatar
phpMick's avatar MohamedTam...Testing
1

Only use sqlite in tests

Hi, i just wondering ... is there any way to put some code into our test to grantee our tests using sqlite, if it dose not, tests must not run. i want our tests, only runs on sqlite.

faraz73's avatar
faraz73's avatar faraz73Testing
4

Laravel testing SQLite Alter Column Issue

I am using sqlite for our feature test with in-memory database. I found that SQLite had a problem with modifying column with alter table query. please tell us any solution to solve it or any replacement way like using MySQL for testing database and how to deal with that. thank you. Our laravel version is 8. and we use MySQL for main database

FarhadMohammadi's avatar
FarhadMohammadi's avatar FarhadMoha...Laravel
3

Can't use sqlite in memory DB for pest test

I am about to start testing with Pest! It seems great BUT.. I am following instructions and have successfully been running the first test tests 😅 - But when I go to my phpunit.xml and uncomments the following rows to start use in memory sqlite db the test tests do not pass any more: <server name="DB_CONNECTION" value="sqlite"/> <server name="DB

Brainmaniac's avatar
Brainmaniac's avatar tykusTesting
8

Alternative to sqlite database for testing.

Hello guys. I have an old project that has some migrations issues related to the sqlite. And Sqlite doesnot support dropping foreign key, renaming column names etc. So I created a test mysql database for testing and iam currently testing like that. But the testing process has become very slow because of using mysql database. Anyone has a better experience on replacing sqlite da

grgbikash05's avatar
grgbikash05's avatar tykusTesting
1

Having both SQLite and MySQL running for Tests.

Hi all, Thanks for taking the time to review this query. Basically, we have a situation where we have an application that uses some MySQL only functions, i.e. ANY_VALUE, MAX, etc. It is done in this way because of how complex the requirements are for what we are building. This isn't the problem. The problem we have is during our tests, which use SQLite, those functions do not e

robsykes's avatar
robsykes's avatar robsykesLaravel
4

MySQL vs. SQLite in testing

I ran into the same problem again and again in testing Laravel application. I have some database queries where the most simplest solution is using the database built-in functions. For example: CONCAT(date, ' ', time) NOW() field REGEXP 'pattern' These functions, and the REGEXP operator works fine under MySQL, but get error if I try to test these queries under SQLite. I know

netdjw's avatar
netdjw's avatar martinbeanTesting
5

Add value to already existed column in laravel sqlite

I tried this following query to add values to the enum field in laravel: Schema::table('files', function (Blueprint $table) { $table->enum('file_type',['p','sq','pr','ao']) ->comment('p => property, sq => square offset or FloorPlan, pr => pricing review, ao => availability_overlay') ->change(); }); With above code: it throws erors as:

ssquare's avatar
ssquare's avatar ssquareLaravel
2