Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Database questions

 
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 09-11-2017, 02:00 PM
 
classw classw is offline
    
Join Date: Sep 2017
Posts: 0
 

Default Database questions

I am wondering two things, actually a lot more but let’s start here.

First is there any similar data table layout documentation for version 5.3.3? I found this one (https://help.x-cart.com/index.php?title=X-Cartatabase_layout)

The second question: We are much better mySQL/Nodejs programmers than PHP programmers. What are the implications of just doing direct data inserts and updates into the data tables for adding/updating products, categories, and orders?
__________________
X-Cart Business 5.3.3.3
Reply With Quote
  #2  
Old 09-11-2017, 10:01 PM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Database questions

Quote:
Originally Posted by classw
First is there any similar data table layout documentation for version 5.3.3? I found this one (https://help.x-cart.com/index.php?title=X-Cartatabase_layout)

The site for X-Cart 5 developers is here:
http://devs.x-cart.com/

There is no database chart for X-Cart 5 because the layout depends on installed modules.
There are many modules that alter the database, so any ready-made chart won't work for most of X-Cart users.

Quote:
Originally Posted by classw
The second question: We are much better mySQL/Nodejs programmers than PHP programmers. What are the implications of just doing direct data inserts and updates into the data tables for adding/updating products, categories, and orders?

By sending direct queries you risk to break the database consistency. It is highly recommended to avoid this in X-Cart 5.

X-Cart 5 uses an ORM library (Doctrine 2). You can start reading about working with the database from there:
http://devs.x-cart.com/en/basics/understanding_models.html
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:10 AM.

   

 
X-Cart forums © 2001-2020