English Boards > Requests

USING OTHER DATA BASE

(1/1)

meccool74:
HI NICE TEAM

PLZ CAN I USE PERVASIVE SQL

THANX

emre:
SambaPOS runs with Microsoft SQL Server.

carsolve:
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:
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.

Navigation

[0] Message Index