Database type

Questions and Answers about the POS Pizza 6 & 7 Databases
Member
Posts: 20
Joined: Sat Jan 07, 2012 1:25 pm

Database type

Postby NetTech » Sat Jan 07, 2012 1:40 pm

I see that you said that you are using SQLite for the POS system. I am guessing that is only on the stand alone version since SQLite is an embedded database engine without network support. Just compact local access. What system are you using on your server? MySQL?

Jake

Veteran Member
Posts: 177
Joined: Fri Apr 18, 2003 11:50 am
Location: New Jersey

Re: Database type

Postby H-Man » Sat Jan 07, 2012 2:14 pm

I could be wrong, but I am fairly certain that all 3 versions CS, LT, SA, do use the same data so that you can easily move data from one type to another.

Member
Posts: 20
Joined: Sat Jan 07, 2012 1:25 pm

Re: Database type

Postby NetTech » Sat Jan 07, 2012 2:31 pm

Thanks but "same data" is not equal to "same database" or DBMS. The free version is most definitely using SQLite, but the network version has to be using a networked DBMS. Unless it's sharing an SQLite file via file sharing. Then it really wouldn't be a true client/server platform, and from what I have read so far it says it is.

Jake

Site Admin
User avatar
Posts: 2082
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Database type

Postby Scott » Sat Jan 07, 2012 3:52 pm

NetTech wrote:Thanks but "same data" is not equal to "same database" or DBMS. The free version is most definitely using SQLite, but the network version has to be using a networked DBMS. Unless it's sharing an SQLite file via file sharing. Then it really wouldn't be a true client/server platform, and from what I have read so far it says it is.


The networked version [CS] is client/server and does not share any files via file sharing. The client and server portions talk to each other via pure TCP/IP. The server is our own, and uses SQLite under it as the Database System. All requests to/from the database are transported from our server to the clients over a TCP network connection. The server can handle any SQLite stuff as well as dongle and other stuff needed by the POS system.

The database file and structure is 100% identical for all 3 versions of POS Pizza 6.x as H-Man pointed out. These data files are standard SQLite database files and are completely portable between the different versions of POS Pizza 6.

Scott

Return to Database Help and Discussion

Who is online

Users browsing this forum: No registered users and 2 guests