Thermit
Site Admin
Joined: 11 Aug 2004
Posts: 272
|
| MySQL Intro |
|
|
The MySQL database server is the world's most popular open source database. Its architecture makes it extremely fast and easy to customize. Extensive reuse of code within the software and a minimalistic approach to producing functionally-rich features has resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the storage engine makes it possible to run with strict transaction control or with ultra-fast transactionless disk access, whichever is most appropriate for the situation.
The MySQL database server is available under the MySQL AB "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/open source GNU General Public License (commonly known as the "GPL") or under a commercial license.
The MySQL database server supports a broad subset of the ANSI SQL 99 syntax, along with extra extensions such as the REPLACE statement and the LIMIT clause for SELECT and DELETE. Alternative syntaxes from other database systems are also supported, to make porting applications easier.
Cross-platform support is available for a wide range of platforms, including Linux, Microsoft Windows, FreeBSD, Sun Solaris, IBM's AIX, Mac OS X, HP-UX, AIX, QNX, Novell NetWare, SCO OpenUnix, SGI Irix, and Dec OSF.
MySQL Manual
|
Fri Aug 27, 2004 1:42 pm
|
|
|
Peter
Joined: 15 Nov 2004
Posts: 9
Location: New Jersey |
| MySQL Intro |
|
|
Hi,
I went through the post as well as I also followed the SQL Manual Link. Can not you provide any link for beginners for SQL this seems to be a document for advanced lerner?
I appreciate your efforts to make such article available for forum members.
Peter
--------------------
http://www.accuwebhosting.com
peter@accuwebhosting.com
A Quality Hosting and Designing Service Provider
|
|
Thu Nov 18, 2004 8:13 am
|
|
|
UnXpected
Joined: 19 Aug 2004
Posts: 58
|
Useful info 
But there are some saying MS access is better ?
|
|
Thu Nov 18, 2004 1:16 pm
|
|
|
Peter
Joined: 15 Nov 2004
Posts: 9
Location: New Jersey |
| MySQL Intro |
|
|
Hi UnXpected,
Thanks for your advice but you did not provide any link. Can you?
:-)
Peter
-----------------
http://www.accuwebhosting.com
peter@accuwebhosting.com
A Quality Hosting and Designing Service Provider
|
|
Thu Nov 18, 2004 2:10 pm
|
|
|
Thermit
Site Admin
Joined: 11 Aug 2004
Posts: 272
|
Peter,
I haven't found a good basic Intro to MySQL document yet, but hopefully we will and can post it here.
I use Access almost daily, and it is not in the same category as MySQL as far as using for web-based purposes. Access has a few neat tools, however these are more targeted to use in a development environment. MySQL is the obvious standout for use with web servers in support of database driven web software like forums and databases. At least that's my opinion.
|
|
Thu Nov 18, 2004 2:20 pm
|
|
|
Euler
Joined: 02 Sep 2004
Posts: 109
|
|
|
|
Access is better? Than MySQL? LOL! For WHAT? :)
They aren't even in the same game. Different ballpark, different league, different sport.
For offline backroom data processing on a standalone PC using custom data entry screens and compatibility with other MS products, Access is a fairly decent piece of software. Maybe even on a LAN. You might do better with Delphi.
But for most sorts of internet services, MySQL is unparalleled for speed, simplicity and stability.
It's fast and stable because they implemented the critical 20% of RDBMS functionality that handles 80% of need. Stable repository, indices, POSIX and ANSI standard relational operations, standard SQL interface and a sleek client / server architecture.
Because they left out transactions, rollbacks, journaling and a whole host of other tweaky features that clog up the execution pipeline with fringe functionality, MySQL is THE fastest RDBMS. Before you make me prove that, let me throw some caveats at ya.
Rather than dicker over tests and measurements and process only to realize we've wasted time with the semantics of comparative OSes, allow me to somply weaken my original statement. Don't believe it? Fine. You don't have to.
Because MySQL has less code, it is more efficient. Take it or leave it.
MySQL is now starting to go back and provide these previously optional features. If I'm not mistaken, they already have optional builds where you CAN have transactions and rollbacks and some of the finer features of the Oracles of the world. So why can it still bel fast?
Well, if you want trollbacks, it's NOT fast. But if you don't NEED rollbacks, you build your version WITHOUT them and your version is faster. Best of either world, but you can't have it both ways.
Fine grain control, courtesy of building from source. Try THAT with Access. heh.
One more point to share. If you are using MySQL without the swanky features, your data is basically in a fast car with no seatbelts. In case the machine fails while your work is swapped in, database corruption is not just possible, it's probable. So consult your design and search your soul. Can you afford to lose the data? If it's a life-n-death app, you can afford to buy Oracle and you can also afford the performance penalty of Oracle so you should pay them.
But if you're doing a message board or a prototype app or any other networked application where speed is important, flexibility is important and the data can be replaced, MySQL is the absolute best tool waiting for ya.
Personally, I use PostgreSQL, but that's another post for another day.
|
|
Fri Nov 19, 2004 11:42 pm
|
|
|
 
|
|
All times are GMT. The time now is Wed Feb 08, 2012 10:45 am
|
|
|
|
| |
