#10509 (Better handling of database-specific information)

2009-11-07 Thread Christophe Pettus
Allow Django to use the INSERT...RETURNING functionality of PG 8.2+ even if autocommit isn't being used. -- Get rid of the need to repeatedly call SELECT version(). Some other functionality that's not directly relevant to this ticket, but related and useful: -- Allow for Serializable transact

autocommit, INSERT... RETURNING and PostgreSQL 8.2+

2009-11-07 Thread Christophe Pettus
was introduced into 8.2, and that syntax is required for correct operation while autocommit is True. But I'm not sure I understand the reasoning; does anyone know why INSERT ... RETURNING is required in that case? Thanks! -- -- Christophe Pettus x...@thebuil

Re: autocommit, INSERT... RETURNING and PostgreSQL 8.2+

2009-11-08 Thread Christophe Pettus
On Nov 8, 2009, at 8:39 AM, Seb Potter wrote: > transaction pooling Ah, of course. Thank you! -- -- Christophe Pettus x...@thebuild.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django de

Patch uploaded for ticket 12180

2010-01-31 Thread Christophe Pettus
o the database, using PostgreSQL 8.4.1, using psycopg2, if that INSERT is the first thing done by a view on a particular connection to the database, when DATABASE_OPTIONS autocommit: True is set. Comments welcome, thanks! -- -- Christophe Pettus x...@thebuild.com -- You received this me

Re: Patch uploaded for ticket 12180

2010-01-31 Thread Christophe Pettus
the review process. Thanks! -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-develop...@googlegroups.com. To unsubscribe from this group, s

Re: DoS using POST via hash algorithm collision

2011-12-29 Thread Christophe Pettus
ield. A SlowLoris or similar attack would seem to be far more effective and less implementation-dependent. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group,

commit_on_success leaves incorrect PostgreSQL isolation mode?

2012-03-18 Thread Christophe Pettus
e the decorators call managed(True)), which means that _leave_transaction_management in the psycopg2 backend will not reset the transaction isolation level; the code in the psycopg2 backend seems to assume that it will be run in the new transaction context, not the previous one. Or am I missing s

Re: Database pooling vs. persistent connections

2013-02-28 Thread Christophe Pettus
xample, on PostgreSQL, ABORT; DISCARD ALL is the recommended way of resetting a connection, so being able to implement that would be great. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To u

Re: Database pooling vs. persistent connections

2013-02-28 Thread Christophe Pettus
have this configuration, it's an error. The fact that the error is now surfacing doesn't make it a correct configuration. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To un

Re: Database pooling vs. persistent connections

2013-02-28 Thread Christophe Pettus
s finished. If you have more workers than database connections, you have either (a) over-configured the number of workers, which is generally a bad thing to do, or (b) you are accepting that you will at high-load points get refused connections. I don't see either one as being correct. -- -

Re: Switch to database-level autocommit

2013-03-01 Thread Christophe Pettus
On Mar 1, 2013, at 4:48 AM, Aymeric Augustin wrote: > Yay or nay? +1. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To unsubscribe from this group and stop receiving emails fro

Re: Switch to database-level autocommit

2013-03-03 Thread Christophe Pettus
ge-case-y. Does it exist in any case besides model inheritance? If not, could we have the ORM wrap those operations in a transaction in that particular case? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Djan

Re: Switch to database-level autocommit

2013-03-03 Thread Christophe Pettus
ing > it from PostgreSQL to BSD. Absolutely; it would be my honor. Just contact me off-list and we can sort out the details. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To unsu

Re: Switch to database-level autocommit

2013-03-04 Thread Christophe Pettus
On Mar 4, 2013, at 5:00 AM, Aymeric Augustin wrote: > PostgreSQL and Oracle use the "repeatable read" isolation level by default. Without explicitly changing it, PostgreSQL's default is READ COMMITTED. Or are we setting it explicitly to REPEATABLE READ in the new model?

Re: Switch to database-level autocommit

2013-03-04 Thread Christophe Pettus
On Mar 4, 2013, at 7:24 AM, Aymeric Augustin wrote: > PostgreSQL and Oracle use the "read committed" ... Sorry, replied too soon! > The reasoning and the conclusion still stand. Agreed. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you a

Re: Good practices for production settings

