BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Database choices          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Tim Guest Posted: Wed Mar 21, 2007 1:40 pm    Post subject: Database choices From D1 to D5, pretty much all my database applications were based on the BDE and Paradox tables. However, with D7 and dbExpress, I now use MySQL for most of my business apps which are developed for specific clients and where I go in and install MySQL as part of the project. I am now developing a multi-user program which will be available to anyone via a web site and there is a question over what database to use. Any database must be seemlessly part of the installation, just like the BDE in an InstallShield installation, but have all the language and client/server functionality of MySQL 5. MySQL also has the advantage of being free. The separate installation of MySQL rules it out (I think) as a database for this particular use and while I have no particular problem with the BDE/Paradox option, I am concerned about the SQL language limitations of it. Can anyone suggest a good route for me to take? Many thanks. Back to top Thomas Steinmaurer Guest Posted: Wed Mar 21, 2007 2:03 pm    Post subject: Re: Database choices Hi Tim, Quote: From D1 to D5, pretty much all my database applications were based on the BDE and Paradox tables. However, with D7 and dbExpress, I now use MySQL for most of my business apps which are developed for specific clients and where I go in and install MySQL as part of the project. I am now developing a multi-user program which will be available to anyone via a web site and there is a question over what database to use. Any database must be seemlessly part of the installation, just like the BDE in an InstallShield installation, but have all the language and client/server functionality of MySQL 5. MySQL also has the advantage of being free. Only if you release your software under GPL. Otherwise you have to obtain a commercial license. Open source doesn't necessarily mean "free beer". Quote: The separate installation of MySQL rules it out (I think) as a database for this particular use and while I have no particular problem with the BDE/Paradox option, I am concerned about the SQL language limitations of it. Can anyone suggest a good route for me to take? In alphabetical order (not starting another religious discussion *g*): Advantage, Firebird, NexusDB come to my mind. - Advantage has a local server as a set of files which is royality free. There is an upgrade path to a real server at a fair price. Nothing to install, just copy your application with these files. - Firebird has an embedded server as a set of files. There is also an upgrade path to the real server. Firebird is free for use even for commercial purposes. Feel free to donate a few bucks to the Firebird project via the Firebird Foundation when you earn money with Firebird. - NexusDB is a commercial product. You have to purchase a developer license, but deployment is royality free. NexusDB *can be* fully embedded into your application executable, but there is also a separate server available. -- Best Regards, Thomas Steinmaurer LogManager Series - Logging/Auditing Suites supporting InterBase, Firebird, Advantage Database, MS SQL Server and NexusDB V2 Upscene Productions http://www.upscene.com Back to top Oliver Guest Posted: Wed Mar 21, 2007 2:22 pm    Post subject: Re: Database choices Quote: Any database must be seemlessly part of the installation, just like the BDE in an InstallShield installation, but have all the language and client/server functionality of MySQL 5. MySQL also has the advantage of being free. I don't believe MySQL is actually free for commercial use. But in any case I recommend the free version of MS SQL Server 2005 (SQL Server Express). Oliver Townshend Back to top Tim Guest Posted: Wed Mar 21, 2007 4:42 pm    Post subject: Re: Database choices Thanks for the advice everyone. My comment about MySQL being free was I accept, a little rash, and doesn't, I think, reflect my intentions. I am intending for the basic program to be free, but if it proves popular, then I may provide a paid for version with additional features when I have time to support it, at which point I will ensure that all license issues are covered and paid for. Tim Back to top Guillem Guest Posted: Wed Mar 21, 2007 5:53 pm    Post subject: Re: Database choices Oliver wrote: Quote: I don't believe MySQL is actually free for commercial use. it is not. Only for non-commercial use. -- Best regards :-) Guillem Vicens Meier Dep. Informática Green Service S.A. www.clubgreenoasis.com -- Contribute to the Indy Docs project: http://docs.indyproject.org -- In order to contact me remove the -nospam Back to top Wayne Niddery [TeamB] Guest Posted: Wed Mar 21, 2007 8:21 pm    Post subject: Re: Database choices Tim wrote: Quote: I am now developing a multi-user program which will be available to anyone via a web site and there is a question over what database to use. The separate installation of MySQL rules it out (I think) as a database for this particular use and while I have no particular problem with the BDE/Paradox option, I am concerned about the SQL language limitations of it. It's not so much the SQL limits of the BDE as the ability of the BDE to function reliably in a multi-threaded environment which is required for a web site. The BDE is absolutely the wrong choice for this. If free is a requirement, it limits your choices a lot. Firebird would be fine but most other free versions have limits on concurrent users or other limitations. The free version of MS SQL Server would not be usable for the web - at least for more than a few users. Advantage Local server does not allow this, you must buy the server edition, and as others have pointed out, mySql would not be free either. If reasonable user license costs are not actually a problem then all of these and others are candidates, and that should definitely include InterBase. It can be installed seamlessly as part of your application installation. scales very well, matches the SQL standard very well and has all the proper features of a fully relational SQL database. -- Wayne Niddery - Winwright, Inc (www.winwright.ca) "Some see private enterprise as a predatory target to be shot, others as a cow to be milked, but few are those who see it as a sturdy horse pulling the wagon." - Winston Churchill Back to top Tim Guest Posted: Thu Mar 22, 2007 8:11 am    Post subject: Re: Database choices Thanks Wayne and Mikael. However, you have misunderstood my comments, although now that I come to read it again, I can see how you might have done. My program is not running ON a web site, but available as a download FROM a web site. The reason I mentioned it was that unlike previous database programs where I have installed a database as part of the project, I have no idea who will download the program so the database must be installed as part of the installation program. Tim "Mikael Eriksson" <micke314 (AT) gmail (DOT) com> wrote in message news:4602265c$1 (AT) newsgroups (DOT) borland.com... Quote: Hi! Wayne and Tim, Wayne Niddery [TeamB] skrev: Tim wrote: I am now developing a multi-user program which will be available to anyone via a web site and there is a question over what database to use. The BDE is absolutely the wrong choice for this. I totally agree with Wayne that BDE is wrong for this. In a web application available to anyone your primary concern should be performance. The free version of MS SQL Server would not be usable for the web - at least for more than a few users. The limits for SQL Server Express 2005 are: 1 CPU 1 GB RAM 4 GB Database size I believe that this generally is sufficient for more then a few users but it pretty much depends on what your application does. regards /Micke Back to top Mikael Eriksson Guest Posted: Thu Mar 22, 2007 8:11 am    Post subject: Re: Database choices Hi! Wayne and Tim, Wayne Niddery [TeamB] skrev: Quote: Tim wrote: I am now developing a multi-user program which will be available to anyone via a web site and there is a question over what database to use. The BDE is absolutely the wrong choice for this. I totally agree with Wayne that BDE is wrong for this. In a web application available to anyone your primary concern should be performance. Quote: The free version of MS SQL Server would not be usable for the web - at least for more than a few users. The limits for SQL Server Express 2005 are: 1 CPU 1 GB RAM 4 GB Database size I believe that this generally is sufficient for more then a few users but it pretty much depends on what your application does. regards /Micke Back to top Wayne Niddery [TeamB] Guest Posted: Thu Mar 22, 2007 8:25 pm    Post subject: Re: Database choices Tim wrote: Quote: However, you have misunderstood my comments, although now that I come to read it again, I can see how you might have done. My program is not running ON a web site, but available as a download FROM a web site. The reason I mentioned it was that unlike previous database programs where I have installed a database as part of the project, I have no idea who will download the program so the database must be installed as part of the installation program. Ok, that obviosuly changes things. I would still advise against using the BDE/Paradox in general just because it is so long in the tooth and there are so many other choices that have smaller footprints and simpler, more reliable, implemenations. Though it the application is really just single user then this isn't much of an issue. Going with one of the other choices is better IMO. -- Wayne Niddery - Winwright, Inc (www.winwright.ca) "Nurture your mind with great thoughts. To believe in the heroic makes heroes." — Benjamin Disraeli Back to top Jeff Guest Posted: Sat Mar 24, 2007 1:25 am    Post subject: Re: Database choices What about Postgres... is it free for commercial use? Jeff Back to top Andrew V. Fionik Guest Posted: Sat Mar 24, 2007 10:12 am    Post subject: Re: Database choices Hello, Tim! You wrote on Thu, 22 Mar 2007 06:53:40 -0000: T> However, you have misunderstood my comments, although now that I come to T> read it again, I can see how you might have done. T> My program is not running ON a web site, but available as a download T> FROM a web site. The reason I mentioned it was that unlike previous T> database programs where I have installed a database as part of the T> project, I have no idea who will download the program so the database T> must be installed as part of the installation program. A Firebird or Interbase is good candidate. They both able to be installed together with program with only single DLL. No separate installation process is neccessary. Moreover, if your users later want to use their database in classic client-server style they just need to reconfigure your application to use remote database instead of local. --- Andrew V. Fionik. SQL Maestro Group, http://www.sqlmaestro.com Database administration, management and development tools for Oracle, MS SQL Server, PostgreSQL, Firebird, MySQL, MaxDB, SQLite. Back to top Bill Todd Guest Posted: Sun Mar 25, 2007 1:51 am    Post subject: Re: Database choices Jeff wrote: Quote: What about Postgres... is it free for commercial use? Jeff AFAIK yes, it is. -- Bill Todd (TeamB) Back to top Tim Guest Posted: Thu Mar 29, 2007 8:11 am    Post subject: Re: Database choices Just thought a follow up is in order. I have investigated, and tried out where possible, a number of database options, including the ones mentioned in the replies, and as a BDE alternative, Firebird seems hard to beat. The Interbase heritage has a certain appeal to Delphi users, it supports every functionality I could want, the embedded version couldn't be simpler and the standard dbExpress Interbase drivers seem to work OK, although I have yet to try out transactions. Thanks for the help. Tim Back to top Hubert Rétif Guest Posted: Fri May 18, 2007 1:51 pm    Post subject: Re: Database choices Quote: I have investigated, and tried out where possible, a number of database options, including the ones mentioned in the replies, and as a BDE alternative, Firebird seems hard to beat. I have now this choice phase behind me. Starting with MySQL for initial development, but living it because licencing costs too much for this purpose, I had a look to Firebird, SQL Server Express, MSDE and PostgreSQL 8.2. Latest has been my final choice, combined with PostgresDAC from Microolap. Until now I don't think it was a bad choice. Hubert Retif Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.