Hi all,
What's the best way to insert long strings that contain numerous
special characters into a PG database?
I'm assuming that importing an SQL script with prepared statements is
the way to go. If so, how to escape all the special characters?
I've found documentation on PQescapeStrin
In response to Dino Vliet :
> I arrived at 15 functions because I had 7 or 8 joins in the past and saw that
> my disk was getting hid and I had heard someplace that RAM is faster so I
> rewrote those 7 or 8 joins as functions in pl/pgsql. They were just simple
> lookups, although some of the functi
On Fri, Jul 30, 2010 at 3:05 AM, John Gage wrote:
> Shopping carts, company blogs, etc. Popular pieces of software.
>
> As common denominators go, that's pretty low.
>
> Perhaps what is needed is a dumbed down version of Postgres.
>
I dont think that is what is required - as I mentioned above,
> Why is MySQL so much more popular right now, especially in the
> OpenSource community?
This is not true in Japan. PostgreSQL and MySQL has been having even
share in many surveys.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Samantha Atkins wrote:
> Why is MySQL so much more popular right now, especially
> in the OpenSource community? As a database I find its
> architecture with multiple underlying engines and other
> quirks to be rather dubious. Then there is the issue of
> commercial licenses and exactly when you
Brad Nicholson wrote:
Postgres also had a reputation of being slow compared to MySQL.
This was due to a lot of really poor MySQL vs Postgres benchmarks
floating around in the early 2000's.
I think more of those were fair than you're giving them credit for. For
many common loads, up until PG
On Thu, Jul 29, 2010 at 10:33 PM, Dean Rasheed wrote:
> On 28 July 2010 02:58, Howard Rogers wrote:
>> For what it's worth, I wrote up the performance comparison here:
>> http://diznix.com/dizwell/archives/153
>>
>
> Thanks, very interesting results. I wonder, are the results being
> sorted by th
On Thu, Jul 29, 2010 at 5:42 PM, Greg Smith wrote:
> Greg Williamson wrote:
>>
>> Our tests -- very much oriented at postGIS found Oracle to be between 5
>> and 15% _faster_ depending on the specifics of the task. We decided to go
>> with postgres given the price difference (several hundred thousa
Samantha Atkins wrote:
Amazon cloud has great scalable MySQL support but apparently not postgreql.
Why?
The perception is that MySQL has good built-in replication usable for
scaling up purposes, and therefore is suitable for cloud deployments.
Whereas the perception is that PostgreSQL has
Joshua D. Drake wrote:
If you look at Rails, Django, Turbo Gears, Catalyst, Groovy+Grails they all
have excellent PostgreSQL
support.
Exactly. If Ivan were building on a Rails or Java software platform,
this discussion of "why is PostgreSQL not well supported?" wouldn't be
happening. T
Greg Williamson wrote:
Our tests -- very much oriented at postGIS found Oracle to be between 5
and 15% _faster_ depending on the specifics of the task. We decided to go
with postgres given the price difference (several hundred thousand dollars for
Oracle in the configuration we needed vs. zip for
On 07/29/10 2:58 PM, Dino Vliet wrote:
Dear postgresql list,
I have some troubles generating data for a analysis task at hand.
I have a table (table A) containing 5 million records and 28 number of
attributes. This table is 461MB big if I copy it to a csv file.
I want to create another
Dear postgresql list,
I have some troubles generating data
for a analysis task at hand.
I have a table (table A) containing 5
million records and 28 number of attributes. This table is 461MB big
if I copy it to a csv file.
I want to create another table (table
B) based o
Shopping carts, company blogs, etc. Popular pieces of software.
As common denominators go, that's pretty low.
Perhaps what is needed is a dumbed down version of Postgres.
My hobby horse. MySQL supports regular expressions... In a [rhymes
with rat's ass]. It "supports" a kind of tinker toy
Hy,
I have a system working with the client-server structure and PostgreSQL 8.4.
My problem is that if a client who is editing a record and lose his connection
to the server,the TCPIP connection is still considered! So, the record stay
allocated for the client in my database.
I need the records
On 07/29/10 12:52 PM, Sandeep Srinivasa wrote:
Biggest example - Wordpress. Strictly mysql only. If I want to throw
together a company blog + mailing list + SEO, I can get it done using
Wordpress in a matter of hours.
Serendipity - http://www.s9y.org - a full featured blog server, in php,
th
On Thu, Jul 29, 2010 at 10:46 PM, Ivan Sergio Borgonovo <
m...@webthatworks.it> wrote:
> On Thu, 29 Jul 2010 08:52:46 -0700
> "Joshua D. Drake" wrote:
>
> > The issue isn't Drupal. It is modules. There are a lot of popular
> > modules that do not work with PostgreSQL (Lightbox for example).
>
> >
On 10-07-29 02:57 PM, Tom Lane wrote:
Samantha Atkins writes:
Why is MySQL so much more popular right now, especially in the
OpenSource community?
I think it's strictly historical. The mysql bias you see in so
many web tools was established in the late 90s, a time when mysql
worked
On Thu, 2010-07-29 at 21:19 +0200, Ivan Sergio Borgonovo wrote:
> On Thu, 29 Jul 2010 14:57:04 -0400
> Tom Lane wrote:
>
> > Samantha Atkins writes:
> > > Why is MySQL so much more popular right now, especially in the
> > > OpenSource community?
> >
> > I think it's strictly historical. The my
On Thu, 29 Jul 2010 14:57:04 -0400
Tom Lane wrote:
> Samantha Atkins writes:
> > Why is MySQL so much more popular right now, especially in the
> > OpenSource community?
>
> I think it's strictly historical. The mysql bias you see in so
> many web tools was established in the late 90s, a time
On Thu, 2010-07-29 at 14:57 -0400, Tom Lane wrote:
> Samantha Atkins writes:
> > Why is MySQL so much more popular right now, especially in the
> > OpenSource community?
>
> I think it's strictly historical. The mysql bias you see in so
> many web tools was established in the late 90s, a time wh
Samantha Atkins writes:
> Why is MySQL so much more popular right now, especially in the
> OpenSource community?
I think it's strictly historical. The mysql bias you see in so
many web tools was established in the late 90s, a time when mysql
worked reasonably well (at least according to the mysq
On Jul 29, 2010, at 10:53 AM, Samantha Atkins wrote:
> This touches on a question I would love to be able to answer
>
> Why is MySQL so much more popular right now, especially in the OpenSource
> community? As a database I find its architecture with multiple underlying
> engines and other qui
This touches on a question I would love to be able to answer
Why is MySQL so much more popular right now, especially in the OpenSource
community? As a database I find its architecture with multiple underlying
engines and other quirks to be rather dubious. Then there is the issue of
commercial
On Thu, 29 Jul 2010 08:52:46 -0700
"Joshua D. Drake" wrote:
> The issue isn't Drupal. It is modules. There are a lot of popular
> modules that do not work with PostgreSQL (Lightbox for example).
> The google checkout module for Ubercart didn't work either until
> relatively recently.
I'd say th
On Thu, Jul 29, 2010 at 10:06 AM, Merlin Moncure wrote:
> On Wed, Jul 28, 2010 at 5:27 PM, J. Greg Davidson wrote:
>> Hi fellow PostgreSQL hackers,
>>
>> I just got burned by the idiomatic loop
>> documented in the PostgreSQL manual as
>>
>> Example 39-2. Exceptions with UPDATE/INSERT
>>
>> I hav
P Kishor wrote:
On Wed, Jul 28, 2010 at 1:38 PM, Stephen Frost wrote:
* P Kishor (punk.k...@gmail.com) wrote:
Three. At least, in my case, the overhead is too much. My data are
single bytes, but the smallest data type in Pg is smallint (2 bytes).
That, plus the per row overhead adds to a fair
On Thu, 2010-07-29 at 08:10 -0400, Ned Lilly wrote:
> On 7/28/2010 3:06 PM Sandeep Srinivasa wrote:
> > yup I did. The reason why I wanted examples was to amply demonstrate,to
> > clients, that postgresql is viable.
> > It is kinda weird if the only examples I have are restricted to the
> > postg
On Thu, 2010-07-29 at 11:57 +0530, Sandeep Srinivasa wrote:
>
> What really, really hurts me is this - come Postgres 9.0 you will have
> the most amazing DB software in the open source community. I (and
> millions of small time developers like me) wont be able to leverage
> that - because our cli
On 29/07/10 22:36, Pierre Thibault wrote:
> Why so? This is something expected by a database used in a constant
> integration environment. Maybe I did not expressed myself very well. Users
> are not changing their models all the time. They create new models which
> mean create new tables and from
On Wed, Jul 28, 2010 at 5:27 PM, J. Greg Davidson wrote:
> Hi fellow PostgreSQL hackers,
>
> I just got burned by the idiomatic loop
> documented in the PostgreSQL manual as
>
> Example 39-2. Exceptions with UPDATE/INSERT
>
> I have now replaced this "standard" idiom
> with a safer one described b
Dear All,
How can i retrieve only spatial enabled tables form the
database(Postgresql/PostGIS).Please let me know.
I am waiting for your great response.
Thanks and Regards,
Venkat
On 28 July 2010 02:58, Howard Rogers wrote:
> For what it's worth, I wrote up the performance comparison here:
> http://diznix.com/dizwell/archives/153
>
Thanks, very interesting results. I wonder, are the results being
sorted by the database? The performance degradation for large numbers
of resu
On 7/28/2010 3:06 PM Sandeep Srinivasa wrote:
yup I did. The reason why I wanted examples was to amply demonstrate,to
clients, that postgresql is viable.
It is kinda weird if the only examples I have are restricted to the postgresql
_community_ websites themselves.
Both xTuple web sites (www.
Brian,
you have two options:
1. Use your own parser (just modify default)
2. Use replace function, like
postgres=# select to_tsvector( replace('qw/er/ty','/',' '));
to_tsvector
--
'er':2 'qw':1 'ty':3
(1 row)
Oleg
On Wed, 28 Jul 2010, Brian Hirt wrote:
I have som
Jayadevan M writes:
> But the initial setup for the client is done by 'Admin' and in that
> work-flow, we need distributed transactions. The transaction will start
> from the 'Admin" server, do some inserts on the 'Client' server and then
> either rollback or commit on both the servers. Is it p
Hi,
We need some help to either design a new logo, or spruce up the
existing logo for PGDay.EU 2010. the European PostgreSQL conference.
It needs to be related to PostgreSQL in some way of course, and needs
to be in colours that will work when converted to black and white or
when printed onto a T-
On Thu, Jul 29, 2010 at 10:50:02AM +0200, Davor J. wrote:
> For completeness, I think this link
> (http://projects.nocternity.net/index.py/en/psql-inheritance) provides some
> scripts you mention.
Very interesting.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 453
Hello everyone,
I saw a question about PostgreSQL and distributed transactions in the mail
archives. But it looked a bit old. I am hoping things have changed and
hence this mail.
We have a database for 'Admin' which will be one PostgreSQL server. We
have different servers for our 'Clients'. We d
Greg Williamson wrote:
Our tests -- very much oriented at postGIS found Oracle to be between 5
and 15% _faster_ depending on the specifics of the task. We decided to go
with postgres given the price difference (several hundred thousand dollars for
Oracle in the configuration we needed vs. zip fo
"Karsten Hilbert" wrote in message
news:20100728182051.gj2...@hermes.hilbert.loc...
> On Tue, Jul 27, 2010 at 10:33:19AM +0200, Davor J. wrote:
>
>> Well... I found it out the hard way :). There are some extra caveats I
>> have
>> come along. There is the very clumsy ALTER TABLE table_name
>> I
On Wed, 28 Jul 2010 22:24:07 -0700
"Joshua D. Drake" wrote:
> On Thu, 2010-07-29 at 07:04 +0200, Ivan Sergio Borgonovo wrote:
>
> > BTW up to my memory Django suggest postgres. I haven't seen any
> > benchmark of Django with pg vs mysql.
> Django was originally developed for Postgres but really
On 28/07/10 02:58, Howard Rogers wrote:
For what it's worth, I wrote up the performance comparison here:
http://diznix.com/dizwell/archives/153
Thanks very much Howard.
It might be my schoolboy-physics ability to fit a curve to two data
points, but does anyone else think that the second and t
Pierre Thibault wrote:
Hello people of the Postgresql world!
I am wondering if Postgresql would a great choice for my database needs.
I would like to create a db with dynamic data model. I would like to
be able to add tables and columns to existing tables while other
queries are running.
It s
44 matches
Mail list logo
