Planet MySQL

Displaying posts with tag: hidden (reset)

Jun

2009

Hidden Features Of Perl, PHP, Javascript, C, C++, C#, Java, Ruby, Python, And Others [Collection Of Incredibly Useful Lists]

Posted by Artem Russakovskii on Sun 21 Jun 2009 19:38 UTC
Tags:

PHP, Oracle, Java, VB.NET, code, Databases, Delphi, perl, c, c++, javascript, css, eclipse, ruby, Programming, Python, Ruby On Rails, feature, Featured, lua, Language, spring, bash, hidden, flash, http, jquery, xpath, program, ror, C Sharp, asp.net, haskell, mod_rewrite, secret, framework, emacs, XSLT, Scala, F#, MySQL, Objective-C, greasemonkey, regex, tcl

Introduction

StackOverflow is an amazing site for coding questions. It was created by Joel Spolsky of joelonsoftware.com, Jeff Atwood of codinghorror.com, and some other incredibly smart guys who truly care about user experience. I have been a total fan of SO since it went mainstream and it's now a borderline addiction (you can see my StackOverflow badge on the right sidebar).

The Story

Update 6/21/09: This server is currently under very heavy load (10-200), even with caching plugins enabled. Please bear with me as I try to resolve the situation.

Feel free to …

[Read more]

Apr

2008

MySQL Conference Liveblogging: MySQL Hidden Treasures (Thursday 11:55PM)

Posted by Artem Russakovskii on Thu 17 Apr 2008 19:01 UTC
Tags:

Databases, conference, hidden, treasures, MySQL

Damien Seguy of Nexen Services presents
easiest session of all (phew, that's a relief)
clever SQL recipes
tweaking SQL queries
shows an example where SELECT is ORDERED by a column that is actually an enum.
- an enum is both a string and a number
- sorted by number
- displayed as string
- can be sorted by string if it's cast as string
compact column
- compacts storage
- faster to search
- if (var)char is turned into enum, some space can be saved, shows example
random order
- order by rand(1) - obviously
- the integer parameter is actually a seed

[Read more]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links