Connect to an Sqlite DB - Laravel documentation procedure doesn't work

As I understand the database connection starts as follow... In file database.php, Laravel will check if a variable called DB_CONNECTION exists in the .env file, if it does it will use the values from the .env file, if NOT it will use the values in the database.php, correct? Simple enough. If the above statement is true, can you please confirm that my steps below are correct? So

fsdolphin's avatar
fsdolphin's avatar BriareosLaravel
9

Eloquent MySql equivalent of this Sqlite Query

Hi, In the chart.js series, @jeffery_way used sqlite and wrote this Preformance::thisYear() ->selectRaw('strftime("%m", created_at) as month, sum(revenue) as revenue') ->groupBy('month') ->pluck('revenue'); https://laracasts.com/series/charting-and-you/episodes/6 to get the sum of transactions within the last year, grouped by months. I am trying to do somethi

Lordwhizy's avatar
Lordwhizy's avatar LordwhizyEloquent
2

$ php artisan migrate to sqlite but "No connection could be made because the target machine actively refused it"

I just started watching "Laravel from scratch" free series. In "Fetching data" episode https://laracasts.com/series/laravel-5-from-scratch/episodes/7 Jeffry tells about using sqlite database. I have exactly the same set up as Jeffry has but after $ php artisan migrate I receive [PDOException] SQLSTATE[HY000] [2002] No connection could be made because the ta

erop's avatar
erop's avatar RoamingProLaravel
2

Can't Use SQLite

When i try to migrate my database with SQLite i get the following error: [InvalidArgumentException] Database (homestead) does not exist. I have looked into the database.php file in the config folder and manually switching the database type to SQLite and still get the same error.

waydeshepard's avatar
waydeshepard's avatar waydeshepa...Laravel
8

Connecting Laravel to Sqlite in Laravel 5.2

Hi, How can I connect to Sqlite db? This is what I did that didn't work. Created project. Created database.sqlite inside the database folder (database\database.sqlite). Changed 'default' => env ('DB_CONNECTION', 'mysql'), to 'default' => env ('DB_CONNECTION', 'sqlite'), in the database.php file. Ran php artisan migrate. Got an error. What files do I need to modify to es

fsdolphin's avatar
fsdolphin's avatar ayoobLaravel
27

SQLite Database Seeder Problem - help?

I'm just putting the finishing touches on a artisan console command that pulls all the records out of a database and automatically builds seeders. I took Jeffery's excellent advice to automate this process. Everything is working great with MySQL, it seeds lots of tables with lots of records no problem. But I ran my Behat tests which use SQLite in-memory databases for rapid test

ChristopherSFSD's avatar
ChristopherSFSD's avatar jekinneyGeneral
1

DATE_FORMAT() FAILING IN SQLITE

I have a method calculating the number of user signups; public function getSignupsCount() { $users = DB::select('select count(id) as count, DATE_FORMAT(created_at, "%M %y") as months from users group by months order by created_at'); return $users; } My functional tests use Sqlite based database. When testing this method,

stevepop's avatar
stevepop's avatar ValTesting
9

sqlite database is empty after migrate

I'm following along with Laravel 5 Fundamentals (migrations) and am struggling to get the migration to work. I have set up database.sqlite in project/database. I run 'php artisan migrate' which appears to successfully migrate tables But, when I check project/database/database.sqlite it is empty (tested by running sqlite3 and also viewing the file) I've checked the video comme

philb's avatar
philb's avatar NilaWaEbab...Laravel
5

Homestead sqlite timestamp non-contant default

