![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 6 of 6 total |
![]() |
Wed, Oct 15 2014 3:29 PM | Permanent 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 PM | Permanent Link |
Raul Globestar Systems ![]() | 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 PM | Permanent 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 AM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
TD Advanced Data Systems, Inc. | Thanks everyone for the feedback.
TD |
This web page was last updated on Thursday, March 30, 2023 at 10:19 AM | Privacy Policy![]() © 2023 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |