2
I’m developing a local app for desktop. As there will be no database servers, I studied some, such as Firebird, Sqlite, Access and even Localdb. But I still feel "lost" in which to work. I know the general choice is Sqlite, but I did not feel safe about the security of it, since it does not offer passwords to access it.
I do not want a comparative, but only an orientation of those who have experience. Remembering again that the bank will be local, not shared.
6
It is possible to encrypt and control access by Sqlite, not ready, you have to do this process, but it is doable.
I would think twice before discarding it. Other options may have more facilities, but if you do not know what you are doing you will not have security. Remembering that if the person has access to the file and there is a password of knowledge of people or even inserted into the machine in some way, the security will never be 100%.
I wouldn’t use MDB, but you can use SQL Server Compact (which is legacy but still supported), or Firebird if you like it. There is a version of its own to work in an embedded way, it has limitations but I think it will serve you.
Localdb is an option that will work well and is more suitable for those who are used to SQL Server. Of course it is much heavier. It comes out a bit of what we call an embedded database, not characterized by being a database for desktop, but only you will be able to say if it is suitable for your situation. Obviously it has limitations of SQL Server Express, but meets well almost all desktop situations, if you accept the weight of it.
As you suggested, I went deeper on the Sqlite and opted for it. I thank you for the guidance !
Browser other questions tagged c# database sql-server sqlite firebird
You are not signed in. Login or sign up in order to post.
Take a look at the HSQLDB. It is done in java but supports c# as well.
– user28595
I’ll see about HSQLDB. I appreciate the tip !
– Renato