MySQL (play /maɪ ˌɛskjuːˈɛl/ "My S-Q-L", officially, but also called /maɪ ˈsiːkwəl/ "My Sequel") is the world's most used[5] open source relational database management system (RDBMS) as of 2008 that runs as a server providing multi-user access to a number of databases.
It is named after co-founder Michael Widenius' daughter, My.The SQL phrase stands for Structured Query Language.
The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack—LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured database management system often use MySQL.
For commercial use, several paid editions are available, and offer additional functionality. Applications which use MySQL databases include: TYPO3, Joomla, WordPress, phpBB, MyBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google (though not for searches), Facebook, Twitter, Flickr,Nokia.com, and YouTube. Contents
Interfaces MySQL Workbench in Windows
MySQL is primarily an RDBMS and ships with no GUI tools to administer MySQL databases or manage data contained within the databases. Users may use the included command line tools,[19][20] or use MySQL "front-ends", desktop software and web applications that create and manage MySQL databases, build database structures, back up data, inspect status, and work with data records. The official set of MySQL front-end tools, MySQL Workbench is actively developed by Oracle, and is freely available for use.
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS)[2] produced and marketed by Oracle Corporation.
Larry Ellison and his friends, former co-workers Bob Miner and Ed Oates, started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex. Contents
Physical and logical structures
An Oracle database system—identified by an alphanumeric system identifier or SID[4]—comprises at least one instance of the application, along with data storage. An instance—identified persistently by an instantiation number (or activation id: SYS.V_$DATABASE.ACTIVATION#)—comprises a set of operating-system processes and memory-structures that interact with the storage. (Typical processes include PMON (the process monitor) and SMON (the system monitor).) Oracle documentation can refer to an active database instance as a "shared memory realm".
Users of Oracle databases refer to the server-side memory-structure as the SGA (System Global Area). The SGA typically holds cache information such as data-buffers, SQL commands, and user information. In addition to storage, the database consists of online redo logs (or logs), which hold transactional history. Processes can in turn archive the online redo logs into archive logs (offline redo logs), which provide the basis (if necessary) for data recovery and for the physical-standby forms of data replication using Oracle Data Guard.
If the Oracle database administrator has implemented Oracle RAC (Real Application Clusters), then multiple instances, usually on different servers, attach to a central storage array. This scenario offers advantages such as better performance, scalability and redundancy. However, support becomes more complex, and many sites do not use RAC. In version 10g, grid computing introduced shared resources where an instance can use (for example) CPU resources from another node (computer) in the grid.
The Oracle DBMS can store and execute stored procedures and functions within itself. PL/SQL (Oracle Corporation's proprietary procedural extension to SQL), or the object-oriented language Java can invoke such code objects and/or provide the programming structures for writing them.
The excitement of the rumour mill, the titillation of every leaked
photo led to higher than ever levels of expectation over the iPhone 5
features, and while the announcement was greeted with some derision at
the lack of perceived headline improvements, the record sales tell an
entirely different story.
Given the underwhelming changes to the iPhone 4S,
the iPhone 5 launch really needs to re-energise customers to prove
Apple can repeat the game-changing trick it managed with the iPhone 4.
The iPhone 5 price is predictably high, so consumers will need to bear that in mind too when looking for their next smartphone.
So is the Apple iPhone 5 the greatest smartphone ever, one that finally see Apple ascend to the top spot in our 20 best mobile phones chart? Or is it a case of too little, too late?
Design
We'll
begin in the traditional manner: how the thing actually feels in the
hand. With the iPhone 5 there will be many types of prospective buyer:
the upgrader from the 4 (or more-money-than-sense iPhone 4S upgraders),
those tired of their Android handset and those taking their first steps
in the smartphone market and want to get one of them iThingies their
friend/child has. Well,
all of those picking up the iPhone 5 will have the same reaction: this
thing is amazingly light. You've probably heard the numbers by now (20
per cent lighter than the predecessor, as well as beating most of the
opposition too at 112g.)
It's an odd sensation, but it actually
detracts from the experience when you first pick it up. We've praised
the weighty feel of the iPhone in the past, lending it a premium feel in
the face of toy-like phones, and it's almost disappointing that Apple
decided to join that clan.
However, through extended use this
problem quickly disappears, as the overall effect of the phone is still a
chassis designed for strength, it just sits more anonymously in the
pocket.
You'll
obviously see the change in height too – the iPhone 5 stands 123.8mm
tall to allow for the larger 4-inch screen. In truth, those not familiar
with the iPhone 4S probably wouldn't notice the difference, which is
why it's a good move from Apple to include the larger screen if it's not
going put people off that hate larger phones. The
decision to stick at 4-inches is Apple's admission that while it
recognises people are all over the idea of having more screen real
estate to play with it doesn't want to move away from the thumb-friendly
nature of the device.
Through a mixture of moving the centre of
gravity slightly as well as repositioning the screen within the bezel,
it's still possible to scroll your thumb mostly around the whole display
one-handed, which Apple is clearly keen to keep hold of. However,
we're not convinced of that argument any more, and the power button was
still a little out of reach when using the phone normally, as was
anything in the top left-hand corner of the screen. #
This was no
issue in reality, as scooting the phone down a touch in the palm is a
natural action. But if that's the case, then why not offer a 4.3-inch
screen at least?
There's more to a phone than a screen these days
(although increasingly less and less) and the general construction of
the iPhone 5 is excellent to say the least. We've
tested both the ceramic white version and the anodised black, and the
two tone effect on the back of the phone is stunning, both visually and
under the finger.
It doesn't beat the sheer beauty of the HTC One
S, with its micro-arc oxidised back and rounded lines, but it's
well-set in second place. The
two sections of pigmented glass at the top and the bottom of the phone
add a pleasant effect, and the sapphire glass is meant to be thoroughly
durable, to complement the Gorilla Glass on the front.
Apple
knows consumers get furious when they drop and iPhone, and is clearly
seeking to stop the smashes before they happen with a tougher exterior -
although it seems the anodised black version is more prone to
scratching, which means sadly you'll have to think about getting a cover
for that beautiful frame.
The same industrial band around the
outside is in effect again as on the iPhone 4 and 4S, with small
sections removed where the antenna joins.
Apple has gone for a
more advanced form of antenna here, meaning the days of lost signal are
gone, and generally increasing the power of your call connection and GPS
lock on too. There
are other big design changes here too: the headphone jack has moved to
the bottom of the phone, and the iconic 30-pin connector has been
retired in favour of the new Lightning port, giving a headache to all
those that have invested in chargers, docks and other accessories over
their iPhone lives.
You can buy an adaptor, but it's going to be
pricey: £25 or $30 when it lands in October. And unless you want to keep
it permanently attached to the bottom of the iPhone 5 you'll need to
buy a few, which is far from ideal.
However, let's not harangue
Apple too much for this: a smaller connector is not only easier to use
(you can plug the smaller cable in either way round, and the connection
feels more solid), but you're rewarded with a thinner and more compact
phone to boot. The
decision to move the 3.5mm headphone jack to the bottom is an odd one,
as while it allows you to slip the phone into the pocket head-first when
listening to music, which is a more natural action, it's a real pain in
the posterior for some apps that will only work in landscape a certain
way up.
Using it this way means your headphones experience will be one of having to jiggle the jack around two fingers.
It's
not the most comfortable way to hold a phone, and even when using the
phone in portrait mode, the jack gets in the way somewhat.
There
are other smaller design changes to the iPhone 5 too, such as the iSight
front-facing camera moving to the middle and the home button being
noticeably more robust to help reduce instances of a broken portal to
your home screen. But
enough about what the phone looks like - the killer question is how the
thing feels in hand. And we'll sum it up by saying: smooth. It's a
little slippery, and we were always worried we would drop the darned
thing.
But that's the only negative thing about the design (apart
from the low weight initially) as it sits in the palm nicely and allows
you to do it all with one hand, including hitting the top-mounted
power/lock button with ease.
That lock button is actually still
loose, as it was on the iPhone 4S, meaning when you shake the phone
around you can hear it clicking away, which undoes a lot of the premium
feel Apple is going for.
Make no mistake, the iPhone 5 is one of
the most beautifully crafted phones out there - but when you're paying
£529 ($199) up front for the thing, we'd hope this would be the very
minimum Apple would be doing. And
while it looks nice, from the front it doesn't really add much to the
design of the iPhone - it's certainly not the same as the jaw-dropping
design of the iPhone 4 compared to the 3GS... it's another evolution in
the iLine. It's not bad, but for those that hoped the iPhone 5 would be
another step change there's a good chance they'll be disappointed about
the look... until they feel the lovely back on offer.
There was a
real chance here for Apple: remove the bezel and give the front of the
screen a look that's similar to the OLED TVs from the likes of Samsung
or LG… but instead we're treated to the same lines as before.
You
always get the feeling that Apple saves what it can for the next
iteration of the iPhone, and while there's nothing wrong with the
current construction we can see the edge-to-edge screen becoming
something amazing on the iPhone 6.
Way back in early 2004 Mark Zuckerberg gave birth to Facebook, then at thefacebook.com. At that time Mark Zuckerberg was a sophomore at Harvard University. The name for Facebook came from the publications that some colleges pass out to students at the beginning of the year to help students get to know each other better, called a Facebook.
In the beginning there was Harvard and only Harvard. Facebook was created as a way for Mark Zuckerberg and other Harvard students to keep in touch over the Internet and get to know each other better. Facebook became so popular, in just a matter of months, that is was soon opened to other colleges. By the end of the following year it was also open to high schools. The year after that it was opened to the general Internet public, as long as you were 13 and older. Facebook's Investors
Facebook has investors including PayPal co-founder Peter Thiel, Accel Partners, and Greylock Partners. In 2007 Microsoft jumped in and invested $246 million for a 1.6% share in Facebook. The next month Hong Kong billionaire Li Ka-shing made a large investment too. Yahoo! and Google both offered to buy Facebook, but Mark Zuckerberg says that Facebook's not for sale. How Facebook Makes Money
Facebook mainly makes their money from advertising revenue. That's why you'll see banner ads on Facebook. That's how they can manage to create such a great service to you for free. Facebook's Many Features
Over time Facebook has added many new features to their website. You'll now find a news feed, more privacy features, Facebook notes, the ability to add images to your blog and comments, importing other blogs into Facebook, instant messaging, and much more. Also, new apps are born on Facebook every day.
We're back with a more comprehensive review of Apple's new
iPad 3, including new gamut benchmarks pitting the iPad 3 against an
array of recent Android-based tablets. Is Apple's latest offering a
disappointment to those expecting more—or a game-changer?
Every new product launch from Apple is enveloped in hype and hoopla.
Some folks look for reasons to love the new hardware, while others spend
hours looking for that one flaw that'll get everyone's attention. Not
surprisingly, the iPad 3 launched to a full media circus.
But not everyone's expectations were satisfied by Apple’s
third-generation tablet. Looking back at how this product family has
evolved, the iPad 2 advanced in a pretty clear way.
It was smaller, thinner, lighter, and delivered better performance. The
iPad 2 was expensive, yes. However, its improvements over the company's
first-generation effort made the price tag worthwhile for a great many.
The third-generation iPad is a different beast. Rather than tackle
"smaller, thinner, lighter, and faster" again, Apple bolsters this
device's image quality with a significantly higher-resolution display.
The HD resolution is accompanied by a more powerful graphics processor
able to maintain performance, even under the load of greater pixel
density.
Our LCD benchmarks allow us to accurately quantify the image quality improvements, which you may have already seen in our first look at the iPad 3. To briefly recap, we found substantially better color performance and saturation.
To focus exclusively on the iPad's new screen is to overlook a
multitude of other small changes that Apple made, though. Today, we're
going back to explore all of that in a more comprehensive review of
Apple's newest tablet.
Compared to the iPad 2, The New iPad, as Apple calls it, feels very
familiar. It's virtually the same size as its predecessor, and there are
almost no changes to where notable components appear. The camera,
microSIM card (4G model), speakers, buttons, and docking connector are
all right where someone with an iPad 2 would expect to find them.
Last year, we noted that the iPad 2's docking connector was a bit of a
bother, and even this point carries over. The curved casing makes it
difficult to easily dock, often resulting in the connector scratching
the tablet's chassis near the port. From a usability standpoint, the
curved design also makes it harder to get tactile feedback from the
power, volume, and mute buttons.
Although the design isn't any different, some folks can easily
distinguish between the iPad 2 and 3. If you set one down next to the
other, you'll notice that The New iPad is slightly thicker (though not
by much; it's just a .03-inch difference).
More notable is that the newest iPad is about 10% heavier. Even
that's pretty minor, though. About 18 g separates the third-gen 4G model
and the first-gen Wi-Fi model.
PrestaShop is the world’s leading Open-source e-commerce solution powering more than 125,000 stores worldwide. Backed by the industry’s leading partners, PrestaShop ensures easy online selling by providing more than 300 advanced features that can all be customized to fit the needs of every online business. The growing Success of PrestaShop’s software is thanks to countless code contributions, suggestions and encouragement from its ever-expanding 350,000 member Community. PrestaShop is the winner of the 2010 and 2011 Best Open-source Business Application awards, and its passion for pursuing excellence is fueled by business owners who desire a free, powerful and easy
Technical requirements
A domain name
Web server: Apache 1.3, Apache 2.x, Nginx or Microsoft IIS
Joomla is an award-winning content management system (CMS), which
enables you to build Web sites and powerful online applications. Many
aspects, including its ease-of-use and extensibility, have made Joomla
the most popular Web site software available. Best of all, Joomla is
an open source solution that is freely available to everyone.
What's a content management system (CMS)?
A
content management system is software that keeps track of every piece
of content on your Web site, much like your local public library keeps
track of books and stores them. Content can be simple text, photos,
music, video, documents, or just about anything you can think of. A
major advantage of using a CMS is that it requires almost no technical
skill or knowledge to manage. Since the CMS manages all your content,
you don't have to.
What are some real world examples of what Joomla! can do?
Joomla is used all over the world to power Web sites of all shapes and sizes. For example:
