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 
ptinson
677 posts

Ultimate Geek

Trusted

  #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



MurrayM
2455 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #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.

ptinson
677 posts

Ultimate Geek

Trusted

  #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



MurrayM
2455 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #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)

ptinson
677 posts

Ultimate Geek

Trusted

  #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

MurrayM
2455 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #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.

ptinson
677 posts

Ultimate Geek

Trusted

  #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

 
 
 

Cloud spending continues to surge globally, but most organisations haven’t made the changes necessary to maximise the value and cost-efficiency benefits of their cloud investments. Download the whitepaper From Overspend to Advantage now.
mattwnz
20141 posts

Uber Geek


  #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.

ptinson
677 posts

Ultimate Geek

Trusted

  #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

adw

175 posts

Master Geek


  #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....

ptinson
677 posts

Ultimate Geek

Trusted

  #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





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









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.