On Thu, 2004-03-18 at 20:31, Dan Coutu wrote:
> I've created new users and granted them specific access to certain
> tables in a database via standard SQL. Seems pretty straightforward
> to me. No file was necessary. Isn't that what you were expecting?
That certainly sounds better than what we ha
On Thu, 2004-03-18 at 09:07, Cole Tuininga wrote:
> On Wed, 2004-03-17 at 16:13, Dan Coutu wrote:
> > Some of the really nice features of PostgreSQL are:
>
> *snip*
>
> We've been considering taking another look at postgresql. There was two
> things that were rather lacking last time we looked a
Dan Coutu wrote:
Interesting! I had not heard that they were planning to support triggers too.
Thanks for pointing that out.
Interesting to me too...I had not been following the goings on with
MySQL too closely although I've been using it for a long time. Keep in
mind that the MySQL v. 5.0
On Wed, 2004-03-17 at 16:13, Dan Coutu wrote:
> Some of the really nice features of PostgreSQL are:
*snip*
We've been considering taking another look at postgresql. There was two
things that were rather lacking last time we looked at it and I was
wondering if you had any take on it:
1) Realtime
On Wed, 2004-03-17 at 16:46, Travis Roy wrote:
> > - You can define triggers (MySQL can't do this).
>
> From: http://www.mysql.com/products/mysql/
>
> "Stored procedures and triggers
>
> Stored procedures allow you to create functions and subroutines
> that run on the server. This makes it
- You can define triggers (MySQL can't do this).
From: http://www.mysql.com/products/mysql/
"Stored procedures and triggers
Stored procedures allow you to create functions and subroutines
that run on the server. This makes it possible to grant access to
specific queries without granting car
> Ted Roche writes:
>
> > I would welcome experiences and opinions (like I have to ask!) on the
> > various database backends available.
I've used both MySQL and PostgreSQL extensively. My take on them is that
if you need something lightweight and fast to implement that non-DBA
types can handle t
Thanks, Kevin. I am looking for something a bit more complex, and I probably
should have explained that.
I develop business applications involving dozens to hundreds of tables of
data, and I'm looking to move some of these applications to a F/OSS backend
from ISAM tables and/or Oracle/SQL Server b
