BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  standalone app with DB Goto page 1, 2  Next          BorlandTalk.com Forum Index -> comp.lang.pascal.delphi.databases View previous topic :: View next topic   Author Message Denis Jeanroy Guest Posted: Thu Feb 12, 2004 1:56 pm    Post subject: standalone app with DB Hello I have to develop an application with a database, but no third party software is allowed (Access, SQL server, ...). the program must include its own database engine, or use an external one, beeing a part of the package installed. the software will be not used on a single computer. Multi users DB is not necessary. Complex queries are necessary (typically what SQL can do). BDE is ruled out, and I consider using something like MySql. What are the options for this function ? Is it possible to use MySql without purchasing this software or licence for every installation ? Can MySql (or other DB software) be easily included in an installation package using Installshield express ? Thanks for your advice Denis Back to top pr Guest Posted: Thu Feb 12, 2004 6:58 pm    Post subject: Re: standalone app with DB "Denis Jeanroy" <nospam (AT) work (DOT) com> wrote Quote: Hello I have to develop an application with a database, but no third party software is allowed (Access, SQL server, ...). the program must include its own database engine, or use an external one, beeing a part of the package installed. the software will be not used on a single computer. Multi users DB is not necessary. Complex queries are necessary (typically what SQL can do). Embedded Firebird. PR Back to top Rick Carter Guest Posted: Fri Feb 13, 2004 1:28 am    Post subject: Re: standalone app with DB "Denis Jeanroy" <nospam (AT) work (DOT) com> wrote Quote: I have to develop an application with a database, but no third party software is allowed (Access, SQL server, ...). the program must include its own database engine, or use an external one, beeing a part of the package installed. the software will be not used on a single computer. Multi users DB is not necessary. Complex queries are necessary (typically what SQL can do). BDE is ruled out, and I consider using something like MySql. I've read your post several times, and I'm still confused about what you want. You say "no third party software," then you say you're considering MySQL. Do you mean that you're looking for a free solution? You don't mention what version of Delphi you have. If you have TClientDataSet, and the data doesn't need to move from one computer to another, simply storing the data in .cds or ..xml format might be sufficient. Advantage might be something else to look at, since the local server is free, and it's fairly easy to deploy with a small footprint. And what do you mean by "the software will not be used on a single computer?" Then the next thing you say is that it will not be multi-user. Rick Carter Chair, Paradox/Delphi SIG, Cincinnati PC Users Group Back to top nisse Guest Posted: Fri Feb 13, 2004 9:44 am    Post subject: Re: standalone app with DB Take a look at Pervasive SQL (Btrieve) standalone version "Denis Jeanroy" <nospam (AT) work (DOT) com> skrev i meddelandet news:402bad41$0$19647$4d4eb98e (AT) read (DOT) news.fr.uu.net... Quote: Hello I have to develop an application with a database, but no third party software is allowed (Access, SQL server, ...). the program must include its own database engine, or use an external one, beeing a part of the package installed. the software will be not used on a single computer. Multi users DB is not necessary. Complex queries are necessary (typically what SQL can do). BDE is ruled out, and I consider using something like MySql. What are the options for this function ? Is it possible to use MySql without purchasing this software or licence for every installation ? Can MySql (or other DB software) be easily included in an installation package using Installshield express ? Thanks for your advice Denis Back to top Ray Porter Guest Posted: Fri Feb 13, 2004 5:36 pm    Post subject: Re: standalone app with DB Hi Denis, Your requirements seems a little contradictory. You say no third party software is allowed but then you go on to list MySQL as a possible database engine. MySQL is definitely "third party" software and far more expensive than Access if you're using it in a commercial environment. If you're writing a standalone application, I'd recommend you use the tools available to you in D8 and .Net. If you need something more powerful than Access or MSDE, you could look at MySQL or Interbase (Firebird). I think MySQL's price for a commercial server license is $495. I'm not sure about Firebird. Note that you can use MySQL free only if you're willing to make the source code for your application opensource/freeware. Ray Porter "Denis Jeanroy" <nospam (AT) work (DOT) com> wrote Quote: Hello I have to develop an application with a database, but no third party software is allowed (Access, SQL server, ...). the program must include its own database engine, or use an external one, beeing a part of the package installed. the software will be not used on a single computer. Multi users DB is not necessary. Complex queries are necessary (typically what SQL can do). BDE is ruled out, and I consider using something like MySql. What are the options for this function ? Is it possible to use MySql without purchasing this software or licence for every installation ? Can MySql (or other DB software) be easily included in an installation package using Installshield express ? Thanks for your advice Denis Back to top Denis Jeanroy Guest Posted: Mon Feb 16, 2004 12:11 pm    Post subject: Re: standalone app with DB what i meant was : only one package to install, no third party software to be purchased by the user (like Access) and to install separately. I use Delphi 6 Pro. Denis Back to top Denis Jeanroy Guest Posted: Mon Feb 16, 2004 12:20 pm    Post subject: Re: standalone app with DB Wow, i didn't kown that MySql was not free ! The application IS a commercial and professional software, and the source code can't be opensource. What I mean with "no third party" is in fact no software to purchase or install separately. The application is developped for a client who must be free to install and duplicate freely. He won't have to deal with licences or complex installations. Denis Back to top Ray Porter Guest Posted: Mon Feb 16, 2004 4:38 pm    Post subject: Re: standalone app with DB "Denis Jeanroy" <nospam (AT) work (DOT) com> wrote Quote: Wow, i didn't kown that MySql was not free ! The application IS a commercial and professional software, and the source code can't be opensource. What I mean with "no third party" is in fact no software to purchase or install separately. The application is developped for a client who must be free to install and duplicate freely. He won't have to deal with licences or complex installations. Take a look at the following web site: http://www.kylecordes.com/bag/index.html Kyle maintains a fairly accurate listing of db tools for Delphi. DBISAM seems to meet your needs but I don't think it's available for Delphi 8 or ..Net yet. Meeting your requirements completely for full SQL support, freely distributable and 0-installation issues may be tough. You may also have to purchase a single-developer license for any tool you decide to use. Good luck, Ray Back to top Alfredo Novoa Guest Posted: Mon Feb 16, 2004 5:48 pm    Post subject: Re: standalone app with DB "Denis Jeanroy" <nospam (AT) work (DOT) com> wrote Quote: Hello I have to develop an application with a database, but no third party software is allowed (Access, SQL server, ...). the program must include its own database engine, or use an external one, beeing a part of the package installed. the software will be not used on a single computer. Multi users DB is not necessary. Complex queries are necessary (typically what SQL can do). Embedded FireBird with no doubt. Regards Alfredo Back to top Aage Johansen Guest Posted: Tue Feb 17, 2004 7:37 am    Post subject: Re: standalone app with DB På Mon, 16 Feb 2004 13:20:33 +0100, skrev Denis Jeanroy <nospam (AT) work (DOT) com>: Quote: Wow, i didn't kown that MySql was not free ! The application IS a commercial and professional software, and the source code can't be opensource. What I mean with "no third party" is in fact no software to purchase or install separately. The application is developped for a client who must be free to install and duplicate freely. He won't have to deal with licences or complex installations. DBISAM isn't free, but once purchased (by you) it can be freely deployed - no licences. Moreover, there isn't anything to deploy. Don't know about their server version - take a look at elevatesoft. Firebird is free (see [url]www.ibphoenix.com)[/url]. Nothing to pay (however, support is appreciated!). Very nice C/S database, based on Interbase/6. You may have to purchase a component set as IBX is not guaranteed to work with it. There may be free ones. I use IBO (ibObjects), but there are others. -- Aage J. Back to top Ray Porter Guest Posted: Tue Feb 17, 2004 2:31 pm    Post subject: Re: standalone app with DB "Aage Johansen" <aage.johansen (AT) kreftregisteret (DOT) no> wrote Quote: DBISAM isn't free, but once purchased (by you) it can be freely deployed - no licences. Moreover, there isn't anything to deploy. Don't know about their server version - take a look at elevatesoft. Firebird is free (see [url]www.ibphoenix.com)[/url]. Nothing to pay (however, support is appreciated!). Very nice C/S database, based on Interbase/6. You may have to purchase a component set as IBX is not guaranteed to work with it. There may be free ones. I use IBO (ibObjects), but there are others. Does Firebird compile into the app with no redistributables? My understanding was that you had to have an Interbase server running somewhere? Guess I need to take a look and see. My impression was that DBISAM came closest to meeting the original poster's requirements except that he would have to purchase a developer's license. Ray Back to top Denis Jeanroy Guest Posted: Tue Feb 17, 2004 4:36 pm    Post subject: Re: standalone app with DB once again, thank you everybody for all your helpful answers Denis Back to top Alfredo Novoa Guest Posted: Tue Feb 17, 2004 5:23 pm    Post subject: Re: standalone app with DB Aage Johansen <aage.johansen (AT) kreftregisteret (DOT) no> wrote Quote: DBISAM isn't free, but once purchased (by you) it can be freely deployed - no licences. Moreover, there isn't anything to deploy. Don't know about their server version - take a look at elevatesoft. It lacks many of the Firebird's features. Quote: Firebird is free (see [url]www.ibphoenix.com)[/url]. Nothing to pay (however, support is appreciated!). Very nice C/S database DBMS, not database ;-) Quote: , based on Interbase/6. You may have to purchase a component set as IBX is not guaranteed to work with it. But it works fine. Regards Alfredo Back to top Aage Johansen Guest Posted: Wed Feb 18, 2004 7:58 am    Post subject: Re: standalone app with DB På Tue, 17 Feb 2004 09:31:36 -0500, skrev Ray Porter: Quote: ... Does Firebird compile into the app with no redistributables? My understanding was that you had to have an Interbase server running somewhere? Guess I need to take a look and see. I've not tried the embedded version. Anyhow, Firebird does not require a separate server - I develop with the RDBMS running locally. Quote: My impression was that DBISAM came closest to meeting the original poster's requirements except that he would have to purchase a developer's license. Yes, I believe so. In particular as it is to be a single user application. -- Aage J. Back to top Robert Mischke Guest Posted: Wed Feb 18, 2004 12:56 pm    Post subject: Re: standalone app with DB "Denis Jeanroy" <nospam (AT) work (DOT) com> wrote: Quote: what i meant was : only one package to install, no third party software to be purchased by the user (like Access) and to install separately. I use Delphi 6 Pro. I didn't see the start of this thread, so maybe this was mentioned already... but I was looking for the same thing and I got the very helpful hint to look at http://www.sqlite.org/ . Single-user sql database in dll form, royalty (and even copyright) free. Works fine for me :) PS: There are several Delphi wrappers for it. HTH, Robert Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> comp.lang.pascal.delphi.databases All times are GMT Goto page 1, 2  Next Page 1 of 2   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.