Author Topic: USING OTHER DATA BASE  (Read 15601 times)

meccool74

  • Newbie
  • *
  • Posts: 5
USING OTHER DATA BASE
« on: January 18, 2013, 09:14:45 pm »
HI NICE TEAM

PLZ CAN I USE PERVASIVE SQL

THANX

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: USING OTHER DATA BASE
« Reply #1 on: January 19, 2013, 07:35:22 pm »
SambaPOS runs with Microsoft SQL Server.

carsolve

  • Newbie
  • *
  • Posts: 4
Re: USING OTHER DATA BASE
« Reply #2 on: March 10, 2013, 09:30:42 pm »
Emre,

Will this always be the case? The SQL Server that most will have installed in is a crippled version which is limited to using only 1 or 2 gigs of ram which limits the performance of SQL server. Support for other DB's is desirable. MySQL, FireBird are excellent embedded DB choices which are easy to deploy and maintain. I have briefly browsed the code and it does not seem like a big leap to support other DB's if so needed. Is there a reason that MS SQL Server is the default. It does not look like any stored procedures or back end programmability is being used so there does not seem to be any dependency on MS SQL. Can you tell us more?
Abi

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: USING OTHER DATA BASE
« Reply #3 on: March 11, 2013, 04:38:43 am »
We used Entity Framework. This is an Microsoft ORM library that makes DB development easier. In theory any database can be used with SambaPOS that have Entity Framework provider library. There is a MySQL Connector library that supports EF but I didn't tried it before. Referencing the library and a connection string change should do the job.