SambaPOS Forum

English Boards => Requests => Topic started by: meccool74 on January 18, 2013, 09:14:45 pm

Title: USING OTHER DATA BASE
Post by: meccool74 on January 18, 2013, 09:14:45 pm

HI NICE TEAM

PLZ CAN I USE PERVASIVE SQL

THANX

Title: Re: USING OTHER DATA BASE
Post by: emre on January 19, 2013, 07:35:22 pm

SambaPOS runs with Microsoft SQL Server.

Title: Re: USING OTHER DATA BASE
Post by: carsolve 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

Title: Re: USING OTHER DATA BASE
Post by: emre 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.