2013-03-17 Thread Christophe Pettus
On Mar 17, 2013, at 10:33 AM, Aymeric Augustin wrote: > Would anyone like to review it? I only had a chance for a once-over-lightly, but +1 to committing it from my pass; it looks very valuable. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you

Re: Configurable safety options for high performance Django systems

2014-11-23 Thread Christophe Pettus
formance issues all by itself: http://thebuild.com/blog/2014/11/18/when-limit-attacks/ There's no clean fix that wouldn't have significant effects on unsuspecting applications. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscrib

Re: Configurable safety options for high performance Django systems

2014-11-23 Thread Christophe Pettus
application is sending a query that expects to get 100 results back but gets 1,000,000 back, you have a bug that needs to be tracked down and fixed. Patching it by limiting the results is kind of a database version of "except: pass" to get rid of an inconvenient but mysterious except

Re: Configurable safety options for high performance Django systems

2014-11-24 Thread Christophe Pettus
ch the bad application. To me, this is about as logical as putting in DIVIDE_BY_ZERO_RETURNS_NONE with a default of False because someone wrote some legacy code that would work if we did that. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to

Re: Configurable safety options for high performance Django systems

2014-11-24 Thread Christophe Pettus
reating the Django and psycopg2 objects does. I'll note also that it's not that server that dies in this case; the particular thread doing the request gets an exception. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Googl

Re: Configurable safety options for high performance Django systems

2014-11-24 Thread Christophe Pettus
rticular case, where you have the relatively unusual situation that: 1. You have this problem, and, 2. You can't fix the code to solve this problem. ... you probably have the right answer is having a local patch for Django. -- -- Christophe Pettus x...@thebuild.com -- You received this

Re: Psycopg2 version support

2015-02-15 Thread Christophe Pettus
observation. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an email to djang

Unfortunate /login behavior in 1.8 (and 1.7)?

2015-04-06 Thread Christophe Pettus
. This effectively prevents me from logging into the admin. I assume this has something to do with the redirection change in 1.7 for the admin login. If I change the name of /login to /customer_login, that confusion goes away. -- -- Christophe Pettus x...@thebuild.com -- You received this

Re: Unfortunate /login behavior in 1.8 (and 1.7)?

2015-04-06 Thread Christophe Pettus
Ignore my silliness... operator error, that the 1.7 change flushed out! On Apr 6, 2015, at 11:36 PM, Christophe Pettus wrote: > I have a site with a /login URL. This URL is for customer logins to an > ecommerce site, and is distinct from the /admin/login to the Django admin. >

Re: Support for UNLOGGED tables in PostgreSQL

2015-07-15 Thread Christophe Pettus
ongly advise *against* *ever* even mentioning fsync = off anywhere in the Django documentation; that is such a horribly bad idea in 99.95% of real-life situations that steering people towards it as a "go faster" button is very unwise. -- -- Christophe Pettus x...@thebuild.com --

Re: Support for UNLOGGED tables in PostgreSQL

