Board index » delphi » Re: which embedded database to use?

Jim Wine

Delphi Developer
 

Re: which embedded database to use?


2005-04-20 10:05:27 PM
delphi23
The best solution for this scenario is DBSIAM (www.elevatesoft.com). The
enigine is very fast and written in Delphi. You don't need a separate
DB-Server executable as the engine itself can be linked into your
application. So you will get an single exe with a full SQL-DB build in. For
your needs the absolutly best choise.
Regards
"Bryce K. Nielsen" <XXXX@XXXXX.COM>schrieb im Newsbeitrag
Quote
Working on a new app that needs a database, however the majority of the
users will be non-computer-savvy users, so any DB-Management would need to
be built into the application and run behind the scenes. I was thinking
about using Firebird for this, but it is been a while since I have looked at
non-Oracle/MS SQL servers out there. What other DBs do you recommend for
something like this? For the most part, they will be single users with 0
DBAdmin skills, though there is a potential for multi-users however these
would probably have a DBAdmin of some sort.

-BKN

 
 
Ed Dressel

Delphi Developer

2005-04-20 10:13:48 PM

Re: which embedded database to use?

Quote
I didn't think you could "embed" Firebird. I was under the impression it
had to be it is own install/managed app. I have only used IB 6 (right when it
went opensource) and even then only in limited fashion. It seemed to be a
good choice, but wasn't sure if other good ones have presented themselves,
and I wasn't sure how to do an "embedded" version.
you are going to like this<g>---I just install one DLL into my app directory
(unless it is a 9x machine, in which case there may be a problem with some
MS DLLs versioning problems and then I install 2 other DLLs into my app
directory). AFAICR everything but security works with this. it is actually
*very* nice.
Ed Dressel
 
K. Sallee

Delphi Developer

2005-04-20 10:15:37 PM

Re: which embedded database to use?

Quote
FreeIB DB Components
And JvUIB (comes with JEDI) and Zeos components
Quote
and Marathon IDE
IBExpert has a personal edition.
Kevin
--
Software for resource managers and researchers
www.ecostats.com
 

Ralf Mimoun

Delphi Developer

2005-04-20 10:28:48 PM

Re: which embedded database to use?

Marc Scheuner writes:
...
Quote
I would give the nod to NexusDB for yet another reason: support for a
native ADO.NET provider. So if you fancy doing any kind of .NET
oriented work, you can access it no problem from C# or Delphi.NET -
DBISAM is lacking such a feature (and it doesn't seem to be high on
their list of priorities, either).
Not really true. Take a look at the ADO.Net provider from Context Software
(www.contextsoft.com/). And about Elevate Software priorities: they
are finising the .Net version of DBISAM. So, it is not only very high on
their priority list, it is their current project. And there will be a native
ADO.Net provider from Elevate Software in the near future.
Ralf
 
Ralf Mimoun

Delphi Developer

2005-04-20 10:32:42 PM

Re: which embedded database to use?

Lauchlan M writes:
...
Quote
Let's see, we are talking about embedded apps here so I would drop:

nxQuery
nxDatabase
nxSession
nxServerEngine
nxSQLEngine

That makes 5 for me.
But you need the database, session, engine and SQL engine component only
once eg. in a data module, not on every form. I don't know NexusDB, but in
DBISAM, you can work with the query component alone. You just have to set
the directory as database. And there are default objects for session,
database and engine, so you can use then and set the properties (eg. for
C/S) in the source code.
...
Quote
But even so, dropping four components on a data module once per
project would not be so big a deal to me.
Exactly. I don't cry that I can not connect a TDBEdit directly to a TDataset,
and a clean structure and hierarchy can only help.
Ralf
 
Eric Schreiber

Delphi Developer

2005-04-20 10:51:11 PM

Re: which embedded database to use?

Captain Jake writes:
Quote
the earth is wobbling so badly that there are now 53
seasons a year.
Except here in the Chicago area, where, as you know, we still only have
the two seasons - flipping cold and stinking hot.
 
Johnnie Norsworthy

Delphi Developer

2005-04-20 11:14:42 PM

Re: which embedded database to use?

"Captain Jake" <jake[nospam]@jsnewsreader.com>writes
Quote
>www.delphi32.com/magazine/articles/20/1/
That's a rather unfortunate article, not to mention outright wrong in
parts.
For example, it says that to set up a simple query in NexusDB you need to
drop 5 components on a form. That is not even close to being true.
Maybe they mean a:
Memo - to type the query
Button - to start the query
Query - database component
DataGrid - to display the results
Label - for your copyright notice
<g>
Yes, that article is as bogus as you can get. Every once in a while it will
be referenced by someone on Elevate's (DBISAM) newsgroups who actually
thinks it is legitimate.
 
Fikret Hasovic

Delphi Developer

2005-04-20 11:31:52 PM

Re: which embedded database to use?

Firebird. Embedded works great! And you can put it into your exe, so
you'll need to distribute only your app exe and db files...
--
Best regards
Fikret Hasovic fikret.fbtalk.net
USAID TAMP Senior Programmer
* FirebirdSQL Foundation member.
- Join today at www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
jedivcs.sourceforge.net/
* Firebird and Fyracle news
www.fyracle.org
Posted with XanaNews 1.17.3.1
 
