Re: Best way to inplace alter a list going into postgres

From	Ben Finney <ben+python@benfinney.id.au>
Newsgroups	comp.lang.python
Subject	Re: Best way to inplace alter a list going into postgres
Date	2016-06-01 06:10 +1000
Message-ID	<mailman.59.1464725431.1839.python-list@python.org> (permalink)
References	<705c69aa-f82d-4e03-9d83-bb33ed20ad4d@googlegroups.com> <574d2805$0$1521$c3e8da3$5496439d@news.astraweb.com> <60214c2e-4015-403e-95e7-a77771e94ddc@googlegroups.com> <9ffc7ef3-3ec5-45ea-87be-b7e4e41e815c@googlegroups.com> <85d1o26lat.fsf@benfinney.id.au>

Show all headers | View raw

Sayth Renshaw <flebber.crue@gmail.com> writes:

> Probably easier to handle in postgres http://stackoverflow.com/a/37538641/461887

Yes, a proper RDBMS is expressly optimised for manipulating the data.

Especially when the problem at hand is expressible as a set operation,
the RDBMS is almost always the better place to do that.

This assumes you have an RDBMS that is good at manipulating data
efficiently (which rules out MySQL, but you've already done that I see.)

-- 
 \     “[…] we don’t understand what we mean when we say that [God] is |
  `\    ‘good’, ‘wise’, or ‘intelligent’.” —Karen Armstrong, _The Case |
_o__)                                                   For God_, 2009 |
Ben Finney

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Best way to inplace alter a list going into postgres Sayth Renshaw <flebber.crue@gmail.com> - 2016-05-30 21:27 -0700
  Re: Best way to inplace alter a list going into postgres Ben Finney <ben+python@benfinney.id.au> - 2016-05-31 14:54 +1000
    Re: Best way to inplace alter a list going into postgres Sayth Renshaw <flebber.crue@gmail.com> - 2016-05-30 22:42 -0700
      Re: Best way to inplace alter a list going into postgres Ben Finney <ben+python@benfinney.id.au> - 2016-05-31 15:52 +1000
  Re: Best way to inplace alter a list going into postgres Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2016-05-31 15:58 +1000
    Re: Best way to inplace alter a list going into postgres Sayth Renshaw <flebber.crue@gmail.com> - 2016-05-30 23:19 -0700
      Re: Best way to inplace alter a list going into postgres Sayth Renshaw <flebber.crue@gmail.com> - 2016-05-31 01:46 -0700
        Re: Best way to inplace alter a list going into postgres Ben Finney <ben+python@benfinney.id.au> - 2016-06-01 06:10 +1000

csiph-web