Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
View this topic in a long page with up to 500 replies per page Create new topic
1 | 2 | 3 
677 posts

Ultimate Geek
+1 received by user: 27

Trusted

  Reply # 876359 13-Aug-2013 11:14
Send private message

You would be surprised how many people code expecting auto increment numbers to be sequential...




meat popsicle

1502 posts

Uber Geek
+1 received by user: 173


  Reply # 876364 13-Aug-2013 11:22
Send private message

ptinson: You would be surprised how many people code expecting auto increment numbers to be sequential...

When I want a unique ID I usually use:


md5(uniqid(rand()))


which works very well to give me a random 32 character ID.

I was using the auto increment to generate order numbers, but they were only for display purposes and behind the scenes everything linked up via my random ID's.  It didn't matter to my application that the order numbers weren't sequential, it just looked a bit odd when looking at a list of orders.

But I've explained why to my client and they're happy with that.

677 posts

Ultimate Geek
+1 received by user: 27

Trusted

  Reply # 876371 13-Aug-2013 11:33
Send private message

Thats a good pattern to follow. Many are not so robust.
I wasnt suggesting you fall into the category of sloppy coders i am referring to.





meat popsicle

1502 posts

Uber Geek
+1 received by user: 173


  Reply # 876374 13-Aug-2013 11:40
Send private message

ptinson: Thats a good pattern to follow. Many are not so robust.
I wasnt suggesting you fall into the category of sloppy coders i am referring to.

That's ok, no offence taken!

I don't use auto increment all that often, and if I really wanted sequential numbers I suppose I could just do it myself rather than relying on MySQL to do it.

Now, when can we expect a PHP upgrade on the iServe platform?  5.2.17 is getting a bit long in the tooth and I had one client that wanted to run the latest version of Silverstripe CMS but it requires PHP 5.3.2+ (not that I'm sure how well Silverstripe would work on a shared hosting environment)

677 posts

Ultimate Geek
+1 received by user: 27

Trusted

  Reply # 876378 13-Aug-2013 11:47
Send private message

Its something we are working through at the moment.
As you would expect an upgrade from where we are to 5.3.2+ is not a small task.

We have a few options we are considering.

The changes may simply be so big that we have to stand up new nodes then customers perform a migration and any code changes required to support that.

So the short story is, we are actively working on it at the moment...






meat popsicle

1502 posts

Uber Geek
+1 received by user: 173


  Reply # 876383 13-Aug-2013 11:52
Send private message

Thanks for the update on where you are with upgrading PHP. Yes, an upgrade could well break some websites, so if I had to choose I'd go for setting it up separately and allowing customers to migrate after they've done their testing. Good luck with getting it working! If you need anyone to do some testing then I've got a variety of PHP sites ranging from simple to complex.

677 posts

Ultimate Geek
+1 received by user: 27

Trusted

  Reply # 876419 13-Aug-2013 12:56
Send private message

Thanks well keep that in mind, we certainly will need to test with some customers.




meat popsicle

14421 posts

Uber Geek
+1 received by user: 1888


  Reply # 876441 13-Aug-2013 13:19
Send private message

MurrayM: Thanks for the update on where you are with upgrading PHP. Yes, an upgrade could well break some websites, so if I had to choose I'd go for setting it up separately and allowing customers to migrate after they've done their testing. Good luck with getting it working! If you need anyone to do some testing then I've got a variety of PHP sites ranging from simple to complex.


That is what is normally done anyway by hosts, the old version continues to run, and 5.3 is setup on new accounts, or you change the template of an old site to 5.3.

677 posts

Ultimate Geek
+1 received by user: 27

Trusted

  Reply # 876476 13-Aug-2013 13:59
Send private message

Yep. Very common practice, and is very likely to be what we do.
We would also be setting a 'sunset' date for the older version.

There are also plans in place to upgrade a lot of the asp/mssql hosting as well, more will be said about that as the time comes.





meat popsicle

adw



174 posts

Master Geek
+1 received by user: 24


  Reply # 876489 13-Aug-2013 14:28
Send private message

Sounds great. Let's hope it's well communicated to your users with plenty of time, rather than just finding our sites don't work....

677 posts

Ultimate Geek
+1 received by user: 27

Trusted

  Reply # 876507 13-Aug-2013 14:37
Send private message

Its almost certain that the migration will be driven by you, so you would have control over when it cuts over not us.
The shutdown date would be well advertised and we would be in touch with customers that had not migrated before we took any action...





meat popsicle

1 | 2 | 3 
View this topic in a long page with up to 500 replies per page Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.