ODP: [firebird-support] Install a DB Firebird on a web site
Hi, As your description is not precise i post few possibilities. 1. Simply run regular Firebird and connect to network by e.g. RDP over VPN or something like that. 2. Implement application server e.g. by using DataSnap and use it in new places from e.g. smartphone 3. If you have or need web server, and this web server is only one accesing your db, then you can simply use embeded Firebird server on any hosting. I use it on cheap Windows hosting and connect many clients by web page. This really depend on your situation, plans and needs Regards, Karol Bieniaszewski
Re: [firebird-support] Install a DB Firebird on a web site
On 2019/03/27 17:10, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 27-3-2019 13:01, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > Good morning, > My clients use an application written with Delphi that use a Firebird > Database 2.5 (business accounting). > Necessity has risen to access the same database from more subjects that > uses the same application. > I was thinking of moving the database Firebird from the computer to a > Web site, to allow all one connection directed by app. > Ithink this is possible for Firebird, but I have not succeeded in > finding the way to install Firebird on a site or to find a site that can > manage the Firebird driver. > Obviously I could move the database to a MySql or similar already > existing on a site, but it should be managed with Php and medium Web pages. > Is the question first of all: it is possible to install Firebird on > Web?And how? Looking for documentation, I have found only instructions > of installation and problem list of connection, but for local computer > or in an intranet. > Does documentation exist related to my problem? > I thank for a possible answer. > Antonio BIANCA You don't install Firebird on a website (nor do you install MySQL on a website for that matter). A website is a thing accessed through HTTP. Given your application uses Delphi, you either need to allow those multiple parties to be able to securely access your Firebird server (eg through a VPN), or maybe you need to build a webservice that replaces your direct database access. Building a webservice to replace direct database access is an extremely broad topic, where accessing the Firebird database is probably the least of your worries. In any case, your question is quite vague to actually answer. You may want to clarify exactly what you're looking for and why. Mark -- Mark Rotteveel Mark is 100% correct, but I think I understand your question. You want to access FB database remotely from applications. To do that on your "website" which are actually just a virtual pc that provides certain services like a "website", will imply that you need access to that "pc", install Firebird and and configure FB and the Pc to allow remote access, etc. There are many pitfalls this way. Web providers regular change their rules, antivirus etc and any one of them may suddenly prevent access to your DB. After many trails, I found that are only two solutions that work. A virtual server provided by a service provider where you can install your own software and manage it. Due to a lack of knowledge, I only use Windows based servers, but I see no reason why Linux will not work. The second option is open your Firebird server for remote access. This has nothing to do with Firebird and general means you have setup your internet router to forward request on port 3050/3060 to your FB Server with a few changes to Firebird.conf. That server must have a fix local IP and router internet connection must have a fix IP or you can use DDNS. Clearly there are security issues with this, as it gives people with the right info direct access to your DB's from virtually any software that can access a FDB database. Cornie
[firebird-support] Re: Install a DB Firebird on a web site
Antonio... I believe you are asking how you install a Firebird Database Engine on a "hosted web site" by one of the many providers available to developers on the Internet. If this is the case, than you will not find many that support the Firebird Database intrinsically whereas most support either SQL Server and\or MySQL. In fact, a casual search for such providers yielded very little for this type of support. Unfortunately, Firebird is not as popular an Open Source alternative as MySQL or PostgreSQL. As a result, you may have to build your hosted web site with an external access to a Firebird Database Server, which the provider you choose may assist in your implementation. If however, you are asking how to load a Firebird Database to a web site, in essence as part of a web application that is being hosted, than Mark is correct in his reply in that you do not load a database engine to a web site. Normally in well defined distributed systems, the database is implemented on a completely separate, physical tier. However, since administrators have found it easier to simply add a database engine on to the same server that is hosting web site processes, you now normally find what would normally be an application server also running a database engine. Thus for example an application server would have IIS supporting the running of ASP.NET web applications while also have a database engine installed on the same machine. If you could clarify what you are seeking to do, it would help you in getting a more concise answer to your original question... Steve Naidamast Sr. Software Engineer
RE: [firebird-support] Install a DB Firebird on a web site
My approach was to set up a Windows VM on Azure / AWS and install the app there. Then use RDP clients to access the app in the cloud. Users can access the app from pretty much any device that has RDP client software. Mac / Win / iPAD etc. Then at least your DB access from app is local to the VM and nice and fast as well as your DB is not open to the outside world. -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, 27 March, 2019 17:32 To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Install a DB Firebird on a web site On 27/03/2019 12:01, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > I was thinking of moving the database Firebird from the computer to a > Web site, to allow all one connection directed by app. > Ithink this is possible for Firebird, but I have not succeeded in > finding the way to install Firebird on a site or to find a site that > can manage the Firebird driver. If your delphi application is designed for multiple clients to access the same database, then it is just a matter of making the database accessible on the internet. That does not involve a website, but it does open the database to scrutiny by anybody else on the internet. My own websites use Firebird as a tool to store the data that is displayed on the website, but is only accessible by the local copy of PHP, while another application has BuilderC clients spread across multiple locations all accessing the one copy of Firebird one a closed network. As Mark says, what are you actually trying to achieve? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media - https://rainbowdigitalmedia.co.uk ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Install a DB Firebird on a web site
On 27/03/2019 12:01, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > I was thinking of moving the database Firebird from the computer to a > Web site, to allow all one connection directed by app. > Ithink this is possible for Firebird, but I have not succeeded in > finding the way to install Firebird on a site or to find a site that can > manage the Firebird driver. If your delphi application is designed for multiple clients to access the same database, then it is just a matter of making the database accessible on the internet. That does not involve a website, but it does open the database to scrutiny by anybody else on the internet. My own websites use Firebird as a tool to store the data that is displayed on the website, but is only accessible by the local copy of PHP, while another application has BuilderC clients spread across multiple locations all accessing the one copy of Firebird one a closed network. As Mark says, what are you actually trying to achieve? -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media - https://rainbowdigitalmedia.co.uk ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Install a DB Firebird on a web site
On 27-3-2019 13:01, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > Good morning, > My clients use an application written with Delphi that use a Firebird > Database 2.5 (business accounting). > Necessity has risen to access the same database from more subjects that > uses the same application. > I was thinking of moving the database Firebird from the computer to a > Web site, to allow all one connection directed by app. > Ithink this is possible for Firebird, but I have not succeeded in > finding the way to install Firebird on a site or to find a site that can > manage the Firebird driver. > Obviously I could move the database to a MySql or similar already > existing on a site, but it should be managed with Php and medium Web pages. > Is the question first of all: it is possible to install Firebird on > Web?And how? Looking for documentation, I have found only instructions > of installation and problem list of connection, but for local computer > or in an intranet. > Does documentation exist related to my problem? > I thank for a possible answer. > Antonio BIANCA You don't install Firebird on a website (nor do you install MySQL on a website for that matter). A website is a thing accessed through HTTP. Given your application uses Delphi, you either need to allow those multiple parties to be able to securely access your Firebird server (eg through a VPN), or maybe you need to build a webservice that replaces your direct database access. Building a webservice to replace direct database access is an extremely broad topic, where accessing the Firebird database is probably the least of your worries. In any case, your question is quite vague to actually answer. You may want to clarify exactly what you're looking for and why. Mark -- Mark Rotteveel