Nick Hodges [TeamB]

Delphi Developer

2005-04-20 11:48:43 PM

Re: which embedded database to use?

Eric Schreiber writes:
Quote

Except here in the Chicago area, where, as you know, we still only
have the two seasons - flipping cold and stinking hot.
There are only two season here in Minnesota, too: Winter and
RoadConstruction.
--
Nick Hodges -- TeamB
Lemanix Corporation -- www.lemanix.com
Read my Blog -- www.lemanix.com/nick
 
Wayne Niddery [TeamB]

Delphi Developer

2005-04-21 02:13:14 AM

Re: which embedded database to use?

Lauchlan M writes:
Quote

- it is c/s.

- No it isn't really c/s, it is a file server.

- What do you mean eactly by c/s, file server, etc?
The difference is very simple:
- Do applications talk to *another process* (the database server) to
retrieve / update data? Yes = C/S.
- or does the application directly (embedded code or via DLL) read and
write to the database files? Yes = file server.
If it allows both modes, that is fine, many products do, but only when set up
as a separate process is it C/S.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
"The two most abundant elements in the universe are hydrogen and
stupidity." - Harlan Ellison
 
J. Lee

Delphi Developer

2005-04-21 03:03:15 AM

Re: which embedded database to use?

I use DBISAM in all my apps/ISAPI dlls/CGIs:
*embedded
*componentized server lets you easily create your own DB server quickly, or
just use the server shipped with the product
*very easy administration and setup
*you can either use C/S or shared file mode (the same app can even switch
between the two)
*buy once, distribute freely (royalty free)
*fast and compact, but secure with secure connections and encryption
*the ABSOLUTE BEST support you will ever receive in any product
But don't take my word for it: Best Database Engine 2002, Best Database
Engine 2003, Best Database Engine 2004
Delphi Informant Magazine
go to www.elevatesoft.com and download a free trial
~J. Lee
"Bryce K. Nielsen" <XXXX@XXXXX.COM>writes
Quote
Working on a new app that needs a database, however the majority of the
users will be non-computer-savvy users, so any DB-Management would need to
be built into the application and run behind the scenes. I was thinking
about using Firebird for this, but it is been a while since I have looked at
non-Oracle/MS SQL servers out there. What other DBs do you recommend for
something like this? For the most part, they will be single users with 0
DBAdmin skills, though there is a potential for multi-users however these
would probably have a DBAdmin of some sort.

-BKN

 
J. Lee

Delphi Developer

2005-04-21 04:11:39 AM

Re: which embedded database to use?

Bryce,
Also, DBISAM has a native linux server that can serve up the same data files
as the Windows version.
Last time I checked, NexusDB did not have this and was not ever intending to
have it.
~J. Lee
Quote
>I would give the nod to NexusDB for yet another reason: support for a
 >native ADO.NET provider. So if you fancy doing any kind of .NET
 >oriented work, you can access it no problem from C# or Delphi.NET -
 >DBISAM is lacking such a feature (and it doesn't seem to be high on
 >their list of priorities, either).
Not really true. Take a look at the ADO.Net provider from Context Software
(www.contextsoft.com/). And about Elevate Software priorities: they
are finising the .Net version of DBISAM. So, it is not only very high on
their priority list, it is their current project. And there will be a
native ADO.Net provider from Elevate Software in the near future.
 
Hannes Danzl[NDD]

Delphi Developer

2005-04-21 05:22:26 AM

Re: which embedded database to use?

Quote
Looks like it.
Still I am very satisfied with "Absolute".
please don't get my message above wrong: i don't (and never did) say
that absolute is not a good solution or in anyways involved with that
article. We really don't want to fight with our competitors on any
other level than quality and pricing ;)
--
Hannes Danzl [NexusDB Developer]
Newsgroup archive at www.tamaracka.com/search.htm
 
Lauchlan M

Delphi Developer

2005-04-21 08:33:30 AM

Re: which embedded database to use?

Quote
>- What do you mean eactly by c/s, file server, etc?
The difference is very simple:
- Do applications talk to *another process* (the database server) to
retrieve / update data? Yes = C/S.
- or does the application directly (embedded code or via DLL) read and
write to the database files? Yes = file server.

If it allows both modes, that is fine, many products do, but only when set
up
as a separate process is it C/S.
Thanks Wayne.
I was aware of this distinction, I was just pointing out that there had been
some (heated) discussion about whether dbisam was really c/s, and it looked
like this conversation was heading in that direction.
Apparently it wasn't though.
And for the record I have no position on whether dbisam is c/s or f/s - I
am not familiar enough with it to say.
Lauchlan M
 
Lauchlan M

Delphi Developer

2005-04-21 08:36:21 AM

Re: which embedded database to use?

Quote
I don't know NexusDB, but in
DBISAM, you can work with the query component alone. You just have to set
the directory as database. And there are default objects for session,
database and engine, so you can use then and set the properties (eg. for
C/S) in the source code.
I think in nxdb you need to drop the various components.
Maybe you could link certain units in to achieve the same effect and set
their properties in code, but surely it would be easier just to drop the
components.
Lauchlan M