On 6/06/2011 8:59, Thomas Guettler wrote:
Hi,
how do you store recurring events in a database?
Selecting all events in a week/month should be fast (comming from an index).
My solution looks like this:
Table event:
Columns: id, name, recurring, start_datetime, end_datetime
recurring is
What settings would you recommend for using postgres in an enterprise
application together with jboss?
there are numerous auth options (from the documentation):
19.3.1. Trust
authenticationhttp://www.postgresql.org/docs/8.4/interactive/auth-methods.html#AUTH-TRUST
19.3.2. Password
On 06/08/11 12:18 AM, eyal edri wrote:
currently i've chosen MD5 as the auth, but is that the best option?
thats the usual choice for JDBC apps.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing
On 8/06/2011 3:18 PM, eyal edri wrote:
What settings would you recommend for using postgres in an enterprise
application together with jboss?
Most such applications have the database servers on an isolated network
only accessible to the app server, not to the wider world. In these
cases
On Wed, 8 Jun 2011 10:18:23 +0300, eyal edri wrote:
What settings would you recommend for using postgres in an enterprise
application together with jboss?
there are numerous auth options (from the documentation):
19.3.1. Trust authentication [1]19.3.2. Password authentication [2]
19.3.3.
On 07/06/2011 23.52, Tom Lane wrote:
Very fast on a very narrow set of use cases ...
Can you explain a little (if possible)?
Thank you
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
hello
i have a lot of files in microsoft word format. each file consists of text
and images (other text formatting like font is not important).
i want to store this documents in Postgresql, and documents must display on
web page when corresponding user requests occurs.
it seems theres 2 way to do
On Mon, Jun 06, 2011 at 12:59:44PM +0200, Thomas Guettler wrote:
how do you store recurring events in a database?
Check this:
http://www.justatheory.com/computers/databases/postgresql/recurring_events.html
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid
Hi Radoslaw,
On Wed, 08 Jun 2011 07:30:33 +0200, Radosław Smogura
rsmog...@softperience.eu wrote:
But, I think GreenPlum is share nothing, isn't it?
Yes, indeed. In very simple words Greenplum is a parallel processing
database solution that implements the shared-nothing architecture. One
Hi everyone,
We've just moved our website database from pg 8.4 to pg 9.0 and we found
out a very long query (that wasn't that long under 8.4).
And I actually can't explain why it's taking so much timeŠ
Here it is :
EXPLAIN ANALYZE SELECT articles_article.id,
articles_article.name,
On 06/08/2011 06:13 PM, Arash pajoohande wrote:
1. save .doc documents in bytea columns. and show them with a word
reader in web page (disadvantage: it needs a proper .doc reader
installed on user computer)
1a: Convert the .doc files to a standard format like PDF that most
browsers can
Hello,
the problem just resurfaced and the Wiki page dows not really help
very much.
When i look into the pg_stat_activity, i only see that the connections
all state IDLE in transaction.
Is there any way to find out what the transaction is doing exactly to
be able to debug the Problem?
Best
On Wed, Jun 8, 2011 at 9:32 AM, Tarabas tara...@tarabas.de wrote:
Hello,
the problem just resurfaced and the Wiki page dows not really help
very much.
When i look into the pg_stat_activity, i only see that the connections
all state IDLE in transaction.
Is there any way to find out what
Gaëtan Allart gae...@nexylan.com Wednesday 08 of June 2011 14:59:05
Hi everyone,
We've just moved our website database from pg 8.4 to pg 9.0 and we found
out a very long query (that wasn't that long under 8.4).
And I actually can't explain why it's taking so much timeŠ
Here it is :
http://alkiosco.com/lindex02.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Jun 8, 2011 at 11:43 AM, Radosław Smogura
rsmog...@softperience.eu wrote:
You should actually only consider safty of storing of such passwords in
database. If with md5 the password isn't digested like in DIGEST HTTP auth,
and only md5 shortcut is transfferd it has no meaning if you
Hi all -
For most of my database I use UUIDs as primary keys because, well, I
just like it better and like being able to generate a key in the
middle tier when I create new data. However, I have one table that
has a very fixed and immutable set of data with a few thousand
ingredients in it.
On 06/08/11 6:06 AM, Craig Ringer wrote:
1. save .doc documents in bytea columns. and show them with a word
reader in web page (disadvantage: it needs a proper .doc reader
installed on user computer)
1a: Convert the .doc files to a standard format like PDF that most
browsers can display.
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Mike Christensen
Sent: Wednesday, June 08, 2011 2:57 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Converting uuid primary key column to serial int
for
On Wed, Jun 8, 2011 at 1:06 PM, David Johnston pol...@yahoo.com wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Mike Christensen
Sent: Wednesday, June 08, 2011 2:57 PM
To: pgsql-general@postgresql.org
-Original Message-
From: Mike Christensen [mailto:m...@kitchenpc.com]
Sent: Wednesday, June 08, 2011 4:26 PM
To: David Johnston; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Converting uuid primary key column to serial int
I'm assuming I can still have a Serial column that
Dne 8.6.2011 21:37, John R Pierce napsal(a):
On 06/08/11 6:06 AM, Craig Ringer wrote:
1. save .doc documents in bytea columns. and show them with a word
reader in web page (disadvantage: it needs a proper .doc reader
installed on user computer)
1a: Convert the .doc files to a standard format
I'm assuming I can still have a Serial column that is NOT a primary key,
and
it'll incremement just the same as I add rows? If that's the case, I
think that's
a superior approach..
BTW, this table is too small to worry about disk space of UUIDs and/or
perhaps any sort of performance
On Wednesday, June 08, 2011 1:40:35 pm David Johnston wrote:
-Original Message-
From: Mike Christensen [mailto:m...@kitchenpc.com]
Sent: Wednesday, June 08, 2011 4:26 PM
To: David Johnston; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Converting uuid primary key column to
On 09/06/11 03:07, Isak Hansen wrote:
While MD5 is considered broken for certain applications, it's still
perfectly valid for auth purposes.
MD5 rainbow tables can be calculated quickly using services easily
available to anyone (eg: EC2) and rainbow tables for passwords up to 8
chars have been
25 matches
Mail list logo