[DUG] Datebases with Delphi

[Nick]

Rob,

Thanks, firebird doesn't sound to bad, and you can use native Delphi 
components with firebird to from what i've read. All the aps i've done 
so far are simply for end user use - no client/server requirements.

Will research this some more :-) Thanks.

Nick


Robert martin wrote:
> Hi
>
> Firebird is a nice open source / free relational DB (from the 
> Interbase base code).
>
> It has an embedded option that simply requires putting some files in 
> the same dir as the app.  This is for single user DBs.  But with 
> little effor you can switch to a proper client server environment.  
> However at that point you need to install FB server (small footprint) 
> on the server computer and FB client on the clients.  So it might be a 
> bit much work.
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax   +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> Jeremy Coulter wrote:
>> I too develped using the ElevateDB predecessor, that was, until I 
>> tried to use it in a client server arrangment, and THEN it all turned 
>> to POOH !!! It had SERIOUS issues with indexing, and in some cases, 
>> it would transfer around the entire table to update just ONE field !
>> It was at that point I went back to Faithfull old Access, but I use 
>> the Titan native access Access controls, although now we are looking 
>> at moving over to MS SQL 2005 Express, I need to convert them over to 
>> ADO, but thats another story :-)
>>  
>> Jeremy
>>  
>>
>>     -----Original Message-----
>>     From: "Steve Peacocke" <steve.peacocke at gmail.com>
>>     To: "NZ Borland Developers Group - Delphi List" 
>> <delphi at delphi.org.nz>
>>     Date: Tue, 3 Jul 2007 10:42:03 +1200
>>     Subject: Re: [DUG] Datebases with Delphi
>>
>>     ElevateDB comes with a tool for creating / modifying the 
>> database, SQL
>>     testing, creating triggers, stored procedures and functions, views
>>     etc. It can also create in-memory tables that interact with external
>>     tables in the same way as any other ElevateDB table.
>>
>>     I once wrote a SQL tool for its predecessor DBISAM that can
>>     modify/create tables with SQL calls and scripts etc. It can then
>>     transfer the SQL to/from Delphi code - www.trader.co.nz/tools
>>     <http://www.trader.co.nz/tools> - I'm
>>     currently (slowly) changing it for ElevateDB and adding graphical 
>> (MS
>>     Access-like) table manipulation and SQL building.
>>
>>     Steve
>>     --     Steve Peacocke
>>     http://stevepeacocke.blogspot.com/
>>
>>     On 03/07/07, Steve Peacocke <steve.peacocke at gmail.com> wrote:
>>     > Take a good look at ElevateDB from http://www.elevatesoft.com/
>>     >
>>     > This is a reasonably full SQL compliant database that can compile
>>     > directly into your code so you don't have to ship anything
>>     except your
>>     > exe program.
>>     >
>>     > ElevateDB is the newer version of the old and trusted DBISAM
>>     database.
>>     > It can be set up as standalone database, LAN database, or
>>     > Client/Server database (Client Server requires distributing a 
>> small
>>     > program that runs on the server), all without recompiling your
>>     > program. Let the user decide their requirements.
>>     >
>>     > I hear that Firebird can also be compiled into your exe file for
>>     > single user programs.
>>     >
>>     > Steve
>>     >
>>     > On 03/07/07, Nick <nick at salehoo.com> wrote:
>>     > > Hi there :-)
>>     > > When I create a database application, usually I create a MDB
>>     file with
>>     > > Access (create my tables etc) and then interact with the
>>     database in
>>     > > Delphi using TAdoConnection and TAdoQuery.
>>     > >
>>     > > What other standalone database's can I use with Delphi2006 Ent
>>     which, I
>>     > > can ship to the customer without them having to install
>>     anything special.
>>     > >
>>     > > Just like to see what else is out there which simple to get 
>> up and
>>     > > running. (usually one of my databases contains 2-3 tables etc)
>>     > >
>>     > > Cheers
>>     > > Nick
>>     _______________________________________________
>>     NZ Borland Developers Group - Delphi mailing list
>>     Post: delphi at delphi.org.nz
>>     Admin: http://delphi.org.nz/mailman/listinfo/delphi
>>     Unsubscribe: send an email to delphi-request at delphi.org.nz with
>>     Subject: unsubscribe
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> NZ Borland Developers Group - Delphi mailing list
>> Post: delphi at delphi.org.nz
>> Admin: http://delphi.org.nz/mailman/listinfo/delphi
>> Unsubscribe: send an email to delphi-request at delphi.org.nz with 
>> Subject: unsubscribe
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with 
> Subject: unsubscribe
>