wha?ekerazha wrote:Does it use db transactions? This is critical.
lmao that was my exact reaction, but I decided to keep it to myself.Qphoria wrote:wha?
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
from the articleekerazha wrote:Database transactionsQphoria wrote:wha?
http://dev.mysql.com/doc/innodb/1.1/en/ ... ransaction
opencart uses myism so no no transactions, and I'd hardly call it crititcal as practically no other ecommerce application does it either.as implemented by InnoDB
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Yeah, you need InnoDB for transactions with MySQL.Xsecrets wrote: from the articleopencart uses myism so no no transactions, and I'd hardly call it crititcal as practically no other ecommerce application does it either.as implemented by InnoDB
This is critical because integrity is critical for ecommerce applications. Indeed, Magento uses transactions.
Postgres can do that, but many people have only access to mysql on hosted servers.
Even if Magneto offers it, remember to ask you hosting service if they do.
If you do your own servers, you're set!
You even tune your server to get more juice out it!
Problem is that most of the carts on the net try to go for the 90% percentile for ease of installation.
@ PDO/xPDO
This is one reason why brought the PDO question.
You add a layer to the db but gain:
abstraction, easy to read sql queries, somewhat cleaner code, AND you gain access to several other DBs other than mysql.
Which brings up the point.
Is mysql really the best basket to put all your eggs in?
Even if Magneto offers it, remember to ask you hosting service if they do.
If you do your own servers, you're set!
You even tune your server to get more juice out it!
Problem is that most of the carts on the net try to go for the 90% percentile for ease of installation.
@ PDO/xPDO
This is one reason why brought the PDO question.
You add a layer to the db but gain:
abstraction, easy to read sql queries, somewhat cleaner code, AND you gain access to several other DBs other than mysql.
Which brings up the point.
Is mysql really the best basket to put all your eggs in?
930sc ... because it is fun!
Yes, but OpenCart uses MySQL, so adding InnoDB support (to use transactions) would be easier than adding PostgreSQL support.SapporoGuy wrote:Postgres can do that, but many people have only access to mysql on hosted servers.
Can you explain in more detail?
@ ease of transition
Not sure, since I'd know what is required to support inno db.
However, I do know that the cart basically would need ever sql query re-written to move to PDO or another adbstraction system.
@ once again
I don't know many hosting services that support inno db for mysql and to add to the fun.
Oracle might just F*uck us all and say "pay royalties".
Which is why the RoR is really keen on moving to mysql lite or some other "open source" DB.
Still comes down to hosting service for most people.
@ ease of transition
Not sure, since I'd know what is required to support inno db.
However, I do know that the cart basically would need ever sql query re-written to move to PDO or another adbstraction system.
@ once again
I don't know many hosting services that support inno db for mysql and to add to the fun.
Oracle might just F*uck us all and say "pay royalties".
Which is why the RoR is really keen on moving to mysql lite or some other "open source" DB.
Still comes down to hosting service for most people.
930sc ... because it is fun!
Every hosting service that I've used in the last 6 years allows for InnoDB tables.SapporoGuy wrote:@ once again
I don't know many hosting services that support inno db for mysql and to add to the fun.
However, you can easily check if InnoDB is available.
theoretically, yes.
I'm not as knowledgeable as Xsecrets on the db side of things so ...
But I'd still imagine that a fair number of the sql queries might not work due to slight differences between the various DB distros.
@ ekerazha
What do you need to change to make the current sql queries support Inno DB?
I don't have the time at the moment to google and study this and you seem to know the difference.
Could you educate me?
I'm not as knowledgeable as Xsecrets on the db side of things so ...
But I'd still imagine that a fair number of the sql queries might not work due to slight differences between the various DB distros.
@ ekerazha
What do you need to change to make the current sql queries support Inno DB?
I don't have the time at the moment to google and study this and you seem to know the difference.
Could you educate me?
930sc ... because it is fun!
Basically nothing, but avoid things like COUNT(*) queries without WHERE clause, because they are slow on InnoDB (I don't know if OpenCart uses them).SapporoGuy wrote: What do you need to change to make the current sql queries support Inno DB?
Also, you have to change something if you want to take advantage of things like transactions, using START TRANSACTION, COMMIT etc. statements.
well yes the classes are there, but I'm 99% certain that if you tried to use it on another db things would break all to pieces. I'm not overly familiar with other db systems, but I'm fairly certain that many of the db queries are using mysql specific syntaxes.Qphoria wrote:opencart suports many dbs technically.. look in the db folder.. there are different classes for db.. at the moment none of them are working except mysql but it should (theoretically) be as simple as setting up the main class for the individual db
I guess this is where the pdo crap and abstraction or active record would come in, but that would be a nightmare to code.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
true if all your queries are purely standard, It's been a long time since I looked into what all is part of the standard, since I pretty much only use mysql, but I'm pretty sure some of the stuff used heavily is not standard.Qphoria wrote:Not really sure to be honest.. most syntax is the same for basic queries in all dbs that I've used professionally (oracle, sybase, sql) but haven't tried opencart with other DBs to know for sure.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Who is online
Users browsing this forum: No registered users and 6 guests