Hi I run my integration tests with 'sqlite_testing' => [ 'driver' => 'sqlite', 'database' => ':memory:', 'prefix' => '', ], and use the use DatabaseMigrations; Trait. Until now everything was fine. Today i tried to add a timestamp column to an existing table. Schema::table('mytablename', function ($table) {

gwa's avatar
gwa's avatar gwaTesting
4

sqlite problem -(case sensitive)

I am using sqlite as db. But It seems it is case sensitive when i sort the db tables. How can I fix this ? I couldn't find anything that works with laravel. thanks

numberone's avatar
numberone's avatar rodrigo.pe...Eloquent
2

sqlite pdoexception connection refused

hello, following the Laravel From Scratch No.13 authenticate your users laracast i followed the instructions, laravel new some-project, php artisan make:auth, touch database/database.sqlite and default database connection set to sqlite, so far so good. after trying, php artisan migrate.. i get the following error... [PDOException] SQLSTATE[HY000] [2002] Connection refus

dboyd's avatar
dboyd's avatar kevindeesLaravel
11

connect Sqlite database on webserver

I want to use SQLITE for my laravel5 project on my webserver. I migrated my local laravel 5 project onto my AWS ec2 lamp Ubuntu server. http://realtoraxe.com/realtoraxe/public/ but it shows InvalidArgumentException in SQLiteConnector.php line 34: Database does not exist. I changed the database.php set for sqlite <?php return array( 'default' => 'sqlite', 'con

patricoles's avatar
patricoles's avatar ohffsLaravel
1

PHPUnit, SQLite, and Cascading Deletes

Hi all, I'm using cascading deletes on a pivot table in my database. Using a tool like MySQL Workbench to delete records manually, this works as expected (both records disappear). In my tests (which use an SQLite database) I can't seem to get the related records to delete. Is there a limitation with this type of thing with SQLite? Any type of setup I am overlooking?

noleafclover614@gmail.com's avatar
noleafclover614@gmail.com's avatar noleafclov...Testing
0

Laravel change Sqlite file in Model class based on username

Hi guys! I'm new with Laravel. I was developed an app with CakePHP and can archived this, but I think I want to move to Laravel. So How can I archive it? My app is about: After user registered I create an Sqlite file database for each user so I can query their product base on their info. Here my last question and answer on StackOverFlow. http://stackoverflow.com/questions/33491

kajasb's avatar
kajasb's avatar kajasbLaravel
0

SQLite date column != MYSQL date column?

Hey guys, Not sure how to handle this one, if at all possible? MySQL handles date columns as expected i.e. just 01/01/2015. However SQLite seems to want to include times as well so the same record in SQLite looks something like 01/01/2015 00:00:00.000000 So when I'm using methods such as firstOrNew, it's not able to find the record that is already there (hope that makes sense).

Dan's avatar
Dan's avatar DanTesting
6

sqLite "no such table" Error In Unit Tests With Migrations

I have set up unit tests in Laravel 5.1 using sqLite ion-memory databases. I am getting the following error when running my tests: PDOException: SQLSTATE[HY000]: General error: 1 no such table: versions My unit test employ migration and transaction traits as per the Laravel documentation: http://laravel.com/docs/5.1/testing The stack trace shows that this error occurs during t

mikebronner's avatar
mikebronner's avatar kortbyTesting
7

SQLite Database Config not working for Artisan

I try to use Lumen with SQLite. If I have this setup in my .env DB_CONNECTION=sqlite DB_DATABASE='../storage/database.sqlite' then, this is working: $results = User::all(); but, when I try to migrate via Artisan, I'll get: "Database (../storage/database.sqlite) does not exists. When I change my .env to: DB_CONNECTION=sqlite DB_DATABASE='storage/database.sqlite' then Artisa

kay899's avatar
kay899's avatar ifarooqLumen
8

Lumen testing with SQLite

First off, this is my first application using Lumen and It's awesome! But I've ran into a little problem that I can't figure out how to solve. I've google for about an hour before I posted this but if this is a duplicate, feel free to link me to the solution. I'm loading my .env file for the regular applicaiton with MySQL but in testing i want to use SQLLite with the DatabaseMi

Dzemal's avatar
Dzemal's avatar DzemalTesting
0

SQLITE configuration for Laravel

hi all, im pretty new to laravel and following the laracast videos I got stuck creating the SQLITE DB. when I enter "sqlite3" in the terminal I get the following message: michael learning-laravel-5 $ sqlite3 SQLite version 3.8.10.2 2015-05-20 18:17:19 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" t

Danyo's avatar
Danyo's avatar jlrdwLaravel
1

Laravel can not open SQLite database

Hy, I got a very strange behaviour in my L 5.1 app. I use two databases. One is an MySQL, the other is a SQLIte. If the SQLite file does not exist, is automaticaly created within a provider. The only table inside is also created here. I created a model to access the SQLite. The database file has the owner and group of the httpd. The strange thing here is, that the app runs on H

vlehnen's avatar
vlehnen's avatar amcsiEloquent
17

Sqlite Migrations failing

Hi all, I recently added a column change to my db but this is causing migrations to fail when run against the sqlite test db. It's complaining about not finding a column name and then proceeding to take ages completing the rest of the tests because of a table lock issue. The output of my travis build shows the errors https://travis-ci.org/ArthurGuy/BBMembershipSystem/builds/805

ArthurGuy's avatar
ArthurGuy's avatar ArthurGuyTesting
1

Finding the "shortest path" with SQLite and Lua

Hello! I have relational SQLite setup with 2 tables: nodes table with columns id and connector_id connectors table with columns id, name, node_from_id and node_to_id I need to find all nodes between x and y node. Example from 2 to 7 like node 2 leads to node 12, nodel 12 leads to 3 and 3 leads to 7 So i would get nodes 12 and 3. But there can be other connectors as well and i a

keevitaja's avatar
keevitaja's avatar keevitajaGeneral
34

SQLite migration failing to add deleted_at (soft delete column)

My php artisan migrate and :rollback work as expected. I'm using the following migration script on Laravel 4. Schema::table('orders', function(Blueprint $table) { $table->softDeletes(); }); } When I run phpunit I get the following error on all of my tests: Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1 no such column: orders.de

skrypt's avatar
skrypt's avatar TaelkirTesting
3

MySQL vs SQLite RoT

What are some rule of thumb when to use MySQL or SQLite as a database in Laravel ?

Lugi's avatar
Lugi's avatar milonGeneral
1

DatabaseMigration trait fails with SQLite on alter table

I'm using :inmemory: SQLite driver, and it was all working fine until I added a non-nullable field I'm getting the following error: Cannot add a NOT NULL column with default value NULL (SQL: alter table "stores" add column "mall_id" integer not null) This would be pretty obvious if my table already had rows, you can't add a non-null column without a default

rephiscorth's avatar
rephiscorth's avatar rephiscort...Testing
0

SQLite -- Issue dropping columns, SQLite/Laravel providing incorrect errors

In my structure, I have several enum columns. I was unaware that SQLite cannot use enum, so when someone dropped a complaint that migration was failing I found out the hard way. To remedy the issue, I'm creating a migration file that drops and replaces the existing enum columns with new string columns that are given integrity through mutators in the model. The problem is, SQLit

Jawsh's avatar
Jawsh's avatar sebastians...Eloquent
4

Sqlite with Laravel ignoring cascade deletions

I'd like to use sqlite for development and testing but it seems that sqllite with laravel ignores foreign key cascades. It looks like from sqlite that Laravel should be sending "PRAGMA foreign_keys = ON;" with each connection to enable them. Is there a way to do this without hacking on the laravel source today? Perhaps just making an environment level configuration?

Hitchhiker's avatar
Hitchhiker's avatar HitchhikerEloquent
0

I'm using homestead and after the migration I can't see the tables in sqlite

Hello there. I have been following the tutorial provided in laracasts so far. But I'm stuck with migration. I have two files with my database/migrations folder; users, password_resets I successfully migrated those files with the command php artisan migrate However, when I went into sqlite (sqlite3 storage/database.sqlite) and Input .tables, Nothing appears. How is wrong with me

Wooyoung's avatar
Wooyoung's avatar bobbybouwm...Laravel
1

Codeception using Sqlite

Hi Guys, So I'm going around in circles with Codeception with regards to setting up and tearing down a database between tests. I'd like to have a sqlite database that I can migrate into, run my tests against and then roll back. I have the Db module install, I have Laravel5 module installed but I'm stuck. How would I set this up? Is anyone else doing this? Is there a tutorial so

RyanHavoc's avatar
RyanHavoc's avatar RyanHavocLaravel
0

Lumen/Laravel + sqlite: Only use $table->increments in migrations or it won't auto increment.

Lumen/Laravel + sqlite tip: Only use $table->increments in migrations or it won't auto increment. I tried all the variations of bigIncrements and tinyIncrements and tinyInteger including adding the unsigned and increments() at the end to no avail. The only thing that works with sqlite is the increments() method.

nateritter's avatar
nateritter's avatar nateritterTips
2

Lumen + sqlite + TestDummy relationships

When using Lumen, sqlite, and laracasts/TestDummy, I'm finding that relationships in the Fakers aren't being built out. For instance, in my factories.php I have the following: <?php $factory('App\Approval', [ 'id' => $faker->randomDigitNotNull, 'person_id' => 'faker:App\Person', 'service_id' => 'faker:App\Service', 'processed_at' => $faker->

nateritter's avatar
nateritter's avatar nateritterTesting
3

SQLite migration ALTER TABLE not working

Hi guys, So I have a table with clients. Each client has a name and an email and so on. We first decided that the email was required. Now we don't want that anymore and the column needs to be nullable. To do this we use a migration of course . create_clients_table migration class CreateClientsTable extends Migration { public function up() { Schema::create('clie

bobbybouwmann's avatar
bobbybouwmann's avatar edmillsTesting
6

Unit Test Models with Sqlite

Hi folks, I am newbie php and Laravel developer. I am trying to do unit testing of my models but I'm not sure about what configuration I need for Laravel 5. I followed this guide but is not working for me: (https://laracasts.com/lessons/test-databases-in-memory) This is my test (at the moment is not doing anything): class UserModelTest extends TestCase { /** * A basic

gribas's avatar
gribas's avatar gribasTesting
0

[L5] SQLite Foreign Key Support

Hi, I thought I had setup foreign key constraints on my sqlite database correctly but any time I deleted a record the constraint didn't seem to work (on delete cascade). After a quick Google search I came across this SO thread: http://stackoverflow.com/questions/9433250/foreign-key-constraint-doesnt-work That thread suggested I check if foreign key support was enabled: http://w

keithmclaughlin's avatar
keithmclaughlin's avatar EuperiaGeneral
11

[migrations] SQLite General error: 1 Cannot add a NOT NULL column with default value NULL

Hi guys, I'm having problems with my migrations and sqlite, let me explain :) I created a migration that add a column to an existing table. it looks like this: public function up() { Schema::table('organisations', function (Blueprint $table){ $table->string('long_name'); }); } public function down() {

fenos's avatar
fenos's avatar mundiakalu...General
11

[Solved] TestDummy and Codeception with SQLite in memory error - Integrity constraint 19

Hi guys, I followed both the latest Test Dummy and SQLite in memory lessons and tried to implement an integration test for a user repository to make sure every thing works as planned. To start off, here's the migration for the table. $table->increments('id'); $table->char('username', 32)->unique(); $table->char('password', 64); $table->char('remember_token', 1

Everon's avatar
Everon's avatar alfrednuti...General
4

laravel sqlite database with codeception acceptance

I am creating great unit tests that work with an sqlite database, that on each test the sqlite database (in memory) gets a migrations and seeds. the code: class TestCase extends Illuminate\Foundation\Testing\TestCase { protected $withDb = false; /** * Creates the application. * * @return \Symfony\Component\HttpKernel\HttpKernelInterface */ public function createApp

tzookb's avatar
tzookb's avatar theshiftex...General
1

Dealing with differences between sqlite and mysql

I'm quite new to laravel. However I've been building an api using TDD. On a couple of occasions my tests fail with the test sqlite in memory, but pass with mysql. In one instance I wrote a wrapper to make it pass for both by detecting with if(\Config::get('database.default')=="mysql") I was wondering how others handle this.

crisward's avatar
crisward's avatar martinbeanGeneral
2

How to handle multi-tenancy with multiple SQLite databases

Hi everyone. I'm considering implementing multi-tenancy for my Laravel app using Turso, since to me that feels the easiest to manage and has built in backup systems (not to mention its free and very scaleable). What I'm not sure about is how to roll out migrations across the app's databases cleanly. How would I handle a situation where the codebase is ahead of the migration sc

mkrell's avatar
mkrell's avatar jlrdwDevOps
3

SQLite Write Ahead Logging

I'd like to enable WAL but am unsure how to do it in the best way. This blog post shows adding it to my database.php connection information using the after parameter. But I also see a specific entry called journal_mode in the database connection that I assume could be used for the same purpose and would look like 'journal_mode' => 'WAL' but I haven't been able to find the do

curtismchale's avatar
curtismchale's avatar LaryAILaravel
2

Change SQLITE version

I have to update my default MYSQL lite version to get drops working correctly on L11. But i'm not sure how to change it. On Rocky9.3, ❯ sqlite3 --version 3.46.0 2024-05-23 13:25:27 96c92aba00c8375bc32fafcdf12429c58bd8aabfcadab6683e35bbb9cdebf19e (64-bit) From L11 PDO {#3707 inTransaction: false attributes: { CASE: NATURAL ERRMODE: EXCEPTION PERSISTENT: false DRIVER_NAME: "

Stacky's avatar
Stacky's avatar StackyServers
2

empty sqlite database after migration

in .env i set DB_CONNECTION=sqlite and comment all other DB variables created database.sqlite file and sudo chmod 777 that file php artisan migrate and connect to the database through tableplus and database is empty i am using windows11, docker, wsl2, sail, ubuntu. all files in my project is 777 i have tried all solutions form internet and none of them helped. anyone knows sol

lukgol26's avatar
lukgol26's avatar lukgol26Laravel
14

view and edit sqlite database from command line on server

What are my options here, do you think? Running redhat on the server.

TheDude's avatar
TheDude's avatar SinnbeckServers
3

Odd problem testing using in-memory Sqlite database

Hello peeps. I hope you can help me solve this odd little problem. I have PhpUnit configued to use an in-memory SqlLite database. <env name="DB_CONNECTION" value="sqlite" /> <env name="DB_DATABASE" value=":memory:" /> I'm testing a custom artisan command which creates a super user that checks if an email already exists in the

normykinz's avatar
normykinz's avatar SinnbeckTesting
9

sail sqlite file not found

from my docker-compose.yml sqlite3: image: nouchka/sqlite3:latest stdin_open: true tty: true volumes: - ./db/:/root/db/ I actually have this working in one instance, but cannot get it to work again. I have tried: config:clear numerous sail build --no-cache touched a blank file in .env DB_DATABASE="../db/database.sqlite" touched database.sqlite i

chucklin72's avatar
chucklin72's avatar onovaesGeneral
12

get data from Sqlite database in different language

I have json column in my table. something like this: "{"en": "english name", "ka": "ქართული"}". when i query database, for kafield i get this: "{"en":"english name","ka":"\u10e2\u10d4\u10e1\u10e2\u10d8"}". how can i get data in foreign language in it's original form? . this wo

DavidBuchukuri's avatar
DavidBuchukuri's avatar vincent150...Eloquent
1

could not find driver (SQL: PRAGMA foreign_keys = ON;) sqlite

I am working with a personal project which was sent to me, could you tell me why when I give to migrate my tables I get an error which says that "could not find drivers (SQL: PRAGMA foreign_keys = ON)". I tell you today I did my upgrade to php 8.0.3 and the project I do with laravel 8, from laragon in the same I get activated or selected extension=pdo_sqlite

gabo25's avatar
gabo25's avatar jlrdwGeneral
3

How to extends DB facade setting the driver to 'sqlite' and the database file?

I want to create a new class to create my own methods, but letting the methods of DB facade avaliable too, but i want to create a new Facade that i call and it already come with a database configured, is it possible?

JoaoHamerski's avatar
JoaoHamerski's avatar JoaoHamers...Laravel
2

How to connect to a sqlite database in runtime execution?

So i have a .sqlite3 file that i get from an API and i store this file in public/cache/, i would like to know how to i connect to this database to perform query search and etc...

JoaoHamerski's avatar
JoaoHamerski's avatar JoaoHamers...Laravel
6

Phpunit + SQLite General error: 1 Cannot add a NOT NULL column with default value NULL

i've this error when i try my test. but working when the application is live.

Djomobil's avatar
Djomobil's avatar DjomobilTesting
5