Introducing user specific timezones in existing high-traffic web app? -

-

Long story is short, we have developed a web app for internal use and one thing is moving forward for another And now it's a mother-in-law who has more than 1,000 users. The problem is that everything related to the date (which is very much!) Is hard work at Pacific Time (do not ask) and users clearly want their time zone.

I have read the best

I think the "big problem" has been estimated, which is the way to manage time zones in web applications, but right now Our current, live, mission-only that we are talking about the code of 100k + line, and possibly related to date of at least 100 different DB questions.

What I've read, it seems like to "correctly" manage the timezone to store everything in UTC and then users have to convert them to output to texas ...

But at this point there will be nothing wrong in modifying all date related queries and wrapping all the dates originally with Convert_Ties converting existing PDT timestamps into user's timezone To t?

As far as I can tell that we change all date fields in DB to UTC and convert MySQL to run the program, R. UTC will have to do this anyway, so at this point Is there any special reason to convert all existing date fields to UTC?

OK, "right" depends a lot about your application, and in your application How many dates are used In many circumstances, it is really necessary to store in UTC as well as to change the user's time zone. But not all of these

For example, if your dates are part of the recurrence pattern to schedule future events, then you will not use UTC for not .

As another example, if you have only a date-field, then the probability of those dates is "business days" that may be based on user's time zone, but it is time for your business May be based on the area.

The most common case of storage as a UTC occurs when you are referring to an immediate instant in time, such as the timestamp storage (last tension) of something in reality.

- Why not only base it on Pacific time? Well, the time of the Pacific is not fixed as UTC is it during the PTT UTC-8 in winter and UTC-7 in summer during PDT. Because of this, there is a difference of one hour per year where the local time is missing, and overlaps for one hour where the local time is repeated.

  • Create a new column in your database table for UTC time

    I can read more about this.

    Li> Type some code to adjust local time in UTC Use daylight saving time transition to add 8 hours or 7 hours to calculate UTC time. Copy the adjusted value to the new fields.

  • Manually retrieve the values ​​that fall into overlap. For Pacific Time, this DST is between the end date of 1: 00: 00.000 and 1: 59: 59.999 . You may need to manually adjust these values, because they can be either PDT or PST. To make an occupation, see if you have any other value to consider. For example, if you have an automatic incremental primary key, then sorting according to that key, timestamps must be almost sequential.
  • Now that you have a new column for UTC, then start changing all your code to use it.
  • Eventually, you can remove the old column.

Comments

Post a Comment

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

-
I have a SKScene where I am adding an SKSpriteNode I have subclassed the SKSpriteNode class to create this node. In the subclass I am defining some SKActions on Sprite. What do I want to do when the end of this phantom ends the SKAction sequence, then I add a new Prayer node to this scene. How is this possible. The following code is mine: The code for the sequence is that I'm running on the Scansprinitode subclass (TEMissileNode): - SKAction * moveDown = [SKAction moveToY: Self.position.y - 20 Duration: 0.2]; SKAction * animation = [SKAction animateWithTextures: textures timePerFrame: time / 7]; SKAction * moveMissileProjectile = [SKAction Moving: Pointoffscreen Term: Time]; SKAction * group = [SKAction group: @ [animation, movement projectile]]; SKAction * Sequence = [SKAction Sequence: @ [Hilldown, Group, [SKAction removalFromParent]]]; [Self run action: sequence]; From the main scene, I call those actions that execute these tasks TEMissileNode * missile = [tmissil...
Read more

Matlab transpose a table vector -

-
An embarrassing simple question seems to be, but how can I move a Matlab table vector? aTableT = aTable '; I tried a standard syntax for the simple interaction of a line vector to a line vector aTable : ATableT = reshape (aTable, 1, Height (aTable)); and aTableT = rot90 (aTable); According to the head, the last time table should work for table, see. However, I get this error code: Error type in using table / permit (line 396) Undefined function 'permute' for the input arguments. Error in rot 90 (line 29) b = magnitude (b, [2 1 3: ndims (a)]); NB: fliplr is not useful either pretty sure I have covered clear angles - any ideas? Thanks! Try changing your table into an array, move it, then back to a table In other words, try doing this: aTableArray = table2array (aTable); ATableT = array 2table (aTableArray. '); I have also read the document for rot90 , and it says that rot90 is definitely working for tables Do, and I find you...
Read more

c# - Textbox not clickable but editable -

-
I have a small form with 10 text boxes, I have set them in the correct tab order. I want them on my tab service I was wondering if there is a way to set the text box so that they can be selected for editing until they are tabbed. That is ... I do not want the end user to edit the text box to click on them, I just want to make them editable through tabu. this should do the trick public partial category poor text box: Text Box {Safe Override Zero WndProc (Ref: Message Message) {if (m.msg == (Int) WM.LBUTTONDOWN) {Return; // mount down events} base.WndProc (ref m); }} Window message enum can be found. How to do this without anherizing: text box : class EatMouseDown: netwindows {safe override zero WndProc (ref message message) {if (m.msg == (int) WM.LBUTTONDOWN) {return; } Base.WandProc (Ref M); }} Safe Override Zero Onload (EventEurge E) {base.OnLoad (e); How to do this without any part: left a clean part, whatever is important, this can be a buggy but it works R...
Read more