2015-07-16 Thread Christophe Pettus
aluable, and advising them to do a setting that runs the risk of them losing that data seems like a bad idea. The Django documentation is not the place to go into the ramifications of fsync (or even synchronous_commit, although that's significantly less risky). -- -- Christophe Pettus

Re: Support for UNLOGGED tables in PostgreSQL

2015-07-19 Thread Christophe Pettus
. > > Having a fast test suite is such an important part of development that it > shouldn't be held back by attempting to protect the world from people who > cannot be helped. > > Luke > > On 16/07/15 16:49, Christophe Pettus wrote: >> On Jul 16, 2015, at 1

Re: Support for UNLOGGED tables in PostgreSQL

2015-07-20 Thread Christophe Pettus
#x27;s point at the people whose >>> responsibility it really is :) >>> >>> -- >>> Curtis >>> >>> On 20 July 2015 at 06:44, Aymeric Augustin >>> wrote: >>>> I agree with pointing to the relevant section of the PostgreSQL >

Re: future of QuerySet.extra()?

2015-07-31 Thread Christophe Pettus
egroups.com. > To post to this group, send email to django-developers@googlegroups.com. > Visit this group at http://groups.google.com/group/django-developers. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-developers/CAMwjO1FQAJqrXu3HcSpP3xDF%2BA

Re: Making max_length argument optional

2015-09-21 Thread Christophe Pettus
nceptually they're different things. I don't think the relatively modest benefit of having no default justifies the problems that result on other platforms. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "

Re: Making max_length argument optional

2015-09-21 Thread Christophe Pettus
obvious gain. What's the benefit there? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emai

Re: Making max_length argument optional

2015-09-21 Thread Christophe Pettus
that something bad doesn't get into the database. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiv

Re: Making max_length argument optional

2015-09-21 Thread Christophe Pettus
st for because it is required > for the database backend. Well, that's not a practice I think we need to go to great lengths to support. If you *really* *must* have a VARCHAR field without a length, you can always use a migration to strip it off. -- -- Christophe Pettus x...@thebui

Re: Making max_length argument optional

2015-09-21 Thread Christophe Pettus
ng less depending on Oracle's encoding? Requiring a max_length is enforcing a good practice. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsub

Re: Making max_length argument optional

2015-09-21 Thread Christophe Pettus
, you just use TextField, and if you are either targeting a different database, or writing one that runs on multiple ones, you probably want CharField with a specific length. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups &qu

Re: Making max_length argument optional

2015-09-22 Thread Christophe Pettus
't think of it. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an emai

Re: Methodology for increasing the number of PBKDF2 iterations

2015-09-22 Thread Christophe Pettus
t correct? My understanding was that the passwords were only modified when changed. Given that it is a unidirectional hash, I'm not sure how they *would* be rehashed. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google G

Re: Methodology for increasing the number of PBKDF2 iterations

2015-09-22 Thread Christophe Pettus
roblem, since it's no worse than a user resetting their password. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group an

Why does transaction management only commit on is_dirty?

2010-10-22 Thread Christophe Pettus
ould be near-free on any back-end, since there are no changes, and it eliminates the IIT issue on PostgreSQL (and perhaps other problems on MySQL that I'm not as familiar with). What am I missing? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscr

Re: Why does transaction management only commit on is_dirty?

2010-10-22 Thread Christophe Pettus
On Oct 22, 2010, at 4:01 PM, Jacob Kaplan-Moss wrote: > It's a bug: http://code.djangoproject.com/ticket/9964. > > Looks like the patch there is OK, but still needs some work (there's a > couple of TODOs still). On it! :) -- -- Christophe Pettus x...@thebuild.com

Ticket 9964 (was Re: Why does transaction management only commit on is_dirty?)

2010-10-23 Thread Christophe Pettus
t is closed... somehow, by some means (probably a rollback when the connection closes). Is this really explicit-enough behavior that maintaining it is important? Are applications really relying on it? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are sub

Re: RFC #9964 - fix "missing" db commits by forcing managed transactions to close

2010-11-25 Thread Christophe Pettus
behavior. In the proposed fix, such transactions will commit instead. This is, however, pretty much the same as relying on uninitialized values in memory to be consistent, and I don't see any reason not to declare such code buggy. I've gotten around this by having my own version of commit_o

Pluggable encryption for django auth (design proposal)

2010-11-27 Thread Christophe Pettus
it does not. (Optional: Adding the algorithm as a default parameter to User.set_password().) Comments? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email

Re: Pluggable encryption for django auth (design proposal)

2010-11-27 Thread Christophe Pettus
ite the passwords to disk, and having an architecture to handle this seems like a good idea. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-develop..

Re: Pluggable encryption for django auth (design proposal)

2010-11-27 Thread Christophe Pettus
f passwords and their hashes, (pwd, hash(pwd)). The attacker then runs down the dictionary, comparing hashes; if they get a hit, they know the password. The salt defeats this by making the pwd -> hash(pwd) mapping incorrect. -- -- Christophe Pettus x...@thebuild.com -- You received

Re: Pluggable encryption for django auth (design proposal)

2010-11-27 Thread Christophe Pettus
for a plain dictionary attack, either, for the same reason as a brute force attack. Anyway, back to the discussion of the actual proposal. :) -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" gro

Re: Pluggable encryption for django auth (design proposal)

2010-11-28 Thread Christophe Pettus
lication can brute force 700 million MD5s per second, doubling the length is not really going to make it any more secure. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this g

Re: Pluggable encryption for django auth (design proposal)

