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
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 only the
On Wed, 17 Dec 2014 15:09:40 +0530
VENKTESH GUTTEDAR venkteshgutte...@gmail.com 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
On Tue, Dec 16, 2014 at 11:36 PM, Joseph Kregloh jkreg...@sproutloud.com
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
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 17 December 2014 at 13:55, Thomas Kellerer spam_ea...@gmx.net 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
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 = (
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 than
On Wed, 17 Dec 2014 13:55:46 +0100
Thomas Kellerer spam_ea...@gmx.net 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
On Wed, 17 Dec 2014 16:51:10 +0530
VENKTESH GUTTEDAR venkteshgutte...@gmail.com 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
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 that
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
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
On Wed, Dec 17, 2014 at 3:39 AM, VENKTESH GUTTEDAR
venkteshgutte...@gmail.com 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
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
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 patr...@judicata.com
wrote:
I encountered this today and it
Patrick Krecker patr...@judicata.com 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
Patrick Krecker wrote
I encountered this today and it was quite surprising:
select version();
version
--
PostgreSQL 9.3.5 on
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.
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
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
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
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
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.
On Thu, Dec 18, 2014 at 10:23 AM, Adrian Klaver
adrian.kla...@aklaver.com 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
On 12/17/2014 05:39 PM, Michael Paquier wrote:
On Thu, Dec 18, 2014 at 10:23 AM, Adrian Klaver
adrian.kla...@aklaver.com wrote:
Just out of curiosity is there a reason PGDATA is not listed with the other
environment variables here?:
On Thu, Dec 18, 2014 at 12:05 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
Are there any more then those listed on the libpq page and PGDATA?
No other PG* I am aware of.
--
Michael
This! I'm surprised it took so long to somebody suggest an object store.
On Dec 17, 2014 9:22 PM, Jonathan Vanasco postg...@2xlp.com 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
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 postg...@2xlp.com
mailto:postg...@2xlp.com wrote:
I wouldn't even store it on the
Adrian Klaver adrian.kla...@aklaver.com 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.
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
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
32 matches
Mail list logo