Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Using ODBC on web server
Wed, Oct 15 2014 3:29 PMPermanent Link

TD

Advanced Data Systems, Inc.

I am new to EWB but love it so far.  I have several questions:

1. If I install the Firebird ODBC drivers on the web server, will each client that connects have to have the ODBC drivers installed locally also to make the app work? FYI, I will be running the app on a VPS which will be running Ubuntu Linux.

2. What are the downside to using ODBC to connec to database on web server?

3. Does EWB have the equivalent of the DataModule in Delphi?

4. Some of my forms will have a good many comboboxs that will be filled from tables ( this is static data).  Will adding say 12 datasets to a form cause a performance problem?

5. On my development machine I have EWB installed along with the Firebird ODBC drivers and I can connect to the Firebird database fine.  What will I need to create when I deploy the app as in will I need  a web server like Apache, etc?

Thanks,
TD
Wed, Oct 15 2014 3:49 PMPermanent Link

Raul

Team Elevate Team Elevate

On 10/15/2014 3:29 PM, TD wrote:
> 1. If I install the Firebird ODBC drivers on the web server, will each client that connects have to have the ODBC drivers installed locally also to make the app work? FYI, I will be running the app on a VPS which will be running Ubuntu Linux.

No - the database connectivity would all be on the server side. Since
you're running ubuntu you'd have to write your own server side to handle
the client requests, access data and return it to clients.

> 3. Does EWB have the equivalent of the DataModule in Delphi?

No but you can do without it (same way DM is not required in delphi) -
just create a class and create components in code.

> 4. Some of my forms will have a good many comboboxs that will be filled from tables ( this is static data).  Will adding say 12 datasets to a form cause a performance problem?

depends - each one of those would require a trip to the server to be
populated. Since it's static content you can probably load them all once
and then keep for the session. Hence should be no impact.

> 5. On my development machine I have EWB installed along with the Firebird ODBC drivers and I can connect to the Firebird database fine.  What will I need to create when I deploy the app as in will I need  a web server like Apache, etc?
>
Are you using EWB web server and/or the EWB built-in dataset manager?

If so then EWB web server does not run on ubuntu so you likely need to
write your own back end to handle all of this (for example apache + your
favourite server side toolset like PHP). You could try to run EWb web
server with wine or use windows VPS.

Raul
Thu, Oct 16 2014 12:49 PMPermanent Link

TD

Advanced Data Systems, Inc.

Raul wrote:

If so then EWB web server does not run on ubuntu so you likely need to
write your own back end to handle all of this (for example apache + your
favourite server side toolset like PHP). You could try to run EWb web
server with wine or use windows VPS.

Thanks Raul.  From what you have said I would be far better off to switch to a MS Windows VPS.  That would mean I could use the EWB web server and use ODBC and let EWB handle all of the data transfer stuff.  I need to create this app fairly quickly so the less new stuff I need to learn the better right now.

I now have some additional questions:

1. How much traffic can the EWB web server handle?

2. Since this app will be facing the internet (it will of course have a login page), what security problems do I face?

3. Can someone recommend a cheap MS Windows VPS provider that I can use for now to do beta testing?

Thanks,
TD
Fri, Oct 17 2014 3:57 AMPermanent Link

Matthew Jones

TD wrote:

> 1. How much traffic can the EWB web server handle?

Only you can tell that - it depends on what your application does. If
you connect, load three data records and do nothing else it will handle
lots, but if your application is constantly doing database access using
complex queries, then it won't handle so many users. You'd want to
re-imagine your code then to have the server work differently and not
be a database direct.


> 2. Since this app will be facing the internet (it will of course have
> a login page), what security problems do I face?

Putting a database onto the web can be dangerous so you need to check
authentication etc. Fortunately, Elevate is a small database so
unlikely to be worth anyone doing a scanner looking for vulnerable
servers like they did with SQL Server in the old days. Just make sure
that you have no standard names or passwords. Keep them strong. Make
sure no one can drop tables etc. Make sure you have a backup happening.


>
> 3. Can someone recommend a cheap MS Windows VPS provider that I can
> use for now to do beta testing?

I was going to say I don't know, but I will mention the Azure virtual
machines. I used one for a year or so, and it was good. It was
basically a standard Windows machine that I could do anything with, but
virtualised so if the hardware failed it would magically reboot inside
a minute without me doing anything. It cost me something like $70 a
month (actually never more than 55 GBP, depends on how many days in the
month). You may have some number of hours free if you are on MSDN.


--

Matthew Jones
Fri, Oct 17 2014 5:25 AMPermanent Link

Walter Matte

Tactical Business Corporation

>>  3. Can someone recommend a cheap MS Windows VPS provider that I can use for now to do beta testing?


I use a VPS from http://www.1and1.com and someone recently told me about http://www.vps-mart.com

Walter
Sun, Oct 19 2014 7:24 PMPermanent Link

TD

Advanced Data Systems, Inc.

Thanks everyone for the feedback.

TD
Image