Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Best DB For Commercial Application

Posted on 1997-11-26
1
196 Views
Last Modified: 2010-04-04
Hi,

I'm putting together a commercial application - one I want to sell through te Internet.  I'm very worried about someone 'hacking' to my tables once they are deployed and doing whatever with teh data.  I'm currently using Paradox, but I have access to create a dBASE table through P7 (of course) and I have Access97.  Which of these databases are the most secure for commerical applications.

I know I could add a password, but there are tricks all around on how to break the enturnal DB security schemes.  i also 'heard' encrypting and decrypting DB tables tend to have an adverse effect on them in the long run.  Can someone refer me to a good DB encryption program - preferably Freeware?

Thanks
0
Comment
Question by:d4jaj1
1 Comment
 
LVL 1

Accepted Solution

by:
anilms earned 30 total points
ID: 1352116
If your choice is limited to DBF, Paradox and Access, I would say that Access is the best for commercial deployment. DBF is no doubt the easiest to use, but then anybody can break into DBF files and do what they want. Access is atleast a proper database with all the tables in one single MDB file. You can also consider using BTrieve, your data is not only much more secure, your processing speed also goes up drastically.

Encryption/Decryption may not be a good option as people will still try to open the files using any editor and they might end up corrupting files ( For example, almost all editors replace chr(0) with chr(32) ). That is why among most RDBMS, encryption is used for transferring data and not for storing data.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question