Still prefer Firebird: - Open Source - Easy installation/maintenance - Good components and drivers (ODBC/Native) - Plenty support on the Net - Fast - Runs multiple databases - You can have multiple firebird-servers in your network, each looking for its own port to connect - Multi-platform (Windows/Linux/*nix-variants (Solaris/MAC/FreeBSD, HP-UX)) - Supports Stored Procedures (I only use Stored Procedures, no dynamic queries/statements for me anymore) - You can perform maintenance/updates etc. through batch-files/input sql-files without having your customer to login etc.
Only 2 shortages (1 of them should be solved in next generation): - You can't do joins/queries over multiple databases from 1 database, you will have to use client for that (should be solved in next generation) - You can't create (temp) tables on the fly in Stored Procedures, allthough there is a mechanism in the Stored Procedures that does about the same (For select * from tables into variables) -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] abdollah nouri Verzonden: woensdag 4 april 2007 7:06 Aan: Moderated discussion list about database programming with Borland's Delphi Onderwerp: Re: BDE Replacement Database I selected MySql with CrLab component suite, It is open source database and core lab mysql component is very good component. ----- Original Message ---- From: James Fergus <[EMAIL PROTECTED]> To: delphi-db@elists.org Sent: Tuesday, April 3, 2007 7:14:09 PM Subject: Re:BDE Replacement Database After doing some research I selected the 'Advantage' database from Extended systems - now part of Sybase. The Local server version is free, and moving to the client server model is easy and inexpensive. The free management tool is very good and the integration into the Delphi environment is very tight. I have been very pleased so far. James F [EMAIL PROTECTED] wrote: > Send Delphi-DB mailing list submissions to > delphi-db@elists.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.elists.org/mailman/listinfo/delphi-db > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Delphi-DB digest..." > > > Today's Topics: > > 1. Re: [!! SPAM] Re: Handling BDE Keyviolations in Delphi forms > ([EMAIL PROTECTED]) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 30 Mar 2007 14:29:03 EST > From: [EMAIL PROTECTED] > Subject: Re: [!! SPAM] Re: Handling BDE Keyviolations in Delphi forms > To: delphi-db@elists.org > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="US-ASCII" > > I am using the Absolute database. It works fine for the stuff I do and it is > inexpensive - actually free for personal use. Look them up at > _www.componentace.com_ (http://www.componentace.com) > > George > > > > ************************************** See what's free at http://www.aol.com. > > > ------------------------------ > > _______________________________________________ > Delphi-DB mailing list > Delphi-DB@elists.org > http://www.elists.org/mailman/listinfo/delphi-db > > > End of Delphi-DB Digest, Vol 51, Issue 1 > **************************************** > > > -- _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097 _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db Paul van Mil Senior Developer MAD-Systems Burg. van Suchtelenstr. 26 6641 XN Beuningen (Gld) The Netherlands Url: www.madsystems.nl Tel.: +31 (0)24-366 1501 Fax.: +31 (0)24-366 1502 Mob.: +31 (0)6 2251 4084 Email: [EMAIL PROTECTED] ************************************************************************* Disclaimer: MAD-Systems is de enige opdrachtnemer van alle werkzaamheden. Nederlands recht is van toepassing. De aansprakelijkheid van MAD-Systems is beperkt tot de uitkering die plaatsvindt onder de verzekering van MAD-Systems tegen beroepsaansprakelijkheid. Disclaimer: MAD-Systems is the exclusive contractual party with respect to all work and services undertaken. Dutch laws shall apply. The aggregate liability of MAD-Systems shall be limited to the proceeds available under MAD-Systems professional liability insurance. This e-mail message is intended exclusively for the addressee(s). If the e-mail was sent to you by mistake, would you please contact us immediately by e-mail through "[EMAIL PROTECTED]". In that case, we also request that you destroy the e-mail and that you neither use the contents nor disclose them in any manner to third parties, because the message may contain confidential information which is protected by professional secrecy. Any addressee should be aware that internet e-mail is subject to risks; MAD-Systems therefore denies any responsibility for damages resulting from the use of Internet e-mail. ************************************************************************* This email is checked on virusses through Norton Antivirus, updated 2007-04-03 _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db