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" <[EMAIL PROTECTED]>
To: "NZ Borland Developers Group - Delphi List"
<[email protected]>
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with
Subject: unsubscribe
------------------------------------------------------------------------
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with
Subject: unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with
Subject: unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