2010-11-28 Thread Christophe Pettus
e entropy in the password selection. If everyone has a unique password, it doesn't help at all (admittedly unlikely). Again, it's a linear benefit, but not an exponential one. Right. So, about that proposal... :) -- -- Christophe Pettus x...@thebuild.com -- You received

#12180: Test case advice

2010-11-28 Thread Christophe Pettus
AUTOCOMMIT: True in the database options). Is there some quick guidance from those more experienced than me? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send ema

.limit() on a QuerySet

2010-11-29 Thread Christophe Pettus
te).order_by('entry_date').limit(limit=1, offset=0) Then, in the template, {{ previous_entry.get }} could be used to fetch the result. Thoughts? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django deve

Re: .limit() on a QuerySet

2010-11-29 Thread Christophe Pettus
mind, and thanks. :) -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-develop...@googlegroups.com. To unsubscribe from this group, send email to

Re: Purpose of constant_time_compare?

2010-12-08 Thread Christophe Pettus
On Dec 8, 2010, at 12:08 PM, Jonas H. wrote: > Can the time spent in *one single string comparison* really make such a huge > difference? Yes. http://codahale.com/a-lesson-in-timing-attacks/ -- -- Christophe Pettus x...@thebuild.com -- You received this message because y

Fetching results of a query set

2010-12-11 Thread Christophe Pettus
ts of GET_ITERATOR_CHUNK_SIZE (which is hard coded right now to be 100). So, in the case of using .iterator() (no caching of results), it shouldn't have more than 100 result objects in memory at once, unless the client of the query set is saving them. Am I reading it correctly? -- -- Christophe P

Re: ForeignKey with null=True

2010-12-16 Thread Christophe Pettus
is done. If I'm understanding your point, this isn't true; NULL does not match NULL on a join. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to thi

Re: ForeignKey with null=True

2010-12-16 Thread Christophe Pettus
it should never return related objects; ditto for the reverse situation. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-develop...@g

Re: RFC #9964 - fix "missing" db commits by forcing managed transactions to close

2010-12-21 Thread Christophe Pettus
On Dec 21, 2010, at 11:39 AM, Jacob Kaplan-Moss wrote: > Unless there are objections, I'm going to accept this approach and > check in a change based on Shai's latest -bugfix patch. FWIW, +1. -- -- Christophe Pettus x...@thebuild.com -- You received this message because yo

Re: r13363 change to use pg_get_serial_sequence

2010-12-23 Thread Christophe Pettus
27;s stored in pg_depend. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-develop...@googlegroups.com. To unsubscribe from this group, send em

Re: Transaction Documentation Clarification

2011-02-17 Thread Christophe Pettus
rror exception thrown instead. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@googlegroups.com. To unsubscribe from this group, s

#14733: A vote in favor of no validation of .raw() queries

2011-03-09 Thread Christophe Pettus
You must know what you are doing" feature in the first place, I don't see the need to be strict about the input, at the cost of some very useful functionality. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups

Re: #14733: A vote in favor of no validation of .raw() queries

2011-03-12 Thread Christophe Pettus
are doing, so let's just get out of their way and let them get on with it. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developer

Re: #14733: A vote in favor of no validation of .raw() queries

2011-03-14 Thread Christophe Pettus
On Mar 12, 2011, at 12:56 PM, Jacob Kaplan-Moss wrote: > Christophe, can you write a patch including a new warning to put in the docs? All set: http://code.djangoproject.com/ticket/14733 -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed

Re: Composite primary keys

2011-03-15 Thread Christophe Pettus
dering of the fields in the class declaration becomes important. That could, potentially, be surprising. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, s

Re: Composite primary keys

2011-03-16 Thread Christophe Pettus
osite field. In all of these cases, what we're really creating is a composite index on a set of standard fields. Introducing a more powerful index-creation syntax into Django isn't a bad idea, but we shouldn't call it a "field" if it is not. -- -- Christophe Pettus

Re: Composite primary keys

2011-03-16 Thread Christophe Pettus
ble, and have db_index=True be a shortcut to creating one. That might be more machinery than we want just for composite primary keys though. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers&qu

Re: Composite primary keys

2011-03-21 Thread Christophe Pettus
I'd like to make one more pitch for a slightly different implementation here. My concern with CompositeField isn't based on the fact that it doesn't map one-to-one with a field in the table; it's that it doesn't have any of the semantics that are associated with a field. In particular, it can'

