DBF File Format - Considerations A Secure Option

DBF File Format - Considerations A Secure Option

Postby Otto » Fri Jul 26, 2024 7:43 am

Hello friends,

The DBF file format is a stable, reliable, and widely used option for data storage and management.
In a multi-user environment, the probability of concurrent access is relatively low, and the wait times in the event of collisions are minimal.
Therefore, the DBF format represents a good and secure choice, especially for applications that require robust and simple data management.

Best regards,
Otto

Image
Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6312
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBF File Format - Considerations A Secure Option

Postby wartiaga » Fri Jul 26, 2024 12:16 pm

Otto,

I currently use dbf a lot as a database, I have some problems but nothing serious, the big problem for me is that anyone with the slightest knowledge can access the database from outside the system using a third-party program. Any suggestions in this regard?

Thanks in advance.
wartiaga
 
Posts: 210
Joined: Wed May 25, 2016 1:04 am

Re: DBF File Format - Considerations A Secure Option

Postby Otto » Fri Jul 26, 2024 1:35 pm

Hello wartiaga,

How does your program work? Direct DBF access by the user is not good. That's why we have switched all applications to RDP.
Only the RDP user has access through the program. Except in our case WINHOTEL - there is no program in his account.

There are various measures you can take to increase the security of your DBF files. Here are some suggestions:

Changing the file extension:
Changing the file extension can help prevent careless users from opening the files, but it does not provide real protection against someone knowledgeable about the file structure.

Hiding folders:
You can hide folders on single-user Windows systems. This can be done simply by changing the folder properties. However, it is important to note that this method only provides superficial protection, as hidden folders can easily be made visible.

Restricting access rights:

Folder access
rights: You can set NTFS access rights so that only certain users or applications can access the files.

Database encryption:
If possible, you can encrypt the data in the database itself. However, this requires the application to be able to read and write the encrypted data.

A column with a continuous checksum is ideal for you as security, as it allows you to detect any manipulation. Log files where changes are additionally recorded also provide security.

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6312
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBF File Format - Considerations A Secure Option

Postby MarcoBoschi » Fri Jul 26, 2024 3:37 pm

Very interesting dear Otto
User avatar
MarcoBoschi
 
Posts: 1065
Joined: Thu Nov 17, 2005 11:08 am
Location: Padova - Italy

Re: DBF File Format - Considerations A Secure Option

Postby Rick Lipkin » Fri Jul 26, 2024 3:53 pm

User avatar
Rick Lipkin
 
Posts: 2663
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Re: DBF File Format - Considerations A Secure Option

Postby Otto » Fri Jul 26, 2024 4:03 pm

Dear Rick,

Do you agree with me that the existing FIVEWIN users already have their solution or a precise plan, e.g., switching to MySQL?

Which new users could we attract by focusing on one of the databases you mentioned?

Can you provide me with arguments on how we can reach new users with this focus? We need new users.

DBF would be "Blue Ocean Strategy" pure. DBF is currently a "Blue Ocean."
In the SEO and marketing context, "Blue Ocean" refers to a market with little to no competition, as opposed to a "Red Ocean," which is highly competitive.

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6312
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBF File Format - Considerations A Secure Option

Postby Rick Lipkin » Fri Jul 26, 2024 4:46 pm

Otto

I think every developer has his or her favorite database and I am in no way saying to use this database or not .. I still use .dbf\cdx to write my reports and build my temp databases .. I like dbf\cdx .. the take away for me is I use what I am comfortable with and .dbf is simple to for me to create, append and delete from and create difficult reports and when done .. just delete the temp report .dbf and its indexes

I like FiveWin because it connects to the most popular Sql databases and I can use .dbf to manipulate data locally ... Fivewin is the PERFECT development environment ..

Rick Lipkin
User avatar
Rick Lipkin
 
Posts: 2663
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Re: DBF File Format - Considerations A Secure Option

Postby vilian » Fri Jul 26, 2024 5:05 pm

I loved DBF files too, and i'm grateful everything i conquered developing with them, but i believe its time is already passed.

I still using them, but just as temporary files, to process reports, like you.

Migrate from DBF to Mysql is too easy, using the mysql native functions provided by FWH. Mr Rao made a great job, your support is amazing and makes the migrate from dbf to mysql easier. MySql is fast, easy, cheap and security, mainly if you are thinking about moving your system to internet.
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 972
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: DBF File Format - Considerations A Secure Option

Postby Otto » Fri Jul 26, 2024 6:07 pm

Dear Rick, dear Vilian,

You are right. But the point is to find new users for harbour/fivewin.
And the only market I see are beginners who need a simple database.

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6312
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBF File Format - Considerations A Secure Option

Postby vilian » Fri Jul 26, 2024 6:15 pm

Otto,

Mysql is also teach at colleges, so everyone who is starting to developer now, already knows mysql. I think will be easier to them, just learning how to use it with FWH. They don't need to learn DBF.
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 972
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: DBF File Format - Considerations A Secure Option

Postby Otto » Fri Jul 26, 2024 7:05 pm

Dear Vilian,
see this:

Image

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6312
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBF File Format - Considerations A Secure Option

Postby Jimmy » Sat Jul 27, 2024 4:30 am

hi Vilian,
vilian wrote:but i believe its time is already passed.

don´t forget that MYSQL is a Client / Server System so you need to Setup that Server Part.

but you also must optimize Server configuration depend on Machine and Type of using
the Website https://pgtune.leopard.in.ua/ can give you Answer for PostgreSQL
i´m still searching for similar for MySQL
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: DBF File Format - Considerations A Secure Option

Postby vilian » Tue Jul 30, 2024 11:12 am

Jimmy,

The default configuration of MySql is good enough to the majority of my small customers. However, to some customers we have to setup better the server.
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 972
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: DBF File Format - Considerations A Secure Option

Postby reinaldocrespo » Tue Jul 30, 2024 3:02 pm

Hello. It is easy to defend and swear by DBF when you have not experimented with SQL. It is hard to miss or even imagine what you have never experienced.

If you are a DBF user, you don’t care much for referential integrity. Sync and replication are just fancy words. Relational joints and result sets are not exiting. Client server technologies, AES256 encryption, user rights, Binary fields, double, integer, money fields, and a hundred others— who needs that?

In my opinion, if you are starting with this, do yourself a favor and learn SQL.


Sent from my iPhone using Tapatalk
User avatar
reinaldocrespo
 
Posts: 979
Joined: Thu Nov 17, 2005 5:49 pm
Location: Fort Lauderdale, FL

Re: DBF File Format - Considerations A Secure Option

Postby Jimmy » Tue Jul 30, 2024 6:53 pm

hi,
vilian wrote:The default configuration of MySql is good enough to the majority of my small customers.
However, to some customers we have to setup better the server.

I have little experience with MYSQL, I work with PostgreSQL
As I said, the most important thing in a client/server system is the configuration of the SQL Server, otherwise you waste a lot of performance.

The default configuration of PostgreSQL Server is designed for an "old" server with 4 GB and 5 clients and is nowhere near the performance of a current server.

There are also differences in the intended use of the SQL Server: LAN or Web

That's why I'm looking for a website for MYSQL, such as https://pgtune.leopard.in.ua/ for PostgreSQL, in order to get maximum performance
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Next

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 78 guests