Hello

I am writing an application that will require database access. This
application will be deployed onto users machines, often using portable
equipment such as laptops.

Before I can begin writing the application I need to research the
available databases on the market and produce a report. Things I
require are:

- A list of the leading database providers. Access, SQLite, Oracle
etc. (Lite versions where available is going to be more desireable)

- A pointer to the direction of any independant reviews, comparisons
etc.

And any other general pointers in the right direction.

Thank You in advance

Delt

"Delt" <jamie_r_wallace (AT) yahoo (DOT) co.uk> wrote:

1) Google is your friend.

2) The term is "database management system". A database is the
data. The program to manipulate the data is a DBMS.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Gene Wirchenko wrote:
One good DBMS is PostgreSQL.

GIYF.

GIYRRGF.

A friend in need is a friend indeed.

-- Lew

When you say 'deployed onto users machines', do you mean that each
deployment will be running it's own database or do you mean that an
application will be deployed that will connect to a central database
server remotely? This is important in determining which DB you choose.

And I agree with Gene, Google certainly is your friend...
-T
On Mar 8, 9:37 am, "Delt" <jamie_r_wall... (AT) yahoo (DOT) co.uk> wrote:

On 9 Mar, 14:00, "yiata" <tri.tru... (AT) gmail (DOT) com> wrote:
Hi guys and thank you for your help so far.

Each deployment will be running its own database, stored on the same
machine.

So far I have looked at SQLite, Oracle Database 10g XE and PostgreSQL
(thanks for that one Lew).

Thanks

Delt

On 3/9/2007 at 7:45 AM, in message
<1173451552.286458.4120 (AT) c51g2000cwc (DOT) googlegroups.com>,
Delt<jamie_r_wallace (AT) yahoo (DOT) co.uk> wrote:
In the vein(?) of Oracle XE, there's also IBM's DB2 Express-C:
http://www-306.ibm.com/software/data/db2/express/

Frank

--

„„„ ÌFrank SwarbrickÌSenior Developer/Analyst „ Mainframe
ApplicationsÌFirstBank Data Corporation „ Lakewood, CO USA

Frank Swarbrick wrote:
<http://en.wiktionary.org/wiki/vein>
vein:
"6. A topic of discussion.
7. A style, tendency, or quality of something."

-- Lew

"Delt" <jamie_r_wallace (AT) yahoo (DOT) co.uk> wrote:

believe to be a complete list of free and freely deployable "heavy
duty" databases at <http://database.profectus.com.au>. They are all
client server databases and, although you can install the server on
each user's machine it is unlikely to be worth it. You won't use all
the extra facilities these databases provide and you will be turning
all your users into data base administrators. In addition they require
large quantities of memory.

The same web page contains a complete list of open source databases
that can be embedded into a Java program. That is, the database code
is a subroutine of, and shipped with, your application. SQLite is a
similar database for C programs.

If you decide to use an embedded database I suggest you post again
specifying your price range, programming language and the facilities
you might need such as stored procedures or triggers. Other things to
consider are whether it can be a server while running in your program
which allows you to look at the data while debugging your program, if
it has an ODBC or JDBC driver so you can use Access or Open Office to
create, populate and test you database, and whether you can keep the
data in memory if you need the extra speed.

On 10 Mar, 06:51, David Segall <d... (AT) address (DOT) invalid> wrote:
Hi Guys

Thank you again for your help. All is finished now. Just as a note I
included in the list MySQL, SQLite, PostgreSQL, IBMs DB2 and Oracle
10g XE.

Delt

"Delt" <jamie_r_wallace (AT) yahoo (DOT) co.uk> wrote: