aaronpkoof yeah i should set aside some time for this. looks like it's going to be hard to have to jump two versions, so gotta get this one out of the way now
dansup"Laravel makes interacting with databases extremely simple across a variety of database backends using either raw SQL, the fluent query builder, and the Eloquent ORM. "
ZegnatI have yet to see a framework that handles multiple db connections smoothly without the user having to beat the framework with a bat. They are all build on the assumption of 1 storage method and then be done.
Zegnatdansup, work example? For data segregation clients demand separate databases for their confidential data. But if you don’t want core application data to be duplicated amongst all those databases you will have at least 2 connections at all times: 1 to your application db, 1 to your client db.
ZegnatThey are definitely edge-cases, but also not unheard of. They are just not the type of applications people have in mind when building a PHP framework.
cweiskewe're using multiple databases to keep canonical data in a relational database (mariadb) that's managed via the backend API only, and have a crate.io store for the frontend - which contains enriched data sets optimized for frontend use cases, so that web pages only have to do a few queries instead of multiple complicated ones
cweiskeanother case we have is integration testing. spinning up a dozen services on our CI setup is not what I want, so I prefer not to start a full MariaDB/MySQL daemon on each test run. simply exchanging the database adapter with an SQLite one is much easier