Re: State of X-Sendfile support?

2011-03-28 Thread Christophe Pettus
Django core, especially given the varying implementations for specific environments. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@googlegr

Re: Composite primary keys

2011-03-31 Thread Christophe Pettus
indexes = ['some_field', 'some_other_field', ('field1', '-field2', ), ] raw_indexes = [ 'some_invariant_function(some_field)' ] (This was proposed by someone else, and isn't original to me; apologies that I can't find the

Extending templates dynamically

2011-05-06 Thread Christophe Pettus
at an inner template is used in multiple wrapper contexts. Is this something that might be worth investigating in Django? Looking at the Django source, the implementation seems quite straight-forward. -- -- Christophe Pettus x...@thebuild.com -- You received this message because yo

Re: Curious (bug?) with db filter __in

2011-10-03 Thread Christophe Pettus
st the DB to see if the problem is in MySQL, or in the Django backend. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@goog

Re: DecimalField model validation

2011-10-06 Thread Christophe Pettus
On Oct 6, 2011, at 9:29 PM, Tai Lee wrote: > Why is ROUND_HALF_EVEN superior? ROUND_HALF_EVEN is the standard when doing financial calculations, an extremely common use of DecimalField. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed

Re: changing the on_delete=CASCADE default

2013-09-26 Thread Christophe Pettus
work for existing applications. I also think we *really* need to push execution of this functionality into the database rather than having the Django core do it, if we're going to be making more use of on_delete. -- -- Christophe Pettus x...@thebuild.com -- You received this message be

Re: changing the on_delete=CASCADE default

2013-09-26 Thread Christophe Pettus
us, error-prone South migration to install the appropriate foreign key constraints, something that Django could very easily do. Perhaps a CASCADE_DB and SET_NULL_DB options on on_delete? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the G

Re: changing the on_delete=CASCADE default

2013-09-26 Thread Christophe Pettus
On Sep 26, 2013, at 3:28 PM, Christophe Pettus wrote: > Perhaps a CASCADE_DB and SET_NULL_DB options on on_delete? And, to be clear, I *am* volunteering to take a go at this code, not just whine. :) -- -- Christophe Pettus x...@thebuild.com -- You received this message because you

Re: changing the on_delete=CASCADE default

2013-09-27 Thread Christophe Pettus
disallow that. (b) You allow it, but warn that if you delete the child, the parent is not cleaned up. I lean towards (a). -- The _DB variations should be considered something like .update and .raw; they're for performance benefits where you know you are doing. They don't need to solve eve

Re: changing the on_delete=CASCADE default

2014-02-05 Thread Christophe Pettus
> -- > You received this message because you are subscribed to the Google Groups > "Django developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-developers+unsubscr...@googlegroups.com. > To post to this group,

Re: RFC: "UPSERT" in PostgreSQL

2014-09-28 Thread Christophe Pettus
uot; where I assume "clean" means "with reasonable behavior in the presence of concurrent activity" and MERGE means "the MERGE statement defined in the standard" is a contradiction in terms, and expecting PostgreSQL to square that circle isn't a reasonable re

Increase default integer keys to 64 bits

2021-01-28 Thread Christophe Pettus
have saved a major foot-gun of either integer exhaustion or a very expensive data migration problem. -- Comments? -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)&quo

Re: Increase default integer keys to 64 bits

2021-01-29 Thread Christophe Pettus
is to make the public default for new projects 64 bit keys; we're doing developers a disservice by making the default path 32 bit keys. -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contrib

Re: Partial indexes, PR help

2018-07-23 Thread Christophe Pettus
te must be marked IMMUTABLE xof=# create index on i(p) where p > '2011-01-01'::timestamp; CREATE INDEX -- -- Christophe Pettus x...@thebuild.com -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself

Re: Partial indexes, PR help

2018-07-23 Thread Christophe Pettus
> On Jul 23, 2018, at 13:05, Christophe Pettus wrote: > > >> On Jul 23, 2018, at 12:20, Mads Jensen wrote: >> >> Q(published__gt=datetime.date(2017, 10, 1)) >> => >> "table"."published" > '2017-10-01'::timestamp; >