Get Data From Multiple Databases In One Project | Laravel Tip

[@rahulkumarsingh1716]

I like the way you explain even the minor details. Good.

[@Laratips]

Thanks

[@mdhamidulislam8645]

thank you. this is very helpful video

[@ayazahamed8254]

Very Well Explained.

[@jimk5734]

would you consider making a video about user access control in a multi-tenant laravel app? i.e tenants adding their own users. your content is good, clean clear explanation. Keep up the good work!

[@luciferzzzzzz]

Great work ❤️ i really like to watch your videos. Keep going

[@Laratips]

Thank you 🙂

[@faheem08]

Can you please make a vidio how we can get data using join method from two different databases two table and show them

[@Kirasim25]

Can you please make a video on Laravel SSO for multiple projects to access same login server( which the projects may be api based or for example laravel backend and react frontend)

[@bashardlaleh2110]

since the Cache is shared between users, so when another user logs in his default connection will be the one set by the last user, so it better be stored in the user's session or cookies instead of cache but of course as you said it all depends on the app

[@Laratips]

Yes absolutely

[@spartacusyusuf9989]

Can you make a video on pusher but using jQuery as frontend while using broadcast route? Also a video of synchronizing database records that where done offline on a local machine with that which is online? Also a video that when a user buys a service it clones the project creates the database, and set the .env on cpanel hosting?

[@pesovatech6899]

Nice thanks for this video

[@Laratips]

Most welcome

[@R0b3]

hi there. Thanks a lot for your support. SO is it possible making one query on one DB and if no result switch to other DB? Thanks a lot.

[@Laratips]

Yes, it is possible. You just need to change the connection name.

[@R0b3]

@@Laratips Ok but is it possible do it automatically inside controller?

[@R0b3]

I'm using oracle db as second DB. I must install some packages extra by using composer? Like for example laravel-oci8??

[@Laratips]

I don't think so. You need to do it separately.

[@R0b3]

@@Laratips and what about oracle connection? Should I install some extra package or just create and connection in ENV and database.php??

[@lidyaamel7642]

How to connect laravel with multiple connections depends on option list. Help me please. Thanks

[@TusharZambare]

How to fetch search result from 2 or more databases like global search engine.

[@akbar01710]

Please create FIFO tutorial in stock management...

[@abdullahsheikh1676]

I follow your all videos , Just I request to you please make a video for How we can use multiple database server like mysql, mongodb etc. Hope you will make it Thank you

[@MedSalemDZ]

Why should I use the same server for the two databases ? Is there any solution for bringing data from two deferent servers?

[@Laratips]

You can have multiple projects in the same server. Lets say you have a customer facing project and a crm in the same server with different databases. Then in crm, you can show some reports by fetching data from the customer facing project database. And I think you can also connect to database of different server but I haven't done that so cant say much about it. In this case you can create api on one server and fetch from another server.

[@TheMarvelsWorld]

If there more database connection, then how can we achieve it without adding database config or env setup for other.

[@Laratips]

You must define a connection in the config/database.php file. In what case you need this feature? There might be other ways of getting things done.

[@pushpenbanerjee9625]

@@Laratips Please make a video about how to parse database.php file on the crud. Thank You.

[@hamzat7621]

Is there any way to push new config setting in database.php in run time.. I have Created database and table on run time but I have occurred problem to push config setting... There is any dynamic way to append new connection

[@Laratips]

You can parse the database.php file on the crud operations and modify it as needed.

[@pushpenbanerjee9625]

Fantastic video. But, if I use database for each user then what to do ? say 100+ user. Please if possible make a video tutorial. Many many thanks.

[@Laratips]

It's simple. In the cache key, you need to also add the user id.

[@pushpenbanerjee9625]

@@Laratips Thank You

[@mausamsapkota9011]

How can migration be handled with multiple databases

[@Laratips]

You can just add a connection property. Check the link below. laravel.com/docs/9.x/migrations#setting-the-migration-connection

[@GergelyCsermely]

Thanks

[@mujejoje99]

Good video 👍, Can you make video about readings from multiple copy of same database (replica) using laravel based on some sort of load balancing which Will split the read evenly between the databases , i wonder if laravel support this kind of functionality

[@Laratips]

I have not done this kind of thing before. If I do it and have a good understanding of it, i will make a video about this as well.

[@pradoshkumarmukhopadhayay3534]

Can you consider my request to create a video on Laravel multi-tenants with different databases from scratch level using Laravel not using any third party? It will help me.

[@ShaikKhaja476]

Hi, am also looking for the same requirement. Could you please any references if you already got

[@manithman9887]

Hi man, I would like you to make video laravel export and import excel with multiple relationship table.

[@Laratips]

Great suggestion! Will make this video soon.

[@manithman9887]

​@@Laratips I'm really appreciate

[@mooodddy1]

Plesae describe more about how to make multiple guard using laravel password

[@mujejoje99]

How to make vs code autocomplete laravel code ?

[@Laratips]

use php intelephense extension

[@palakgarg3968]

please make video zoom app integration laravel

[@bidhanbaniya7605]

finally thanks

[@Laratips]

You are welcome

[@bidhanbaniya7605]

It feels really great seeing Nepali laravel community up to this stage

[@franklee8099]

Awesome

[@Laratips]

Thanks

[@dhanrajchakravarti1368]

laravel infyom package videos

[@Laratips]

I haven't used it before. I will have a look at what it has to offer.