Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
Can Fuel's ORM handle this database design?
I'm wondering if Fuel ORM can handle the design described here:
The following SQL, or maybe something similar, must be generated and executed: SELECT CultureId
FROM Culture WHERE CultureName =
SELECT I.ItemId, IL.[Name], IL.[Description],
I.Price, CL.[Name], CL.[Description]
FROM Item I
INNER JOIN Item_Locale IL ON I.ItemId = IL.ItemID AND IL.CultureId =
INNER JOIN Category C ON I.CategoryId = C.CategoryId
INNER JOIN Category_Locale CL ON C.CategoryID = CL.CategoryId AND CL.CultureId =
WHERE I.SellerId =
Or I must use normal queries? Please advise.
If it's the number of relationships that concerns you, then most certainly, the ORM will handle that. I have had more relationships than that among tables in FuelPHP. I mean this comes down to the ultimate trade-off of development speed vs. performance speed (shaving milliseconds). If you need a very optimized system (scaling, mission critical, etc) then run as natural queries:
$your_query = DB::query('SELECT id, this, that FROM `table_name`');
$your_query->execute(); Or the Active Record-ish implementation will achieve much of the same effect. Though I must agree that sometimes natural queries feel better.
Add a Comment
It looks like you're new here. If you want to get involved, click one of these buttons!
Apply for Membership
↳ Job Board
↳ Installation & Setup
↳ Tips and Tutorials
↳ Code share
In this Discussion