Select database on login form nova

@Tray2 want to separate database based on year coz so much record inside it

@laravelwebdev No need, the database can handle way more than you think.

The limit of the InnoDB engine is 64TB per table.

If you are worried about performance you can use partitions.

@Tray2 okeey, but how to set session on login withh nova?

@laravelwebdev What do you mean?

@Tray2 On the Nova login form page, I want to add a year option (2023,2024,...). When the user logs in, I want to add a session variable containing the selected year

@laravelwebdev How about you just stop creating databases per year? As @tray2 has told you, databases are literally made to hold large amounts of data.

@laravelwebdev

want to separate database based on year coz so much record inside it

This is a really weird approach and not how databases are meant to be used. If you have a sensible schema and use indexes where needed, databases can handle a lot of data. That's what they're for.

If you can describe the real issue that you're having, I'm sure people can help you solve it.

How many records are we talking about? Do you have a peformance issue, or are you worried about something else (e.g. backup restoration time)?

@laravelwebdev I wouldn't do that, but if you want to scope you data, then use a scope for it.

https://laravel.com/docs/11.x/eloquent#query-scopes

@Tray2 i wanto to make global scope :

$builder->where('year', session('year'));

but how can i add a year option (2023,2024,...) on the nova login form . When the user logs in, I want to add a session variable containing the selected year

@laravelwebdev The login view should be found in the resources/views directory, check in the vendors directory, if there isn't one, try running php artisan vendor:publish and then you should be able to update the login view.