Dear All
Could someone please recommend a nice and well documented database program for a person who has never used a database?
Thanks in advance,
Paul
On Sun, 2006-01-29 at 16:37 +0000, Paul Smith wrote:
Dear All
Could someone please recommend a nice and well documented database program for a person who has never used a database?
Thanks in advance,
Paul
MySQL
Paul Smith wrote:
Dear All
Could someone please recommend a nice and well documented database program for a person who has never used a database?
(1) What are you trying to accomplish? (2) Are you looking for a database back end or a front end program for manipulating a database?
On Sun, 2006-01-29 at 10:37, Paul Smith wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
That's not much to go on when asking for a recommendation. The obvious choices on fedora will be MySQL and postgresql and between those, postgresql follows the sql standards more closely and has a less restrictive license. Mysql might be slightly faster if your usage is mostly read-only.
You'll also need client side tools. Perl/php/java are often used for web access and there are some generic frameworks available. Openoffice/base could be used for something more interactive.
On 1/29/06, Les Mikesell lesmikesell@gmail.com wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
That's not much to go on when asking for a recommendation. The obvious choices on fedora will be MySQL and postgresql and between those, postgresql follows the sql standards more closely and has a less restrictive license. Mysql might be slightly faster if your usage is mostly read-only.
You'll also need client side tools. Perl/php/java are often used for web access and there are some generic frameworks available. Openoffice/base could be used for something more interactive.
Thanks to all. I have tried OpenOffice Base, but it is slow. Postgresql seems to be nice. Is there some gui for it, i.e., for postgresql?
Paul
On Sun, Jan 29, 2006 at 17:33:52 +0000, Paul Smith phhs80@gmail.com wrote:
Thanks to all. I have tried OpenOffice Base, but it is slow. Postgresql seems to be nice. Is there some gui for it, i.e., for postgresql?
There is pgadmin. I think its focus is on doing administrative things, so it may not be as good for manipulating data as some other front ends.
You can find out more about pgadmin here: http://www.pgadmin.org/
For front ends for manipulating data you will have a lot more options, since those kinds of programs can typically talk to different database software. For postgres specific stuff you could look for projects at http://gborg.postgresql.org/ and http://pgfoundry.org/ .
On Sun, 2006-01-29 at 11:33, Paul Smith wrote:
On 1/29/06, Les Mikesell lesmikesell@gmail.com wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
That's not much to go on when asking for a recommendation. The obvious choices on fedora will be MySQL and postgresql and between those, postgresql follows the sql standards more closely and has a less restrictive license. Mysql might be slightly faster if your usage is mostly read-only.
You'll also need client side tools. Perl/php/java are often used for web access and there are some generic frameworks available. Openoffice/base could be used for something more interactive.
Thanks to all. I have tried OpenOffice Base, but it is slow. Postgresql seems to be nice. Is there some gui for it, i.e., for postgresql?
If you like base otherwise, you can use postgresql as the backend though odbc or this: http://dba.openoffice.org/drivers/postgresql/ Depending on what you are doing, it may be a good idea to design it so that you can access the tables through an assortment of tools.
Les Mikesell wrote:
On Sun, 2006-01-29 at 10:37, Paul Smith wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
That's not much to go on when asking for a recommendation. The obvious choices on fedora will be MySQL and postgresql and between those, postgresql follows the sql standards more closely and has a less restrictive license. Mysql might be slightly faster if your usage is mostly read-only.
MySQL being faster is than postgresql is mostly a myth. It may be true if you have very simple queries or very few connected users. In general Postgresql is significantly faster.
The MySQL is faster myth, goes back to the MySQL 3 days when that actually was the case, mostly because MySQL back then didn't support transactions, or referential integrety checks while Postgresql did. (MySQL still doesn't fully support referential integrety).
As an example, I created a table containg absolute paths to filenames in my filesystem, the file size and the md5 sum of the file. I then made a query to group the files by the md5 sum, and ordering these groups by file size. On my filesystem that took 12 minutes in postgresql 8.1, and over 16 hours using mysql 5.
To make it worse, MySQL doesn't have the richness in SQL that postgresql offers. This often makes queries to MySQL more clumsy. E.g. try do a relational division without using "exept".
Another factor in the choice between MySQL or Postgresql is the fact that Oracle have bought the innodb storage engine that is the main the one you need to use if you want to come even close to the feature set of postgresql does. In my mind, this creates some uncertainty for the future. It gives a competitor the means to shut down commersial licensing or raise the prices. That can never be good.
If I was to chose between Postgresql and another free database it would be between Postgresql and Firebird, where I would go for firebird for embedded solutions or when I needed to have databases that resided in just one file. Just like Postgresq, Firebird is very close to the sql standard, but it is not as feature rich as Postgresql
Regards Uno Engborg
On 1/30/06, Uno Engborg uno@webworks.se wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
That's not much to go on when asking for a recommendation. The obvious choices on fedora will be MySQL and postgresql and between those, postgresql follows the sql standards more closely and has a less restrictive license. Mysql might be slightly faster if your usage is mostly read-only.
MySQL being faster is than postgresql is mostly a myth. It may be true if you have very simple queries or very few connected users. In general Postgresql is significantly faster.
The MySQL is faster myth, goes back to the MySQL 3 days when that actually was the case, mostly because MySQL back then didn't support transactions, or referential integrety checks while Postgresql did. (MySQL still doesn't fully support referential integrety).
As an example, I created a table containg absolute paths to filenames in my filesystem, the file size and the md5 sum of the file. I then made a query to group the files by the md5 sum, and ordering these groups by file size. On my filesystem that took 12 minutes in postgresql 8.1, and over 16 hours using mysql 5.
To make it worse, MySQL doesn't have the richness in SQL that postgresql offers. This often makes queries to MySQL more clumsy. E.g. try do a relational division without using "exept".
Another factor in the choice between MySQL or Postgresql is the fact that Oracle have bought the innodb storage engine that is the main the one you need to use if you want to come even close to the feature set of postgresql does. In my mind, this creates some uncertainty for the future. It gives a competitor the means to shut down commersial licensing or raise the prices. That can never be good.
If I was to chose between Postgresql and another free database it would be between Postgresql and Firebird, where I would go for firebird for embedded solutions or when I needed to have databases that resided in just one file. Just like Postgresq, Firebird is very close to the sql standard, but it is not as feature rich as Postgresql
Thanks, Uno, for your very detailed explanation.
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Paul
Paul Smith kirjoitti viestissään (lähetysaika maanantai, 30. tammikuuta 2006 12:56):
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Rekall is in Fedora Extras http://www.rekallrevealed.org/
On 1/30/06, Markku Kolkka markkuk@tuubi.net wrote:
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Rekall is in Fedora Extras http://www.rekallrevealed.org/
Thanks, Markku, but as soon as I create a new table, rekall crashes!
Paul
Paul Smith wrote:
On 1/30/06, Markku Kolkka markkuk@tuubi.net wrote:
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Rekall is in Fedora Extras http://www.rekallrevealed.org/
Thanks, Markku, but as soon as I create a new table, rekall crashes!
Start rekall from the command line and see if you get any useful error messages as it crashes. If not try to run it from the command line with strace and see if you can get to the root of the problem.
Regards Uno Engborg.
Paul Smith wrote:
On 1/30/06, Markku Kolkka markkuk@tuubi.net wrote:
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Rekall is in Fedora Extras http://www.rekallrevealed.org/
Thanks, Markku, but as soon as I create a new table, rekall crashes!
Paul
Rekall crashes every time for me also. But I have recently salvaged fifteen years of my son-in-laws customer database with the aid of Navicat and MySql, both of which worked "out of the box." I would suggest that you look at a trial copy of Navicat as a front end.
BobG
On 1/30/06, bobgoodwin bobgoodwin@att.net wrote:
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Rekall is in Fedora Extras http://www.rekallrevealed.org/
Thanks, Markku, but as soon as I create a new table, rekall crashes!
Rekall crashes every time for me also. But I have recently salvaged fifteen years of my son-in-laws customer database with the aid of Navicat and MySql, both of which worked "out of the box." I would suggest that you look at a trial copy of Navicat as a front end.
From strace:
close(1022) = -1 EBADF (Bad file descriptor) close(1023) = -1 EBADF (Bad file descriptor) write(2, "KCrash: Application 'rekall' cra"..., 41KCrash: Application 'rekall' crashing... ) = 41 clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0xb7edc708) = 5613 alarm(0) = 2 waitpid(5613, NULL, 0) = 5613 --- SIGCHLD (Child exited) @ 0 (0) --- write(8, "\0", 1) = -1 EBADF (Bad file descriptor) sigreturn() = ? (mask now [SEGV]) exit_group(253)
Kexi does not update the result of queries if one changes elements of a table. A restart seems to be needed!
Navicat is commercial...
Well, I think I will use OpenOffice Base, until I learn Postgresql enough, although OOo Base is slow on my computer because it uses Java and my computer is 5 years old...
Paul
On Mon, 30 Jan 2006 17:47:40 +0000 Paul Smith phhs80@gmail.com wrote:
On 1/30/06, bobgoodwin bobgoodwin@att.net wrote:
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Rekall is in Fedora Extras http://www.rekallrevealed.org/
That sounds and looks interesting. Has anyone installed and tried rekall?? Just curious.
On Monday 30 January 2006 13:07, CodeHeads wrote:
On Mon, 30 Jan 2006 17:47:40 +0000
Paul Smith phhs80@gmail.com wrote:
On 1/30/06, bobgoodwin bobgoodwin@att.net wrote:
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Rekall is in Fedora Extras http://www.rekallrevealed.org/
That sounds and looks interesting. Has anyone installed and tried rekall?? Just curious.
There is also announcement by IBM earlier today that DB2 was being free'ed in a smaller scale version that won't tun on huge SMP machines as its only limitation.
I'm not a DB guru, but shouldn't that be at least looked at?
-- Best regards, ~WILL~ Public Key: 0xC8E166BB Key: http://code-heads.com/keys/ch1.asc Linux Registered User: 406084
Gene Heskett wrote:
On Monday 30 January 2006 13:07, CodeHeads wrote:
On Mon, 30 Jan 2006 17:47:40 +0000
Paul Smith phhs80@gmail.com wrote:
On 1/30/06, bobgoodwin bobgoodwin@att.net wrote:
> As desktop databases for Linux, I guess one can only find > OpenOffice Base and Kexi, is not it? > Rekall is in Fedora Extras http://www.rekallrevealed.org/
That sounds and looks interesting. Has anyone installed and tried rekall?? Just curious.
There is also announcement by IBM earlier today that DB2 was being free'ed in a smaller scale version that won't tun on huge SMP machines as its only limitation.
I'm not a DB guru, but shouldn't that be at least looked at?
I havn't got any info on this yet, but I would suspect that it is supposed to run on Red Hat Enterprise edition. Even though it may run on Fedora as well, chosing some free database that is well tested on that platform is probably a better option.
Regards Uno Engborg
Paul Smith wrote:
On 1/30/06, Uno Engborg uno@webworks.se wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
That's not much to go on when asking for a recommendation. The obvious choices on fedora will be MySQL and postgresql and between those, postgresql follows the sql standards more closely and has a less restrictive license. Mysql might be slightly faster if your usage is mostly read-only.
MySQL being faster is than postgresql is mostly a myth. It may be true if you have very simple queries or very few connected users. In general Postgresql is significantly faster.
The MySQL is faster myth, goes back to the MySQL 3 days when that actually was the case, mostly because MySQL back then didn't support transactions, or referential integrety checks while Postgresql did. (MySQL still doesn't fully support referential integrety).
As an example, I created a table containg absolute paths to filenames in my filesystem, the file size and the md5 sum of the file. I then made a query to group the files by the md5 sum, and ordering these groups by file size. On my filesystem that took 12 minutes in postgresql 8.1, and over 16 hours using mysql 5.
To make it worse, MySQL doesn't have the richness in SQL that postgresql offers. This often makes queries to MySQL more clumsy. E.g. try do a relational division without using "exept".
Another factor in the choice between MySQL or Postgresql is the fact that Oracle have bought the innodb storage engine that is the main the one you need to use if you want to come even close to the feature set of postgresql does. In my mind, this creates some uncertainty for the future. It gives a competitor the means to shut down commersial licensing or raise the prices. That can never be good.
If I was to chose between Postgresql and another free database it would be between Postgresql and Firebird, where I would go for firebird for embedded solutions or when I needed to have databases that resided in just one file. Just like Postgresq, Firebird is very close to the sql standard, but it is not as feature rich as Postgresql
Thanks, Uno, for your very detailed explanation.
As desktop databases for Linux, I guess one can only find OpenOffice Base and Kexi, is not it?
Paul
Is kexi a database in its own capacity? That was news to me. I thaught that it was used as frontend to other databases, much as you can use OpenOffice to connect to anything with ODBC or JDBC.
If you count desktop frontends, you could also check out Rekall http://www.thekompany.com/products/rekall/
If you are looking for an Access replacement, Firebird combined with OpenOffice Base, Kexi, Rekall might do it. Just like in Access, a in Firebird a database is just one file that you can store anywhere you like in the file system (the Firebird engine must still be installed though).
Using Postgresql, would be more comparable to MS-SQLServer. Unless you really don't need the one file feature of Firebird, I would suggest you go for postgresql, as it has much better free documentation, and better support in free other free software applications.
Regards Uno Engborg
On Monday 30 Jan 2006 12:43, Uno Engborg wrote:
If you are looking for an Access replacement, Firebird combined with OpenOffice Base, Kexi, Rekall might do it. Just like in Access, a in Firebird a database is just one file that you can store anywhere you like in the file system (the Firebird engine must still be installed though).
The new database model in OpenOffice2 looks to me to be the nearest thing to an Access replacement. What's more, it can read existing tables in many formats, and use them relationally. I've only looked briefly, but it looked promising to me.
Anne
Anne Wilson wrote:
On Monday 30 Jan 2006 12:43, Uno Engborg wrote:
If you are looking for an Access replacement, Firebird combined with OpenOffice Base, Kexi, Rekall might do it. Just like in Access, a in Firebird a database is just one file that you can store anywhere you like in the file system (the Firebird engine must still be installed though).
The new database model in OpenOffice2 looks to me to be the nearest thing to an Access replacement. What's more, it can read existing tables in many formats, and use them relationally. I've only looked briefly, but it looked promising to me.
Anne
The problem is that it tend to get slow, for large datasets. It is therefore usually better to just use it as a frontend to other databases.
Regards Uno Engborg
On Monday 30 Jan 2006 13:21, Uno Engborg wrote:
Anne Wilson wrote:
The problem is that it tend to get slow, for large datasets. It is therefore usually better to just use it as a frontend to other databases.
I would think that it was quite unsuitable for large datasets - I'm not surprised that you confirm that. I was thinking more of personal databases - addresses, record-collections, and so on. Quite a different requirement ;-) For large datasets I would agree with earlier posters - you need something much more powerful, mySQL or postgreSQL
Anne
On Sun, 29 Jan 2006 16:37:30 +0000 Paul Smith phhs80@gmail.com opined:
Dear All
Could someone please recommend a nice and well documented database program for a person who has never used a database?
Thanks in advance,
Paul
You haven't stated your goals. There are two parts.
A. I find the simplest and fastest DB to be MySQL.
B. There are only four or five PHP functions that you need to learn to create browser based queries. It is surprisingly simple. Do one and you have a template that you can use over and over again.
On Sun, 2006-01-29 at 13:12, David Cary Hart wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
Thanks in advance,
You haven't stated your goals. There are two parts.
A. I find the simplest and fastest DB to be MySQL.
Those are pretty short-term and limited goals. I'd guess finding one that handles standard sql and had the least restrictive license might be more important.
B. There are only four or five PHP functions that you need to learn to create browser based queries. It is surprisingly simple. Do one and you have a template that you can use over and over again.
Likewise, if you use php you are fairly restricted in what you can do. Perl would be a more general interface.
On 1/29/06, David Cary Hart Fedora@tqmcube.com wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
You haven't stated your goals. There are two parts.
A. I find the simplest and fastest DB to be MySQL.
B. There are only four or five PHP functions that you need to learn to create browser based queries. It is surprisingly simple. Do one and you have a template that you can use over and over again.
I only want a database for managing my own data, and I do not intend to access it from Internet.
Meanwhile, I learned that Kexi also has the driver for postgresql. Kexi seems quite fast, but the version on extras repositories is rather old.
Postgresql still not working:
$ createdb mydb createdb: could not connect to database postgres: FATAL: role "psmith" does not exist [psmith@localhost Desktop]$
Any ideas?
Paul
Am Sonntag, den 29.01.2006, 19:41 +0000 schrieb Paul Smith:
Postgresql still not working:
$ createdb mydb createdb: could not connect to database postgres: FATAL: role "psmith" does not exist [psmith@localhost Desktop]$
Any ideas?
Paul
[root]# su - postgres
Did you any configuration on the server yet?
On 1/29/06, Thomas Springer th.springer@gmx.net wrote:
Postgresql still not working:
$ createdb mydb createdb: could not connect to database postgres: FATAL: role "psmith" does not exist [psmith@localhost Desktop]$
Any ideas?
[root]# su - postgres
Did you any configuration on the server yet?
Thanks, Thomas.
$ postgres postgres does not know where to find the server configuration file. You must specify the --config-file or -D invocation option or set the PGDATA environment variable. $
I guess I have not configured the server. How can I do that? Or where can I find appropriate documentation?
Paul
Am Sonntag, den 29.01.2006, 20:20 +0000 schrieb Paul Smith:
$ postgres postgres does not know where to find the server configuration file. You must specify the --config-file or -D invocation option or set the PGDATA environment variable. $
I guess I have not configured the server. How can I do that? Or where can I find appropriate documentation?
Paul
You asked for a well documented dbms, right?
http://www.postgresql.org/docs/8.0/interactive/index.html
What RPMs have you installed? Did you use yum and fc-repos?
To start|stop the backend as root: # service postgresql start|stop Start|Stop when booting in runlevel 5: # chkconfig --level 5 postgresql on|off To start as postgres % export PGDATA=/var/lib/pgsql/data % pg_ctl start 1> /var/lib/pgsql/postmaster.log 2>&1 & In homedir of postgres you will find a logfile from the initdb. Have a look, it tells you how to start To stop as postgres % pg_ctl stop -w See pg_ctl --help To connect to backend there is a nice command: % psql template1 See psql --help
HTH Thomas
On 1/29/06, Thomas Springer th.springer@gmx.net wrote:
$ postgres postgres does not know where to find the server configuration file. You must specify the --config-file or -D invocation option or set the PGDATA environment variable. $
I guess I have not configured the server. How can I do that? Or where can I find appropriate documentation?
You asked for a well documented dbms, right?
http://www.postgresql.org/docs/8.0/interactive/index.html
What RPMs have you installed? Did you use yum and fc-repos?
To start|stop the backend as root: # service postgresql start|stop Start|Stop when booting in runlevel 5: # chkconfig --level 5 postgresql on|off To start as postgres % export PGDATA=/var/lib/pgsql/data % pg_ctl start 1> /var/lib/pgsql/postmaster.log 2>&1 & In homedir of postgres you will find a logfile from the initdb. Have a look, it tells you how to start To stop as postgres % pg_ctl stop -w See pg_ctl --help To connect to backend there is a nice command: % psql template1 See psql --help
Thanks, Thomas.
Paul
Paul Smith wrote:
On 1/29/06, Thomas Springer th.springer@gmx.net wrote:
$ postgres postgres does not know where to find the server configuration file. You must specify the --config-file or -D invocation option or set the PGDATA environment variable. $
I guess I have not configured the server. How can I do that? Or where can I find appropriate documentation?
You asked for a well documented dbms, right?
http://www.postgresql.org/docs/8.0/interactive/index.html
What RPMs have you installed? Did you use yum and fc-repos?
To start|stop the backend as root: # service postgresql start|stop Start|Stop when booting in runlevel 5: # chkconfig --level 5 postgresql on|off To start as postgres % export PGDATA=/var/lib/pgsql/data % pg_ctl start 1> /var/lib/pgsql/postmaster.log 2>&1 & In homedir of postgres you will find a logfile from the initdb. Have a look, it tells you how to start To stop as postgres % pg_ctl stop -w See pg_ctl --help To connect to backend there is a nice command: % psql template1 See psql --help
Thanks, Thomas.
Paul
Note that the database "template1" is the database that is used as templates when you create other databases in the future. So, only add things that all your databases should have. This is a good place to install languages for stored procedures.
Regards Uno Engborg
Paul Smith wrote:
On 1/29/06, David Cary Hart Fedora@tqmcube.com wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
You haven't stated your goals. There are two parts.
A. I find the simplest and fastest DB to be MySQL.
B. There are only four or five PHP functions that you need to learn to create browser based queries. It is surprisingly simple. Do one and you have a template that you can use over and over again.
I only want a database for managing my own data, and I do not intend to access it from Internet.
Meanwhile, I learned that Kexi also has the driver for postgresql. Kexi seems quite fast, but the version on extras repositories is rather old.
Postgresql still not working:
$ createdb mydb createdb: could not connect to database postgres: FATAL: role "psmith" does not exist [psmith@localhost Desktop]$
Any ideas?
Paul
I assume that you are logged in as psmith when you get that error. Postgresql have its own user/role names, but guesses that there is a user named psmith, as this is your Linux login. If you haven't created the user psmith in the database engine as well, you get the error above.
To fix it: log in as root su - postgres createuser psmith
Then create the database using: createdb -O psmith mydb
If that doesn't work make sure that postgres is running by doing /etc/init.d/postgresql status if not run /etc/init.d/postgresql start to start it. Then try again.
You should also check out your $PGDATA/pg_hba.conf to make sure that the database is accessible from the right places, and by the right users.
Regards Uno Engborg
On Sun, 29 Jan 2006 19:41:36 +0000 Paul Smith phhs80@gmail.com opined:
On 1/29/06, David Cary Hart Fedora@tqmcube.com wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
You haven't stated your goals. There are two parts.
A. I find the simplest and fastest DB to be MySQL.
B. There are only four or five PHP functions that you need to learn to create browser based queries. It is surprisingly simple. Do one and you have a template that you can use over and over again.
I only want a database for managing my own data, and I do not intend to access it from Internet.
Correct. But if you put the database on a machine running httpd, you can manage the database, run reports, etc. from your web browser. I find this approach much faster and simpler than installing a front end like rek
A very good stock program to get you started is phpmyadmin.
Meanwhile, I learned that Kexi also has the driver for postgresql. Kexi seems quite fast, but the version on extras repositories is rather old.
Postgresql still not working:
$ createdb mydb createdb: could not connect to database postgres: FATAL: role "psmith" does not exist [psmith@localhost Desktop]$
Any ideas?
Paul
David Cary Hart wrote:
On Sun, 29 Jan 2006 19:41:36 +0000 Paul Smith phhs80@gmail.com opined:
On 1/29/06, David Cary Hart Fedora@tqmcube.com wrote:
Could someone please recommend a nice and well documented database program for a person who has never used a database?
You haven't stated your goals. There are two parts.
A. I find the simplest and fastest DB to be MySQL.
B. There are only four or five PHP functions that you need to learn to create browser based queries. It is surprisingly simple. Do one and you have a template that you can use over and over again.
I only want a database for managing my own data, and I do not intend to access it from Internet.
Correct. But if you put the database on a machine running httpd, you can manage the database, run reports, etc. from your web browser. I find this approach much faster and simpler than installing a front end like rek
A very good stock program to get you started is phpmyadmin.
There is a similar application for Postgresql, phpPgAdmin. You can run a demo at: http://phppgadmin.sourceforge.net/?page=demo Even if you don't intend to web enable your database this also gives you an opportunity to check out Postgresql without installing it.
Regards Uno Engborg
On 1/30/06, Uno Engborg uno@webworks.se wrote:
A very good stock program to get you started is phpmyadmin.
There is a similar application for Postgresql, phpPgAdmin. You can run a demo at: http://phppgadmin.sourceforge.net/?page=demo Even if you don't intend to web enable your database this also gives you an opportunity to check out Postgresql without installing it.
Thanks a lot, Uno. That is quite useful, specially for a beginner with databases like me.
Paul
Paul Smith wrote:
Dear All
Could someone please recommend a nice and well documented database program for a person who has never used a database?
I was browsing IBM's selection last evening. DB2 is the RDBMS if you're serious about performance. Free to developers. There's Informix, probably free to developers, I didn't check. Cloudscape, avaiilable as Derby from the Apache project. Cloudscape is for imbedding in applications, and may work well with OOo.
There's Interbase (maybe renamed) from Borland, got open-sourced a few years ago, and Ingres from CA.
And of course, mySQL (more of a file manager, really) and Postgresql that both ship with most popular Linux distros.
Oh, and there's my old favourite from the early 80s, Adabas (originally from .de) that I think now ships from mysql.com under the moniker MaxDB. Adabas-D was shipped by Star Division as part of (some) StarOffice commercial offerings. It may well still work with OOo better than any other.
On Sun, 2006-01-29 at 16:37 +0000, Paul Smith wrote:
Dear All
Could someone please recommend a nice and well documented database program for a person who has never used a database?
Thanks in advance,
Paul
There is also sqlite. It is for very simple databases and I think there are not many tools for it if at all.
A couple of applications make use of it though.