|
| Accessing HFSQL through the internet |
| Iniciado por guest, 29,ene. 2016 13:10 - 9 respuestas |
| |
| | | |
|
| |
| Publicado el 29,enero 2016 - 13:10 |
Greeting,
I need to plan a new project, with a database of approximately 100 tables, most with a small number of records (<1000) and approximately 10 table with a large number of records generally numeric data, the total estimated size of the database is <100MB.
The database must be on the user's private remote hosts and users access it from different locations via the Internet, to enter data and print reports. It must be Windev windows applications for 30 employees.
At the same database should also be made a small web application with 5-10 web forms and tables into which data are entered by external clients of the company. It is expected a maximum of 60 simultaneous connections.
I'm thinking about using HFSQL server which could be accessed directly over the Internet, due to the need for the classic Windows applications. Web part I thought realized through AWP technology.
Can it work? What do you think about direct access HFSQL database over the internet? This seems to me good in theory, but I have not tested enough this setup to terms with multiple connections.
What would be better to use: HFSQL or MSSQL express?
I'm worried about the direct access over the Internet, whether it works satisfactorily?
Are there any obstacles for that?
I do not want to mess with web services because of the limited time available for the project.
Please advise me if you have experience in similar situations.
Thanks! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2016 - 13:22 |
Hi Marijan,
direct access to HFSQL works so far. We use it for years with middle and large databases for hundred of users.
It´s fast and stable.
The only disadvantage is that the users must open the HFSQL Port (for example 4900) outgoing which is not allowed in many companies. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2016 - 16:38 |
Michael,
Thanks for reply.
HFSQL Port is not a problem.
What about virtual servers & HFSQL? Did you tested this?
(I know that is not recomended by PCSoft, but if server is not loaded...) |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2016 - 17:03 |
Hi,
if possible don't use "direct access over the Internet" . it's matter of lucky and unlucky . just because you lucky for few years , doesn't mean you will lucky tomorrow . at least use VPN.
if you need connect from windows application , web application , mobile application . you might as well create a webservice |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2016 - 18:12 |
Hi,
I have some DB´s on a Microsoft Hyper V, works.
You don´t should use dynamic memory, that´s the only thing to avoid. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,enero 2016 - 23:53 |
I use it with 60 users 100,000 records in many tables works very well.
The only advice is use queries only to fill tables it is the fastest way, hFilter on a table very slow with a lot of records.
Dw |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2016 - 03:25 |
| I distribute my windev app (SQL Server DB) over the internet using Windows RemoteApp. The advantage of this vs merely access DB over the internet is that you only have to distribute a RDP connection to the user and when you update the application you only have to update the exe in a single location. From the user perspective it looks like they are running the app directly on their desktop. The only downside is that drag and drop is not supported from client to host. (copy and paste does work) |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
102 mensajes |
|
| Publicado el 01,febrero 2016 - 13:05 |
We use a virtual windows server (cheap, about 20 Euro/month) with HFSQL 19 for a couple of programs and apps with about 10 to 100 users. Works great.
I see some problems with HFSQL if you're planning to use lots of SQL. Capabilities of HFSQL is very limited if it comes to subselects or selects within selects.
This won't work:
SELECT field1
, field2
, (SELECT something ELSE)
FROM TABLE
This won't work as well:
SELECT * FROM (
SELECT field1
, field2
, field3
FROM TABLE
)
--
http://arnoldconsult.de
WinDev 20 with Oracle, WinDevMobile Android Apps and Motorola Windows CE Mobile Barcode Scanners, Python 3 with Oracle and MySQL |
| |
| |
| | | |
|
| | |
| |
| Publicado el 01,febrero 2016 - 21:25 |
Thank you very much for your answers!
Your experiences are very helpful.
Steve:
For this kind of solutions I forgot, though met with such applications.
I'm interested in how the reports and printouts work in such an environment,
as well as whether there is any licensing restriction regarding the
simultaneous connections on windows server?
Can a solution designed in that way also replace the web application part?
(web application was the first idea for the sole reason to avoid the need
for installation on external associates) |
| |
| |
| | | |
|
| | |
| |
| Publicado el 02,febrero 2016 - 03:36 |
Quote
Marijan Tomasic
Thank you very much for your answers!
Your experiences are very helpful.
Steve:
For this kind of solutions I forgot, though met with such applications.
I'm interested in how the reports and printouts work in such an environment,
as well as whether there is any licensing restriction regarding the
simultaneous connections on windows server?
Can a solution designed in that way also replace the web application part?
(web application was the first idea for the sole reason to avoid the need
for installation on external associates)
Reports and printing work fine. You can configure your RDP connections to use local resources. You do need to have Terminal Service licenses for this method. |
| |
| |
| | | |
|
| | | | |
| | |
|