by Otto » Thu Jul 18, 2024 1:02 pm
Dear Maurizio,
Here is a paradigm shift, and that is RDP and now mod harbour.
Even if you have 5 users, it is very unlikely that more than one will open the file at the same second. You really need to rethink here.
How we use DBF - everything is only remotely accessible - it is like a single-user solution.
I have known SQL for a very long time and worked with SQL when I rewrote the program to VB6 and VB.NET.
With all the comments, I always feel like it's being implied that I don't know SQL. I have used SQL for over 10 years.
But the situation is different today. With SSDs, we have similar speeds on the hard drive as in the main memory.
But assuming that SQL is the ultimate solution is wrong. And you can see that the new database trend is NoSQL databases.
It is clear that we have to add some functions ourselves with DBF.
How do you solve incremental search in tables on the web to achieve "XBROWSE standard"? You can't load the entire database.
You have to reload with each entered character. And here it's about milliseconds.
Especially in competition with competitors, the incremental search in the tables, which is extremely fast in FIVEWIN, always gave us advantages.
For example, security:
SQL databases: A user with read and write permissions can execute SQL queries and save the results locally, which essentially equates to downloading the data.
DBF files: Access to DBF files typically requires a special program. If this program only exists on the server and the user has no direct access to the files, they must perform the queries server-side.
Here, for example, I read the entire FW WEB Server and save the content here with me.
I understand: My young collaborators agree to use FW but not to use DBF. As an employee, I would also first look after myself and stay as compatible with the job market as possible.
One can then easily switch to another company as an employee. Of course, this is not in my interest as a company owner!
I actually just want to provoke some thought about whether it makes sense to recommend everyone to switch to SQL.
I am interested in how to solve incremental search - or possibly the FW test server is not the best. Maybe we will hear real results.
Best regards,
Otto
Especially for web design, dbf is great - and there would also be a large target audience for HARBOUR and FIVEWIN
Where I have a lot of experience is web pages. for example, DBF files are excellent here. Especially the quick maintenance directly with remote access to the
web server and there with the dbf editor is extremely fast.
I used to use WordPress, but it is no comparison with dbf files. when flexibility is needed, DBF files are unbeatable.
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club********************************************************************