Is it even possible to change/remove the sqlite database?? | Laravel | Page 1

lapis salmon Apr 15, 2024, 9:20 PM

#

Hello everyone, I am working on a website with laravel 11 and I ran into a problem while trying to deploy the website.
First of all, I don't use/need a database for my website, but apparently Laravel now has a standard database or something? What for??
I tried to deploy the website on my server, using Docker, but it didn't work and I could not change the database to mysql, I also can't change the database to mysql in my dev environment (.env file) for some reason. how? and why??

potent oracle Apr 15, 2024, 9:22 PM

#

It's certainly possible, have you tried clearing your config cache?

lapis salmon Apr 15, 2024, 9:59 PM

#

potent oracle It's certainly possible, have you tried clearing your config cache?

Yes, works

#

Why can sqlite not be used in production tho?

potent oracle Apr 15, 2024, 9:59 PM

#

it can, you probably don't have permissions setup correctly

mild frigate Apr 16, 2024, 7:58 AM

#

lapis salmon Why can sqlite not be used in production tho?

Poor performance. Only one process can write to sqlite.

potent oracle Apr 16, 2024, 9:06 AM

#

It does have it's use cases, not everything has enough load to require an actual DB

lapis salmon Apr 17, 2024, 10:59 PM

#

@potent oracle so, now I am getting this error... in production

#

I tried config clear and everything and migrate:fresh

#

cant get it to work

potent oracle Apr 17, 2024, 11:00 PM

#

do you have a sessions table migration in your migrations folder?

lapis salmon Apr 17, 2024, 11:00 PM

#

nope, but I never had one

#

It's some build in laravel 11 shit

potent oracle Apr 17, 2024, 11:01 PM

#

not in the create_users_table migration?

lapis salmon Apr 17, 2024, 11:01 PM

#

ohhh yeah apparently

#

wait

lapis salmon Apr 17, 2024, 11:02 PM

#

potent oracle not in the create_users_table migration?

yeah I do have it and I also have it in my production files

potent oracle Apr 17, 2024, 11:04 PM

#

are you running this in docker or something?

lapis salmon Apr 17, 2024, 11:04 PM

#

yep

potent oracle Apr 17, 2024, 11:04 PM

#

are you running the artisan commands within the container?

lapis salmon Apr 17, 2024, 11:04 PM

#

yep

#

tried running docker exec laravel php artisan migrate:fresh

potent oracle Apr 17, 2024, 11:05 PM

#

I'm confused as to how migrate:fresh wouldn't complain but there's still no sessions table

lapis salmon Apr 17, 2024, 11:05 PM

#

which does run, but it doesnt make it work

lapis salmon Apr 17, 2024, 11:05 PM

#

potent oracle I'm confused as to how migrate:fresh wouldn't complain but there's still no sess...

I have no damn clue either

potent oracle Apr 17, 2024, 11:06 PM

#

you haven't set a different connection or something up right?

lapis salmon Apr 17, 2024, 11:06 PM

#

wdym exactly?

potent oracle Apr 17, 2024, 11:08 PM

#

in the database config or something, there's clearly something weird going in with dbs somewhere

lapis salmon Apr 17, 2024, 11:09 PM

#

not that I know of

#

for some reason it doesnt create a new database.sqlite file either?? In my development environment it does tho

potent oracle Apr 17, 2024, 11:13 PM

#

when you switch back to sqlite or?

#

pretty sure that database.sqlite file is made by the installer, not the app itself

lapis salmon Apr 17, 2024, 11:16 PM

#

potent oracle pretty sure that database.sqlite file is made by the installer, not the app itse...

there is this in the composer.json which does that

            "@php artisan key:generate --ansi",
            "@php -r \"file_exists('database/database.sqlite') || touch('database/database.sqlite');\"",
            "@php artisan migrate --graceful --ansi"
        ]```

lapis salmon Apr 17, 2024, 11:17 PM

#

potent oracle when you switch back to sqlite or?

whenever you run migrate, and there is no sqlite file, it makes a new one

#

but for some reason it doesnt do that

#

and if I make one myself it still doenst work

potent oracle Apr 17, 2024, 11:17 PM

#

that's not part of the migrate command?

#

that's a post-create script

lapis salmon Apr 17, 2024, 11:18 PM

#

yeah I know, I assume thats what does that tho or does it not?

#

otherwise I have no clue how the file gets created

#

but it normally does

potent oracle Apr 17, 2024, 11:18 PM

#

no that gets ran by the installer once it's finished

#

more accurately it gets ran by composer's project installer

lapis salmon Apr 17, 2024, 11:19 PM

#

no clue then

potent oracle Apr 17, 2024, 11:22 PM

#

you should just be able to touch the database.sqlite file to make that if you want to move back to sqlite

lapis salmon Apr 17, 2024, 11:23 PM

#

potent oracle you should just be able to touch the database.sqlite file to make that if you wa...

I tried that, ran migrations and it still doesnt work

potent oracle Apr 17, 2024, 11:23 PM

#

did you set the db driver back?

lapis salmon Apr 17, 2024, 11:23 PM

#

didnt change it

potent oracle Apr 17, 2024, 11:24 PM

#

weren't you using mysql?

#

what are you currently trying to do?

lapis salmon Apr 17, 2024, 11:25 PM

#

potent oracle weren't you using mysql?

tried to switch, couldnt get it to work, switched back

#

or well, a friend set it back up but its still using sqlite

#

or atleast in the .env it is

#

in the docker-compose there is mariadb

potent oracle Apr 17, 2024, 11:26 PM

#

could you share your docker compose

lapis salmon Apr 17, 2024, 11:30 PM

#

any clue?

potent oracle Apr 17, 2024, 11:31 PM

#

uhh, well you'd need you DB_CONNECTION to be set to mariadb

#

I also wouldn't recommend the bitnami containers

lapis salmon Apr 17, 2024, 11:32 PM

#

potent oracle uhh, well you'd need you DB_CONNECTION to be set to `mariadb`

damn that worked

#

thx man

#

idk how tf that worked before without that ho

lapis salmon Apr 17, 2024, 11:32 PM

#

potent oracle I also wouldn't recommend the bitnami containers

ahh why

potent oracle Apr 17, 2024, 11:32 PM

#

there are official mariadb containers and the bitnami laravel container uses artisan serve which is not good

lapis salmon Apr 17, 2024, 11:33 PM

#

ahh damn alr alr, thx, I'll look into it later

lapis salmon Apr 17, 2024, 11:33 PM

#

potent oracle I also wouldn't recommend the bitnami containers

only for mariadb or also for laravel?

#Is it even possible to change/remove the sqlite database??