hi
is there any dbms (relational) which is available for free & for
windows/linux. my other constraints is that the dbms should support
sql-99 & it should fit on 1 cd. i know about oracle 9i windows
personal edition but it takes 3 cds. how about mysqlplus, db2 & sql
server (these are the names i know). are they available for free
download ? if yes, tell me their url. do you know of any relational
dbms from other good companies like oracle, ibm, microsoft. how's
sybase ?
thx

On May 27, 4:33 pm, punit arya <arya.pu... (AT) gmail (DOT) com> wrote:
hey.. its me again.. i got some free dbms by browsing thru this
group's articles. thx anyway

punit arya <arya.punit (AT) gmail (DOT) com> wrote:

the download sizes. The list is of free and freely distributable
databases (plus some open source Java DBs which are probably not
relevant here). If the database is for personal use then you can count
yourself as a developer and use the enterprise versions of DB2 or
Oracle at no charge.

On 27.05.2007 13:33 punit arya wrote:
PostgreSQL, http://www.postgresql.org fits easily on a CD (16MB
download) and can very well compete with Oracle and all the others.

I don't know though, how complete the SQL-99 implementation is. But
between the open source DBMS my experience was, that Postgres was always
closest to the standard.

Thomas

On May 29, 11:20 am, Thomas Kellerer <JUAXQOSZF... (AT) spammotel (DOT) com>
wrote:
I downloaded postgresql. the zipped installer was small enough & I
installed that on my windows xp partition. It's working fine. some of
my grudges:
the window in which we type & execute sql queries runs from dos. I
expected an independent window. still thats fine for a free dbms.
not enough documentation on installation & post installation
configuration. that was a lot of bother & tough too (it took me two
nights in a row to configure it satisfactorily).

Thanks anyway.

PS: I'm hooked to firebird v2. Its really nice & comes with adequate
documentation.

On May 27, 9:12 pm, David Segall <d... (AT) address (DOT) invalid> wrote:
I got to your link above. It was really helpful. I got to know
firebird (the dbms I've become hooked to now) from your page only.
Many many thanks.

On 29.05.2007 10:11 punit arya wrote:
First: it does *not* run from "DOS". DOS is an ancient operating system
and is no longer supported nor will any of the Postgres tools run "from
dos". Those are full blown win32 (console) applications)

SQL tool which can be used for batch processing and other tasks). In
Firebird it is called isql.exe and in Postgres it is called psql.exe

If you are looking for a graphical administration tool try PGAdmin III
(see http://www.postgresql.org/download/)


Did you check out
http://www.postgresql.org/docs/8.2/static/index.html
http://www.postgresql.org/docs/faqs.FAQ_windows.html
http://pgfoundry.org/projects/pginstaller

And then there is additional information here:
http://www.postgresql.org/docs/techdocs

Firebird you need to collect PDFs from various sources and there is no
single document describing the current SQL syntax completely. If you try
to find the syntax for something that you don't know when it was added,
you first need to read the old Interbase docs, then the release notes
for 1.0, then for 1.0.2, then for 1.0.3 then for 1.5, then for 1.5.1,
then for 1.5.2, then for 1.5.3, thenfor 1.5.4 and the the release notes
for 2.0. Not something I'd call "adequate". With postgres you have the
complete description in one document for each release.

But I agree Firebird is a nice DBMS (if it wasn't for the
documentation). I do find it strange though that you can only change
user passwords with a commandline tool running on the server, you cannot
change a user password from a client machine and only the first 8
character of a password are checked.

Thomas

On 29.05.2007 10:11 punit arya wrote:
Btw: Postgres has an excellent mailing list which is mirrored on a
newsgroup server, so you can read it with your favorite newsreader

Check out
http://www.postgresql.org/community/lists/

In adddition to the news server mentioned there, the lists are also
available on news.gmane.org with a kind of "automatic" registration.
The first time you post to a list on gmane.org you will receive a
confirmation message, once you reply to that message you can post to
that list without further ado.

Thomas

On May 29, 1:31 pm, Thomas Kellerer <JUAXQOSZF... (AT) spammotel (DOT) com>
wrote:
Hi Thomas

I know that postgresql is a lot more famous than firebird. Although
the zip installer that I downloaded from the postgresql site (which
was for personal use) did not have a seperate application that lets
you enter SQL queries in a seperate windows. I did rummaged through
PGAdminIII, I found it very nice, helpful to get server status, & the
databases & tables. It also had a (quite hidden) facility that lets
you enter SQL queries, this interface wasn't as powerful as a regular
command line prompt specialised application. I also tried the
firebird's isql.exe tool. It was good enough for my needs. That's what
I use when I have to work on databases on my windows system.

Regarding the links that point to postgresql, I must have missed them.
I'll be more careful in the future. Thanks for pointing those out.

Also I didnt realise that I needed to go through the docs of earlier
versions & of InterBase. I found the docs for latest version
sufficient enough for my needs.

After all this, I think that IBM's DB2 would be the best choice (on
windows) for high level needs than just basic SQL exploration because
of brand reputation & the contest on databases they organise every
year here in India. I ordered it free from IBM site & they said
overseas delivery takes around 4-6 weeks.

Meantime, to fulfill my SQL needs, I have also done a little bit
exploration of MySQL on Linux. Guess, I'll stick to Firebird (because
of its simplicity) on Windows until DB2 comes & MySQL on Linux.

Thanks Thomas.

On May 29, 1:37 pm, Thomas Kellerer <JUAXQOSZF... (AT) spammotel (DOT) com>
wrote:
once.
databases as your profession ?