8.1 SQL database??

[Barry]

HI

I was looking at the new feature of storing page and products in SQL.

Page and Product Databases in SQL (Pro, Manager, Starter)
Page and Product information is now stored in an SQL database.

I don't see anything mentioned in the help about that.

Would I have to create a My_SQL database for that to work?

Barry

[jim]

The SQL is built into ShopSite so you do not have to have an SQL
database server installed on your machine. It will not interface with a
MySQL server.

Jim

Barry wrote:

HI

I was looking at the new feature of storing page and products in SQL.

Page and Product Databases in SQL (Pro, Manager, Starter)
Page and Product information is now stored in an SQL database.

I don't see anything mentioned in the help about that.

Would I have to create a My_SQL database for that to work?

Barry

[Dennis K. Moore]

So how can I use SQL commands to update the database outside of the ShopSite
Backoffice? I currently have a MySQL database which I have all of my
products. I use SQL commands to update the database. I then create XML
files to be used by ShopSite to update the product database. This is very
cumbersome.

If you do not support SQL outside of ShopSite, at minimum what database
product are you using?

/dkm



"jim" <jstavast@xmission.com> wrote in message
news:e9tun5$nv1$1@eval.shopsite.com...

The SQL is built into ShopSite so you do not have to have an SQL database
server installed on your machine. It will not interface with a MySQL
server.

Jim

Barry wrote:
HI

I was looking at the new feature of storing page and products in SQL.

Page and Product Databases in SQL (Pro, Manager, Starter)
Page and Product information is now stored in an SQL database.

I don't see anything mentioned in the help about that.

Would I have to create a My_SQL database for that to work?

Barry

[mokele]

Shopsite 8.1 is using SQLite,version 2, http://www.sqlite.org/. SQLite is at version 3. SQLite has a command line interface that you can download and use, which I did and was able to look at the Shopsite Database. You can use PHP, Perl, etc. with SQLite as long as you have PHP, Perl, either compiled with SQLite support.

SQL is SQLs the command you use like Insert, Update, etc. should all be the same, just need to learn the syntax for SQLite commands.

Here are YourHost.com one of our Techs is working on getting PHP 4 compile with SQLite support. PHP 5 has SQLite support built in. Then I'm going to have out it with working with Shopsite databases directly. Having open databases opens up all sort of potential, of couse there is a down fall of clobbering info, but if you use the Shopsite databases and just read them and create your own database/tables, shouldn't be to much of an issue. Just recently finished a project, using Shopsite XML feed, MySQL, but going to rewrite it since I can access the databases directly.

Scott
YourHost.com

So how can I use SQL commands to update the database outside of the ShopSite
Backoffice? I currently have a MySQL database which I have all of my
products. I use SQL commands to update the database. I then create XML
files to be used by ShopSite to update the product database. This is very
cumbersome.

If you do not support SQL outside of ShopSite, at minimum what database
product are you using?

/dkm



"jim" <jstavast@xmission.com> wrote in message
news:e9tun5$nv1$1@eval.shopsite.com...

The SQL is built into ShopSite so you do not have to have an SQL database
server installed on your machine. It will not interface with a MySQL
server.

Jim

Barry wrote:
HI

I was looking at the new feature of storing page and products in SQL.

Page and Product Databases in SQL (Pro, Manager, Starter)
Page and Product information is now stored in an SQL database.

I don't see anything mentioned in the help about that.

Would I have to create a My_SQL database for that to work?

Barry

[url][/url][url][/url]

[ShopSite David]

ShopSite v8.1.x is using version 3 of SQLite. ShopSite 8.0 was using version 2 of SQLite. Also note that calls written for SQLite version 2 are not necessarily backward compatible with version 3. This is one of the reasons that ShopSite's recommeded interface to the DBs is through XML as opposed to direct access.

[mokele]

I understand what you're saying, compatibility is always a issue, its just life, which also includes work arounds for stuff that is missing, the project I finsihed not too long using 8.0.x, I needed the recordnumber what I see is being called the productid, I had to write a work around for that, now I can fix since its in 8.1, but if I accessed the database directly wouldn't have need for a work around which was a very frustrating work around.

To me pulling the XML, putting another database to manipulate the data is an extra step. Why do the extra step when I can do queries directly against the source.

ShopSite v8.1.x is using version 3 of SQLite. ShopSite 8.0 was using version 2 of SQLite. Also note that calls written for SQLite version 2 are not necessarily backward compatible with version 3. This is one of the reasons that ShopSite's recommeded interface to the DBs is through XML as opposed to direct access.