Request for feedback for SQL

[cdmmaui]

Hello Everyone,

I am creating a new application that will run on Windows in a localized environment with possibility of remote data access from another location, possibly cross country here in USA.

My customer does not want to purchase high cost MS SQL.

Could you provide your professional opinion and the best SQL that I should utilize? I have seen a lot about MarioDB and wanted feedback on best SQL. There is an expectation that system may be processing more than 1000 transactions per week.

Thank you in advance for your help!

[Rick Lipkin]

Darrell

There is no limitation to the number of connections for the free version of Sql Server Express :

https://stackoverflow.com/questions/529 ... ition-free

However there are hardware Limitations

Code: Select all

As found on MSDN, you can use SQL Server Express Edition in production environment but you have to consider some technical limitations:

maximum of 1 processor, up to 4 cores allowed
maximum memory utilized (per instance of SQL Server Database Engine) 1GB
maximum relational Database size 10GB
 

https://logicalread.com/sql-server-expr ... d-b5mhSyM8

Code: Select all

Limitations

While the SQL Server Express editions can definitely be used for production databases, there are some important limitations that you need to be aware of:

The relational database engine is limited to the lesser of 1 socket or 4 cores.
The buffer cache of each instance is limited to 1MB of RAM.
If you have the SQL Server Express with Advanced Services edition, the Reporting Services components are limited to 4GB of RAM.
Databases are limited to 10GB of storage per database data file. FILESTREAM data does not count toward this limit.
SQL Agent is not present.
 

Rick Lipkin

[cdmmaui]

Hi Rick,

Thank you!

[nageswaragunupudi]

My preferences:
1. MariaDB ( free, powerful and no limitations )
2. SQLEXPRESS ( free. works same way as MSSQL server with limitations on datasize, etc. But these limitations are not at all important )

[cdmmaui]

Dear Rao,

Thank you. Where can I download MariaDB?

Thank you,

[nageswaragunupudi]

https://mariadb.org/

[Rick Lipkin]

Rao

Looking at the MariaDB site .. it appears there is a jconnector ... does jconnector have to be loaded as a client on each desktop ?

Rick Lipkin

[nageswaragunupudi]

No.
If you want to use ADO, we need to install ODBC connector.

But we advise using either built-in library in FWH or 3rd party libs like Dolphin or TMySql. In these three cases, we need to have a dll file in the exe folder. FWH provides everything that is required including libs and dlls.

So, it is just install MariaDB and go.