On 12/17/2014 10:14 PM, harpagornis wrote:
I am developing a Windows desktop application so the client is the desktop
application. Depending on the installation, the app will be running in
single user mode, with the server and client both on only one machine, using
127.0.0.1. In that type of in
I am developing a Windows desktop application so the client is the desktop
application. Depending on the installation, the app will be running in
single user mode, with the server and client both on only one machine, using
127.0.0.1. In that type of installation, there is little or no reason the
Adrian Klaver writes:
> On 12/17/2014 05:39 PM, Michael Paquier wrote:
>> PGDATA is not an environment variables that can be used for
>> connections with libpq, see for example fe-connect.c.
> I see. Still it would be nice to have all the environment variables in
> one place.
> Are there any mor
On 12/17/2014 07:37 PM, Arthur Silva wrote:
This! I'm surprised it took so long to somebody suggest an object store.
I thought they did, a file system:)
On Dec 17, 2014 9:22 PM, "Jonathan Vanasco" mailto:postg...@2xlp.com>> wrote:
I wouldn't even store it on the filesystem if I could a
This! I'm surprised it took so long to somebody suggest an object store.
On Dec 17, 2014 9:22 PM, "Jonathan Vanasco" wrote:
>
> I wouldn't even store it on the filesystem if I could avoid that.
> Most people I know will assign the video a unique identifier (which is
> stored in the database) and
On Thu, Dec 18, 2014 at 12:05 PM, Adrian Klaver
wrote:
> Are there any more then those listed on the libpq page and PGDATA?
>
No other PG* I am aware of.
--
Michael
On 12/17/2014 05:39 PM, Michael Paquier wrote:
On Thu, Dec 18, 2014 at 10:23 AM, Adrian Klaver
wrote:
Just out of curiosity is there a reason PGDATA is not listed with the other
environment variables here?:
http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
PGDATA is not an envi
On Thu, Dec 18, 2014 at 10:23 AM, Adrian Klaver
wrote:
> Just out of curiosity is there a reason PGDATA is not listed with the other
> environment variables here?:
>
> http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
PGDATA is not an environment variables that can be used for
conne
Adrian Klaver-4 wrote
> Just out of curiosity is there a reason PGDATA is not listed with the
> other environment variables here?:
>
> http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
Yes, because PGDATA is not a client concern and thus is not something that
libpq cares about.
C
Just out of curiosity is there a reason PGDATA is not listed with the
other environment variables here?:
http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
> Are there other methods/ practices commonly used for these operations?
> Thank you in advance.
You've got some serious confusion between client/server and other things
going on here...Adrian addressed those. It might help to think of the fact
that the clients and server are typically not on t
On 12/17/2014 11:38 AM, harpagornis wrote:
Some more questions if you please. I am in Houston, and we don't have a
postgres users group. If anyone knows of some postgres groups that have
webcasts of their meetings, let me know. Thanks.
I am trying to figure out how to manage the SSL client ce
On Wed, Dec 17, 2014 at 3:11 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
>
> Patrick Krecker wrote
> > I encountered this today and it was quite surprising:
> >
> > select version();
> >version
> >
> >
> -
I wouldn't even store it on the filesystem if I could avoid that.
Most people I know will assign the video a unique identifier (which is stored
in the database) and then store the video file with a 3rd party (e.g. Amazon
S3).
1. This is often cheaper. Videos take up a lot of disk space. Havin
Patrick Krecker wrote
> I encountered this today and it was quite surprising:
>
> select version();
>version
>
> --
> PostgreSQL 9.3.5 on x86_64-unk
Patrick Krecker writes:
> As expected, the following fails:
> select count from foo;
> ERROR: column "count" does not exist
> LINE 1: select count from foo;
>^
> But if I change the syntax to something I thought was equivalent:
> select foo."count" from foo;
> count
> ---
>
Sorry, I changed the email as I was writing it but I forgot to change the
subject line. An appropriate subject would be 'Strange behavior when
referencing non-existent column foo."count".'
On Wed, Dec 17, 2014 at 2:50 PM, Patrick Krecker
wrote:
>
> I encountered this today and it was quite surpri
I encountered this today and it was quite surprising:
select version();
version
--
PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubu
On Wed, Dec 17, 2014 at 3:39 AM, VENKTESH GUTTEDAR
wrote:
> Hello,
>
> I am using PostGreSQL 9.3.5 and DJango1.7.5 and python 3.3.
>
> I am working on a application where i will get video files from mobile
> app, and i have to store in the server,
>so my question is how do i store vide
Some more questions if you please. I am in Houston, and we don't have a
postgres users group. If anyone knows of some postgres groups that have
webcasts of their meetings, let me know. Thanks.
I am trying to figure out how to manage the SSL client certificates in a
Windows 7 environment, both i
On 12/17/2014 4:55 AM, Thomas Kellerer wrote:
Turns out the Postgres as well isn't really slower at this than the file system.
For small files around 50k both perform similar: the average time to read the
blob from a bytea column was around 2ms whereas the average time to read the
blob from th
On Wednesday, December 17, 2014 01:55:46 PM Thomas Kellerer wrote:
> Albe Laurenz schrieb am 17.12.2014 um 11:07:
> > and the performance will be worse than reading files from the file system.
>
> There is a Microsoft research [1] (from 2006) which tested this "myth" using
> SQL Server. It showed
On Wed, 17 Dec 2014 16:51:10 +0530
VENKTESH GUTTEDAR wrote:
Hi Venktesh,
[you should not reply directly to me; hit reply all to post your messages to
the list]
>
> can you help me in achieving this, i mean how to store it in a file
> system how to fetch it from there.
Nope. It's not post
On Wed, 17 Dec 2014 13:55:46 +0100
Thomas Kellerer wrote:
>
> Another downside you didn't mentioned is the fact that you have to distribute
> the files in the filesystem properly.
> Having thousands or even millions of files in a single directory is not going
> to be maintenance friendly either
Thomas Kellerer wrote:
> Albe Laurenz schrieb am 17.12.2014 um 11:07:
>> and the performance will be worse than reading files from the file system.
>
> There is a Microsoft research [1] (from 2006) which tested this "myth" using
> SQL Server.
> It showed that the database might actually be faster
It would be nice if PostgreSQL has *_extend (similar to $.extend from
jQuery or _.extend from UnderscoreJs) for JSON/JSONB columns, so we could
write it like this:
UPDATE tablename
SET jsoncolumn = json_extend(jsoncolumn, $2)
WHERE id = $1;
instead of this:
UPDATE tablename
SET data = (
On 17 December 2014 at 13:55, Thomas Kellerer wrote:
> Albe Laurenz schrieb am 17.12.2014 um 11:07:
>> and the performance will be worse than reading files from the file system.
>
> There is a Microsoft research [1] (from 2006) which tested this "myth" using
> SQL Server.
> It showed that the dat
Albe Laurenz schrieb am 17.12.2014 um 11:07:
> and the performance will be worse than reading files from the file system.
There is a Microsoft research [1] (from 2006) which tested this "myth" using
SQL Server.
It showed that the database might actually be faster than the file system.
As this
On Tue, Dec 16, 2014 at 11:36 PM, Joseph Kregloh
wrote:
>
> archive_command:
> archive_command = '/usr/local/pgsql/data/log_shipper.sh "%p" "%f"'
>
> log_shipper.sh
> #!/usr/local/bin/bash
> rsync -a $1 pgprod@prod-db-slave:archive/$2 < /dev/null;
> rsync -a $1 pgprod@prod-db-slave:p3_wal_files/$2
On Wed, 17 Dec 2014 15:09:40 +0530
VENKTESH GUTTEDAR wrote:
>so my question is how do i store video's or video files in DB, or do i
> need to store only the link of that video file, if yes then where i have to
> store the file and how to access that file to display in an html page.
If you
VENKTESH GUTTEDAR wrote:
> I am using PostGreSQL 9.3.5 and DJango1.7.5 and python 3.3.
>
> I am working on a application where i will get video files from mobile app,
> and i have to store in the server,
> so my question is how do i store video's or video files in DB, or do i need
> to store onl
Hello,
I am using PostGreSQL 9.3.5 and DJango1.7.5 and python 3.3.
I am working on a application where i will get video files from mobile
app, and i have to store in the server,
so my question is how do i store video's or video files in DB, or do i
need to store only the link of that v
32 matches
Mail list logo
