Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Files for ServerComputer
Message
From
24/08/2023 17:41:05
 
 
To
24/08/2023 16:07:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01686954
Message ID:
01686974
Views:
50
As do others here, I strongly recommend using a real RDBMS for any application which needs to support multiple simultaneous users. One possibility is SQL Server Express edition, which is free as in beer:
https://www.microsoft.com/en-ca/sql-server/sql-server-downloads

It has some performance throttling/scale limits, which in practice won't affect a very small organization such as you describe:
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16#scale-limits

Its hardware requirements are fairly modest. You may not even need to have a separate "server" computer on the network; if an existing PC has a modern CPU with at least 4 cores, and at least 8GB RAM then you can install SQL Server components and database(s) there. Other computers on the LAN can also access it. This is the same architecture that QuickBooks Desktop uses.

Flat-file DBF/DBC "databases" are much more vulnerable to malware/ransomware than RDBMS databases. It's also much easier to prevent unauthorized access with an RDBMS.
Shared DBF/DBC databases require careful networking setup by a skilled network admin, since the introduction of SMB2 with Windows Vista. There have been several extensive threads here on this topic, you can search by "SMB2" e.g. Message#01584063
RDBMSs are more flexible and "future proof". Third party apps such as Excel can directly talk to SQL Server. Web servers and other types of apps can also connect to and make use of data in SQL Server.

As others have pointed out, various open-source (libre and free as in beer) RDBMSs such as PostgreSQL, MySQL/MariaDB etc. are SQL Server alternatives and don't have performance throttling. Although they are Linux-native I believe some can be installed on Windows. If so, they could be installed in the same fashion as SQL Server Express, on non-dedicated hardware.

>Thank you Lutz et al.
>
>This is a very small organization. Definitely do not have the budget or moolah to purchase SQL lite or anything that rhymes with SQL. Just trying to provide them with some database application to assist in managing some of their assets and resources on a regular basis, again, small mom-pop setup with about 4 employees of caterers and event planners.
>
>>>Howdy,
>>>
>>>Have a potential client that is wanting to have a central database for all his employees to have access to via an application I'm develping. What files do I need to ensure I load on the designated "server" computer /main computer. I'm guessing one file in particular would be a separate project file that only has the dbc??
>>>
>>>Thanks in Advance....
>>
>>Views / CA over network to a shared folder will work - somehow. It needs to transport the data along the network, and as soon as more then one access the same table, VFP tends to move the whole data (table, memo and index) on every requery. We skipped the idea for decades and run on terminal services. Much faster, no network fuzz.
>>Or use some SQL Server (something on a LINUX will do, no need to feed M$ ) that provides you with the data. Much less data transfer.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform